/// <summary> /// 凭证科目实例化(此方法已被重写) /// </summary> /// <returns></returns> protected virtual FKTZSServiceManagerEntity InitFKTZSServiceManagerEntity(ApplyNoEntity item) { FKTZSServiceManagerEntity fktzsServiceManagerEntity = new FKTZSServiceManagerEntity(); fktzsServiceManagerEntity.SetAccountPayableAdvanceReceivedAC().SetActualPayableAC().SetCostAdjustmentAC("SAPLinks.Bussiness.AfterSaleBussiness.CostAdjustmentAC").SetInputVatAC(). SetInputVATDifferenceAdjustmentAC().SetInputVATDifferencesTurnOutCreditAC().SetInputVATDifferencesTurnOutDebtorAC(); return(fktzsServiceManagerEntity);//SAPLinks.Bussiness.AfterSaleBussiness }
private static string StringFormat(ApplyNoEntity applyNoEntity) { string query = @"select TASKID,APPLY_NO,APPLY_DISPLAYNAME,APPLY_DEPT,APPLY_DEPTCODE,PAY_OBJ_ID,PAY_OBJ_NAME,XREF2_HD,WBJE_TOTAL,WBCS_TOTAL from DABAN_BPM_{0}.DBO.FKTZS_C_H where PROCESS_TYPE = '{1}' and YCWC_TYPE = '{2}' and APPLY_NO='{3}'"; query = string.Format(query, applyNoEntity.BasicEntity.Company, applyNoEntity.BasicEntity.FktzsProcessType.ProcessType, applyNoEntity.BasicEntity.FktzsYcWcType.YCWCType, applyNoEntity.ApplyNo); return(query); }
private static string StringFormat(ApplyNoEntity applyNoEntity) { string query = @"select 'ZP' InvoiceType,INV_CODE,INV_NO,AMOUNT,TAX from DABAN_BPM_{0}.DBO.FKTZS_ZP_C_D where TASKID={1} union all select 'PP' InvoiceType,INV_CODE,INV_NO,AMOUNT,0 TAX from DABAN_BPM_{0}.DBO.FKTZS_PP_C_D where TASKID={1}"; query = string.Format(query, applyNoEntity.BasicEntity.Company, applyNoEntity.TaskID); return(query); }
public static IKPSQ Create(ApplyNoEntity applyNoEntity) { if (applyNoEntity.BasicEntity.FktzsYcWcType.YCWCType == FKTZSYCWCType.YC) { return(new KPSQ_YC()); } else { return(new KPSQ_WC()); } }
private static string StringFormat(ApplyNoEntity applyNoEntity) { //AND SRC_TASKID<>CURRENT_TASKID为了过滤E单据 string query = @"select BB.TASKID,BB.Z_GLBH,BB.C_WBCS from ( select * from BPMDB.DBO.MAIN_KPSQ_DATAUSED where CURRENT_TASKID={0} AND SRC_TASKID<>CURRENT_TASKID ) AA left join DABAN_BPM_{1}.DBO.KPSQ_ZYDXX_D BB on AA.SRC_TASKID=BB.TASKID and AA.XBLNR=BB.Z_GLBH and AA.CBXZ=BB.Z_GLBH_PK"; query = string.Format(query, applyNoEntity.TaskID, applyNoEntity.BasicEntity.Company); return(query); }
private static string StringFormat(ApplyNoEntity applyNoEntity) { string query = @"SELECT * FROM ( SELECT ID,TASKID,Z_GLBH,Z_GLBH_PK,Z_YWLX,Z_HTBH,Z_YYDD,KHBM,S_KPJE,C_SAKNR,C_SNWBMC,C_WBJE,SJZFJE FROM [DABAN_BPM_{1}].[DBO].[FKTZS_ZYD_D] WHERE TASKID={0} UNION ALL SELECT ID,TASKID,Z_GLBH,Z_GLBH_PK,Z_YWLX,Z_HTBH,Z_YYDD,KHBM,S_KPJE,C_SAKNR,C_SNWBMC,C_WBJE,SJZFJE FROM [DABAN_BPM_{1}].[DBO].[FKTZS_ZYD_EXCEL_D] WHERE TASKID={0} ) AA ORDER BY ID ASC"; query = string.Format(query, applyNoEntity.TaskID, applyNoEntity.BasicEntity.Company); return(query); }
public static FKTZSServiceEntity Load(ApplyNoEntity applyNoEntity) { FKTZSServiceEntity fktzsServiceEntity = new FKTZSServiceEntity(); fktzsServiceEntity.ApplyNoEntity = applyNoEntity; fktzsServiceEntity.Fktzs_C_HEntitys = FKTZS_C_HEntity.Load(applyNoEntity); fktzsServiceEntity.InvoiceEntitys = InvoiceEntityCollection.Load(applyNoEntity); //2018-8-21 11:57:44改造开票申请取数逻辑。开票申请有偿、无偿的取数表不同 fktzsServiceEntity.KpsqEntitys = KPSQFactory.Create(applyNoEntity).Load(applyNoEntity);//KPSQEntityCollection.Load(applyNoEntity); fktzsServiceEntity.FKTZSZYDEntitys = FKTZSZYDEntityCollection.Load(applyNoEntity); return(fktzsServiceEntity); }
private ApplyNoEntityCollection AggData(DataTable dt) { ApplyNoEntityCollection applyNos = new ApplyNoEntityCollection(); foreach (DataRow item in dt.Rows) { ApplyNoEntity applyNoEntity = new ApplyNoEntity(); applyNoEntity.ApplyNo = Convert.ToString(item["APPLY_NO"]); applyNoEntity.TaskID = Convert.ToString(item["TaskID"]); applyNoEntity.FinishAt = Convert.ToDateTime(item["FinishAt"]).ToString("yyyyMMdd"); applyNoEntity.BasicEntity = _applyNoBasicEntity; applyNos.Add(applyNoEntity); } return(applyNos); }
/// <summary> /// 凭证科目实例化 /// 2018-8-21 13:32:10改造, /// 根据单号区分有偿、无偿取数格式 /// </summary> /// <returns></returns> protected override FKTZSServiceManagerEntity InitFKTZSServiceManagerEntity(ApplyNoEntity applyNoEntity) { FKTZSServiceManagerEntity fktzsServiceManagerEntity = new FKTZSServiceManagerEntity(); //DICS06营业有偿 if (applyNoEntity.BasicEntity.FktzsYcWcType.YCWCType == FKTZSYCWCType.YC) { fktzsServiceManagerEntity.SetAccountPayableAdvanceReceivedAC().SetActualPayableAC().SetCostAdjustmentAC("SAPLinks.Bussiness.AfterSaleBussiness.YC.CostAdjustmentAC").SetInputVatAC(). SetInputVATDifferenceAdjustmentAC().SetInputVATDifferencesTurnOutCreditAC().SetInputVATDifferencesTurnOutDebtorAC(); } else { fktzsServiceManagerEntity.SetAccountPayableAdvanceReceivedAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.AccountPayableAdvanceReceivedAC"). SetActualPayableAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.ActualPayableAC").SetCostAdjustmentAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.CostAdjustmentAC"). SetInputVatAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.InputVatAC").SetInputVATDifferenceAdjustmentAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.InputVATDifferenceAdjustmentAC"). SetInputVATDifferencesTurnOutCreditAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.InputVATDifferencesTurnOutCreditAC").SetInputVATDifferencesTurnOutDebtorAC("SAPLinks.Bussiness.AfterSaleBussiness.WC.InputVATDifferencesTurnOutDebtorAC"); } return(fktzsServiceManagerEntity);//SAPLinks.Bussiness.AfterSaleBussiness }
private DataTable ExecuteQuery(ApplyNoEntity applyNoEntity, string query) { return(SQLHelper.ExecuteDataset(applyNoEntity.BasicEntity.ConnStr, CommandType.Text, query).Tables[0]); }
public KPSQEntityCollection Load(ApplyNoEntity applyNoEntity) { return(AggData(ExecuteQuery(applyNoEntity, StringFormat(applyNoEntity)))); }
public static FKTZS_C_HEntity Load(ApplyNoEntity applyNoEntity) { return(AggData(ExecuteQuery(applyNoEntity, StringFormat(applyNoEntity)))); }
public static FKTZSZYDEntityCollection Load(ApplyNoEntity applyNoEntity) { return(AggData(ExecuteQuery(applyNoEntity, StringFormat(applyNoEntity)))); }