internal static void AddItemTable1(DataTable itemTable, Installment dataForm, WorkflowDataFields fields, string summaryAmount) { List<string> list = summaryAmount.Split(';').ToList<string>(); list.Remove(""); DataTable dt = new DataTable(); dt.Columns.Add("ExpenseType"); dt.Columns.Add("ItemAmount"); dt.Columns.Add("CostCenter"); dt.Columns.Add("GLAccount"); dt.Columns.Add("PRWorkFlowNumber"); dt.Columns.Add("SubPRNo"); dt.Columns.Add("Title"); dt.Columns.Add("FANO"); dt.Columns.Add("ItemInstallmentAmount"); //foreach (DataRow dr in itemTable.Rows) //{ // DataRow newdr = dt.Rows.Add(); // newdr["ExpenseType"] = dr["ExpenseType"].ToString(); // newdr["GLAccount"] = dr["GLAccount"].ToString(); // newdr["CostCenter"] = dr["CostCenter"].ToString(); // newdr["ItemAmount"] = dr["ItemAmount"].ToString(); // newdr["PRWorkFlowNumber"] = fields["Title"].ToString(); // newdr["SubPRNo"] = fields["SubPRNo"].ToString(); // newdr["Title"] = fields["SubPRNo"].ToString(); // newdr["FANO"] = dr["FANO"].AsString(); //} for (int i = 0; i < itemTable.Rows.Count;i++ ) { DataRow newdr = dt.Rows.Add(); newdr["ExpenseType"] = itemTable.Rows[i]["ExpenseType"].ToString(); newdr["GLAccount"] = itemTable.Rows[i]["GLAccount"].ToString(); newdr["CostCenter"] = itemTable.Rows[i]["CostCenter"].ToString(); newdr["ItemAmount"] = itemTable.Rows[i]["ItemAmount"].ToString(); newdr["PRWorkFlowNumber"] = fields["Title"].ToString(); newdr["SubPRNo"] = fields["SubPRNo"].ToString(); newdr["Title"] = fields["SubPRNo"].ToString(); newdr["FANO"] = itemTable.Rows[i]["FANO"].AsString(); newdr["ItemInstallmentAmount"] = list[i].Trim(); } dataForm.ItemTable = dt; }
internal static void AddItemTable1(Installment dataForm, WorkflowDataFields fields) { AddItemTable1(dataForm.ItemTable, dataForm, fields, dataForm.SummaryAmount); }
internal static void SaveSAPItemsDetails1(Installment dataForm) { BatchInsertSAPItems("PaymentRequestItemDetails", dataForm.ItemTable); }
public bool SavePeymentRequestData(Installment installmentForm, WorkflowDataFields fields) { if (Session["ContractPONo"] == null || (Session["ContractPONo"] != null && Session["ContractPONo"].ToString() != txtContractPO.Text)) { DataTable dTable = PaymentRequestComm.GetPaymentRequestInfoByContractPONo(txtContractPO.Text.ToUpper()).GetDataTable(); if (dTable != null && dTable.Rows.Count > 0) { ErrorMessage = " 您输入的合同编号已经存在,请重新输入 "; return false; } } if ((PaymentRequestMode)Session["PRMode"] == PaymentRequestMode.New) { if (ViewState["PrDict"] == null) { CreateWorkFlowNumber(); } if (((Dictionary<string, string>)ViewState["PrDict"])["PIIndex"].ToString() == "1") { SetPaymentRequestInfo(); } else { PaymentRequestComm.SetPaymentRequestInfo(PONO, new List<object[]>() { new object[] { "Status", PaymentRequestStatus.InProcess }, new object[] { "ContractPO", txtContractPO.Text } }); } SetPaymentRequestUser(fields); } string paidInd = string.Empty; if (ViewState["Installment"] != null) { paidInd = (ViewState["Installment"] as DataTable).Rows[0]["PaidInd"].ToString(); } if ((ViewState["Installment"] == null || paidInd == "1") && IsFromPO == false) { SetInstallmentInfo(installmentForm); } SetPaymentRequestItemsInfo(fields); return true; }
private void SetInstallmentViewState(Installment installmentForm) { DataTable dTable = CreateInstalmentDT(); DataRow dRow = dTable.NewRow(); dRow["PaidBefore"] = 0; dRow["NewPaidBefore"] = 0; dRow["PaidInd"] = 1; dRow["Balance"] = 0; dRow["PaidThisTime"] = 100; if (radioInstallment.SelectedValue == "Yes" && string.IsNullOrEmpty(txtTotalAmount.Text) == false) { if (string.IsNullOrEmpty(((TextBox)installmentForm.InstallmentRepeaterControl.Items[0].FindControl("txtPaid")).Text) == false) { dRow["Balance"] = radioInstallment.SelectedValue == "Yes" ? (100 - decimal.Parse( ((TextBox)installmentForm.InstallmentRepeaterControl.Items[0].FindControl("txtPaid")).Text)).ToString() : "0"; dRow["PaidThisTime"] = radioInstallment.SelectedValue == "Yes" ? ((TextBox)installmentForm.InstallmentRepeaterControl.Items[0].FindControl("txtPaid")).Text : "100"; } } dTable.Rows.Add(dRow); ViewState["Installment"] = dTable; }
/// <summary> /// /// </summary> private void SetInstallmentInfo(Installment installmentForm) { SetInstallmentViewState(installmentForm); if ((PaymentRequestMode)Session["PRMode"] == PaymentRequestMode.Edit && IsFromPO == false) { PaymentRequestComm.DelInstallmentInfo(((Dictionary<string, string>)ViewState["PrDict"])["PONO"]); } List<List<object[]>> prInfos = new List<List<object[]>>(); if (radioInstallment.SelectedValue == "Yes") { int i = 0; foreach (RepeaterItem rItem in installmentForm.InstallmentRepeaterControl.Items) { AddInstallmentToList(prInfos, ++i, 0, ((TextBox)rItem.FindControl("txtPaid")).Text, ((TextBox)rItem.FindControl("txtPaidAmount")).Text, ((CheckBox)rItem.FindControl("txtIsNeedGR")).Checked ? "1" : "0", ((TextBox)rItem.FindControl("txtComments")).Text, txtTotalAmount.Text, ((Dictionary<string, string>)ViewState["PrDict"])["PONO"], "分期第 " + i.ToString() + " 次付款"); } } else { //一次性付款 AddInstallmentToList(prInfos, 1, 0, 100, txtTotalAmount.Text, 0, "", txtTotalAmount.Text, ((Dictionary<string, string>)ViewState["PrDict"])["PONO"], "1 次性付款"); } PaymentRequestComm.SetInstallmentInfo(prInfos); }