private void BoundBiddingDtl(string BiddingReturnCodeStr) { this.CheckBoxList1.Items.Clear(); RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = this.BiddingCode; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select("SupplierCode='" + DropSupplier.SelectedValue + "'")) { ListItem li = new ListItem(RmsPM.BLL.BiddingDtl.GetBiddingDtlNameByCode(dr["BiddingDtlCode"].ToString()), dr["BiddingReturnCode"].ToString()); if (this.MoneyState == ModuleState.Eyeable) { li.Text += " 报价:" + dr["Money"].ToString(); } this.CheckBoxList1.Items.Add(li); } dt = bidding.GetBiddingReturn(); foreach (DataRow dr in dt.Select("BiddingReturnCode in (" + BiddingReturnCodeStr + "'') and flag='1' and SupplierCode='" + DropSupplier.SelectedValue + "'")) { RmsPM.BLL.BiddingReturn br = new RmsPM.BLL.BiddingReturn(); br.BiddingReturnCode = dr["BiddingReturnCode"].ToString(); ListItem li = new ListItem(RmsPM.BLL.BiddingDtl.GetBiddingDtlNameByCode(br.BiddingDtlCode), dr["BiddingReturnCode"].ToString()); if (this.MoneyState == ModuleState.Eyeable) { li.Text += " 报价:" + dr["Money"].ToString(); } li.Selected = true; this.CheckBoxList1.Items.Add(li); } }
public string SubmitBiddingMessage() { try { string ErrMsg = ""; RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.dao = this.dao; bidding.BiddingCode = this.BiddingCode; DataTable dt = bidding.GetBiddingReturnNoMessage(); int i = 0; foreach (DataRow drsupplier in dt.Select()) { string BiddingReturnCode = ""; string BiddingDtlCode = ""; BiddingReturnCode = "'" + drsupplier["BiddingReturnCode"].ToString() + "',"; BiddingDtlCode = "'" + drsupplier["BiddingDtlCode"].ToString() + "',"; RmsPM.BLL.BiddingMessage cBiddingMessage = new RmsPM.BLL.BiddingMessage(); cBiddingMessage.BiddingMessageCode = ""; cBiddingMessage.BiddingCode = bidding.BiddingCode; cBiddingMessage.ProjectCode = bidding.ProjectCode; cBiddingMessage.ContractNember = this.tdContractNemberTop.InnerText + i.ToString(); cBiddingMessage.ContractName = bidding.Title; cBiddingMessage.ContractType = bidding.Type; cBiddingMessage.Supplier = drsupplier["SupplierCode"].ToString(); cBiddingMessage.ContractDate = DateTime.Now.ToShortDateString(); cBiddingMessage.Remark = ""; cBiddingMessage.CreateDate = DateTime.Now.ToShortDateString(); cBiddingMessage.CreateUser = ""; cBiddingMessage.AttachUser = ""; cBiddingMessage.State = "0"; cBiddingMessage.Flag = "0"; cBiddingMessage.BiddingReturnCode = BiddingReturnCode; cBiddingMessage.BiddingDtlCode = BiddingDtlCode; cBiddingMessage.dao = this.dao; cBiddingMessage.BiddingMessageSubmit(); i++; } return(ErrMsg); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(Rms.Web.JavaScript.Alert(true, "保存出错:" + ex.Message)); throw ex; } }
/// **************************************************************************** /// <summary> /// 数据加载 /// </summary> /// **************************************************************************** private void LoadData(bool Flag) { this.ViewState["BiddingReturnCodeStr"] = ""; if (this.ApplicationCode != "") { RmsPM.BLL.BiddingMessage cBiddingMessage = new RmsPM.BLL.BiddingMessage(); cBiddingMessage.BiddingMessageCode = this.ApplicationCode; this.BiddingCode = cBiddingMessage.BiddingCode; this.ProjectCode = cBiddingMessage.ProjectCode; this.SupplierCode = cBiddingMessage.Supplier; this.ProjectCode = cBiddingMessage.ProjectCode; RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = cBiddingMessage.BiddingCode; this.ViewState["Money"] = bidding.Money; this.ViewState["mostly"] = bidding.Accessory; this.ViewState["BiddingType"] = bidding.Type; this.tdbiddingContent.InnerHtml = bidding.Content.Replace("\n", "<br>"); if (Flag) { this.txtProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(cBiddingMessage.ProjectCode); this.txtContractNember.Value = cBiddingMessage.ContractNember; this.txtContractName.Value = cBiddingMessage.ContractName; this.txtContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(cBiddingMessage.ContractType); //this.txtSupplier.InnerHtml = " "+RmsPM.BLL.ProjectRule.GetSupplierName(cBiddingMessage.Supplier); this.txtContractDate.Value = cBiddingMessage.ContractDate; this.txtRemark.Value = cBiddingMessage.Remark; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select()) { ListItem li = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(dr["SupplierCode"].ToString()), dr["SupplierCode"].ToString()); if (!DropSupplier.Items.Contains(li)) { this.DropSupplier.Items.Add(li); } } ListItem lis = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(cBiddingMessage.Supplier), cBiddingMessage.Supplier); this.DropSupplier.Items.Add(lis); this.DropSupplier.SelectedIndex = this.DropSupplier.Items.IndexOf(this.DropSupplier.Items.FindByValue(cBiddingMessage.Supplier)); BoundBiddingDtl(cBiddingMessage.BiddingReturnCode); this.ViewState["BiddingReturnCodeStr"] = cBiddingMessage.BiddingReturnCode; } else { this.tdProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(cBiddingMessage.ProjectCode); this.tdContractNember.InnerHtml = " " + cBiddingMessage.ContractNember; this.tdContractName.InnerHtml = " " + cBiddingMessage.ContractName; this.tdContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(cBiddingMessage.ContractType); this.tdSupplier.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetSupplierName(cBiddingMessage.Supplier); this.tdBiddingDtl.InnerHtml = this.GetBiddingDtlListStr(cBiddingMessage.BiddingReturnCode, cBiddingMessage.Supplier); this.tdContractDate.InnerHtml = " " + cBiddingMessage.ContractDate; this.tdRemark.InnerHtml = " " + cBiddingMessage.Remark.Replace("\n", "<br>"); } } else { RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = this.BiddingCode; this.ViewState["Money"] = bidding.Money; this.ViewState["mostly"] = bidding.Accessory; this.ViewState["BiddingType"] = bidding.Type; this.tdbiddingContent.InnerHtml = bidding.Content.Replace("\n", "<br>"); this.txtProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(bidding.ProjectCode); this.txtContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(bidding.Type); this.ProjectCode = bidding.ProjectCode; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select()) { ListItem li = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(dr["SupplierCode"].ToString()), dr["SupplierCode"].ToString()); if (!DropSupplier.Items.Contains(li)) { this.DropSupplier.Items.Add(li); } } BoundBiddingDtl(""); this.txtContractName.Value = bidding.Title; } //构建编号 RmsPM.BLL.BiddingMessage biddingMessage = new RmsPM.BLL.BiddingMessage(); biddingMessage.BiddingCode = this.BiddingCode; System.Data.DataTable BiddingMessagedt = biddingMessage.GetBiddingMessages() as System.Data.DataTable; string CNnum = "0"; if (BiddingMessagedt != null) { CNnum = BiddingMessagedt.Rows.Count.ToString(); } RmsPM.BLL.BiddingPrejudication bp = new RmsPM.BLL.BiddingPrejudication(); bp.BiddingCode = this.BiddingCode; DataTable dtp = bp.GetBiddingPrejudications(); DataRow[] drw = dtp.Select("", "CreateDate desc"); if (drw.Length > 0) { this.ContractNember = drw[0]["Number"].ToString() + "-" + CNnum; } }
/// **************************************************************************** /// <summary> /// 数据加载 /// </summary> /// **************************************************************************** private void LoadData(bool Flag) { this.ViewState["BiddingReturnCodeStr"] = ""; if (this.ApplicationCode != "") { RmsPM.BLL.BiddingMessage cBiddingMessage = new RmsPM.BLL.BiddingMessage(); cBiddingMessage.BiddingMessageCode = this.ApplicationCode; this.BiddingCode = cBiddingMessage.BiddingCode; this.ProjectCode = cBiddingMessage.ProjectCode; this.SupplierCode = cBiddingMessage.Supplier; this.ProjectCode = cBiddingMessage.ProjectCode; RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = cBiddingMessage.BiddingCode; this.ViewState["Money"] = bidding.Money; this.ViewState["mostly"] = bidding.Accessory; this.ViewState["BiddingType"] = bidding.Type; if (Flag) { this.txtProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(cBiddingMessage.ProjectCode); this.txtContractNember.Value = cBiddingMessage.ContractNember; this.txtContractName.Value = cBiddingMessage.ContractName; this.txtContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(cBiddingMessage.ContractType); this.txtContractDate.Value = cBiddingMessage.ContractDate; //this.TxtRemark.Value = cBiddingMessage.Remark; //this.SelectName.Value = cBiddingMessage.AttachUser; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select()) { ListItem li = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(dr["SupplierCode"].ToString()), dr["SupplierCode"].ToString()); if (!DropSupplier.Items.Contains(li)) { this.DropSupplier.Items.Add(li); } } ListItem lis = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(cBiddingMessage.Supplier), cBiddingMessage.Supplier); this.DropSupplier.Items.Add(lis); this.DropSupplier.SelectedIndex = this.DropSupplier.Items.IndexOf(this.DropSupplier.Items.FindByValue(cBiddingMessage.Supplier)); BoundBiddingDtl(cBiddingMessage.BiddingReturnCode); this.ViewState["BiddingReturnCodeStr"] = cBiddingMessage.BiddingReturnCode; } else { this.tdProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(cBiddingMessage.ProjectCode); this.tdContractNember.InnerHtml = " " + cBiddingMessage.ContractNember; this.tdContractName.InnerHtml = " " + cBiddingMessage.ContractName; this.tdContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(cBiddingMessage.ContractType); this.tdSupplier.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetSupplierName(cBiddingMessage.Supplier); this.tdBiddingDtl.InnerHtml = this.GetBiddingDtlListStr(cBiddingMessage.BiddingReturnCode, cBiddingMessage.Supplier); this.tdContractDate.InnerHtml = " " + cBiddingMessage.ContractDate; //this.tdUserNames.InnerHtml = " " + cBiddingMessage.AttachUser; //this.tdRemark.InnerHtml = " " + cBiddingMessage.Remark.Replace("\n", "<br>"); } } else { RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = this.BiddingCode; this.ViewState["Money"] = bidding.Money; this.ViewState["mostly"] = bidding.Accessory; this.ViewState["BiddingType"] = bidding.Type; //this.tdbiddingContent.InnerHtml = bidding.Content.Replace("\n", "<br>")+" "; this.txtProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(bidding.ProjectCode); this.txtContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(bidding.Type); this.ProjectCode = bidding.ProjectCode; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select()) { ListItem li = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(dr["SupplierCode"].ToString()), dr["SupplierCode"].ToString()); if (!DropSupplier.Items.Contains(li)) { this.DropSupplier.Items.Add(li); } } BoundBiddingDtl(""); this.txtContractName.Value = bidding.Title; } //构建编号 RmsPM.BLL.BiddingMessage biddingMessage = new RmsPM.BLL.BiddingMessage(); biddingMessage.BiddingCode = this.BiddingCode; System.Data.DataTable BiddingMessagedt = biddingMessage.GetBiddingMessages() as System.Data.DataTable; string CNnum = "0"; if (BiddingMessagedt != null) { CNnum = BiddingMessagedt.Rows.Count.ToString(); } RmsPM.BLL.BiddingPrejudication bp = new RmsPM.BLL.BiddingPrejudication(); bp.BiddingCode = this.BiddingCode; DataTable dtp = bp.GetBiddingPrejudications(); DataRow[] drw = dtp.Select("", "CreateDate desc"); if (drw.Length > 0) { this.ContractNember = drw[0]["Number"].ToString() + "-" + CNnum; } /****************最后报价*****************/ RmsPM.BLL.BiddingManage bm = new RmsPM.BLL.BiddingManage(); RmsPM.BLL.BiddingReturn cBiddingReturn = new RmsPM.BLL.BiddingReturn(); bm.BiddingCode = this.BiddingCode; string BiddingEmitCode = bm.GetLastBiddingEmitCode(); cBiddingReturn.BiddingEmitCode = BiddingEmitCode; DataTable dtReturn = cBiddingReturn.GetBiddingReturns(); decimal tempMoney = 0; foreach (DataRow drReturnSupplier in RmsPM.BLL.ConvertRule.GetDistinct(dtReturn, "BiddingDtlCode", "").Select()) { decimal Money = 0; foreach (DataRow drReturnAll in dtReturn.Select()) { if (drReturnSupplier["BiddingDtlCode"].ToString() == drReturnAll["BiddingDtlCode"].ToString()) { if (System.Convert.ToDecimal(drReturnAll["Money"]) > Money) { Money = System.Convert.ToDecimal(drReturnAll["Money"]); } } } tempMoney += Money; } this.ViewState["MaxMoney"] = tempMoney; /***************************************/ }
/// **************************************************************************** /// /// <summary> /// 初始化 /// </summary> /// **************************************************************************** protected void InitPage() { this.ViewState["BiddingReturnCodeStr"] = ""; string BiddingMessageCode = Request["BiddingMessageCode"] + ""; this.BiddingCode = Request["BiddingCode"] + ""; this.ApplicationCode = BiddingMessageCode; if (BiddingMessageCode != "") { RmsPM.BLL.BiddingMessage cBiddingMessage = new RmsPM.BLL.BiddingMessage(); cBiddingMessage.BiddingMessageCode = BiddingMessageCode; RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = cBiddingMessage.BiddingCode; this.txtProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(cBiddingMessage.ProjectCode); this.ProjectCode = cBiddingMessage.ProjectCode; this.txtContractNember.Value = cBiddingMessage.ContractNember; this.txtContractName.Value = cBiddingMessage.ContractName; this.txtContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(cBiddingMessage.ContractType); this.txtContractDate.Value = cBiddingMessage.ContractDate; this.txtRemark.Value = cBiddingMessage.Remark; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select()) { ListItem li = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(dr["SupplierCode"].ToString()), dr["SupplierCode"].ToString()); if (!DropSupplier.Items.Contains(li)) this.DropSupplier.Items.Add(li); } ListItem lis = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(cBiddingMessage.Supplier), cBiddingMessage.Supplier); this.DropSupplier.Items.Add(lis); this.DropSupplier.SelectedIndex = this.DropSupplier.Items.IndexOf(this.DropSupplier.Items.FindByValue(cBiddingMessage.Supplier)); BoundBiddingDtl(cBiddingMessage.BiddingReturnCode); this.ViewState["BiddingReturnCodeStr"] = cBiddingMessage.BiddingReturnCode; } else if (BiddingCode != "") { RmsPM.BLL.Bidding bidding = new RmsPM.BLL.Bidding(); bidding.BiddingCode = BiddingCode; this.txtProjectCode.InnerHtml = " " + RmsPM.BLL.ProjectRule.GetProjectName(bidding.ProjectCode); this.ProjectCode = bidding.ProjectCode; this.txtContractType.InnerHtml = " " + RmsPM.BLL.ContractRule.GetContractTypeName(bidding.Type); this.ProjectCode = bidding.ProjectCode; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select()) { ListItem li = new ListItem(RmsPM.BLL.ProjectRule.GetSupplierName(dr["SupplierCode"].ToString()), dr["SupplierCode"].ToString()); if (!DropSupplier.Items.Contains(li)) this.DropSupplier.Items.Add(li); } BoundBiddingDtl(""); this.txtContractName.Value = bidding.Title; //构建编号 RmsPM.BLL.BiddingMessage biddingMessage = new RmsPM.BLL.BiddingMessage(); biddingMessage.BiddingCode = this.BiddingCode; System.Data.DataTable BiddingMessagedt = biddingMessage.GetBiddingMessages() as System.Data.DataTable; string CNnum = "0"; if (BiddingMessagedt != null) CNnum = BiddingMessagedt.Rows.Count.ToString(); RmsPM.BLL.BiddingPrejudication bp = new RmsPM.BLL.BiddingPrejudication(); bp.BiddingCode = this.BiddingCode; DataTable dtp = bp.GetBiddingPrejudications(); DataRow[] drw = dtp.Select("", "CreateDate desc"); if (drw.Length > 0) this.txtContractNember.Value = drw[0]["Number"].ToString() + "-" + CNnum; } else { Response.Write(JavaScript.ScriptStart); Response.Write("window.alert('招标计划不存在!');"); Response.Write("window.opener=null;window.close();"); Response.Write(JavaScript.ScriptEnd); return; } }