private BOL_INVOICE_INFO Cast_INVOICE_INFO(DataRow row, string TRANSACTION_TYPE) { int count; //List<BOL_INVOICE_INFO> INVOICE_INFO_LIST = new List<BOL_INVOICE_INFO>(); BOL_INVOICE_INFO oINVOICE_INFO = new BOL_INVOICE_INFO(); #region cmt //int Key_source_Monthly_usage_fee_REQ_SEQ =row["TRANSACTION_TYPE"].ToString() ; //int Supplier_Initial_expense_REQ_SEQ; //int Supplier_Monthly_usage_fee_REQ_SEQ; //int Production_information_browsing_Initial_expense_REQ_SEQ; //int View_production_information_Annual_usage_fee_REQ_SEQ; //if (Key_source_Monthly_usage_fee_REQ_SEQ>0) //{ // oINVOICE_INFO.TRANSACTION_TYPE = "12"; // INVOICE_INFO_LIST.Add(oINVOICE_INFO); //} //if(Supplier_Initial_expense_REQ_SEQ > 0) //{ //} #endregion oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString(); return(oINVOICE_INFO); }
public void UpdateInvoice_Info(BOL_INVOICE_INFO B_InvoiceInfo, out string strMessage) { strMessage = ""; ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateInvoice); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATION_TOTAL_AMOUNT", B_InvoiceInfo.ALLOCATION_TOTAL_AMOUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_COMPLETION_DATE", B_InvoiceInfo.ALLOCATED_COMPLETION_DATE != null ? B_InvoiceInfo.ALLOCATED_COMPLETION_DATE : (object)DBNull.Value)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", B_InvoiceInfo.TYPE_OF_ALLOCATION)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_DEPOSIT_YYMM", B_InvoiceInfo.STATUS_ACTUAL_DEPOSIT_YYMM)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_DEPOSIT_DATE", B_InvoiceInfo.STATUS_ACTUAL_DEPOSIT_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", B_InvoiceInfo.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@YEAR_MONTH", B_InvoiceInfo.YEAR_MONTH)); oMaster.ExcuteQuery(2, out strMessage); }
public void UpdateInvoiceFor37(BOL_INVOICE_INFO B_InvoiceInfo, out string strMessage) { strMessage = ""; ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdateInvoiceFor37); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_CASH_FORECAST_MM", B_InvoiceInfo.STATUS_CASH_FORECAST_MM)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PLAN_DEPOSIT_YYMM", B_InvoiceInfo.STATUS_PLAN_DEPOSIT_YYMM)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_MDB_UPDATE", (B_InvoiceInfo.STATUS_ACTUAL_MDB_UPDATE != null ? Convert.ToDateTime(B_InvoiceInfo.STATUS_ACTUAL_MDB_UPDATE).ToString("yyyy-MM-dd") : (object)DBNull.Value))); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACC_RECEIVABLE_DATE", (B_InvoiceInfo.STATUS_ACC_RECEIVABLE_DATE != null ? Convert.ToDateTime(B_InvoiceInfo.STATUS_ACC_RECEIVABLE_DATE).ToString("yyyy-MM-dd") : (object)DBNull.Value))); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DUNNING_COUNT", B_InvoiceInfo.DUNNING_COUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DUNNING_DATE", (B_InvoiceInfo.DUNNING_DATE != null ? Convert.ToDateTime(B_InvoiceInfo.DUNNING_DATE).ToString("yyyy-MM-dd") : (object)DBNull.Value))); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ANSWER_DATE", (B_InvoiceInfo.ANSWER_DATE != null ? Convert.ToDateTime(B_InvoiceInfo.ANSWER_DATE).ToString("yyyy-MM-dd") : (object)DBNull.Value))); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DUE_DATE", (B_InvoiceInfo.PAYMENT_DUE_DATE != null ? Convert.ToDateTime(B_InvoiceInfo.PAYMENT_DUE_DATE).ToString("yyyy-MM-dd") : (object)DBNull.Value))); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ANSWER_MEMO", B_InvoiceInfo.ANSWER_MEMO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", B_InvoiceInfo.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@YEAR_MONTH", B_InvoiceInfo.YEAR_MONTH)); oMaster.ExcuteQuery(2, out strMessage); }
private void PrepareDataForUpdate(DataRow dtReceiptDetail_Customer, DataTable dtBatch_Invoice, DateTime run_date) { decimal ALLOCATED_MONEY = 0; decimal.TryParse((dtReceiptDetail_Customer["ALLOCATED_MONEY"] == null ? "" : dtReceiptDetail_Customer["ALLOCATED_MONEY"].ToString()), out ALLOCATED_MONEY); decimal DEPOSIT_AMOUNT = 0; decimal.TryParse((dtReceiptDetail_Customer["DEPOSIT_AMOUNT"] == null ? "" : dtReceiptDetail_Customer["DEPOSIT_AMOUNT"].ToString()), out DEPOSIT_AMOUNT); decimal decAvailableAmount = DEPOSIT_AMOUNT - ALLOCATED_MONEY; int SEQ_NO = 0; int.TryParse((dtReceiptDetail_Customer["SEQ_NO"] == null ? "" : dtReceiptDetail_Customer["SEQ_NO"].ToString()), out SEQ_NO); DateTime DEPOSIT_DATE; DateTime.TryParse((dtReceiptDetail_Customer["DEPOSIT_AMOUNT"] == null ? "" : dtReceiptDetail_Customer["DEPOSIT_DATE"].ToString()), out DEPOSIT_DATE); int ALLOCATED_QUANTITY = 0; int.TryParse((dtReceiptDetail_Customer["ALLOCATED_QUANTITY"] == null ? "" : dtReceiptDetail_Customer["ALLOCATED_QUANTITY"].ToString()), out ALLOCATED_QUANTITY); decimal CalculateForType = 0; if (decAvailableAmount != 0) { BOL_RECEIPT_DETAILS oRECEIPT_DETAILS = new BOL_RECEIPT_DETAILS(); oRECEIPT_DETAILS.ALLOCATED_QUANTITY = ALLOCATED_QUANTITY; oRECEIPT_DETAILS.ALLOCATED_MONEY = ALLOCATED_MONEY; //20201117_追加_ALLOCATED_MONEYを初期値でセット #region Prepare Invoice, Reserve Info and Receipt Detail for (int i = 0; i < dtBatch_Invoice.Rows.Count; i++) { //BILL PRICE decimal BILL_PRICE = 0; decimal.TryParse((dtBatch_Invoice.Rows[i]["BILL_PRICE"] == null ? "" : dtBatch_Invoice.Rows[i]["BILL_PRICE"].ToString()), out BILL_PRICE); //ALLOCATATION TOTAL AMOUNT calculate decimal ALLOCATION_TOTAL_AMOUNT = 0; decimal.TryParse((dtBatch_Invoice.Rows[i]["ALLOCATION_TOTAL_AMOUNT"] == null ? "" : dtBatch_Invoice.Rows[i]["ALLOCATION_TOTAL_AMOUNT"].ToString()), out ALLOCATION_TOTAL_AMOUNT); //BILL TRANSFER FEE decimal BILL_TRANSFER_FEE = 0; decimal.TryParse((dtBatch_Invoice.Rows[i]["BILL_TRANSFER_FEE"] == null ? "" : dtBatch_Invoice.Rows[i]["BILL_TRANSFER_FEE"].ToString()), out BILL_TRANSFER_FEE); string strYear_Month = (dtBatch_Invoice.Rows[i]["YEAR_MONTH"] == null ? "" : dtBatch_Invoice.Rows[i]["YEAR_MONTH"].ToString()); string strCompanyNoBox = (dtBatch_Invoice.Rows[i]["COMPANY_NO_BOX"] == null ? "" : dtBatch_Invoice.Rows[i]["COMPANY_NO_BOX"].ToString()); CalculateForType = BILL_PRICE - ALLOCATION_TOTAL_AMOUNT + BILL_TRANSFER_FEE; CalculateForType = (CalculateForType < 0 ? CalculateForType * -1 : CalculateForType); BOL_RESERVE_INFO oRESERVE_INFO = new BOL_RESERVE_INFO(); BOL_INVOICE_INFO oInvoiceInfo = new BOL_INVOICE_INFO(); if (decAvailableAmount >= CalculateForType) //Type A { //Prepare Update For Invoice oInvoiceInfo.ALLOCATION_TOTAL_AMOUNT = ALLOCATION_TOTAL_AMOUNT + CalculateForType; oInvoiceInfo.ALLOCATED_COMPLETION_DATE = run_date; oInvoiceInfo.YEAR_MONTH = strYear_Month; oInvoiceInfo.COMPANY_NO_BOX = strCompanyNoBox; oInvoiceInfo.TYPE_OF_ALLOCATION = 1; oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_YYMM = DEPOSIT_DATE.ToString("yyMM"); oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_DATE = DEPOSIT_DATE.ToString("yyyy-MM-dd"); lstInvoiceInfo.Add(oInvoiceInfo); //Prepare Insert For Reserve Info oRESERVE_INFO.SEQ_NO = SEQ_NO; oRESERVE_INFO.BILLING_CODE = strCompanyNoBox + strYear_Month; oRESERVE_INFO.PAYMENT_DAY = run_date; oRESERVE_INFO.TYPE_OF_ALLOCATION = 1; oRESERVE_INFO.RESERVE_AMOUNT = CalculateForType; oRESERVE_INFO.DIFF_ALLOCATION_AMOUNT = decAvailableAmount - CalculateForType; lstReserveInfo.Add(oRESERVE_INFO); //Prepare Update for receipt detail oRECEIPT_DETAILS.ALLOCATED_MONEY += CalculateForType; if (DEPOSIT_AMOUNT == oRECEIPT_DETAILS.ALLOCATED_MONEY) { oRECEIPT_DETAILS.ALLOCATED_COMPLETION_DATE = run_date; } oRECEIPT_DETAILS.SEQ_NO = SEQ_NO; oRECEIPT_DETAILS.PAYMENT_DAY = run_date; oRECEIPT_DETAILS.TYPE_OF_ALLOCATION = 1; oRECEIPT_DETAILS.ALLOCATED_QUANTITY += 1; lstReceiptDetail.Add(oRECEIPT_DETAILS); decAvailableAmount = decAvailableAmount - CalculateForType; } else if (decAvailableAmount < CalculateForType) //Type B { //Prepare Update For Invoice Info oInvoiceInfo.ALLOCATION_TOTAL_AMOUNT = ALLOCATION_TOTAL_AMOUNT + decAvailableAmount; if (CalculateForType == 0) { oInvoiceInfo.ALLOCATED_COMPLETION_DATE = run_date; } oInvoiceInfo.YEAR_MONTH = strYear_Month; oInvoiceInfo.COMPANY_NO_BOX = strCompanyNoBox; oInvoiceInfo.TYPE_OF_ALLOCATION = 1; oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_YYMM = DEPOSIT_DATE.ToString("yyMM"); oInvoiceInfo.STATUS_ACTUAL_DEPOSIT_DATE = DEPOSIT_DATE.ToString("yyyy-MM-dd"); lstInvoiceInfo.Add(oInvoiceInfo); //Prepare Insert For Reserve Info oRESERVE_INFO.SEQ_NO = SEQ_NO; oRESERVE_INFO.BILLING_CODE = strCompanyNoBox + strYear_Month; oRESERVE_INFO.PAYMENT_DAY = run_date; oRESERVE_INFO.TYPE_OF_ALLOCATION = 1; oRESERVE_INFO.RESERVE_AMOUNT = decAvailableAmount; oRESERVE_INFO.DIFF_ALLOCATION_AMOUNT = decAvailableAmount - CalculateForType; lstReserveInfo.Add(oRESERVE_INFO); //Prepare Update for Receipt Detail oRECEIPT_DETAILS.ALLOCATED_COMPLETION_DATE = run_date; oRECEIPT_DETAILS.ALLOCATED_MONEY = DEPOSIT_AMOUNT; oRECEIPT_DETAILS.SEQ_NO = SEQ_NO; oRECEIPT_DETAILS.PAYMENT_DAY = run_date; oRECEIPT_DETAILS.TYPE_OF_ALLOCATION = 1; oRECEIPT_DETAILS.ALLOCATED_QUANTITY += 1; lstReceiptDetail.Add(oRECEIPT_DETAILS); decAvailableAmount = decAvailableAmount - CalculateForType; } ALLOCATED_MONEY += oRECEIPT_DETAILS.ALLOCATED_MONEY; if (oRECEIPT_DETAILS.ALLOCATED_COMPLETION_DATE != null) { break; } } #endregion RECEIPT_DETAILS oRCP = new RECEIPT_DETAILS(Properties.Settings.Default.MyConnection); INVOICE_INFO oInv = new INVOICE_INFO(Properties.Settings.Default.MyConnection); RESERVE_INFO oReseve = new RESERVE_INFO(Properties.Settings.Default.MyConnection); string strMessage = ""; for (int i = 0; i < lstReceiptDetail.Count; i++) { oRCP.UpdateReceipt_Detail(lstReceiptDetail[i], out strMessage); } for (int i = 0; i < lstInvoiceInfo.Count; i++) { oInv.UpdateInvoice_Info(lstInvoiceInfo[i], out strMessage); } for (int i = 0; i < lstReserveInfo.Count; i++) { oReseve.insert(lstReserveInfo[i], out strMessage); } } }
public string CreateInvoiceData(string BILLING_DATE, string status) { string errorStatus = ""; using (TransactionScope dbTxn = new TransactionScope()) { try { int OFFSET = 0; int LIMIT = 0; String strMessage = ""; int TOTAL; int countForInsert = 0; string checkGetOrCreate = "CREATE"; DateTime yearMonth = Convert.ToDateTime(BILLING_DATE); String YEAR_MONTH = yearMonth.ToString("yyyyMM"); if (InvoiceAllocationAmountCheck(BILLING_DATE)) { errorStatus = "3"; return(errorStatus); } if (status == "1") { //delete Existing Invoice List bool checkDelete = HandleDelete(BILLING_DATE); if (!checkDelete) { errorStatus = "0"; return(errorStatus); } } //Select Invoice Data INVOICE_INFO DAL_INVOICE_INFO = new INVOICE_INFO(con); DataTable dt = DAL_INVOICE_INFO.GetInvoiceList(YEAR_MONTH, OFFSET, LIMIT, checkGetOrCreate, out strMessage, out TOTAL); for (int i = 0; i < dt.Rows.Count; i++) { decimal Key_source_Monthly_usage_fee_REQ_SEQ = 0; decimal Supplier_Initial_expense_REQ_SEQ = 0; decimal Supplier_Monthly_usage_fee_REQ_SEQ = 0; decimal Production_information_browsing_Initial_expense_REQ_SEQ = 0; decimal View_production_information_Annual_usage_fee_REQ_SEQ = 0; DataRow row = dt.Rows[i]; if (!string.IsNullOrEmpty(row["Key_source_Monthly_usage_fee"].ToString())) { Key_source_Monthly_usage_fee_REQ_SEQ = Convert.ToDecimal(row["Key_source_Monthly_usage_fee"].ToString()); } if (!string.IsNullOrEmpty(row["Supplier_Initial_expense"].ToString())) { Supplier_Initial_expense_REQ_SEQ = Convert.ToDecimal(row["Supplier_Initial_expense"].ToString()); } if (!string.IsNullOrEmpty(row["Supplier_Monthly_usage_fee"].ToString())) { Supplier_Monthly_usage_fee_REQ_SEQ = Convert.ToDecimal(row["Supplier_Monthly_usage_fee"].ToString()); } if (!string.IsNullOrEmpty(row["Production_information_browsing_Initial_expense"].ToString())) { Production_information_browsing_Initial_expense_REQ_SEQ = Convert.ToDecimal(row["Production_information_browsing_Initial_expense"].ToString()); } if (!string.IsNullOrEmpty(row["Viewing_production_information_Annual_usage_fee"].ToString())) { View_production_information_Annual_usage_fee_REQ_SEQ = Convert.ToDecimal(row["Viewing_production_information_Annual_usage_fee"].ToString()); } BOL_INVOICE_INFO oINVOICE_INFO = new BOL_INVOICE_INFO(); #region Set value in Model oINVOICE_INFO.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString(); oINVOICE_INFO.INVOICE_DATE = DateTime.Now; oINVOICE_INFO.NCS_CUSTOMER_CODE = row["NCS_CUSTOMER_CODE"].ToString(); oINVOICE_INFO.BILL_SUPPLIER_NAME = row["BILL_COMPANY_NAME"].ToString(); oINVOICE_INFO.BILL_SUPPLIER_NAME_READING = row["COMPANY_NAME_READING"].ToString(); oINVOICE_INFO.BILL_COMPANY_NAME = row["COMPANY_NAME"].ToString(); oINVOICE_INFO.BILL_DEPARTMENT_IN_CHARGE = row["BILL_DEPARTMENT_IN_CHARGE"].ToString(); oINVOICE_INFO.BILL_CONTACT_NAME = row["BILL_CONTACT_NAME"].ToString(); oINVOICE_INFO.BILL_HONORIFIC = "様"; oINVOICE_INFO.BILL_POSTAL_CODE = row["BILL_POSTAL_CODE"].ToString(); oINVOICE_INFO.BILL_ADDRESS = row["BILL_ADDRESS"].ToString(); oINVOICE_INFO.BILL_ADDRESS_2 = row["BILL_ADDRESS_BUILDING"].ToString(); string CONTRACT_PLAN = row["CONTRACT_PLAN"].ToString(); if (CONTRACT_PLAN == "SERVER") { oINVOICE_INFO.PLAN_SERVER = 1; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 0; } if (CONTRACT_PLAN == "SERVERRIGHT") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 1; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 0; } if (CONTRACT_PLAN == "BROWSERAUTO") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 1; oINVOICE_INFO.PLAN_BROWSER = 0; } if (CONTRACT_PLAN == "BROWSER") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 1; } if (CONTRACT_PLAN == "PRODUCT") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 0; } oINVOICE_INFO.PLAN_AMIGO_CAI = Utility_Component.dtColumnToInt(row["OP_AMIGO_CAI"].ToString()); oINVOICE_INFO.PLAN_AMIGO_BIZ = Utility_Component.dtColumnToInt(row["OP_AMIGO_BIZ"].ToString()); oINVOICE_INFO.PLAN_ADD_BOX_SERVER = Utility_Component.dtColumnToInt(row["OP_BOX_SERVER"].ToString()); oINVOICE_INFO.PLAN_ADD_BOX_BROWSER = Utility_Component.dtColumnToInt(row["OP_BOX_BROWSER"].ToString()); oINVOICE_INFO.PLAN_OP_FLAT = Utility_Component.dtColumnToInt(row["OP_FLAT"].ToString()); oINVOICE_INFO.PLAN_OP_SSL = Utility_Component.dtColumnToInt(row["OP_CLIENT"].ToString()); oINVOICE_INFO.PLAN_OP_BASIC_SERVICE = Utility_Component.dtColumnToInt(row["OP_BASIC_SERVICE"].ToString()); oINVOICE_INFO.PLAN_OP_ADD_SERVICE = Utility_Component.dtColumnToInt(row["OP_ADD_SERVICE"].ToString()); if (row["SOCIOS_USER_FLG"].ToString() == " ") { oINVOICE_INFO.PLAN_OP_SOCIOS = 0; } if (row["SOCIOS_USER_FLG"].ToString() == "*") { oINVOICE_INFO.PLAN_OP_SOCIOS = 1; } oINVOICE_INFO.BILL_DEPOSIT_RULES = row["BILL_DEPOSIT_RULES"].ToString(); oINVOICE_INFO.BILL_TRANSFER_FEE = Utility_Component.dtColumnToDecimal(row["BILL_TRANSFER_FEE"].ToString()); oINVOICE_INFO.BILL_EXPENSES = Utility_Component.dtColumnToDecimal(row["BILL_EXPENSES"].ToString()); DateTime date = Convert.ToDateTime(BILLING_DATE); var lastDateOfMonth = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month)).ToString("dd"); var lastDay = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month)).DayOfWeek; var BILL_DATE = BILLING_DATE + "/" + lastDateOfMonth; DateTime PaymentDay = Convert.ToDateTime(BILL_DATE); string strPaymentDay = ""; if (lastDay.ToString() == "Saturday") { strPaymentDay = PaymentDay.AddDays(-1).ToString(); } if (lastDay.ToString() == "Sunday") { strPaymentDay = PaymentDay.AddDays(-2).ToString(); } if (lastDay.ToString() != "Saturday" && lastDay.ToString() != "Sunday") { strPaymentDay = PaymentDay.ToString(); } oINVOICE_INFO.BILL_PAYMENT_DATE = Utility_Component.dtColumnToDateTime(strPaymentDay); oINVOICE_INFO.STATUS_PRINT = null; oINVOICE_INFO.STATUS_MEMO = null; oINVOICE_INFO.STATUS_SEND = null; oINVOICE_INFO.STATUS_MAIL_DATE = null; //declare check oINVOICE_INFO.STATUS_ACC_RECEIVABLE_DATE = null; oINVOICE_INFO.STATUS_INVOCE_COPY_DATE = null; oINVOICE_INFO.STATUS_ACTUAL_MDB_UPDATE = null; oINVOICE_INFO.STATUS_ACTUAL_DEPOSIT_YYMM = null; oINVOICE_INFO.STATUS_ACTUAL_DEPOSIT_DATE = null; oINVOICE_INFO.STATUS_CASH_FORECAST_MM = null; //need to change set value string depositRuleCheck = row["BILL_DEPOSIT_RULES"].ToString(); if (depositRuleCheck == "0") { oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = date.AddMonths(1).ToString("yyMM"); } if (depositRuleCheck == "1") { oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = date.ToString("yyMM"); } if (depositRuleCheck == "2") { oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = date.AddMonths(2).ToString("yyMM"); } //oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = row["BILL_SUPPLIER_NAME"].ToString(); oINVOICE_INFO.STATUS_PAY_NOTICE_DATE = null; oINVOICE_INFO.TYPE_OF_ALLOCATION = 0; oINVOICE_INFO.ALLOCATION_TOTAL_AMOUNT = 0; oINVOICE_INFO.ALLOCATED_COMPLETION_DATE = null; oINVOICE_INFO.DUNNING_COUNT = 0; oINVOICE_INFO.DUNNING_DATE = null; oINVOICE_INFO.ANSWER_DATE = null; oINVOICE_INFO.PAYMENT_DUE_DATE = null; oINVOICE_INFO.ANSWER_MEMO = null; oINVOICE_INFO.SPECIAL_NOTES_1 = null; oINVOICE_INFO.SPECIAL_NOTES_2 = null; oINVOICE_INFO.SPECIAL_NOTES_3 = null; oINVOICE_INFO.SPECIAL_NOTES_4 = null; #endregion if (Key_source_Monthly_usage_fee_REQ_SEQ > 0) { string TRANSACTION_TYPE = "12"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM"); oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Key_source_Monthly_usage_fee"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Key_source_Monthly_usage_fee_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Key_source_Monthly_usage_fee_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } if (Supplier_Initial_expense_REQ_SEQ > 0) { string TRANSACTION_TYPE = "21"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM") + "IC"; oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Supplier_Initial_expense"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Supplier_Initial_expense_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Supplier_Initial_expense_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } if (Supplier_Monthly_usage_fee_REQ_SEQ > 0) { string TRANSACTION_TYPE = "22"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM"); oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Supplier_Monthly_usage_fee"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Supplier_Monthly_usage_fee_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Supplier_Monthly_usage_fee_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } if (Production_information_browsing_Initial_expense_REQ_SEQ > 0 || View_production_information_Annual_usage_fee_REQ_SEQ > 0) { string TRANSACTION_TYPE = "32"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM"); oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Production_information_browsing_Initial_expense"].ToString()) + Utility_Component.dtColumnToDecimal(row["Viewing_production_information_Annual_usage_fee"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Production_information_browsing_Initial_expense_TAX"].ToString()) + Utility_Component.dtColumnToDecimal(row["View_production_information_Annual_usage_fee_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Production_information_browsing_Initial_expense_INCLUDING_TAX"].ToString()) + Utility_Component.dtColumnToDecimal(row["View_production_information_Annual_usage_fee_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } } if (string.IsNullOrEmpty(strMessage) && countForInsert > 0) { errorStatus = "1," + countForInsert; dbTxn.Complete(); } else { errorStatus = "2"; } } catch (Exception ex) { errorStatus = "2"; } } return(errorStatus); }
public Response UpdateInvoice_37(string strData) { try { DataTable dt = Utility.Utility_Component.JsonToDt(strData); string strError = ""; for (int i = 0; i < dt.Rows.Count; i++) { string STATUS_CASH_FORECAST_MM = (dt.Rows[i]["STATUS_CASH_FORECAST_MM"] == null ? "" : dt.Rows[i]["STATUS_CASH_FORECAST_MM"].ToString()); string STATUS_PLAN_DEPOSIT_YYMM = (dt.Rows[i]["STATUS_PLAN_DEPOSIT_YYMM"] == null ? "" : dt.Rows[i]["STATUS_PLAN_DEPOSIT_YYMM"].ToString()); string STATUS_ACTUAL_MDB_UPDATE = (dt.Rows[i]["STATUS_ACTUAL_MDB_UPDATE"] == null ? "" : dt.Rows[i]["STATUS_ACTUAL_MDB_UPDATE"].ToString()); string STATUS_ACC_RECEIVABLE_DATE = (dt.Rows[i]["STATUS_ACC_RECEIVABLE_DATE"] == null ? "" : dt.Rows[i]["STATUS_ACC_RECEIVABLE_DATE"].ToString()); string DUNNING_DATE = (dt.Rows[i]["DUNNING_DATE"] == null ? null : dt.Rows[i]["DUNNING_DATE"].ToString()); string ANSWER_DATE = (dt.Rows[i]["ANSWER_DATE"] == null ? null : dt.Rows[i]["ANSWER_DATE"].ToString()); string PAYMENT_DUE_DATE = (dt.Rows[i]["PAYMENT_DUE_DATE"] == null ? null : dt.Rows[i]["PAYMENT_DUE_DATE"].ToString()); string ANSWER_MEMO = (dt.Rows[i]["ANSWER_MEMO"] == null ? "" : dt.Rows[i]["ANSWER_MEMO"].ToString()); string COMPANY_NO_BOX = dt.Rows[i]["COMPANY_NO_BOX"].ToString(); string YEAR_MONTH = dt.Rows[i]["YEAR_MONTH"].ToString(); int DUNNING_COUNT = int.Parse(dt.Rows[i]["DUNNING_COUNT"] == null ? "0" : dt.Rows[i]["DUNNING_COUNT"].ToString()); DateTime?dtm_DUNNING_DATE, dtm_ANSWER_DATE, dtm_PAYMENT_DUE_DATE, dtm_STATUS_ACC_RECEIVABLE_DATE, dtm_STATUS_ACTUAL_MDB_UPDATE; try { dtm_DUNNING_DATE = DateTime.ParseExact(DUNNING_DATE, "yyyyMMdd", CultureInfo.InvariantCulture); } catch (Exception) { dtm_DUNNING_DATE = null; } try { dtm_ANSWER_DATE = DateTime.ParseExact(ANSWER_DATE, "yyyyMMdd", CultureInfo.InvariantCulture); } catch (Exception) { dtm_ANSWER_DATE = null; } try { dtm_PAYMENT_DUE_DATE = DateTime.ParseExact(PAYMENT_DUE_DATE, "yyyyMMdd", CultureInfo.InvariantCulture); } catch (Exception) { dtm_PAYMENT_DUE_DATE = null; } try { dtm_STATUS_ACTUAL_MDB_UPDATE = DateTime.ParseExact(STATUS_ACTUAL_MDB_UPDATE, "yyyyMMdd", CultureInfo.InvariantCulture); } catch (Exception) { dtm_STATUS_ACTUAL_MDB_UPDATE = null; } try { dtm_STATUS_ACC_RECEIVABLE_DATE = DateTime.ParseExact(STATUS_ACC_RECEIVABLE_DATE, "yyyyMMdd", CultureInfo.InvariantCulture); } catch (Exception) { dtm_STATUS_ACC_RECEIVABLE_DATE = null; } INVOICE_INFO oINV = new INVOICE_INFO(Properties.Settings.Default.MyConnection); BOL_INVOICE_INFO oINFO = new BOL_INVOICE_INFO(); oINFO.STATUS_CASH_FORECAST_MM = STATUS_CASH_FORECAST_MM; oINFO.STATUS_PLAN_DEPOSIT_YYMM = STATUS_PLAN_DEPOSIT_YYMM; oINFO.STATUS_ACC_RECEIVABLE_DATE = dtm_STATUS_ACC_RECEIVABLE_DATE; oINFO.STATUS_ACTUAL_MDB_UPDATE = dtm_STATUS_ACTUAL_MDB_UPDATE; oINFO.DUNNING_DATE = dtm_DUNNING_DATE; oINFO.ANSWER_DATE = dtm_ANSWER_DATE; oINFO.ANSWER_MEMO = ANSWER_MEMO; oINFO.PAYMENT_DUE_DATE = dtm_PAYMENT_DUE_DATE; oINFO.COMPANY_NO_BOX = COMPANY_NO_BOX; oINFO.YEAR_MONTH = YEAR_MONTH; string strMessage = ""; if (!oINV.CheckIfItIsOrigin(oINFO.COMPANY_NO_BOX, oINFO.YEAR_MONTH, oINFO.DUNNING_DATE, out strMessage)) { oINFO.DUNNING_COUNT = DUNNING_COUNT + 1; } else { oINFO.DUNNING_COUNT = DUNNING_COUNT; } oINV.UpdateInvoiceFor37(oINFO, out strMessage); strError = strError + strMessage; } if (strError == "") { response.Status = 1; response.Message = "Success."; } else { response.Status = 0; response.Message = strError; } return(response); } catch (Exception ex) { response.Status = 0; response.Message = ex.Message + "\n" + ex.StackTrace; return(response); } }
public void insert(BOL_INVOICE_INFO B_InvoiceInfo, out string strMessage) { strMessage = ""; ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert); oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", B_InvoiceInfo.COMPANY_NO_BOX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_TYPE", B_InvoiceInfo.TRANSACTION_TYPE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@YEAR_MONTH", B_InvoiceInfo.YEAR_MONTH)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@INVOICE_DATE", B_InvoiceInfo.INVOICE_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_HONORIFIC", B_InvoiceInfo.BILL_HONORIFIC)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_AMOUNT", B_InvoiceInfo.BILL_AMOUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_TAX", B_InvoiceInfo.BILL_TAX)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_PRICE", B_InvoiceInfo.BILL_PRICE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_PAYMENT_DATE", B_InvoiceInfo.BILL_PAYMENT_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PRINT", B_InvoiceInfo.STATUS_PRINT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_MEMO", B_InvoiceInfo.STATUS_MEMO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_SEND", B_InvoiceInfo.STATUS_SEND)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_MAIL_DATE", B_InvoiceInfo.STATUS_MAIL_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACC_RECEIVABLE_DATE", B_InvoiceInfo.STATUS_ACC_RECEIVABLE_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_INVOCE_COPY_DATE", B_InvoiceInfo.STATUS_INVOCE_COPY_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_MDB_UPDATE", B_InvoiceInfo.STATUS_ACTUAL_MDB_UPDATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_DEPOSIT_YYMM", B_InvoiceInfo.STATUS_ACTUAL_DEPOSIT_YYMM)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_DEPOSIT_DATE", B_InvoiceInfo.STATUS_ACTUAL_DEPOSIT_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_CASH_FORECAST_MM", B_InvoiceInfo.STATUS_CASH_FORECAST_MM)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PLAN_DEPOSIT_YYMM", B_InvoiceInfo.STATUS_PLAN_DEPOSIT_YYMM)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PAY_NOTICE_DATE", B_InvoiceInfo.STATUS_PAY_NOTICE_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", B_InvoiceInfo.TYPE_OF_ALLOCATION)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATION_TOTAL_AMOUNT", B_InvoiceInfo.ALLOCATION_TOTAL_AMOUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DUNNING_COUNT", B_InvoiceInfo.DUNNING_COUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@DUNNING_DATE", B_InvoiceInfo.DUNNING_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ANSWER_DATE", B_InvoiceInfo.ANSWER_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DUE_DATE", B_InvoiceInfo.PAYMENT_DUE_DATE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ANSWER_MEMO", B_InvoiceInfo.ANSWER_MEMO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_TYPE", B_InvoiceInfo.TRANSACTION_TYPE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_SUPPLIER_NAME", B_InvoiceInfo.BILL_SUPPLIER_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_SUPPLIER_NAME_READING", B_InvoiceInfo.BILL_SUPPLIER_NAME_READING)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_COMPANY_NAME", B_InvoiceInfo.BILL_COMPANY_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPARTMENT_IN_CHARGE", B_InvoiceInfo.BILL_DEPARTMENT_IN_CHARGE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_CONTACT_NAME", B_InvoiceInfo.BILL_CONTACT_NAME)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_POSTAL_CODE", B_InvoiceInfo.BILL_POSTAL_CODE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_ADDRESS", B_InvoiceInfo.BILL_ADDRESS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_ADDRESS_2", B_InvoiceInfo.BILL_ADDRESS_2)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@NCS_CUSTOMER_CODE", B_InvoiceInfo.NCS_CUSTOMER_CODE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPOSIT_RULES", B_InvoiceInfo.BILL_DEPOSIT_RULES)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_TRANSFER_FEE", B_InvoiceInfo.BILL_TRANSFER_FEE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_EXPENSES", B_InvoiceInfo.BILL_EXPENSES)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_SERVER", B_InvoiceInfo.PLAN_SERVER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_SERVER_LIGHT", B_InvoiceInfo.PLAN_SERVER_LIGHT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_BROWSER_AUTO", B_InvoiceInfo.PLAN_BROWSER_AUTO)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_BROWSER", B_InvoiceInfo.PLAN_BROWSER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_AMIGO_CAI", B_InvoiceInfo.PLAN_AMIGO_CAI)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_AMIGO_BIZ", B_InvoiceInfo.PLAN_AMIGO_BIZ)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_ADD_BOX_SERVER", B_InvoiceInfo.PLAN_ADD_BOX_SERVER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_ADD_BOX_BROWSER", B_InvoiceInfo.PLAN_ADD_BOX_BROWSER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_FLAT", B_InvoiceInfo.PLAN_OP_FLAT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_SSL", B_InvoiceInfo.PLAN_OP_SSL)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_BASIC_SERVICE", B_InvoiceInfo.PLAN_OP_BASIC_SERVICE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_ADD_SERVICE", B_InvoiceInfo.PLAN_OP_ADD_SERVICE)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_SOCIOS", B_InvoiceInfo.PLAN_OP_SOCIOS)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_COMPLETION_DATE", B_InvoiceInfo.ALLOCATED_COMPLETION_DATE != null ? B_InvoiceInfo.ALLOCATED_COMPLETION_DATE : (object)DBNull.Value)); oMaster.ExcuteQuery(1, out strMessage); //_M01 = oMaster.intRtnID; // return intRtn; }