public String UpdateAccountStatus(FormCollection form) { logger.Info("form:" + form.Count); string msg = ""; int i = 0; string[] lstForm = form.Get("plan_account_id").Split(','); string[] lstDate = form.Get("payment_date").Split(','); string[] lstCheck = form.Get("check_no").Split(','); List <PLAN_ACCOUNT> lstItem = new List <PLAN_ACCOUNT>(); if (form.Get("status") != null) { string[] lstStatus = form.Get("status").Split(','); for (int j = 0; j < lstForm.Count(); j++) { PLAN_ACCOUNT item = new PLAN_ACCOUNT(); item.PLAN_ACCOUNT_ID = int.Parse(lstForm[j]); item.PAYMENT_DATE = Convert.ToDateTime(lstDate[j]); item.CHECK_NO = lstCheck[j]; item.MODIFY_DATE = DateTime.Now; if (lstStatus[j].ToString() == "") { item.STATUS = 10; } else { item.STATUS = 0; } logger.Debug("Plan Acount Id =" + item.PLAN_ACCOUNT_ID + ", Status =" + item.STATUS); lstItem.Add(item); } } else { for (int j = 0; j < lstForm.Count(); j++) { PLAN_ACCOUNT item = new PLAN_ACCOUNT(); item.PLAN_ACCOUNT_ID = int.Parse(lstForm[j]); item.PAYMENT_DATE = Convert.ToDateTime(lstDate[j]); item.CHECK_NO = lstCheck[j]; item.STATUS = 10; item.MODIFY_DATE = DateTime.Now; logger.Debug("Plan Acount Id =" + item.PLAN_ACCOUNT_ID + ", Status =" + item.STATUS); lstItem.Add(item); } } i = service.refreshAccountStatus(lstItem); if (i == 0) { msg = service.message; } else { msg = "帳款支付狀態已更新"; } return(msg); }
public String updatePlanAccountItem(FormCollection form) { logger.Info("form:" + form.Count); string msg = "更新成功!!"; PLAN_ACCOUNT item = new PLAN_ACCOUNT(); item.PROJECT_ID = form["project_id"]; item.PLAN_ACCOUNT_ID = int.Parse(form["plan_account_id"]); item.CONTRACT_ID = form["contract_id"]; item.ACCOUNT_FORM_ID = form["account_form_id"]; item.PAYMENT_DATE = Convert.ToDateTime(form.Get("date")); try { item.AMOUNT_PAID = decimal.Parse(form["amount_paid"]); } catch (Exception ex) { logger.Error(item.PLAN_ACCOUNT_ID + " not paid amount:" + ex.Message); } try { item.AMOUNT_PAYABLE = decimal.Parse(form["amount_payable"]); } catch (Exception ex) { logger.Error(item.PLAN_ACCOUNT_ID + " not payable amount:" + ex.Message); } item.ACCOUNT_TYPE = form["type"]; logger.Debug("account type = " + form["type"]); item.ISDEBIT = form["isdebit"]; item.STATUS = int.Parse(form["unRecordedFlag"]); item.CREATE_ID = form["create_id"]; item.CHECK_NO = form["check_no"]; item.PAYEE = form["payee"]; item.REMARK = form["remark"]; SYS_USER loginUser = (SYS_USER)Session["user"]; item.MODIFY_ID = loginUser.USER_ID; item.MODIFY_DATE = DateTime.Now; int i = 0; i = service.updatePlanAccountItem(item); if (i == 0) { msg = service.message; } return(msg); }