private string GetBiddingDtlListStr(string BiddingReturnCodeStr, string SupplierCode) { string returnstr = ""; BLL.Bidding bidding = new BLL.Bidding(); bidding.BiddingCode = this.BiddingCode; DataTable dt = bidding.GetBiddingReturn(); foreach (DataRow dr in dt.Select("BiddingReturnCode in (" + BiddingReturnCodeStr + "'') and flag='1' and SupplierCode='" + SupplierCode + "'")) { BLL.BiddingReturn br = new BLL.BiddingReturn(); br.BiddingReturnCode = dr["BiddingReturnCode"].ToString(); if (this.MoneyState == ModuleState.Eyeable) { returnstr += " " + BLL.BiddingDtl.GetBiddingDtlNameByCode(br.BiddingDtlCode) + " 报价:" + br.Money + "<br />"; } else { returnstr += " " + BLL.BiddingDtl.GetBiddingDtlNameByCode(br.BiddingDtlCode) + "<br />"; } } if (returnstr == "") { returnstr = " "; } return(returnstr); }
/// <summary> /// 删除数据 /// </summary> public void Delete() { BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn(); cBiddingReturn.BiddingEmitCode = this.BiddingEmitCode; cBiddingReturn.dao = this.dao; cBiddingReturn.BiddingEmitReturnDelete(); }
private void BoundBiddingDtl(string BiddingReturnCodeStr) { this.CheckBoxList1.Items.Clear(); BLL.Bidding bidding = new BLL.Bidding(); bidding.BiddingCode = this.BiddingCode; DataTable dt = bidding.GetBiddingReturnNoMessage(); foreach (DataRow dr in dt.Select("SupplierCode='" + DropSupplier.SelectedValue + "'")) { ListItem li = new ListItem(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 + "'")) { BLL.BiddingReturn br = new BLL.BiddingReturn(); br.BiddingReturnCode = dr["BiddingReturnCode"].ToString(); ListItem li = new ListItem(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); } }
/// **************************************************************************** /// <summary> /// 提交数据 /// </summary> /// **************************************************************************** public void SubmitData() { string BiddingReturnCode = ""; string BiddingDtlCode = ""; decimal tempMoney = 0; foreach (ListItem li in this.CheckBoxList1.Items) { if (li.Selected) { BLL.BiddingReturn br = new BLL.BiddingReturn(); br.BiddingReturnCode = li.Value; BiddingReturnCode += "'" + br.BiddingReturnCode + "',"; BiddingDtlCode += "'" + br.BiddingDtlCode + "',"; if (System.Convert.ToDecimal(br.Money) > tempMoney) { this.ViewState["MaxMoney"] = br.Money; tempMoney = System.Convert.ToDecimal(br.Money); } } } BLL.Bidding bidding = new BLL.Bidding(); bidding.dao = this.dao; bidding.BiddingCode = this.BiddingCode; BLL.BiddingMessage cBiddingMessage = new BLL.BiddingMessage(); cBiddingMessage.BiddingMessageCode = this.ApplicationCode; cBiddingMessage.BiddingCode = this.BiddingCode; cBiddingMessage.ProjectCode = this.ProjectCode; cBiddingMessage.ContractNember = this.txtContractNember.Value; cBiddingMessage.ContractName = this.txtContractName.Value; cBiddingMessage.ContractType = bidding.Type; cBiddingMessage.Supplier = this.DropSupplier.SelectedValue; cBiddingMessage.ContractDate = this.txtContractDate.Value; cBiddingMessage.Remark = this.txtRemark.Value; cBiddingMessage.CreateDate = DateTime.Now.ToShortDateString(); cBiddingMessage.CreateUser = ""; cBiddingMessage.State = "0"; cBiddingMessage.Flag = "0"; cBiddingMessage.BiddingReturnCode = BiddingReturnCode; cBiddingMessage.BiddingDtlCode = BiddingDtlCode; cBiddingMessage.dao = this.dao; cBiddingMessage.BiddingMessageSubmit(); if (this.ApplicationCode == "") { this.ApplicationCode = cBiddingMessage.BiddingMessageCode; } }
/// **************************************************************************** /// <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(); } } }
/// <summary> /// 显示内容,不可编编辑 /// </summary> private void View_LoadData() { //网上招投标信息 EntityData entity = new EntityData("BiddingEmitTo"); string sql = "select * from BiddingEmitTo where BiddingEmitCode='" + BiddingEmitCode + "' "; QueryAgent QA = new QueryAgent(); entity = QA.FillEntityData("BiddingEmitTo", sql); GridView1.DataSource = entity; GridView1.DataBind(); if (entity.HasRecord()) { this.CheckBox2.Checked = true; } this.CheckBox2.Enabled = false; this.CheckBox2.Visible = this.IsWSZTB; //显示回标单位信息 BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn(); cBiddingReturn.BiddingEmitCode = this.BiddingEmitCode; DataTable dt = cBiddingReturn.GetBiddingReturns(); BindDataGrid1(dt); //显示备注信息 BLL.BiddingEmit biddingemit = new BLL.BiddingEmit(); biddingemit.BiddingEmitCode = this.BiddingEmitCode; this.BiddingCode = biddingemit.BiddingCode; if (IsReturnView) { txtTotalRemark1.Text = biddingemit.TotalRemark; AttachMentList1.AttachMentType = "BiddingReturnModify1"; } else { txtTotalRemark1.Text = biddingemit.TotalRemark2; AttachMentList1.AttachMentType = "BiddingReturnModify2"; } AttachMentList1.MasterCode = biddingemit.BiddingEmitCode; this.AttachMentAdd2.Visible = false; txtTotalRemark1.Enabled = false; Datagrid1.Visible = true; dpAllowAfterClose.SelectedValue = biddingemit.AllowAfterClose.ToString(); LoadBiddingOpener(false); }
/// **************************************************************************** /// <summary> /// 数据加载 /// </summary> /// **************************************************************************** private void LoadData() { try { BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn(); if(_BiddingReturnCode != null) cBiddingReturn.BiddingReturnCode = _BiddingReturnCode; if(_BiddingEmitCode != null) cBiddingReturn.BiddingEmitCode = _BiddingEmitCode; if(_SupplierCode != null) cBiddingReturn.SupplierCode = _SupplierCode; if(_Money != null) cBiddingReturn.Money = _Money; if(_Remark != null) cBiddingReturn.Remark = _Remark; if(_Design != null) cBiddingReturn.Design = _Design; if(_Project != null) cBiddingReturn.Project = _Project; if(_Consultant != null) cBiddingReturn.Consultant = _Consultant; if(_OrderCode != null) cBiddingReturn.OrderCode = _OrderCode; if(_ReturnDate != null) cBiddingReturn.ReturnDate = _ReturnDate; if(_State != null) cBiddingReturn.State = _State; if(_Flag != null) cBiddingReturn.Flag = _Flag; DataTable dt = cBiddingReturn.GetBiddingReturns(); this.dgList.DataSource = dt; this.dgList.DataBind(); this.gpControl.RowsCount = dt.Rows.Count.ToString(); dt.Dispose(); } catch( Exception ex ) { ApplicationLog.WriteLog(this.ToString(),ex,""); } }
/// **************************************************************************** /// <summary> /// 数据加载 /// </summary> /// **************************************************************************** private void LoadData(bool Flag) { BLL.BiddingManage bm = new BLL.BiddingManage(); BLL.BiddingReturn cBiddingReturn = new BLL.BiddingReturn(); if (this.ApplicationCode != "") { cBiddingReturn.BiddingEmitCode = this.ApplicationCode; BLL.BiddingEmit cBiddingEmit = new BLL.BiddingEmit(); cBiddingEmit.BiddingEmitCode = cBiddingReturn.BiddingEmitCode; this.BiddingCode = cBiddingEmit.BiddingCode; bm.BiddingCode = this.BiddingCode; this.ApplicationCode = bm.GetLastBiddingEmitCode(); cBiddingReturn.BiddingEmitCode = this.ApplicationCode; } else { bm.BiddingCode = this.BiddingCode; this.ApplicationCode = bm.GetLastBiddingEmitCode(); cBiddingReturn.BiddingEmitCode = this.ApplicationCode; } this.ProjectCode = bm.ProjectCode; DataTable dt = cBiddingReturn.GetBiddingReturns(); //获取最后的压价信息 dt = BLL.BiddingSystem.GetAuditingMessage(dt, this.BiddingCode, this.ApplicationCode); DataView dv1 = new DataView(dt); //按价格排 DataView dv2 = new DataView(dt); dv2.Sort = "BiddingDtlCode,Money"; int le = dv1.Table.Rows.Count; //DataRow dr dv1.Table.Columns.Add("myState", System.Type.GetType("System.String")); int j = 0; int k = 0; decimal tempMoney = 0; foreach (DataRowView drv2 in dv2) { j++; foreach (DataRowView drv1 in dv1) { if (drv2["BiddingReturnCode"] == drv1["BiddingReturnCode"] && drv2["BiddingDtlCode"] == drv1["BiddingDtlCode"]) { drv1["myState"] = drv2["State"]; if (System.Convert.ToDecimal(drv1["Money"]) > tempMoney) { this.ViewState["MaxMoney"] = drv1["Money"].ToString(); tempMoney = System.Convert.ToDecimal(drv1["Money"]); } break; } } } this.Repeater1.DataSource = dv1; this.Repeater1.DataBind(); for (int i = 0; i < this.Repeater1.Items.Count; i++) { if (Flag) { ((HtmlInputCheckBox)this.Repeater1.Items[i].FindControl("chkAuditing")).Visible = true; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanAuditing")).Visible = false; ((HtmlInputCheckBox)this.Repeater1.Items[i].FindControl("chkAuditing")).Checked = (dt.Rows[i]["Flag"].ToString() == "1"); } else { ((HtmlInputCheckBox)this.Repeater1.Items[i].FindControl("chkAuditing")).Visible = false; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanAuditing")).Visible = true; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanAuditing")).InnerHtml = this.SpanText("1", dt.Rows[i]["Flag"].ToString()); } if (this.State1 == ModuleState.Operable) { for (k = 0; k < ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioDesign")).Items.Count; k++) { ListItem ud_Item = ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioDesign")).Items[k]; if (ud_Item.Value == dt.Rows[i]["Design"].ToString()) { ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioDesign")).Items[k].Selected = true; break; } } // ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioDesign")).SelectedValue = dt.Rows[i]["Design"].ToString(); ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioDesign")).Visible = true; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanDesign")).Visible = false; } else { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanDesign")).InnerHtml = this.SpanText("2", dt.Rows[i]["Design"].ToString()); ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioDesign")).Visible = false; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanDesign")).Visible = true; } if (this.State2 == ModuleState.Operable) { for (k = 0; k < ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioProject")).Items.Count; k++) { ListItem ud_Item = ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioProject")).Items[k]; if (ud_Item.Value == dt.Rows[i]["Design"].ToString()) { ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioProject")).Items[k].Selected = true; break; } } ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioProject")).Visible = true; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanProject")).Visible = false; } else { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanProject")).InnerHtml = this.SpanText("2", dt.Rows[i]["Project"].ToString()); ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioProject")).Visible = false; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanProject")).Visible = true; } if (this.State3 == ModuleState.Operable) { for (k = 0; k < ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioConsultant")).Items.Count; k++) { ListItem ud_Item = ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioConsultant")).Items[k]; if (ud_Item.Value == dt.Rows[i]["Design"].ToString()) { ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioConsultant")).Items[k].Selected = true; break; } } ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioConsultant")).Visible = true; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanConsultant")).Visible = false; } else { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanConsultant")).InnerHtml = this.SpanText("2", dt.Rows[i]["Consultant"].ToString()); ((RadioButtonList)this.Repeater1.Items[i].FindControl("RadioConsultant")).Visible = false; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanConsultant")).Visible = true; } if (this.State4 == ModuleState.Operable) { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("txtState")).Visible = true; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanState")).Visible = false; } else { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("txtState")).Visible = false; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanState")).Visible = true; } //商务标报价是否显示 if (this.State5 == ModuleState.Sightless) { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("txtState")).InnerHtml = " "; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanState")).InnerHtml = " "; ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spMoney")).InnerHtml = " "; } //显示评选结果 if (this.SetAgreementMessage == ModuleState.Sightless) { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanDesign")).Visible = false; } if (this.SetProjectMessage == ModuleState.Sightless) { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanProject")).Visible = false; } if (this.SetAdviserMessage == ModuleState.Sightless) { ((HtmlGenericControl)this.Repeater1.Items[i].FindControl("spanConsultant")).Visible = false; } } dt.Dispose(); }
/// **************************************************************************** /// <summary> /// 提交数据 /// </summary> /// **************************************************************************** public void SubmitData() { if (this.ApplicationCode != "") { DAL.QueryStrategy.BiddingReturnStrategyBuilder sb = new RmsPM.DAL.QueryStrategy.BiddingReturnStrategyBuilder(); sb.AddStrategy(new Strategy(DAL.QueryStrategy.BiddingReturnStrategyName.BiddingCode, this.BiddingCode)); string sql = sb.BuildMainQueryString(); EntityData entity = new EntityData("BiddingReturn"); dao.FillEntity(sql, entity); //删除原有排名 BLL.BiddingSystem.DelHistoryPlace(this.BiddingCode); //产生一张新表 DataTable dt = new DataTable(); dt.Columns.Add("BiddingReturnCode", System.Type.GetType("System.String")); dt.Columns.Add("Money", System.Type.GetType("System.Decimal")); dt.Columns.Add("Remark", System.Type.GetType("System.String")); dt.Columns.Add("ReturnDate", System.Type.GetType("System.String")); dt.Columns.Add("State", System.Type.GetType("System.String")); dt.Columns.Add("BiddingDtlCode", System.Type.GetType("System.String")); DataRow dr; //读取表中信息,并产生排名 for (int i = 0; i < this.dgListEdit.Items.Count; i++) { dr = dt.NewRow(); dr["BiddingReturnCode"] = this.dgListEdit.Items[i].Cells[0].Text.Trim(); dr["Money"] = this.GetControl(i).TotalMoney; dr["Remark"] = ((HtmlTextArea)this.dgListEdit.Items[i].FindControl("txtRemark")).Value.Trim(); dr["ReturnDate"] = ((AspWebControl.Calendar) this.dgListEdit.Items[i].FindControl("txtReturnDate")).Value; dr["BiddingDtlCode"] = this.dgListEdit.Items[i].Cells[8].Text.Trim(); //dr["State"]=i+1; dt.Rows.Add(dr); } BLL.Bidding bd = new BLL.Bidding(); bd.BiddingCode = this.BiddingCode; BLL.BiddingReturn br = new BLL.BiddingReturn(); br.BiddingEmitCode = bd.BiddingLastEmit; DataTable dtreturn = br.GetBiddingReturns(); foreach (DataRow drr in dtreturn.Rows) { if (dt.Select("BiddingReturnCode ='" + drr["BiddingReturnCode"].ToString() + "'").Length == 0) { dr = dt.NewRow(); dr["BiddingReturnCode"] = drr["BiddingReturnCode"]; dr["BiddingDtlCode"] = drr["BiddingDtlCode"]; dr["Money"] = drr["Money"]; dr["Remark"] = drr["Remark"]; dr["ReturnDate"] = drr["ReturnDate"]; //dr.ItemArray.CopyTo(drr.ItemArray, 0); dt.Rows.Add(dr); } } DataView dv = new DataView(dt); dv.Sort = "BiddingDtlCode,Money"; //for(int i=0;i<dv.Rows.Count;i++) int j = 0; string tempBDtlCode = ""; decimal tempMoney = 0; foreach (DataRowView dr2 in dv) { if (tempBDtlCode != dr2["BiddingDtlCode"].ToString()) { tempBDtlCode = dr2["BiddingDtlCode"].ToString(); j = 0; tempMoney = 0; } DataRow[] dr1 = entity.CurrentTable.Select("BiddingReturnCode='" + dr2["BiddingReturnCode"].ToString() + "' and " + "BiddingDtlCode='" + dr2["BiddingDtlCode"].ToString() + "'"); if (dr1.Length > 0) { dr1[0]["Money"] = dr2["Money"]; dr1[0]["Remark"] = dr2["Remark"]; dr1[0]["ReturnDate"] = dr2["ReturnDate"]; //State字段中存放商务标排名,规则为:如果回标金额为0或者为空时不参与商务标排名;金额一样的单位,名次一样。 if (!dr2["Money"].ToString().Equals("0") && !dr2["Money"].ToString().Equals("")) { if (tempMoney != System.Convert.ToDecimal(dr2["Money"])) { j++; } dr1[0]["State"] = j; } else { dr1[0]["State"] = ""; } tempMoney = System.Convert.ToDecimal(dr2["Money"]); } } dao.SubmitEntity(entity); BLL.Bidding bidding = new BLL.Bidding(); bidding.BiddingCode = this.BiddingCode; bidding.State = NowState; bidding.dao = dao; bidding.BiddingSubmit(); //更新备注 BLL.BiddingEmit addRemark = new RmsPM.BLL.BiddingEmit(); addRemark.BiddingEmitCode = this.BiddingEmitCode; addRemark.TotalRemark = this.txtTotalRemark.Text; addRemark.dao = dao; addRemark.BiddingEmitUpdate(); } else { //删除历史排序记录 BLL.BiddingSystem.DelHistoryPlace(this.BiddingCode); DataTable dt = (DataTable)ViewState["dt"]; BLL.BiddingSupplier BSup = new RmsPM.BLL.BiddingSupplier(); DAL.QueryStrategy.BiddingReturnStrategyBuilder sb = new RmsPM.DAL.QueryStrategy.BiddingReturnStrategyBuilder(); sb.AddStrategy(new Strategy(DAL.QueryStrategy.BiddingReturnStrategyName.BiddingEmitCode, this.BiddingEmitCode)); string sql = sb.BuildMainQueryString(); EntityData entity = new EntityData("BiddingReturn"); dao.FillEntity(sql, entity); if (dt.Rows.Count > 0) { dao.DeleteAllRow(entity); dao.SubmitEntity(entity); string stat = "0"; string tempsuppliercodestr = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (((CheckBox)dgListView.Items[i].FindControl("CheckBox1")).Checked == true) { DataRow dr = entity.GetNewRecord(); dr["BiddingReturnCode"] = dt.Rows[i]["BiddingReturnCode"].ToString(); dr["BiddingDtlCode"] = dt.Rows[i]["BiddingDtlCode"].ToString(); dr["SupplierCode"] = dt.Rows[i]["SupplierCode"].ToString(); dr["OrderCode"] = dt.Rows[i]["OrderCode"].ToString(); dr["BiddingEmitCode"] = this.BiddingEmitCode; dr["Abnegate"] = 0; entity.AddNewRecord(dr); //更新供应商表 stat = "1"; //添加评分信息 RmsPM.BLL.BiddingGradeMessage cbiddingGradeMessage = new RmsPM.BLL.BiddingGradeMessage(); cbiddingGradeMessage.ApplicationCode = dt.Rows[i]["BiddingReturnCode"].ToString(); cbiddingGradeMessage.BiddingGradeTypeCode = "100002"; if (cbiddingGradeMessage.GetBiddings().Rows.Count == 0) { cbiddingGradeMessage.BiddingGradeMessageCode = ""; cbiddingGradeMessage.ProjectManage = ""; cbiddingGradeMessage.State = "1"; cbiddingGradeMessage.dao = dao; cbiddingGradeMessage.BiddingGradeMessageAdd(); } ////////////////网上招投标数据产生//////////////////// if (tempsuppliercodestr.IndexOf(dt.Rows[i]["SupplierCode"].ToString()) == -1 && this.CheckBox2.Checked) { tempsuppliercodestr += "," + dt.Rows[i]["SupplierCode"].ToString(); EmitToInsert(dt.Rows[i]["SupplierCode"].ToString(), this.BiddingEmitCode); } /////////////////////////////////////////////////////// } //更新供应商列表 BSup.BiddingSupplierCode = this.dgListView.DataKeys[i].ToString(); BSup.State = stat; BSup.dao = dao; BSup.BiddingSupplierUpdate(); //BSup.BiddingSupplierUpdate(); } dao.SubmitEntity(entity); entity.Dispose(); } //保存开标人 if (this.CheckBox2.Checked) { BiddingBFL.Emit_SendMail(this.BiddingEmitCode, Server.MapPath(ConfigurationManager.AppSettings["VirtualDirectory"].ToString()) + @"\EmailTemplate.xml"); foreach (ListItem opener in chkOpener.Items) { if (opener.Selected) { BiddingBFL.InsertBiddingOpener(this.BiddingEmitCode, opener.Value); } } } } }
/// **************************************************************************** /// <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); } }