public static String ConcreateInsertCommand(APPR_GL_DETAIL source)
{
StringBuilder sqlCommand = new StringBuilder("INSERT INTO APPR_GL_DETAIL ");
sqlCommand.Append("(BRANCH_NO,DOC_TYPE,DOC_NO,DOC_DATE,SEQUENCE,DEPARTMENT,ACCOUNT_CODE,SUBSIDAIRY,ACTIVITY,GL_ACCOUNT,SECRET_ACCOUNT,DESCRIPTION1,DESCRIPTION2,DEBIT,CREDIT,LEDGER_TYPE,CURRENCY_TYPE,UNIT_TYPE,UNIT_AMOUNT,REF_AP,REF_AR,REF_FIXASSET,REF_CHECK_NO,REF_TAX_NO,STATUS_,USER_ID,DATE_UPDATE,DATE_POSTED,TIME_POSTED,REF_BUDGET_CODE,REF_PROJECT,BUD_ACCOUNT_CODE,REF_BUD_YEAR,UNIT_START,UNIT_END,PLAN_CODE,FUND_CODE,DEBIT_CREDIT,JOB_NO,CREATE_FROM_CANCEL,FLAG_CURRENCY,R_ACTIVITY,R_PROJECT,R_SECTION)");
sqlCommand.Append(" Values (");
sqlCommand.Append(BindValue(source.BRANCH_NO) + " ,");
sqlCommand.Append("'" + BindValue(source.DOC_TYPE) + "' ,");
sqlCommand.Append("'" + BindValue(source.DOC_NO) + "' ,");
sqlCommand.Append(BindValue(source.DOC_DATE) + ",");
sqlCommand.Append(BindValue(source.SEQUENCE) + " ,");
sqlCommand.Append("'" + BindValue(source.DEPARTMENT) + "' ,");
sqlCommand.Append("'" + BindValue(source.ACCOUNT_CODE) + "' ,");
sqlCommand.Append("'" + BindValue(source.SUBSIDAIRY) + "' ,");
sqlCommand.Append("'" + BindValue(source.ACTIVITY) + "' ,");
sqlCommand.Append("'" + BindValue(source.GL_ACCOUNT) + "' ,");
sqlCommand.Append(BindValue(source.SECRET_ACCOUNT) + " ,");
sqlCommand.Append("'" + BindValue(source.DESCRIPTION1) + "' ,");
sqlCommand.Append("'" + BindValue(source.DESCRIPTION2) + "' ,");
sqlCommand.Append(BindValue(source.DEBIT) + " ,");
sqlCommand.Append(BindValue(source.CREDIT) + " ,");
sqlCommand.Append("'" + BindValue(source.LEDGER_TYPE) + "' ,");
sqlCommand.Append("'" + BindValue(source.CURRENCY_TYPE) + "' ,");
sqlCommand.Append("'" + BindValue(source.UNIT_TYPE) + "' ,");
sqlCommand.Append(BindValue(source.UNIT_AMOUNT) + " ,");
sqlCommand.Append("'" + BindValue(source.REF_AP) + "' ,");
sqlCommand.Append("'" + BindValue(source.REF_AR) + "' ,");
sqlCommand.Append("'" + BindValue(source.REF_FIXASSET) + "' ,");
sqlCommand.Append("'" + BindValue(source.REF_CHECK_NO) + "' ,");
sqlCommand.Append("'" + BindValue(source.REF_TAX_NO) + "' ,");
sqlCommand.Append("'" + BindValue(source.STATUS_) + "' ,");
sqlCommand.Append("'" + BindValue(source.USER_ID) + "' ,");
sqlCommand.Append(BindValue(source.DATE_UPDATE) + ",");
sqlCommand.Append(BindValue(source.DATE_POSTED) + " ,");
sqlCommand.Append("'" + BindValue(source.TIME_POSTED) + "' ,");
sqlCommand.Append("'" + BindValue(source.REF_BUDGET_CODE) + "' ,");
sqlCommand.Append("'" + BindValue(source.REF_PROJECT) + "' ,");
sqlCommand.Append("'" + BindValue(source.BUD_ACCOUNT_CODE) + "' ,");
sqlCommand.Append(BindValue(source.REF_BUD_YEAR) + ",");
sqlCommand.Append(BindValue(source.UNIT_START) + " ,");
sqlCommand.Append(BindValue(source.UNIT_END) + " ,");
sqlCommand.Append("'" + BindValue(source.PLAN_CODE) + "' ,");
sqlCommand.Append("'" + BindValue(source.FUND_CODE) + "' ,");
sqlCommand.Append("'" + BindValue(source.DEBIT_CREDIT) + "' ,");
sqlCommand.Append("'" + BindValue(source.JOB_NO) + "' ,");
sqlCommand.Append(BindValue(source.CREATE_FROM_CANCEL) + " ,");
sqlCommand.Append(BindValue(source.FLAG_CURRENCY) + " ,");
sqlCommand.Append("'" + BindValue(source.R_ACTIVITY) + "' ,");
sqlCommand.Append("'" + BindValue(source.R_PROJECT) + "' ,");
sqlCommand.Append("'" + BindValue(source.R_SECTION) + "' )");
return(sqlCommand.ToString());
}
public void TestSelectDatabase()
{
APPR_DO_HEADER item = ctx.APPR_DO_HEADER.FirstOrDefault();
APPR_DO_DETAIL appr_do_details = ctx.APPR_DO_DETAIL.FirstOrDefault();
APPR_DO_ADDRESS appr_do_address = ctx.APPR_DO_ADDRESS.FirstOrDefault();
APPR_DO_REMARK appr_do_remark = ctx.APPR_DO_REMARK.FirstOrDefault();
APPR_RECEIVE_H appr_receive_h = ctx.APPR_RECEIVE_H.FirstOrDefault();
APPR_RECEIVE_DETAIL_D appr_receive_detail_d = ctx.APPR_RECEIVE_DETAIL_D.FirstOrDefault();
APPR_GL_HEADER appr_gl_header = ctx.APPR_GL_HEADER.FirstOrDefault();
APPR_GL_DETAIL appr_gl_detail = ctx.APPR_GL_DETAIL.FirstOrDefault();
APPR_DO_HEADER header = new APPR_DO_HEADER()
{
BRANCH_NO = 2,
SECTION = item.SECTION,
DOC_TYPE = item.DOC_TYPE,
DOC_NO = "12122e35451790",
DOC_DATE = item.DOC_DATE,
DESCRIPTION = item.DESCRIPTION,
AMOUNT_BEFORE_DISCOUNT = item.AMOUNT_BEFORE_DISCOUNT,
DISCOUNT_CREDIT_PATTERN = item.DISCOUNT_CREDIT_PATTERN,
DISCOUNT_CASH_PATTERN = item.DISCOUNT_CASH_PATTERN,
DISCOUNT_CREDIT = item.DISCOUNT_CREDIT,
DISCOUNT_CASH = item.DISCOUNT_CASH,
AMOUNT_BEFORE_VAT = item.AMOUNT_BEFORE_VAT,
VAT_RATE = item.VAT_RATE,
VAT_AMOUNT = item.VAT_AMOUNT,
TOTAL_AMOUNT = item.TOTAL_AMOUNT,
LEDGER_TYPE = item.LEDGER_TYPE,
EMP_CODE = item.EMP_CODE,
CUSTOMER_CODE = item.CUSTOMER_CODE,
CUSTOMER_CODE_SHIPTO = item.CUSTOMER_CODE_SHIPTO,
REFER_TYPE = item.REFER_TYPE,
REFER_NO = item.REFER_NO,
REFER_DATE = item.REFER_DATE,
LAST_LINE = item.LAST_LINE,
REMARK = item.REMARK,
STATUS = item.STATUS,
USER_ID = item.USER_ID,
TIME = item.TIME,
REF_BUDGET = item.REF_BUDGET,
REF_PROJECT = item.REF_PROJECT,
BUD_ACCOUNT_CODE = item.BUD_ACCOUNT_CODE,
REF_ACTIVITY = item.REF_ACTIVITY,
STATUS_APPROVE = item.STATUS_APPROVE,
REMARK_APPROVE = item.REMARK_APPROVE,
DATE_APPROVED = item.DATE_APPROVED,
BUD_YEAR = item.BUD_YEAR,
PAYMENT_TERM = item.PAYMENT_TERM,
DELIVERY_DATE = item.DELIVERY_DATE,
DUEDATE = item.DUEDATE,
TYPE_TAX = item.TYPE_TAX,
PAY_TYPE = item.PAY_TYPE,
INVOICE_TYPE = item.INVOICE_TYPE,
MEMBER_CODE = item.MEMBER_CODE,
SALE_TYPE = item.SALE_TYPE,
PAY_CASH = item.PAY_CASH,
PAY_OTHER = item.PAY_OTHER,
PAY_DEPOSIT = item.PAY_DEPOSIT,
TIME_PRINT = item.TIME_PRINT,
DATE_UPDATE = item.DATE_UPDATE,
AR_ACCOUNT = item.AR_ACCOUNT,
SHOW_DOC_DATE = item.SHOW_DOC_DATE,
TYPE_DISPOSE = item.TYPE_DISPOSE,
PREMIUM_AMOUNT = item.PREMIUM_AMOUNT,
PLAN_CODE = item.PLAN_CODE,
FUND_CODE = item.FUND_CODE,
};
ctx.APPR_DO_HEADER.AddObject(header);
ctx.SaveChanges();
ctx.APPR_DO_HEADER.DeleteObject(header);
ctx.SaveChanges();
//Assert.IsNotNull(header);
Assert.IsNotNull(appr_do_details);
Assert.IsNotNull(appr_do_address);
Assert.IsNotNull(appr_do_remark);
Assert.IsNotNull(appr_receive_h);
Assert.IsNotNull(appr_receive_detail_d);
Assert.IsNotNull(appr_gl_header);
Assert.IsNotNull(appr_gl_detail);
}
