Exemple #1
0
        public static String ConcreateInsertCommand(APPR_RECEIVE_DETAIL_D source)
        {
            StringBuilder sqlCommand = new StringBuilder("INSERT INTO APPR_RECEIVE_DETAIL_D ");

            sqlCommand.Append(" (BRANCH_NO,DOC_TYPE,DOC_NO,DOC_DATE,SEQUENCE,PAYMENT_GROUP,PAYMENT_CODE,REFER_NO,REFER_DATE,AMOUNT,USER_ID,DATE_UPDATE,TIME_UPDATE,DESCRIPTION,STATUS,FLAG_RECEIVE,RECEIVE_DATE,SLIP_NO,SLIP_DATE,ACCOUNT_CODE,RETURN_FLAG,RETURN_TYPE,RETURN_NO,RETURN_DATE,SENDING_FLAG,SENDING_TYPE,SENDING_NO,SENDING_DATE,REF_SEQUENCE_NO,SHOW_DOC_DATE)");

            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.PAYMENT_GROUP) + "' ,");
            sqlCommand.Append("'" + BindValue(source.PAYMENT_CODE) + "' ,");
            sqlCommand.Append("'" + BindValue(source.REFER_NO) + "' ,");
            sqlCommand.Append(BindValue(source.REFER_DATE) + ",");
            sqlCommand.Append(BindValue(source.AMOUNT) + " ,");
            sqlCommand.Append("'" + BindValue(source.USER_ID) + "' ,");
            sqlCommand.Append(BindValue(source.DATE_UPDATE) + ",");
            sqlCommand.Append("'" + BindValue(source.TIME_UPDATE) + "' ,");
            sqlCommand.Append("'" + BindValue(source.DESCRIPTION) + "' ,");
            sqlCommand.Append("'" + BindValue(source.STATUS) + "' ,");
            sqlCommand.Append(BindValue(source.FLAG_RECEIVE) + " ,");
            sqlCommand.Append(BindValue(source.RECEIVE_DATE) + ",");
            sqlCommand.Append("'" + BindValue(source.SLIP_NO) + "' ,");
            sqlCommand.Append(BindValue(source.SLIP_DATE) + ",");
            sqlCommand.Append("'" + BindValue(source.ACCOUNT_CODE) + "' ,");
            sqlCommand.Append(BindValue(source.RETURN_FLAG) + " ,");
            sqlCommand.Append("'" + BindValue(source.RETURN_TYPE) + "' ,");
            sqlCommand.Append("'" + BindValue(source.RETURN_NO) + "' ,");
            sqlCommand.Append(BindValue(source.RETURN_DATE) + ",");
            sqlCommand.Append(BindValue(source.SENDING_FLAG) + " ,");
            sqlCommand.Append("'" + BindValue(source.SENDING_TYPE) + "' ,");
            sqlCommand.Append("'" + BindValue(source.SENDING_NO) + "' ,");
            sqlCommand.Append(BindValue(source.SENDING_DATE) + ",");
            sqlCommand.Append(BindValue(source.REF_SEQUENCE_NO) + " ,");
            sqlCommand.Append(BindValue(source.SHOW_DOC_DATE) + ")");

            return(sqlCommand.ToString());
        }
Exemple #2
0
        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);
        }