/// **************************************************************************** /// <summary> /// 删除数据 /// </summary> /// **************************************************************************** public void Delete() { BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl(); cBiddingDtl.BiddingCode = this.ApplicationCode; DataTable dtBiddingdtl = cBiddingDtl.GetBiddingDtls(); foreach (DataRow tempdr in dtBiddingdtl.Select()) { cBiddingDtl.BiddingDtlCode = tempdr["BiddingDtlCode"].ToString(); cBiddingDtl.BiddingDtlDelete(); } }
/// **************************************************************************** /// <summary> /// 数据加载 /// </summary> /// **************************************************************************** private void LoadData(bool Flag) { if (this.ApplicationCode != "") { if (Flag) { this.dgListEdit.DataSource = GetSourceTable(); this.dgListEdit.DataBind(); } else { BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl(); cBiddingDtl.BiddingCode = this.ApplicationCode; DataTable dt; DataTable dtc; if (this.BiddingEmitCode == "") { cBiddingDtl.flag = "1"; dt = cBiddingDtl.GetBiddingDtls(); dtc = dt; } else { dt = cBiddingDtl.GetBiddingDtls(); dtc = cBiddingDtl.GetBiddingDtls(); dtc.Clear(); BLL.BiddingReturn bed = new BLL.BiddingReturn(); bed.BiddingEmitCode = this.BiddingEmitCode; DataTable det = bed.GetBiddingReturns(); for (int i = 0; i < dt.Rows.Count; i++) { if (det.Select(" BiddingDtlCode=" + dt.Rows[i]["BiddingDtlCode"].ToString()).Length != 0) { DataRow dr = dtc.NewRow(); dr.ItemArray = dt.Rows[i].ItemArray; dtc.Rows.Add(dr); } } } this.dgListView.DataSource = dtc; this.dgListView.DataBind(); } } else { if (Flag) { AddNewRows(); } } }
private DataTable GetSourceTable() { BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl(); cBiddingDtl.BiddingCode = this.ApplicationCode; cBiddingDtl.flag = "1"; DataTable dt = cBiddingDtl.GetBiddingDtls(); foreach (DataGridItem dgItem in dgListEdit.Items) { if (dt.Select("BiddingDtlCode=" + dgItem.Cells[0].Text).Length == 0) { DataRow dr = dt.NewRow(); dr["BiddingDtlCode"] = dgItem.Cells[0].Text; dr["Title"] = ((TextBox)dgItem.FindControl("txtTitle")).Text; dr["Remark"] = ((TextBox)dgItem.FindControl("txtRemark")).Text; dr["Money"] = ((WebNumericEdit)dgItem.FindControl("TxtTemMoney")).Value; //增加特殊需求 string companyName = System.Configuration.ConfigurationManager.AppSettings["PMName"].ToString().ToLower(); switch (companyName) { case "gaokepm": dr["OtherMoney"] = System.Convert.ToDecimal(((WebNumericEdit)dgItem.FindControl("TxtOtherMoney")).Value); break; default: dr["OtherMoney"] = 0; break; } RmsPM.Web.UserControls.InputCostBudgetDtl cb = ((RmsPM.Web.UserControls.InputCostBudgetDtl)dgItem.FindControl("Inputcostbudgetdtl1")); dr["CostCode"] = cb.CostCode; dr["CostBudgetSetCode"] = cb.CostBudgetSetCode; dr["PBSCode"] = cb.PBSCode; dr["PBSType"] = cb.PBSType; dr["BiddingCode"] = this.ApplicationCode; dt.Rows.Add(dr); } } foreach (DataRow dr in dt.Select()) { if (this.CheckDtlCode(dr["BiddingDtlCode"].ToString(), this.ViewState["DeleteItems"].ToString())) { dt.Rows.Remove(dr); } } return(dt); }
/// **************************************************************************** /// <summary> /// 数据加载 /// </summary> /// **************************************************************************** private void LoadData(bool Flag) { this.CheckBox2.Visible = this.IsWSZTB; this.TbWSZTB.Visible = this.IsWSZTB; this.GridView1.Visible = this.IsWSZTB; if (this.BiddingEmitCode != "") { BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn(); cBiddingReturn.BiddingEmitCode = this.BiddingEmitCode; BLL.BiddingEmit biddingemit = new BLL.BiddingEmit(); biddingemit.BiddingEmitCode = this.BiddingEmitCode; this.BiddingCode = biddingemit.BiddingCode; DataTable dt = cBiddingReturn.GetBiddingReturns(); if (Flag) { //////////////////////////////////////////////////////////// BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl(); cBiddingDtl.BiddingCode = this.ApplicationCode; DataTable dtl; dtl = cBiddingDtl.GetBiddingDtls(); BLL.BiddingReturn bed = new BLL.BiddingReturn(); bed.BiddingEmitCode = this.BiddingEmitCode; DataTable det = bed.GetBiddingReturns(); for (int i = 0; i < dtl.Rows.Count; i++) { if ((det.Select(" BiddingDtlCode=" + dtl.Rows[i]["BiddingDtlCode"].ToString()).Length) == 0) { dtl.Rows.Remove(dt.Rows[i]); } } //////////////////////////////////////////////////////////// Bind_dgListEdit(dt); this.txtTotalRemark.Text = biddingemit.TotalRemark; } else { Bind_dgListView(dt); } dt.Dispose(); LoadBiddingOpener(false); dpAllowAfterClose.SelectedValue = biddingemit.AllowAfterClose.ToString(); } else { if (this.ViewState["dt"] == null) { BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn(); cBiddingReturn.BiddingEmitCode = this.ApplicationCode; DataTable dt = cBiddingReturn.GetBiddingReturns(); //增加新列 dt.Columns.Add("BiddingSupplierCode", System.Type.GetType("System.String")); dt.Columns.Add("State2", System.Type.GetType("System.String")); BLL.BiddingPrejudication cBiddingPrejudication = new BLL.BiddingPrejudication(); cBiddingPrejudication.BiddingCode = this.BiddingCode; DataTable dtPrejudication = cBiddingPrejudication.GetBiddingPrejudications(); for (int i = 0; i < dtPrejudication.Rows.Count; i++) { BLL.BiddingDtl bdl = new BLL.BiddingDtl(); bdl.BiddingCode = this.BiddingCode; bdl.flag = "1"; DataTable dtbdl = bdl.GetBiddingDtls(); for (int x = 0; x < dtbdl.Rows.Count; x++) { BLL.BiddingSupplier cBiddingSupplier = new BLL.BiddingSupplier(); cBiddingSupplier.BiddingPrejudicationCode = dtPrejudication.Rows[i][0].ToString(); cBiddingSupplier.Flag = "1"; DataTable dtSupplier = cBiddingSupplier.GetBiddingSuppliers(); for (int j = 0; j < dtSupplier.Rows.Count; j++) { DataRow dr = dt.NewRow(); dr["BiddingReturnCode"] = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("BiddingReturn"); dr["SupplierCode"] = dtSupplier.Rows[j]["SupplierCode"].ToString(); dr["BiddingDtlCode"] = dtbdl.Rows[x]["BiddingDtlCode"].ToString(); dr["OrderCode"] = dtSupplier.Rows[j]["OrderCode"].ToString(); dr["BiddingSupplierCode"] = dtSupplier.Rows[j]["BiddingSupplierCode"].ToString(); dr["State2"] = dtSupplier.Rows[j]["State"].ToString(); dt.Rows.Add(dr); } dtSupplier.Dispose(); } } dtPrejudication.Dispose(); this.ViewState["dt"] = dt; dt.Dispose(); } Bind_dgListView((DataTable)this.ViewState["dt"]); LoadBiddingOpener(true); } }
/// **************************************************************************** /// <summary> /// 提交数据 /// </summary> /// <param name="flag">是否修改(true为修改,false为新增)</param> /// **************************************************************************** private void _SubmitData(bool flag) { BLL.BiddingDtl bd = new BLL.BiddingDtl(); bd.BiddingCode = this.ApplicationCode; bd.flag = "1"; EntityData entity = bd.GetBiddingDtlEntity(); foreach (DataRow dr in entity.CurrentTable.Rows) { dr["Flag"] = "0"; } bd.SubmitDtlEntity(entity); decimal TeamMoneyTemp = 0; foreach (DataGridItem dgItem in dgListEdit.Items) { BLL.BiddingDtl cBiddingDtl = new BLL.BiddingDtl(); cBiddingDtl.BiddingDtlCode = dgItem.Cells[0].Text; cBiddingDtl.Title = ((TextBox)dgItem.FindControl("txtTitle")).Text; cBiddingDtl.remark = ((TextBox)dgItem.FindControl("txtRemark")).Text; cBiddingDtl.Money = ((WebNumericEdit)dgItem.FindControl("TxtTemMoney")).Value.ToString(); //增加特殊需求 string companyName = System.Configuration.ConfigurationManager.AppSettings["PMName"].ToString().ToLower(); switch (companyName) { case "gaokepm": cBiddingDtl.OtherMoney = ((WebNumericEdit)dgItem.FindControl("TxtOtherMoney")).Value.ToString(); break; default: cBiddingDtl.OtherMoney = "0"; break; } RmsPM.Web.UserControls.InputCostBudgetDtl cb = ((RmsPM.Web.UserControls.InputCostBudgetDtl)dgItem.FindControl("Inputcostbudgetdtl1")); cBiddingDtl.CostCode = cb.CostCode; cBiddingDtl.CostBudgetSetCode = cb.CostBudgetSetCode; cBiddingDtl.PBSCode = cb.PBSCode; cBiddingDtl.PBSType = cb.PBSType; cBiddingDtl.flag = "1"; if (flag) { cBiddingDtl.BiddingCode = this.ApplicationCode; cBiddingDtl.BiddingDtlSubmit(); } else { cBiddingDtl.BiddingCode = this.ApplicationCode; cBiddingDtl.BiddingDtlAdd(); } TeamMoneyTemp += decimal.Parse(((WebNumericEdit)dgItem.FindControl("TxtTemMoney")).Value.ToString()); } BLL.Bidding b = new BLL.Bidding(); b.BiddingCode = this.ApplicationCode; b.Money = TeamMoneyTemp.ToString(); b.BiddingSubmit(); this.TeamMoney = TeamMoneyTemp.ToString(); }