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); }
public static String ConcreateInsertCommand(APPR_DO_HEADER source) { StringBuilder sqlCommand = new StringBuilder("INSERT INTO APPR_DO_HEADER "); sqlCommand.Append(" (BRANCH_NO,SECTION,DOC_TYPE,DOC_NO,DOC_DATE,DESCRIPTION,AMOUNT_BEFORE_DISCOUNT,DISCOUNT_CREDIT_PATTERN,DISCOUNT_CASH_PATTERN,DISCOUNT_CREDIT,DISCOUNT_CASH,AMOUNT_BEFORE_VAT,VAT_RATE,VAT_AMOUNT,TOTAL_AMOUNT,LEDGER_TYPE,EMP_CODE,CUSTOMER_CODE,CUSTOMER_CODE_SHIPTO,REFER_TYPE,REFER_NO,REFER_DATE,LAST_LINE,REMARK,STATUS,USER_ID,TIME,REF_BUDGET,REF_PROJECT,BUD_ACCOUNT_CODE,REF_ACTIVITY,STATUS_APPROVE,REMARK_APPROVE,DATE_APPROVED,BUD_YEAR,PAYMENT_TERM,DELIVERY_DATE,DUEDATE,TYPE_TAX,PAY_TYPE,INVOICE_TYPE,MEMBER_CODE,SALE_TYPE,PAY_CASH,PAY_OTHER,PAY_DEPOSIT,TIME_PRINT,DATE_UPDATE,AR_ACCOUNT,SHOW_DOC_DATE,TYPE_DISPOSE,PREMIUM_AMOUNT,PLAN_CODE,FUND_CODE ) "); sqlCommand.Append(" Values ("); sqlCommand.Append(BindValue(source.BRANCH_NO) + " ,"); sqlCommand.Append("'" + BindValue(source.SECTION) + "' ,"); sqlCommand.Append("'" + BindValue(source.DOC_TYPE) + "' ,"); sqlCommand.Append("'" + BindValue(source.DOC_NO) + "' ,"); sqlCommand.Append(BindValue(source.DOC_DATE) + " ,"); sqlCommand.Append("'" + BindValue(source.DESCRIPTION) + "' ,"); sqlCommand.Append(BindValue(source.AMOUNT_BEFORE_DISCOUNT) + " ,"); sqlCommand.Append("'" + BindValue(source.DISCOUNT_CREDIT_PATTERN) + "' ,"); sqlCommand.Append("'" + BindValue(source.DISCOUNT_CASH_PATTERN) + "' ,"); sqlCommand.Append(BindValue(source.DISCOUNT_CREDIT) + " ,"); sqlCommand.Append(BindValue(source.DISCOUNT_CASH) + " ,"); sqlCommand.Append(BindValue(source.AMOUNT_BEFORE_VAT) + " ,"); sqlCommand.Append(BindValue(source.VAT_RATE) + " ,"); sqlCommand.Append(BindValue(source.VAT_AMOUNT) + " ,"); sqlCommand.Append(BindValue(source.TOTAL_AMOUNT) + " ,"); sqlCommand.Append("'" + BindValue(source.LEDGER_TYPE) + "' ,"); sqlCommand.Append("'" + BindValue(source.EMP_CODE) + "' ,"); sqlCommand.Append("'" + BindValue(source.CUSTOMER_CODE) + "' ,"); sqlCommand.Append("'" + BindValue(source.CUSTOMER_CODE_SHIPTO) + "' ,"); sqlCommand.Append("'" + BindValue(source.REFER_TYPE) + "' ,"); sqlCommand.Append("'" + BindValue(source.REFER_NO) + "' ,"); sqlCommand.Append(BindValue(source.REFER_DATE) + " ,"); sqlCommand.Append(BindValue(source.LAST_LINE) + " ,"); sqlCommand.Append("'" + BindValue(source.REMARK) + "' ,"); sqlCommand.Append("'" + BindValue(source.STATUS) + "' ,"); sqlCommand.Append("'" + BindValue(source.USER_ID) + "' ,"); sqlCommand.Append("'" + BindValue(source.TIME) + "' ,"); sqlCommand.Append("'" + BindValue(source.REF_BUDGET) + "' ,"); sqlCommand.Append("'" + BindValue(source.REF_PROJECT) + "' ,"); sqlCommand.Append("'" + BindValue(source.BUD_ACCOUNT_CODE) + "' ,"); sqlCommand.Append("'" + BindValue(source.REF_ACTIVITY) + "' ,"); sqlCommand.Append("'" + BindValue(source.STATUS_APPROVE) + "' ,"); sqlCommand.Append("'" + BindValue(source.REMARK_APPROVE) + "' ,"); sqlCommand.Append(BindValue(source.DATE_APPROVED) + " ,"); sqlCommand.Append(BindValue(source.BUD_YEAR) + " ,"); sqlCommand.Append(BindValue(source.PAYMENT_TERM) + " ,"); sqlCommand.Append(BindValue(source.DELIVERY_DATE) + " ,"); sqlCommand.Append(BindValue(source.DUEDATE) + " ,"); sqlCommand.Append("'" + BindValue(source.TYPE_TAX) + "' ,"); sqlCommand.Append("'" + BindValue(source.PAY_TYPE) + "' ,"); sqlCommand.Append("'" + BindValue(source.INVOICE_TYPE) + "' ,"); sqlCommand.Append("'" + BindValue(source.MEMBER_CODE) + "' ,"); sqlCommand.Append("'" + BindValue(source.SALE_TYPE) + "' ,"); sqlCommand.Append(BindValue(source.PAY_CASH) + " ,"); sqlCommand.Append(BindValue(source.PAY_OTHER) + " ,"); sqlCommand.Append(BindValue(source.PAY_DEPOSIT) + " ,"); sqlCommand.Append(BindValue(source.TIME_PRINT) + " ,"); sqlCommand.Append(BindValue(source.DATE_UPDATE) + ","); sqlCommand.Append("'" + BindValue(source.AR_ACCOUNT) + "' ,"); sqlCommand.Append(BindValue(source.SHOW_DOC_DATE) + ","); sqlCommand.Append("'" + BindValue(source.TYPE_DISPOSE) + "' ,"); sqlCommand.Append(BindValue(source.PREMIUM_AMOUNT) + " ,"); sqlCommand.Append("'" + BindValue(source.PLAN_CODE) + "' ,"); sqlCommand.Append("'" + BindValue(source.FUND_CODE) + "' )"); return(sqlCommand.ToString()); }