/// <summary>
/// 插入数据到 AccountPayable 表
/// </summary>
protected void SetAccountPayable()
{
//Cash Advance 只需插入固定的两行记录到SAP中的两个表
for (int i = 1; i < 3; i++)
{
string SPGLIND = i == 1 ? "" : "V";
string ITEMTEXT = CurrentSapParameter.Header;
ACCOUNTPAYABLE accountPay = new ACCOUNTPAYABLE()
{
PMNTTRMS = (string.IsNullOrEmpty(SPGLIND) ? "*" : ""),
ITEMNO_ACC = i,
SP_GL_IND = SPGLIND,
ITEM_TEXT = ITEMTEXT,
PYMT_METH = CurrentSapParameter.PymtMeth,
REF_KEY_1 = CurrentSapParameter.RefDocNo,
VENDOR_NO = CurrentSapParameter.EmployeeID,
BUS_AREA = CurrentSapParameter.BusArea
};
InsertDataAccountPlayble(accountPay);
}
}
/// <summary>
/// 插入数据到第二个表：AccountPayable
/// </summary>
/// <param name="GlobalCount"></param>
/// <param name="SPGLIND"></param>
/// <param name="ITEMTEXT"></param>
protected virtual void SetAccountPayable(int globalCount, string SPGLIND, string REFKEY, string ALLOCNMBR, string ITEMTEXT)
{
ACCOUNTPAYABLE accountPay = new ACCOUNTPAYABLE()
{
PMNTTRMS = (string.IsNullOrEmpty(SPGLIND) ? "*" : ""),
ALLOC_NMBR = ALLOCNMBR,
SP_GL_IND = SPGLIND,
ITEM_TEXT = ITEMTEXT,
REF_KEY_1 = REFKEY,
ITEMNO_ACC = globalCount,
VENDOR_NO = CurrentSapParameter.EmployeeID,
BUS_AREA = CurrentSapParameter.BusArea
};
InsertDataAccountPlayble(accountPay);
}
private void SetAccountPayable(int INDEX, string SPGLIND, string ACCOUNTGL, string REFKEY, string ITEMTEXT, string ALLOCNMBR, string VENDORNO)
{
ACCOUNTPAYABLE accountPay = new ACCOUNTPAYABLE()
{
PMNTTRMS = (string.IsNullOrEmpty(SPGLIND) ? "*" : ""),
ITEMNO_ACC = INDEX,
SP_GL_IND = SPGLIND,
REF_KEY_1 = REFKEY,
GL_ACCOUNT = ACCOUNTGL,
ALLOC_NMBR = ALLOCNMBR,
ITEM_TEXT = ITEMTEXT,
VENDOR_NO = VENDORNO,
BUS_AREA = CurrentSapParameter.BusArea
};
InsertDataAccountPlayble(accountPay);
}
/// <summary>
/// 插入数据到SAP表：AccountPlayble
/// </summary>
/// <param name="accountPlayble"></param>
protected void InsertDataAccountPlayble(ACCOUNTPAYABLE accountPlayble)
{
IRfcTable rfcTableAccountPlayble = mCurrentRfcFunction.GetTable("ACCOUNTPAYABLE");
rfcTableAccountPlayble.Insert();
rfcTableAccountPlayble.CurrentRow.SetValue("ITEMNO_ACC", accountPlayble.ITEMNO_ACC);
rfcTableAccountPlayble.CurrentRow.SetValue("VENDOR_NO", accountPlayble.VENDOR_NO);
rfcTableAccountPlayble.CurrentRow.SetValue("GL_ACCOUNT", accountPlayble.GL_ACCOUNT);
rfcTableAccountPlayble.CurrentRow.SetValue("REF_KEY_1", accountPlayble.REF_KEY_1);
rfcTableAccountPlayble.CurrentRow.SetValue("REF_KEY_2", accountPlayble.REF_KEY_2);
rfcTableAccountPlayble.CurrentRow.SetValue("REF_KEY_3", accountPlayble.REF_KEY_3);
rfcTableAccountPlayble.CurrentRow.SetValue("COMP_CODE", accountPlayble.COMP_CODE);
rfcTableAccountPlayble.CurrentRow.SetValue("BUS_AREA", accountPlayble.BUS_AREA);
rfcTableAccountPlayble.CurrentRow.SetValue("PMNTTRMS", accountPlayble.PMNTTRMS);
rfcTableAccountPlayble.CurrentRow.SetValue("BLINE_DATE", accountPlayble.BLINE_DATE);
rfcTableAccountPlayble.CurrentRow.SetValue("DSCT_DAYS1", accountPlayble.DSCT_DAYS1);
rfcTableAccountPlayble.CurrentRow.SetValue("DSCT_DAYS2", accountPlayble.DSCT_DAYS2);
rfcTableAccountPlayble.CurrentRow.SetValue("NETTERMS", accountPlayble.NETTERMS);
rfcTableAccountPlayble.CurrentRow.SetValue("DSCT_PCT1", accountPlayble.DSCT_PCT1);
rfcTableAccountPlayble.CurrentRow.SetValue("DSCT_PCT2", accountPlayble.DSCT_PCT2);
rfcTableAccountPlayble.CurrentRow.SetValue("PYMT_METH", accountPlayble.PYMT_METH);
rfcTableAccountPlayble.CurrentRow.SetValue("PMTMTHSUPL", accountPlayble.PMTMTHSUPL);
rfcTableAccountPlayble.CurrentRow.SetValue("PMNT_BLOCK", accountPlayble.PMNT_BLOCK);
rfcTableAccountPlayble.CurrentRow.SetValue("SCBANK_IND", accountPlayble.SCBANK_IND);
rfcTableAccountPlayble.CurrentRow.SetValue("SUPCOUNTRY", accountPlayble.SUPCOUNTRY);
rfcTableAccountPlayble.CurrentRow.SetValue("SUPCOUNTRY_ISO", accountPlayble.SUPCOUNTRY_ISO);
rfcTableAccountPlayble.CurrentRow.SetValue("BLLSRV_IND", accountPlayble.BLLSRV_IND);
rfcTableAccountPlayble.CurrentRow.SetValue("ALLOC_NMBR", accountPlayble.ALLOC_NMBR);
rfcTableAccountPlayble.CurrentRow.SetValue("ITEM_TEXT", accountPlayble.ITEM_TEXT);
rfcTableAccountPlayble.CurrentRow.SetValue("PO_SUB_NO", accountPlayble.PO_SUB_NO);
rfcTableAccountPlayble.CurrentRow.SetValue("PO_CHECKDG", accountPlayble.PO_CHECKDG);
rfcTableAccountPlayble.CurrentRow.SetValue("PO_REF_NO", accountPlayble.PO_REF_NO);
rfcTableAccountPlayble.CurrentRow.SetValue("W_TAX_CODE", accountPlayble.W_TAX_CODE);
rfcTableAccountPlayble.CurrentRow.SetValue("BUSINESSPLACE", accountPlayble.BUSINESSPLACE);
rfcTableAccountPlayble.CurrentRow.SetValue("SECTIONCODE", accountPlayble.SECTIONCODE);
rfcTableAccountPlayble.CurrentRow.SetValue("INSTR1", accountPlayble.INSTR1);
rfcTableAccountPlayble.CurrentRow.SetValue("INSTR2", accountPlayble.INSTR2);
rfcTableAccountPlayble.CurrentRow.SetValue("INSTR3", accountPlayble.INSTR3);
rfcTableAccountPlayble.CurrentRow.SetValue("INSTR4", accountPlayble.INSTR4);
rfcTableAccountPlayble.CurrentRow.SetValue("BRANCH", accountPlayble.BRANCH);
rfcTableAccountPlayble.CurrentRow.SetValue("PYMT_CUR", accountPlayble.PYMT_CUR);
rfcTableAccountPlayble.CurrentRow.SetValue("PYMT_AMT", accountPlayble.PYMT_AMT);
rfcTableAccountPlayble.CurrentRow.SetValue("PYMT_CUR_ISO", accountPlayble.PYMT_CUR_ISO);
rfcTableAccountPlayble.CurrentRow.SetValue("SP_GL_IND", accountPlayble.SP_GL_IND);
rfcTableAccountPlayble.CurrentRow.SetValue("TAX_CODE", accountPlayble.TAX_CODE);
rfcTableAccountPlayble.CurrentRow.SetValue("TAX_DATE", accountPlayble.TAX_DATE);
rfcTableAccountPlayble.CurrentRow.SetValue("TAXJURCODE", accountPlayble.TAXJURCODE);
rfcTableAccountPlayble.CurrentRow.SetValue("ALT_PAYEE", accountPlayble.ALT_PAYEE);
rfcTableAccountPlayble.CurrentRow.SetValue("ALT_PAYEE_BANK", accountPlayble.ALT_PAYEE_BANK);
rfcTableAccountPlayble.CurrentRow.SetValue("PARTNER_BK", accountPlayble.PARTNER_BK);
rfcTableAccountPlayble.CurrentRow.SetValue("BANK_ID", accountPlayble.BANK_ID);
rfcTableAccountPlayble.CurrentRow.SetValue("PARTNER_GUID", accountPlayble.PARTNER_GUID);
rfcTableAccountPlayble.CurrentRow.SetValue("PROFIT_CTR", accountPlayble.PROFIT_CTR);
rfcTableAccountPlayble.CurrentRow.SetValue("FUND", accountPlayble.FUND);
rfcTableAccountPlayble.CurrentRow.SetValue("GRANT_NBR", accountPlayble.GRANT_NBR);
rfcTableAccountPlayble.CurrentRow.SetValue("MEASURE", accountPlayble.MEASURE);
rfcTableAccountPlayble.CurrentRow.SetValue("HOUSEBANKACCTID", accountPlayble.HOUSEBANKACCTID);
}