/// <summary>
/// 网上招投标数据写入
/// </summary>
/// <param name="SupplierCode"></param>
/// <param name="EmitCode"></param>
private void EmitToInsert(string SupplierCode, string EmitCode)
{
string pwd = BiddingBFL.NewPassword();
string gid = BiddingBFL.NewBiddingSN();
EntityData entity = new EntityData("BiddingEmit");
string sql = "select * from BiddingEmit insert into BiddingEmitTo(BiddingEmitCode,SupplierCode,IsOnline,SerialNum,SuppPwd) values ('" + EmitCode + "','" + SupplierCode + "','0','" + gid + "','" + pwd + "') ";
if (dao == null)
{
QueryAgent QA = new QueryAgent();
entity = QA.FillEntityData("BiddingEmit", sql);
}
else
{
dao.EntityName = "BiddingEmit";
dao.FillEntity(sql, entity);
}
}
protected void btnSave_ServerClick(object sender, System.EventArgs e)
{
if (BiddingReturnModify1.BiddingReturnCheck())
{
this.RegisterStartupScript("CheckAlert", "<script>alert('回标单位金额和日期必须同时填写！');</script>");
return;
}
else
{
using (StandardEntityDAO dao = new StandardEntityDAO("BiddingReturn"))
{
dao.BeginTrans();
try
{
/***********************************************************/
this.BiddingReturnModify1.dao = dao;
this.BiddingReturnModify1.SubmitData();
/*******************************************************/
dao.CommitTrans();
//手工回标，直接置为已开标
BiddingBFL.SetEmit_State(Request["BiddingEmitCode"] + "", 1);
Response.Write("<script>window.opener.location.reload(true)</script>");
// Response.Write("<script>window.close()</script>");
/*Response.Write(Rms.Web.JavaScript.ScriptStart);
* Response.Write(Rms.Web.JavaScript.OpenerReload(false));
* Response.Write(Rms.Web.JavaScript.WinClose(false));
* Response.Write(Rms.Web.JavaScript.ScriptEnd);*/
}
catch (Exception ex)
{
dao.RollBackTrans();
Response.Write(Rms.Web.JavaScript.Alert(true, "请填写回标单位日期！"));
//throw ex;
}
finally
{
}
}
}
/*******************************************************************/
}
/// <summary>
/// 显示开标人列表
///
/// </summary>
/// <param name="IsNew"></param>
private void LoadBiddingOpener(bool IsNew)
{
List <string> listOpener = BiddingBFL.ListAvaiableBiddingOpener();
List <string[]> listSelectedOpener = BiddingBFL.ListBiddingOpener(this.BiddingEmitCode);
chkOpener.Items.Clear();
foreach (string item in listOpener)
{
ListItem opener = new ListItem();
opener.Text = SystemRule.GetUserName(item);
opener.Value = item;
if (IsNew)
{
opener.Selected = true;
}
else
{
foreach (string[] selectitem in listSelectedOpener)
{
if (selectitem[0] == item)
{
opener.Selected = true;
if (selectitem[1] != "")
{
opener.Text += "(" + selectitem[1] + ")";
}
else
{
opener.Text += "( - - - )";
}
}
}
}
chkOpener.Items.Add(opener);
}
chkOpener.Enabled = false;
}
/// <summary>
/// 更新备注
/// </summary>
public void UpdateRemark()
{
//string lawOfPrice="";//压价
BLL.BiddingEmit addRemark = new RmsPM.BLL.BiddingEmit();
addRemark.BiddingEmitCode = this.BiddingEmitCode;
addRemark.TotalRemark2 = this.txtTotalRemark1.Text;
BLL.Bidding bidd = new RmsPM.BLL.Bidding();
bidd.BiddingCode = Request.QueryString["BiddingCode"];//this.BiddingCode;
string thisState = bidd.State;
//Response.Write(Rms.Web.JavaScript.Alert(true,thisState));
if (thisState == "5" || thisState == "6")
{
addRemark.CreatUser = "******";
//bidd.State = "6";
//bidd.BiddingSubmit();
}
//addRemark.dao = dao;
addRemark.BiddingEmitUpdate();
//if()
//BLL.BiddingEmit.UpdateRemarkByBiddingEmitCode(txtTotalRemark1.Text,this.BiddingEmitCode);
//保存开标后投标单位查看权限/shifou wangshang
BiddingBFL.UpdateEmit_AllowAfterClose(this.BiddingEmitCode, Convert.ToInt32(dpAllowAfterClose.SelectedValue));
int tmpWsZTB = 0;
if (CheckBox2.Checked)
{
tmpWsZTB = 1;
}
else
{
tmpWsZTB = 0;
}
BiddingBFL.UpdateEmit_IsWsZTB(this.BiddingEmitCode, tmpWsZTB);
}
/// ****************************************************************************
/// <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 InitPage()
{
if (Request["State"] + "" == "edit")
{
string ApplicationCode = Request["ApplicationCode"] + "";
string BiddingCode = Request["BiddingCode"] + "";
this.BiddingEmitModify1.ApplicationCode = ApplicationCode;
this.BiddingEmitModify1.BiddingCode = BiddingCode;
this.BiddingReturnModify1.BiddingEmitCode = ApplicationCode;
this.BiddingReturnModify1.BiddingCode = BiddingCode;
this.BiddingReturnModify1.IsWSZTB = this.user.HasRight("210301");
BiddingEmitModify1.State = WorkFlowControl.ModuleState.Operable;
BiddingReturnModify1.State = WorkFlowControl.ModuleState.Eyeable;
this.btnSave.Visible = true;
this.btnReSNandPWD.Visible = false;
if (ApplicationCode != "")
{
this.btnDel.Visible = true;
}
else
{
this.btnDel.Visible = false;
}
BiddingEmitModify1.InitControl();
BiddingReturnModify1.InitControl();
BiddingDtlModify1.ApplicationCode = BiddingCode;
BiddingDtlModify1.State = WorkFlowControl.ModuleState.Eyeable;
if (this.user.HasRight("2106"))
{
BiddingDtlModify1.PriceState = WorkFlowControl.ModuleState.Operable;
}
BiddingDtlModify1.InitControl();
SetBiddingEmitManage();
}
else if (Request["State"] + "" == "view")
{
/*BiddingEmitModify1.State = WorkFlowControl.ModuleState.Eyeable;
* BiddingReturnModify1.State = WorkFlowControl.ModuleState.Other;
* BiddingReturnModify1.BiddingEmitCode=ApplicationCode;*/
string BiddingEmitCode = Request["BiddingEmitCode"] + "";
this.BiddingEmitModify1.ApplicationCode = BiddingEmitCode;
BiddingEmitModify1.State = WorkFlowControl.ModuleState.Eyeable;
BiddingReturnModify1.State = WorkFlowControl.ModuleState.Other;
this.BiddingReturnModify1.IsWSZTB = this.user.HasRight("210301");
BiddingReturnModify1.IsReturnView = false;
BiddingReturnModify1.BiddingEmitCode = BiddingEmitCode;
this.btnSave.Visible = false;
this.btnReSNandPWD.Visible = true;
this.btnDel.Visible = false;
BiddingEmitModify1.InitControl();
BiddingReturnModify1.InitControl();
BiddingDtlModify1.ApplicationCode = BiddingEmitModify1.BiddingCode;
BiddingDtlModify1.State = WorkFlowControl.ModuleState.Eyeable;
BiddingDtlModify1.BiddingEmitCode = BiddingEmitCode;
BiddingDtlModify1.InitControl();
//判断是否能修改
BLL.BiddingEmit bidEmit = new BLL.BiddingEmit();
bidEmit.BiddingEmitCode = BiddingEmitCode;
if (bidEmit.CreatUser == this.user.UserCode)
{
this.btnChange.Visible = true;
}
}
if (Request["NowState"] + "" == "5")
{
Lb_Title.Text = "压 价";
}
this.btnSave.Attributes["OnClick"] = "javascript:if(BiddingEmitCheckSubmit()) ";
BiddingReturnModify1.Show_ttachMentAdd2(BiddingEmitModify1.ApplicationCode);
btnOpen.Visible = BiddingBFL.CanOpenNow(this.BiddingReturnModify1.BiddingEmitCode, this.user.UserCode);
}
protected void btnReSNandPWD_ServerClick(object sender, System.EventArgs e)
{
BiddingBFL.Emit_LastSend(this.BiddingReturnModify1.BiddingEmitCode, Server.MapPath(ConfigurationManager.AppSettings["VirtualDirectory"].ToString()) + @"\EmailTemplate.xml");
}
/// <summary>
/// 开标按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOpen_ServerClick(object sender, System.EventArgs e)
{
BiddingBFL.BiddingOpen(this.BiddingReturnModify1.BiddingEmitCode, this.user.UserCode);
InitPage();
}
