using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using CoreFS.CA06; using System.ComponentModel; using System.Drawing; using System.Windows.Forms; using Infragistics.Win.UltraWinGrid; using System.Collections; using ColumnDefine = Core.StlMes.Client.Sale.Common.TbColumnDefine.TbColumnDefine; namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance { public class SlmBalanceInfo : SaleBusinessMgt.BllBase.BaseBll { //private static string Query = "select * from slm_balanceinfo where 1 = 1 {0}"; private static string Query1 = "select t.*,k.delete_time,k.supply_unit,k.SUPPLY_UNIT_DESC,(SELECT DISTINCT l.TON_PRICE FROM SLM_ORDER_LINE l WHERE l.ORD_LN_PK = t.ORD_LN_PK) TON_PRICE," + "( SELECT DISTINCT l.CREATE_NAME FROM SLM_ORDER_HEAD l WHERE l.ORD_PK = t.ORD_PK ) CREATE_NAME," + "(SELECT MAX( C.IN_TIME_F ) FROM YDM_ZC_BILL_C T INNER JOIN YDM_ZC_INLIST C ON T.MAT_NO = C.MAT_NO WHERE T.BILL_NO = t.askplan_id GROUP BY T.BILL_NO ) IN_TIME_F " + ",nvl(t.DELVRY_WHEREABOUTS，K.DELVRY_WHEREABOUTS) DELVRY_WHEREABOUTS,nvl(t.IS_USE,1) IS_USE,t.MEMO,DECODE(k.BILL_STATUS,'4','是','5','是','否') BILL_STATUS_FLAG " + "from slm_balanceinfo t, ydm_zc_bill_m k where 1 = 1 and t.askplan_id = k.bill_no(+) and t.ord_pk = k.ord_pk(+) and t.ord_ln_pk = k.ord_ln_pk(+) and t.ord_ln_dly_pk = k.ord_ln_dly_pk(+) {0}"; private static string Query = "select t.*,k.delete_time,k.supply_unit,k.SUPPLY_UNIT_DESC,(SELECT DISTINCT l.TON_PRICE FROM SLM_ORDER_LINE l WHERE l.ORD_LN_PK = t.ORD_LN_PK) TON_PRICE, " + "( SELECT DISTINCT l.CREATE_NAME FROM SLM_ORDER_HEAD l WHERE l.ORD_PK = t.ORD_PK ) CREATE_NAME," + "nvl(t.DELVRY_WHEREABOUTS，K.DELVRY_WHEREABOUTS) DELVRY_WHEREABOUTS,nvl(t.IS_USE,1) IS_USE,t.MEMO,DECODE(k.BILL_STATUS,'4','是','5','是','否') BILL_STATUS_FLAG " + "from slm_balanceinfo t, ydm_zc_bill_m k where 1 = 1 and t.askplan_id = k.bill_no(+) and t.ord_pk = k.ord_pk(+) and t.ord_ln_pk = k.ord_ln_pk(+) and t.ord_ln_dly_pk = k.ord_ln_dly_pk(+) {0}"; private static string Query_TRANS = "select * from slm_balance_transmoney where 1 = 1 {0}"; private static string Query_Detail = "select * from slm_balancedetail_all where 1 = 1 {0}"; public SlmBalanceInfo(OpeBase ob) : base(ob) { } private DataSet GetSlmBalaneInfo(string sqlCondition) { string sqlStr = string.Format(Query,sqlCondition); return base.ExecuteQuery(sqlStr); } private DataSet GetSlmBalanceTransMoney(string sqlCondition) { string sqlStr = string.Format(Query_TRANS, sqlCondition); return base.ExecuteQuery(sqlStr); } private DataSet GetSlmBalanceDetailAll(string sqlCondition) { string sqlStr = string.Format(Query_Detail, sqlCondition); return base.ExecuteQuery(sqlStr); } public DataSet GetSlmBalanceDetailAllByAskPlanIdAndSeqAndOrderNoAndSeqAndSteelKeyAndSpetKey(String orderNo, String orderSeq, String orderDlvSeq, String askPlanId, String askPlanIdSeq, String spetKey, String steelCodeKey) { string str = orderNo + orderSeq + orderDlvSeq + spetKey + steelCodeKey + askPlanId + askPlanIdSeq; string sqlCondition = string.Format(" and ord_no||ord_seq||ord_ln_dly||spetkey||steelcodekey||askplan_id||askplan_id_seq = '{0}' ", str); return GetSlmBalanceDetailAll(sqlCondition); } public DataSet GetSlmBalanceDetailAllGroupByBatchNo(String orderNo, String orderSeq, String orderDlvSeq, String askPlanId, String askPlanIdSeq, String spetKey, String steelCodeKey) { string str = orderNo + orderSeq + orderDlvSeq + spetKey + steelCodeKey + askPlanId + askPlanIdSeq; string sql = @"select askplan_id, tallysheet_no, batch_no, min(plid) plid, sum(prd_qty) quantity, sum(nvl(SEND_NUM,0)) SEND_NUM, sum(nvl(act_wgt,0)) act_wgt, sum(round(nvl(case when ISPRECLOSE = '0' then outstockmny else 0 end,0),3)) outstockmny,max(money_type) money_type, RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL from slm_balancedetail_all a where 1 = 1 {0} group by askplan_id,tallysheet_no,batch_no, RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL "; string sqlCondition = string.Format(" and ord_no||ord_seq||ord_ln_dly||spetkey||steelcodekey||askplan_id||askplan_id_seq = '{0}' ", str); return base.ExecuteQuery(string.Format(sql, sqlCondition)); } private DataSet GetBaseCustomberInfo(string sqlCondition) { string sql = @"select a.customer_no, a.customer_nm, a.bigarea, c.basename, a.region_no, d.region_nm, a.user_grp, a.org, a.py, a.validflag, a.create_time, a.create_name, b.sale_org, b.custm_use, a.ABRVITION from slm_base_customer a left join slm_base_custm_use b on a.customer_no = b.customer_no and b.validflag = '1' left join Com_Base_Info c on a.bigarea = c.basecode left join SEL_ADMIN_REGION d on a.region_no = d.region_no where a.validflag = '1' {0} "; sql = string.Format(sql, sqlCondition); return base.ExecuteQuery(sql); } public DataSet GetBaseCustomberInfoBySaleOrg(string saleOrg) { string sqlConditon = string.Format(" and b.sale_org = '{0}' ",saleOrg); return GetBaseCustomberInfo(sqlConditon); } public DataSet GetBaseCustomberInfoBySaleOrgAndCustUse(string saleOrg,string custUse) { string sqlConditon = string.Format(" and b.sale_org = '{0}' and b.custm_use = '{1}' ", saleOrg, custUse); return GetBaseCustomberInfo(sqlConditon); } public DataSet GetSlmBalanceDetailAllGroupByAskPlanId(String askPlanId ) { string sql = @"select askplan_id, tallysheet_no, batch_no, sum(prd_qty) quantity, sum(nvl(act_wgt,0)) act_wgt, sum(round(nvl(case when ISPRECLOSE = '0' then outstockmny else 0 end,0),3)) outstockmny,max(money_type) money_type from slm_balancedetail_all a where 1 = 1 {0} group by askplan_id,tallysheet_no,batch_no "; string sqlStr = @"select askplan_id, tallysheet_no, batch_no, sum(prd_qty) quantity, sum(nvl(act_wgt,0)) act_wgt, sum(round(nvl(case when ISPRECLOSE = '0' then outstockmny else 0 end,0),3)) outstockmny,max(money_type) money_type, RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL from slm_balancedetail_all a where 1 = 1 {0} group by askplan_id,tallysheet_no,batch_no,RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL "; string sqlCondition = string.Format(" and askplan_id = '{0}' ", askPlanId); return base.ExecuteQuery(string.Format(sqlStr, sqlCondition)); } public DataSet GetInvoiceSlmBalanceTransMoney(DateTime dtBegin, DateTime dtEnd) { string sql = @" select sum(a.money) money,a.invoiceno ,max(invoice_id) invoiceperson,max(invoicedate) invoicedate,a.buyercode, buyername,forecorpname FORECORPCODE, MONEY_TYPE REMARK,sum(weight) weight from SLM_BALANCE_TRANSMONEY a where a.status_cd = '2' {0} group by a.invoiceno,a.buyercode,forecorpname ,MONEY_TYPE,buyername "; string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE", dtBegin, dtEnd); return base.ExecuteQuery(string.Format(sql, sqlCondition)); } public DataSet GetInvoiceSlmBalanceTransMoneyOrg(DateTime dtBegin, DateTime dtEnd) { string sql = @" select sum(a.money) money,a.INVOICENO_ORG ,max(invoiceperson_org) invoiceperson_org, max(invoicedate_org) invoicedate_org,a.buyercode, buyername,forecorpname FORECORPCODE, MONEY_TYPE REMARK,sum(weight) weight from SLM_BALANCE_TRANSMONEY a where INVOICENO_ORG is not null {0} group by a.INVOICENO_ORG,a.buyercode,forecorpname ,MONEY_TYPE,buyername "; string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE_ORG", dtBegin, dtEnd); return base.ExecuteQuery(string.Format(sql, sqlCondition)); } public DataSet GetInvoiceSlmBalanceTransMoneyAndOutStockMoney(DateTime dtBegin, DateTime dtEnd) { string sql = @" select sum(a.money) money,a.invoiceno,money_type from SLM_BALANCE_TRANSMONEY a where a.status_cd = '2' and invoice_sts = '0' {0} group by a.invoiceno,money_type "; string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE", dtBegin, dtEnd); return base.ExecuteQuery(string.Format(sql, sqlCondition)); } public DataSet GetInvoiceSlmBalanceTransMoneyAndOutStockMoneyIncludeTax(DateTime dtBegin, DateTime dtEnd) { string sql = @" select sum(a.weight * (decode(a.trans_type, '铁运', 23, 10))) money,a.invoiceno,money_type from SLM_BALANCE_TRANSMONEY a where a.status_cd = '2' {0} group by a.invoiceno,money_type "; string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE", dtBegin, dtEnd); return base.ExecuteQuery(string.Format(sql, sqlCondition)); } public DataSet GetSlmBalanceTransMoneyByLoadTime(DateTime dtBegin, DateTime dtEnd) { string sqlConditin = Util.ConverObject.ConvertDateTimeValueToDbLanguage("LOAD_TIME",dtBegin,dtEnd); return GetSlmBalanceTransMoney(sqlConditin); } public DataSet GetSlmBalanceTransMoneyByRegeditTime(DateTime dtBegin, DateTime dtEnd) { string sqlConditin = Util.ConverObject.ConvertDateTimeValueToDbLanguage("REG_DTIME", dtBegin, dtEnd); return GetSlmBalanceTransMoney(sqlConditin); } public DataSet GetSlmBalanceTransMoneyAskPlanid(string askPlanId) { string sqlCondition = string.Format(" and askplan_id = '{0}' ", askPlanId); return GetSlmBalanceTransMoney(sqlCondition); } public DataSet GetSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime, bool flag) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' ", planBeginDate, planEndDate); string sqlStr = string.Format(flag ? Query : Query1, sqlCondition); return base.ExecuteQuery(sqlStr); } public DataSet GetSlmBalaneInfoByPlanMonth(string strMonth, bool flag) { string sqlCondition = string.Format(" and T.INVOICE_MONTH = '{0}'", strMonth); string sqlStr = string.Format(flag ? Query : Query1, sqlCondition); return base.ExecuteQuery(sqlStr); } public DataSet GetunAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and ticketstatus = '0' ", planBeginDate, planEndDate); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetUnAffrimVirtualTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and ISPRECLOSE = '是' and nvl(ISREALCLOSE,'否') = '是' ", planBeginDate, planEndDate); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and ticketstatus = '1' ", planBeginDate, planEndDate); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetUnAffrimSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime,String suppunit) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and balancestatus = '0' and ticketstatus = '1' ", planBeginDate, planEndDate); if (suppunit == "120504") sqlCondition += " and t.fst_drawee_unit='120607' and supply_unit='120504' "; else sqlCondition += " and t.fst_drawee_unit !='120607' "; return GetSlmBalaneInfo(sqlCondition); } public DataSet GetAffrimSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime, String suppunit) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and balancestatus = '2' ", planBeginDate, planEndDate); if (suppunit == "120504") sqlCondition += " and t.fst_drawee_unit='120607' and supply_unit='120504' "; else sqlCondition += " and t.fst_drawee_unit !='120607' "; return GetSlmBalaneInfo(sqlCondition); } public DataSet GetUnAffrimSlmBalaneInfoByPlanBeginDateAndEndDateOrg(DateTime dtBegiin, DateTime dtEndTime) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and balancestatus_org = '0' and ticketstatus = '1' ", planBeginDate, planEndDate); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetAffrimSlmBalaneInfoByPlanBeginDateAndEndDateOrg(DateTime dtBegiin, DateTime dtEndTime) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and balancestatus_org = '2' ", planBeginDate, planEndDate); return GetSlmBalaneInfo(sqlCondition); } public DataSet GeOrgtInvoiceSlmBalaneInfoByInvoiceBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime) { string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate_org", dtBegiin, dtEndTime); sqlconditon += " and balancestatus_org = '3' "; return GetSlmBalaneInfo(sqlconditon); } public DataSet GetInvoiceSlmBalaneInfoByInvoiceBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime,bool flag) { string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate", dtBegiin, dtEndTime); sqlconditon += " and balancestatus = '3' "; string sqlStr = string.Format(flag ? Query : Query1, sqlconditon); return base.ExecuteQuery(sqlStr); } public DataSet GetInvoiceSlmBalaneInfoByStdAndStell(string str, bool flag) { //string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate", dtBegiin, dtEndTime); string sqlStr = string.Format(flag ? Query : Query1, str); //sqlStr += str; return base.ExecuteQuery(sqlStr); } public DataSet GetInvoiceSlmBalaneInfoByDateAndStatus(DateTime dtBegiin, DateTime dtEndTime,String suppUnit) { string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate", dtBegiin, dtEndTime); sqlconditon += " and balancestatus = '3' "; if (suppUnit == "120504") sqlconditon += " and t.fst_drawee_unit='120607' and k.supply_unit='120504' "; else sqlconditon += " and t.fst_drawee_unit !='120607' "; return GetSlmBalaneInfo(sqlconditon); } public DataSet GetInvoiceSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime) { string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' and balancestatus = '3' ", planBeginDate, planEndDate); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetInvoiceSlmBalanceInfoByInvoiceDate(DateTime dtBegiin, DateTime dtEndTime) { return null; } public DataSet GetInvoicedSlmBalanceInfoByListInvoiceNo(List listInvoiceNo) { string sqlStr = @"select b.taxno, b.address, b.account, a.*, a.spet spec, round(a.money * 0.13/ 1.13, 2) taxmoney from (select sum(money) money, max(price) price, sum(weight) weight, max(steelcodekey) steelcode, max(category) category, max(buyercode) buyercode, max(a.buyername) buyername, max(spetkey) spet, invoiceno || '.' || invoiceno_seq invoiceno, max(invoiceno) invoicenoz, max('') auditingperson, max(invoiceperson) invoiceperson, max(fst_drawee_unit) fst_drawee_unit, max(remark) remark from slm_balanceinfo a where 1 = 1 {0} and a.balancestatus = '3' group by invoiceno || '.' || invoiceno_seq union all select sum(money) money, max(0) price, sum(0) weight, max('') steelcode, max('运费,出库费') category, max(buyercode) buyercode, max(a.buyername) buyername, max('') spet, invoiceno || '.' || '1' invoiceno, max(invoiceno) invoicenoz, max('') auditingperson, max(invoice_id) invoiceperson, max(a.fst_drawee_unit) fst_drawee_unit, max(MONEY_TYPE) remark from slm_balance_transmoney a where 1 = 1 {0} and a.status_cd = '2' and tickettype = '应收' group by invoiceno) a join (select b.customer_no, min(address) address, min(bank) bank, min(account) account, min(tax_id) taxno, min(phone) phone, min(fax) fax from slm_base_order_unit b group by customer_no) b on a.buyercode = b.customer_no order by a.invoiceno "; string sqlConditon = Util.ConverObject.ConvertListStringValueToSqlCondition("INVOICENO", listInvoiceNo); sqlStr = string.Format(sqlStr, sqlConditon); return base.ExecuteQuery(sqlStr); } public DataSet GetInvoicedSlmBalanceInfoByListInvoiceNoOrg(List listInvoiceNo) { string sqlStr = @"select b.taxno, b.address, b.account, a.*, a.spet spec, round(a.money * 0.13 / 1.13, 2) taxmoney from (select sum(money_org) money, max(price_org) price, sum(weight) weight, max(steelcodekey) steelcode, max(category) category, max(fst_drawee_unit) buyercode, max(fst_drawee_unit) buyername, max(spetkey) spet, invoiceno_org || '.' || invoiceno_seq_org invoiceno, max(invoiceno_org) invoicenoz, max('') auditingperson, max(invoiceperson) invoiceperson, max(fst_drawee_unit) fst_drawee_unit, max(remark) remark from slm_balanceinfo a where 1 = 1 {0} and a.balancestatus_org = '3' group by invoiceno_org || '.' || invoiceno_seq_org union all select sum(money) money, max(0) price, sum(0) weight, max('') steelcode, max(MONEY_TYPE) category, max(buyercode) buyercode, max(a.buyername) buyername, max('') spet, invoiceno || '.' || '1' invoiceno, max(invoiceno) invoicenoz, max('') auditingperson, max(invoice_id) invoiceperson, max(fst_drawee_unit) fst_drawee_unit, max(MONEY_TYPE) remark from slm_balance_transmoney a where 1 = 1 and 1 = 2 and a.status_cd = '2' and tickettype = '应收' group by invoiceno) a left join (select b.customer_no, min(address) address, min(bank) bank, min(account) account, min(tax_id) taxno, min(phone) phone, min(fax) fax from slm_base_order_unit b group by customer_no) b on a.buyercode = b.customer_no order by a.invoiceno "; string sqlConditon = Util.ConverObject.ConvertListStringValueToSqlCondition("invoiceno_org", listInvoiceNo); sqlStr = string.Format(sqlStr, sqlConditon); return base.ExecuteQuery(sqlStr); } public DataSet GetSlmBalaneInfoByAskPlanId(String askPlanId) { string sqlCondition = string.Format(" and askplan_id = '{0}' ", askPlanId); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetSlmBalaneInfoByOrderNo(String orderNo) { string sqlCondition = string.Format(" and ord_no = '{0}' ", orderNo); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetSlmBalaneInfoByBuyerCode(String buyercode) { string sqlCondition = string.Format(" and buyercode = '{0}' ", buyercode); return GetSlmBalaneInfo(sqlCondition); } public DataSet GetUnAcceptTransAndOutStockTicket() { string sqlConditon = " and ticketstatus = '0' "; string sql = string.Format(GetBalanceTransMoney(),sqlConditon); return base.ExecuteQuery(sql); } public DataSet GetUnAcceptTicketAndTransAndOutStockTicket(DateTime dtBegin, DateTime deEnd,String cusInfo,String suppunit) { string conditon1 = " "; string conditon2 = " "; if (cusInfo == "2") { if (suppunit == "120504") { conditon1 = " where exists (select 1 from ydm_zc_bill_m b where b.supply_unit='120504') "; conditon2=" and a.fst_drawee_unit='120607' "; } else conditon2 += " and a.fst_drawee_unit !='120607' "; } else { if (suppunit == "120504") conditon1 += " where exists (select 1 from ydm_zc_bill_m b where b.supply_unit='120504') "; else conditon1 += " where exists (select 1 from ydm_zc_bill_m b where b.supply_unit='120501') "; } string sql = GetSlmBalanceInfo(dtBegin, deEnd, "0", conditon1, conditon2); return base.ExecuteQuery(sql); } public DataSet GetAcceptTransAndOutStockTicket() { string sqlConditon = " and ticketstatus = '1' "; string sql = string.Format(GetBalanceTransMoney(), sqlConditon); return base.ExecuteQuery(sql); } public DataSet GetAcceptAndAffrimTransAndOutStockTicket(string suppunit) { string sqlConditon = " and ticketstatus = '1' and status_cd = '1' "; if (suppunit == "120504") sqlConditon += " and a.fst_drawee_unit='120607' and b.supply_unit='120504' "; else sqlConditon += " and a.fst_drawee_unit !='120607' "; string sql = string.Format(GetBalanceTransMoney(), sqlConditon); return base.ExecuteQuery(sql); } public DataSet GetAcceptAndUnAffrimTransAndOutStockTicket(string suppunit) { string sqlConditon = " and ticketstatus = '1' and status_cd = '0' "; if (suppunit == "120504") sqlConditon += " and a.fst_drawee_unit='120607' and b.supply_unit='120504' "; else sqlConditon += " and a.fst_drawee_unit !='120607' "; string sql = string.Format(GetBalanceTransMoney(), sqlConditon); return base.ExecuteQuery(sql); } public DataSet GetAcceptAndAffrimTransAndOutStockTicketOrg() { string sqlConditon = " and ticketstatus = '1' and status_cd_org = '1' "; string sql = string.Format(GetBalanceTransMoney(), sqlConditon); return base.ExecuteQuery(sql); } public DataSet GetAcceptAndUnAffrimTransAndOutStockTicketOrg() { string sqlConditon = " and ticketstatus = '1' and status_cd_org = '0' "; string sql = string.Format(GetBalanceTransMoney(), sqlConditon); return base.ExecuteQuery(sql); } private string GetSlmBalanceInfo(DateTime dtBegin, DateTime deEnd, string ticketype, string condition1, string condition2) { string sql = @" select min(t.askplan_id) askplan_id, (select distinct t.supply_unit from ydm_zc_bill_m t where t.bill_no=askplan_id) supply_unit, ( SELECT DISTINCT t.SUPPLY_UNIT_DESC FROM ydm_zc_bill_m t WHERE t.bill_no = askplan_id ) SUPPLY_UNIT_DESC, min(t.buyername) buyername, t.listnumber, min(t.trans_type_name) trans_type_name, min(t.sale_area_desc) sale_area_desc, min(t.create_dept) create_dept, sum(case when MONEY_TYPE = '货款' then quantity else 0 end) quantity, sum(case when MONEY_TYPE = '货款' then weight else 0 end) weight, 0 money, sum(case when MONEY_TYPE = '出库费' then weight else 0 end) outweight, sum(case when MONEY_TYPE = '出库费' then money else 0 end) OUTSTOCKMNY, sum(case when MONEY_TYPE = '运费' then money else 0 end) transmoney, sum(t.send_num) send_num,min(t.inceptcorpcode) inceptcorpcode from (select min(a.askplan_id) askplan_id, a.buyername, sum(a.quantity) quantity, sum(a.weight) weight, a.sale_area_desc, a.create_dept, a.listnumber, '货款' MONEY_TYPE, 0 money, sum(a.send_num) send_num, min(a.trans_type_name) trans_type_name,min(a.inceptcorpcode) inceptcorpcode from Slm_Balanceinfo a where a.ticketstatus = '{0}' {1} {3} group by listnumber, a.buyername, a.sale_area_desc, a.create_dept union all select min(b.askplan_id) askplan_id, min(b.buyername) buyername, 0, sum(b.weight) weight, min(sale_area_desc) sale_area_desc, min(a.create_dept) create_dept, b.listnumber, b.money_type, sum(b.money) money, 0, min(b.trans_type) trans_type_name, min(inceptcorpcode) inceptcorpcode from Slm_Balance_Transmoney b join (select min(b.create_dept) create_dept, min(b.create_name) create_name, min(b.sale_area_desc) sale_area_desc, bill_no from ydm_zc_bill_m m join slm_order_head b on m.ord_pk = b.ord_pk group by bill_no) a on bill_no = b.askplan_id where b.ticketstatus = '{0}' and b.tickettype = '应收' and b.money > 0 and listnumber is not null group by b.listnumber, b.money_type) t {2} group by listnumber,askplan_id "; string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegin); string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(deEnd); string sqlCondition = string.Format(" and plandate >= '{0}' and plandate <= '{1}' ", planBeginDate, planEndDate); sql = string.Format(sql, ticketype, sqlCondition, condition1, condition2); return sql; } private string GetBalanceTransMoney() { string sql = @" select a.askplan_id, a.listnumber, a.buyercode, a.buyername, min(a.order_no) ORD_NO, min(a.order_seq) ORD_SEQ, a.forecorpname forecorpcode, a.fst_drawee_unit, a.inceptcorpcode, a.trans_type TRANS_TYPE_NAME, a.tickettype, a.MONEY_TYPE, sum(a.money) money, sum(a.weight) weight, a.ord_pk, a.ord_ln_pk, a.ord_ln_dly_pk, min(a.status_cd) BALANCESTATUS, min(a.status_cd_org) BALANCESTATUS_org, min(a.ticketdate) ticketdate, min(a.ticketperson) ticketperson, min(a.reg_id) reg_id, min(a.reg_dtime) reg_dtime, min(b.sale_area_desc) sale_area_desc, min(b.create_dept) create_dept, min(b.create_name) create_name, b.supply_unit from Slm_Balance_Transmoney a join (select min(b.create_dept) create_dept, min(b.create_name) create_name, min(b.sale_area_desc) sale_area_desc, bill_no, min(m.supply_unit) supply_unit from ydm_zc_bill_m m join slm_order_head b on m.ord_pk = b.ord_pk group by bill_no) b on a.askplan_id = b.bill_no where 1=1 {0} and a.tickettype = '应收' group by a.askplan_id, a.listnumber, a.buyercode, a.buyername, a.ord_pk, a.ord_ln_pk, a.ord_ln_dly_pk, a.forecorpcode, a.forecorpname, a.fst_drawee_unit, a.inceptcorpcode, a.trans_type, a.tickettype, a.money_type, b.supply_unit "; return sql; } public void UpdatePrice(string ord_no, string ord_seq, string ord_ln_dly, string askplan_id, string askplan_id_seq, string spetkey, string steelcodekey,double price,string reason,string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "updatePrice", new object[] { ord_no, ord_seq,ord_ln_dly,askplan_id, askplan_id_seq,spetkey,steelcodekey,price.ToString(), reason,person}); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void inputPrice(string ord_no, string ord_seq, string ord_ln_dly, string askplan_id, string askplan_id_seq, string spetkey, string steelcodekey, double price, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "inputPrice", new object[] { ord_no, ord_seq,ord_ln_dly,askplan_id, askplan_id_seq,spetkey,steelcodekey,price.ToString(),person}); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void SetBalPrice(System.Collections.ArrayList list, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "setBalPrice", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void SetBalPriceOrg(System.Collections.ArrayList list, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "setBalPriceOrg", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void Affrim(System.Collections.ArrayList list,string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void Affrim(System.Collections.ArrayList list, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void AffrimOrg(System.Collections.ArrayList list, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "affrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void AffrimOrg(System.Collections.ArrayList list, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "affrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UnAffrim(System.Collections.ArrayList list, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "unaffrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void UnAffrim(System.Collections.ArrayList list, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "unaffrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UnAffrimOrg(System.Collections.ArrayList list, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "unaffrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void UnAffrimOrg(System.Collections.ArrayList list, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "unaffrim", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void Invoice(System.Collections.ArrayList list, string forecode,string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoice", new object[] { list, forecode,person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void InvoiceLightly(System.Collections.ArrayList list, string forecode, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightly", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void InvoiceLightly(System.Collections.ArrayList list, string forecode, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightly", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void InvoiceLightlyGuoM(System.Collections.ArrayList list, string forecode, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightlyForGuoM", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void InvoiceLightlyGuoM(System.Collections.ArrayList list, string forecode, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightlyForGuoM", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void InvoiceLightlyOrg(System.Collections.ArrayList list, string forecode, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "makeInvoiceLightly", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void InvoiceLightlyOrg(System.Collections.ArrayList list, string forecode, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "makeInvoiceLightly", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void InvoiceWithTranMny(System.Collections.ArrayList list, string forecode, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "makeInvoiceTransMoney", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void InvoiceWithOutStockMny(System.Collections.ArrayList list, string forecode, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "makeInvoiceOutStockMoney", new object[] { list, forecode, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void RollBaskAskPlanId(string askPlanId, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "rollBackAskPlanId", new object[] { askPlanId, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void AffrimTicket(string askPlanId, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrimTicket", new object[] { askPlanId, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void AffrimAcceptTicket(System.Collections.ArrayList list, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrimTicketByListNumber", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UnAffrimAcceptTicket(string listnumber, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "unaffrimTicketByListNumber", new object[] { listnumber, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UnAffrimTicket(string askPlanId, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "unAffrimTicket", new object[] { askPlanId, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void RollBaskInvoiceNo(string invoiceNo, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "rollBackInvoiceNo", new object[] { invoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void RollBaskInvoiceNo(string invoiceNo, string person,out string errMsg) { CoreClientParam param = base.GetCoreClientParam(_ServerName, "rollBackInvoiceNo", new object[] { invoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void RollBaskInvoiceNoOrg(string invoiceNo, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "rollBackInvoiceNo", new object[] { invoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } public void SaveTransMoney(List lisths, string person) { foreach (Hashtable hs in lisths) { CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "saveTransMoney", new object[] { hs, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } } public void SaveTransMoneyWithAlineTicket(String billno, String transMny, String ticketType, String AGENCY_FL, String delvaddr, String ordpk, String ordLnPk, String ordLndPk, String indexNo, String person, string weight, string disburasesbill, string transNo, string stampDutyMoney, out string errMsg) { CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "saveTransMoneyWithBillNoAndTransMny", new object[] { billno, transMny, ticketType, AGENCY_FL, delvaddr, ordpk, ordLnPk, ordLndPk, indexNo, person,weight,disburasesbill,transNo,stampDutyMoney }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void SaveTransMoney(List lisths, string person,out string errMsg) { errMsg = ""; foreach (Hashtable hs in lisths) { CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "saveTransMoney", new object[] { hs, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); if (errMsg.Length > 0) return; } } public void AffrimTransMnyTicket(string askPlanId, string person) { CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "affrimTransMnyByAskPlanId", new object[] { askPlanId, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); } /// /// 修改费用信息 /// /// 主键 /// 金额 /// 单据号 /// 类型，应收，应付 /// 操作人 public void EditTransMoney(string transeq,string money,string ticketnum, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "editTransMoney", new object[] { transeq, ticketnum, money, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void DeleteTransMoney(string transeq, string person,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "deleteTransMoney", new object[] { transeq, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UpdateRealInvoiceNO(string invoiceNO, string realInvoiceNo, String person ,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateRealInvoiceNo", new object[] { invoiceNO, realInvoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UpdateRealInvoiceNoOrg(string invoiceNO, string realInvoiceNo, String person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateRealInvoiceNoOrg", new object[] { invoiceNO, realInvoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } // 冲减 public void Credit(System.Collections.ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "credit", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } // 集团冲减 public void CreditOrg(System.Collections.ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "credit", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UpdateSendNum(string ord_no, string ord_seq, string ord_ln_dly, string askplan_id, string askplan_id_seq, string spetkey, string steelcodekey, string sendNum, ArrayList list,string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateSendNum", new object[] { ord_no, ord_seq,ord_ln_dly,askplan_id, askplan_id_seq,spetkey,steelcodekey,sendNum,list,person}); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UpdateInvoiceStatusToLocked(ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateInvoiceStatusToLocked", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void MakeLastInvoiceForTransMnyAndOutStockMoney(ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeLastInvoiceForTransMny", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void MakeFirstInvoiceForTransMnyAndOutStockMoney(ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeFirstInvoiceForTransMny", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UpdateRealInvoiceDate(ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateRealInvoiceDate", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void UpdateRealInvoiceDateOrg(ArrayList list, string person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "updateRealInvoiceDate", new object[] { list, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } /// /// /// /// /// public void AcceptRollBackAndCreaditRecord(System.Collections.ArrayList list, string askPlanid,out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "acceptRollBackAndCreditRecords", new object[] { askPlanid, list }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void CreditByAddNewTicketsWithSameWgt(string invoiceNo,String person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "creditByAddNewTicketsWithSameWgt", new object[] { invoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } public void CreditByAddNewTicketsWithSameWgtOrg(string invoiceNo, String person, out string errMsg) { errMsg = ""; CoreClientParam param = base.GetCoreClientParam(_ServerName, "creditByAddNewTicketsWithSameWgtOrg", new object[] { invoiceNo, person }); CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal); errMsg = base.GetReturnErrorInfo(result); } private string _ServerName = "core.stlmes.server.sale.service.balance.SlmBalanceTickets"; private string _ServerNameTrans = "core.stlmes.server.sale.service.balance.SlmBalanceTransMgt"; private string _ServerNameOrg = "core.stlmes.server.sale.service.balance.SlmBalanceTicketsOrg"; } }