private void Get_BiddingData()
{
BLL.BiddingEmit biddemit = new BiddingEmit();
biddemit.BiddingCode = this.BiddingCode;
DataTable dt = biddemit.GetBiddingEmits();
DataView dv = new DataView(dt);
dv.Sort = "BiddingEmitCode";
this.Bind_DataGrid1(dv);
}
/// <summary>
/// 将BiddingSupplier数据结构的数据集增加第一次议价，第二次议价和第三次议价
/// </summary>
/// <param name="dt"></param>
public void GetResourseData(DataTable dt)
{
dt.Columns.Add("BiddingReturnMondey1", System.Type.GetType("System.String")); //第一次议价
dt.Columns.Add("BiddingReturnMondey2", System.Type.GetType("System.String")); //第二次议价
dt.Columns.Add("BiddingReturnMondey3", System.Type.GetType("System.String")); //第三次议价
string company = System.Configuration.ConfigurationManager.AppSettings["PMName"].ToLower();
switch (company)
{
case "zhudingpm":
this.dgList.Columns[4].HeaderText = "提名人";
break;
default:
this.dgList.Columns[4].HeaderText = "厂商报价";
break;
}
BiddingEmit cbiddingEmit = new BiddingEmit();
cbiddingEmit.BiddingCode = this.BiddingCode;
DataTable dtBiddingEmit = cbiddingEmit.GetBiddingEmits();
BiddingReturn cbiddingReturn = new BiddingReturn();
int i = 0;
if (dtBiddingEmit != null)
{
foreach (DataRow drBiddingEmit in dtBiddingEmit.Select())
{
int j = 0;
cbiddingReturn.BiddingEmitCode = drBiddingEmit["BiddingEmitCode"].ToString();
DataTable dtBiddingReturn = cbiddingReturn.GetBiddingReturns();
int columnIndex = dt.Columns.IndexOf("BiddingReturnMondey1") + i;
if (dtBiddingReturn != null)
{
foreach (DataRow drBiddingReturn in dtBiddingReturn.Select())
{
dt.Rows[j][columnIndex] = drBiddingReturn["Remark"].ToString();
j++;
}
}
i++;
}
}
}
private void LoadData()
{
BLL.Bidding bidding = new RmsPM.BLL.Bidding();
bidding.BiddingCode = this.BiddingCode;
this.Lb_ObMoney.Text = String.Format("{0:N}", Convert.ToDecimal(bidding.ObligateMoney));
//取回商家报价
BLL.BiddingEmit biddEmit = new BiddingEmit();
//string lastCode = biddEmit.GetLastEmitCode(BiddingCode);
//BLL.BiddingReturn biddReturn = new BiddingReturn();
//biddReturn.Flag="1";
//biddReturn.BiddingEmitCode = lastCode;
//Lb_PjMoney.Text = biddReturn.Money;
//Response.Write(Rms.Web.JavaScript.Alert(true,lastCode+"hgjgj"+biddReturn.Money));
string pjMoney = biddEmit.GetFactMoneyByBiddingCode(this.BiddingCode);
Lb_PjMoney.Text = String.Format("{0:N}", Convert.ToDecimal(pjMoney));
Decimal FactMoney = Convert.ToDecimal(pjMoney) - Convert.ToDecimal(bidding.ObligateMoney);
//Lb_PjMoney.Text =
Lb_FactMoney.Text = String.Format("{0:N}", Convert.ToDecimal(FactMoney)); //.ToString();
}
/// <summary>
/// 网上招投标发送Email通知供应商用户名密码，单个供应商
/// </summary>
/// <param name="SupplierCode">供应商编号</param>
/// <param name="EmitToCode">投标编号</param>
/// <param name="pwd">密码</param>
/// <param name="gid">用户名</param>
/// <param name="EmailTemplateFileName">邮件模板XML文件名</param>
private static void SendEmail(string SupplierCode, string EmitToCode, string pwd, string gid, string EmailTemplateFileName)
{
try
{
string Title = "";
string MailBody = "";
string UserMail = "";
string UserName = "";
string BiddingTitle = "";
string MailUser = ConfigurationManager.AppSettings["MailUser"].ToString();
string MailPwd = ConfigurationManager.AppSettings["MailPwd"].ToString();
EntityData entity = new EntityData();
entity = SupplierRule.GetSupplierByCode(SupplierCode);
if (entity.HasRecord())
{
UserName = entity.CurrentTable.Rows[0]["SupplierName"].ToString();
UserMail = entity.CurrentTable.Rows[0]["EMail"].ToString();
entity.Dispose();
if (UserMail != "")
{
Bidding cBidding = new Bidding();
BiddingEmit cBiddingEmit = new BiddingEmit();
StandardEntityDAO dao = new StandardEntityDAO("BiddingEmitTo");
string BiddingCode = cBiddingEmit.GetBiddingEmitByEmitToCode(dao, EmitToCode).CurrentRow["BiddingCode"].ToString();
BiddingTitle = cBidding.GetBiddingName(BiddingCode);
XMLTreeViewManager vm = new XMLTreeViewManager(EmailTemplateFileName);
XmlDocument doc = new XmlDocument();
doc.Load(vm.m_XMLFileName);
XmlNode EmailTypeNode = doc.DocumentElement.SelectSingleNode("BiddingEmitTo");
if (EmailTypeNode != null)
{
Title = EmailTypeNode.SelectSingleNode("Title").InnerText;
MailBody = EmailTypeNode.SelectSingleNode("MailBody").InnerText;
}
Title = Title.Replace("#BiddingTitle#", BiddingTitle);
Title = Title.Replace("#Password#", pwd);
Title = Title.Replace("#GID#", gid);
MailBody = MailBody.Replace("#BiddingTitle#", BiddingTitle);
MailBody = MailBody.Replace("#Password#", pwd);
MailBody = MailBody.Replace("#GID#", gid);
BLL.MailRule mail = new BLL.MailRule();
mail.Title = Title;
mail.Body = MailBody;
mail.ToMail = UserMail;
mail.sendMail();
EmailHistoryInsert("BiddingEmitTo", EmitToCode, Title, UserMail, MailUser, MailBody, DateTime.Now);
}
}
}
catch (Exception ex)
{
ApplicationLog.WriteLog("BiddingBFL", ex, ex.Message);
}
}
/// <summary>
/// 保存数据(状态修改)
/// </summary>
public void SaveData()
{
try
{
//删除所有发标回标信息
BiddingEmit cbiddingEmit = new BiddingEmit();
cbiddingEmit.BiddingCode = this.BiddingCode;
cbiddingEmit.dao = this.dao;
BiddingReturn cbiddingReturn = new BiddingReturn();
cbiddingReturn.dao = this.dao;
EntityData entityEmit = cbiddingEmit.GetBiddingEmitEntitys();
if (entityEmit != null)
{
foreach (DataRow drBiddingEmit in entityEmit.Tables["BiddingEmit"].Select())
{
cbiddingReturn.BiddingEmitCode = drBiddingEmit["BiddingEmitCode"].ToString();
EntityData entityReturn = cbiddingReturn.GetBiddingReturnEntitys();
if (entityReturn != null)
{
foreach (DataRow drBiddingReturn in entityReturn.Tables["BiddingReturn"].Select())
{
drBiddingReturn.Delete();
}
cbiddingReturn.SubmitAllBiddingReturn(entityReturn);
}
entityReturn.Clear();
drBiddingEmit.Delete();
}
cbiddingEmit.SubmitAllBiddingEmit(entityEmit);
entityEmit.Clear();
}
//添加发标回标信息
for (int i = 0; i < DiscussNumber; i++)
{
BiddingEmit biddingEmitTemp = new BiddingEmit();
biddingEmitTemp.dao = this.dao;
biddingEmitTemp.BiddingEmitCode = "";
biddingEmitTemp.BiddingCode = this.BiddingCode;
biddingEmitTemp.CreatDate = System.DateTime.Now.ToString();
biddingEmitTemp.BiddingEmitAdd();
foreach (DataGridItem dg in dgList.Items)
{
BiddingReturn biddingReturnTemp = new BiddingReturn();
biddingReturnTemp.dao = this.dao;
biddingReturnTemp.BiddingReturnCode = "";
biddingReturnTemp.BiddingEmitCode = biddingEmitTemp.BiddingEmitCode;
biddingReturnTemp.SupplierCode = dg.Cells[1].Text.ToString();
string id = "TxtReturn" + System.Convert.ToString(i + 1);
biddingReturnTemp.Remark = ((System.Web.UI.HtmlControls.HtmlInputText)dg.FindControl(id)).Value.ToString();
biddingReturnTemp.BiddingDtlCode = "";
biddingReturnTemp.State = "1";
biddingReturnTemp.Flag = "1";
biddingReturnTemp.BiddingReturnAdd();
}
}
//if (this.CanSelect)
//{
// string[] chkCodes = { };
// ArrayList chkAL = new ArrayList();
// string strchkSelect = Request.Form["chkSelect"] + "";
// if ("" != strchkSelect)
// {
// chkCodes = Request.Form.GetValues("chkSelect");
// int chkCount = chkCodes.Length;
// for (int i = 0; i < chkCount; i++)
// {
// chkAL.Add(chkCodes[i]);
// }
// }
// BiddingSupplier cbs = new BiddingSupplier();
// cbs.BiddingPrejudicationCode = this.BiddingPrejudicationCode;
// cbs.dao = dao;
// DataTable myDT = cbs.GetBiddingSuppliers();
// int dtCount = myDT.Rows.Count;
// for (int r = 0; r < dtCount; r++)
// {
// string strCode = myDT.Rows[r]["BiddingSupplierCode"].ToString();
// cbs.BiddingSupplierCode = strCode;
// if (chkAL.Contains(strCode))
// {
// cbs.Flag = "1";
// }
// else
// {
// cbs.Flag = "0";
// }
// cbs.BiddingSupplierUpdate();
// }
// myDT.Dispose();
//}
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
