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); }