private void LoadData()
{
//绑定几个下拉列表值
btnClose.OnClientClick = ActiveWindow.GetHideReference();
DataSet dsReq = m_bllpms_Customer_Require.GetList("");
DataSet dsStr = m_bllpms_Product_Struc.GetList("");
DataSet dsMet = m_bllpms_Product_Mater.GetList("");
DataSet dsInd = m_bllpms_Product_Indust.GetList("");
DataSet dsTyp = m_bllpms_Product_Type.GetList("");
ddlReq.DataValueField = "CustomerRequireID";
ddlReq.DataTextField = "CustomerRequire";
ddlReq.DataSource = dsReq.Tables[0];
ddlReq.DataBind();
ddlStr.DataValueField = "ProductStrucID";
ddlStr.DataTextField = "ProductStruc";
ddlStr.DataSource = dsStr.Tables[0];
ddlStr.DataBind();
ddlMet.DataValueField = "ProductMaterID";
ddlMet.DataTextField = "ProductMater";
ddlMet.DataSource = dsMet.Tables[0];
ddlMet.DataBind();
ddlInd.DataValueField = "ProductIndustID";
ddlInd.DataTextField = "ProductIndust";
ddlInd.DataSource = dsInd.Tables[0];
ddlInd.DataBind();
int id = GetQueryIntValue("id");
TSM.Model.pms_Product_Info modelpms_Product_Info = m_bllpms_Product_Info.GetModel(id);
if (modelpms_Product_Info == null)
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("参数错误！", String.Empty, ActiveWindow.GetHideReference());
return;
}
//给控件赋初值,显示
lbBatchID.Text = modelpms_Product_Info.ProductBatchID.ToString().Trim();
tbxProName.Text = modelpms_Product_Info.ProductInfoName.ToString().Trim();
ddlStr.SelectedValue = modelpms_Product_Info.ProductStrucID.ToString().Trim();
ddlMet.SelectedValue = modelpms_Product_Info.ProductMaterID.ToString().Trim();
ddlReq.SelectedValue = modelpms_Product_Info.CustomerRequireID.ToString().Trim();
ddlInd.SelectedValue = modelpms_Product_Info.ProductIndustID.ToString().Trim();
tbxPic.Text = modelpms_Product_Info.ProductPhotoNum.ToString().Trim();
tbxSta.Text = modelpms_Product_Info.ProductStandard.ToString().Trim();
tbxWei.Text = modelpms_Product_Info.ProductWeight.ToString().Trim();
tbxOrd.Text = modelpms_Product_Info.OrderQuantity.ToString().Trim();
tbxRem.Text = modelpms_Product_Info.Remarks.ToString().Trim();
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TSM.Model.pms_Product_Info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update pms_Product_Info set ");
strSql.Append("ProductBatchID=@ProductBatchID,");
strSql.Append("CustomerRequireID=@CustomerRequireID,");
strSql.Append("ProductTypeID=@ProductTypeID,");
strSql.Append("ProductStrucID=@ProductStrucID,");
strSql.Append("ProductMaterID=@ProductMaterID,");
strSql.Append("ProductIndustID=@ProductIndustID,");
strSql.Append("ProductInfoName=@ProductInfoName,");
strSql.Append("ProductPhotoNum=@ProductPhotoNum,");
strSql.Append("ProductStandard=@ProductStandard,");
strSql.Append("ProductWeight=@ProductWeight,");
strSql.Append("OrderQuantity=@OrderQuantity,");
strSql.Append("ContourSize=@ContourSize,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where ProductInfoID=@ProductInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductInfoID", SqlDbType.Int, 4),
new SqlParameter("@ProductBatchID", SqlDbType.Int, 4),
new SqlParameter("@CustomerRequireID", SqlDbType.Int, 4),
new SqlParameter("@ProductTypeID", SqlDbType.Int, 4),
new SqlParameter("@ProductStrucID", SqlDbType.Int, 4),
new SqlParameter("@ProductMaterID", SqlDbType.Int, 4),
new SqlParameter("@ProductIndustID", SqlDbType.Int, 4),
new SqlParameter("@ProductInfoName", SqlDbType.VarChar, 64),
new SqlParameter("@ProductPhotoNum", SqlDbType.VarChar, 64),
new SqlParameter("@ProductStandard", SqlDbType.VarChar, 64),
new SqlParameter("@ProductWeight", SqlDbType.Decimal, 9),
new SqlParameter("@OrderQuantity", SqlDbType.VarChar, 64),
new SqlParameter("@ContourSize", SqlDbType.VarChar, 144),
new SqlParameter("@Remarks", SqlDbType.Text)
};
parameters[0].Value = model.ProductInfoID;
parameters[1].Value = model.ProductBatchID;
parameters[2].Value = model.CustomerRequireID;
parameters[3].Value = model.ProductTypeID;
parameters[4].Value = model.ProductStrucID;
parameters[5].Value = model.ProductMaterID;
parameters[6].Value = model.ProductIndustID;
parameters[7].Value = model.ProductInfoName;
parameters[8].Value = model.ProductPhotoNum;
parameters[9].Value = model.ProductStandard;
parameters[10].Value = model.ProductWeight;
parameters[11].Value = model.OrderQuantity;
parameters[12].Value = model.ContourSize;
parameters[13].Value = model.Remarks;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TSM.Model.pms_Product_Info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into pms_Product_Info(");
strSql.Append("ProductBatchID,CustomerRequireID,ProductTypeID,ProductStrucID,ProductMaterID,ProductIndustID,ProductInfoName,ProductPhotoNum,ProductStandard,ProductWeight,OrderQuantity,ContourSize,Remarks)");
strSql.Append(" values (");
strSql.Append("@ProductBatchID,@CustomerRequireID,@ProductTypeID,@ProductStrucID,@ProductMaterID,@ProductIndustID,@ProductInfoName,@ProductPhotoNum,@ProductStandard,@ProductWeight,@OrderQuantity,@ContourSize,@Remarks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProductBatchID", SqlDbType.Int, 4),
new SqlParameter("@CustomerRequireID", SqlDbType.Int, 4),
new SqlParameter("@ProductTypeID", SqlDbType.Int, 4),
new SqlParameter("@ProductStrucID", SqlDbType.Int, 4),
new SqlParameter("@ProductMaterID", SqlDbType.Int, 4),
new SqlParameter("@ProductIndustID", SqlDbType.Int, 4),
new SqlParameter("@ProductInfoName", SqlDbType.VarChar, 64),
new SqlParameter("@ProductPhotoNum", SqlDbType.VarChar, 64),
new SqlParameter("@ProductStandard", SqlDbType.VarChar, 64),
new SqlParameter("@ProductWeight", SqlDbType.Decimal, 9),
new SqlParameter("@OrderQuantity", SqlDbType.VarChar, 64),
new SqlParameter("@ContourSize", SqlDbType.VarChar, 144),
new SqlParameter("@Remarks", SqlDbType.Text)
};
parameters[0].Value = model.ProductBatchID;
parameters[1].Value = model.CustomerRequireID;
parameters[2].Value = model.ProductTypeID;
parameters[3].Value = model.ProductStrucID;
parameters[4].Value = model.ProductMaterID;
parameters[5].Value = model.ProductIndustID;
parameters[6].Value = model.ProductInfoName;
parameters[7].Value = model.ProductPhotoNum;
parameters[8].Value = model.ProductStandard;
parameters[9].Value = model.ProductWeight;
parameters[10].Value = model.OrderQuantity;
parameters[11].Value = model.ContourSize;
parameters[12].Value = model.Remarks;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void SaveProductType()
{
TSM.Model.pms_Product_Info modelpms_Product_Info = new TSM.Model.pms_Product_Info();
modelpms_Product_Info.ProductBatchID = GetQueryIntValue("id");
modelpms_Product_Info.ProductTypeID = 2;
modelpms_Product_Info.ProductIndustID = int.Parse(ddlInd.SelectedValue);
modelpms_Product_Info.ProductMaterID = int.Parse(ddlMet.SelectedValue);
modelpms_Product_Info.ProductStrucID = int.Parse(ddlStr.SelectedValue);
modelpms_Product_Info.CustomerRequireID = int.Parse(ddlReq.SelectedValue);
modelpms_Product_Info.ProductInfoName = tbxProName.Text.Trim();
modelpms_Product_Info.ProductPhotoNum = tbxPic.Text.Trim();
modelpms_Product_Info.ProductStandard = tbxSta.Text.Trim();
modelpms_Product_Info.ProductWeight = Convert.ToDecimal(tbxWei.Text);
modelpms_Product_Info.OrderQuantity = tbxOrd.Text.Trim();
modelpms_Product_Info.Remarks = tbxRem.Text.Trim();
m_bllpms_Product_Info.Add(modelpms_Product_Info);
}
private void sendMail()
{
int id = m_bllpms_Product_Info.GetMaxId() - 1;
TSM.Model.pms_Product_Info modelpms_Product_Info = m_bllpms_Product_Info.GetViewModel(id);
/********发送审批结果通知邮件*******/
MailMessage mmsg2 = new MailMessage();
mmsg2.From = new MailAddress("*****@*****.**", "生产管理系统", Encoding.UTF8);
string senderDisplayName = ConfigurationManager.AppSettings["生产管理系统"];//这个配置的是发件人的要显示在邮件的名称
mmsg2.CC.Add(new MailAddress(modelpms_Product_Info.营销员邮箱));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.CC.Add(new MailAddress("*****@*****.**"));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.Subject = modelpms_Product_Info.图号.ToString().Trim() + "-" + modelpms_Product_Info.产品名称.ToString().Trim() + "-报价通知";
mmsg2.Body = @"
<BODY style= margin:10px; width:1200px; height:900px>
<table style= width:1200px; height:900px>
<tr>
<td colspan=2 style= height:90px>
<img src=http://192.168.0.6/pms/res/images/bg_lft.gif alt=12 />
</td>
</tr>
<tr>
<td rowspan=2><img src= http://192.168.0.6/pms/res/images/bg_lft3.gif alt=22 />
<table style= ""width:570px; height:432px;"">
<tr style="" background-color:#FFB90F; font-weight:bolder; text-align:center ""><td>产品名称</td><td>图号</td><td>规范</tr></tr>
<tr style="" background-color:#D1EEEE; text-align:center;""><td>" + modelpms_Product_Info.产品名称.ToString().Trim()
+ "</td><td>" + modelpms_Product_Info.图号.ToString().Trim() + "</td><td>" + modelpms_Product_Info.规范.ToString().Trim() + @"</td></tr>
<tr style="" background-color:#FFB90F; text-align:center; font-weight:bolder ""><td>产品结构</td><td>材质</td><td>行业</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center ""><td>" + modelpms_Product_Info.产品结构.ToString().Trim()
+ "</td><td>" + modelpms_Product_Info.产品材质.ToString().Trim() + "</td><td>" + modelpms_Product_Info.所在行业.ToString().Trim() + @"</td></tr>
<tr style="" background-color:#FFB90F; text-align:center; font-weight:bold ""><td>顾客要求</td><td>内部顾客</td><td>最终顾客</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; ""><td>" + modelpms_Product_Info.顾客要求.ToString().Trim()
+ "</td><td>" + modelpms_Product_Info.顾客名称.ToString().Trim() + "</td><td>" + modelpms_Product_Info.最终客户.ToString().Trim() + @"</td></tr>
<tr style="" background-color:#FFB90F; text-align:center; font-weight:bold ""><td>净重(T)</td><td>订单量</td><td></td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; ""><td>" + modelpms_Product_Info.净重.ToString().Trim()
+ "</td><td>" + modelpms_Product_Info.订单量.ToString().Trim() + @"</td><td></td></tr>
<tr style="" background-color:#EEEED1; text-align:center; ""><td>备注信息</td><td colspan= 2>" + modelpms_Product_Info.备注.ToString().Trim()
+ @"</td></tr>
<tr style="" background-color:#FFFFFF; text-align:center; font-weight:bold ""><td></td><td></td><td></td></tr>
<tr style="" background-color:#EEEED1; text-align:center ""><td colspan= 3 >请各位领导安排工艺员<a href=""http://192.168.0.6/pms/default.aspx""><span style="" font-weight:bolder; color:Red"">登录系统</span></a>进行报价!</td></tr>
</table></td>
<td><img src= http://192.168.0.6/pms/res/images/bg_rht2.gif alt= 22 /></td>
</tr>
<tr>
<td><img src= http://192.168.0.6/pms/res/images/bg_rht1.gif alt= 22 /></td>
</tr>
<tr>
<td colspan= 2 ><img src= http://192.168.0.6/pms/res/images/bg_btm.gif alt= 22 /></td>
</tr>
</table>
</BODY> ";
mmsg2.IsBodyHtml = true;
SmtpClient msclient2 = new SmtpClient();
msclient2.Host = "192.168.0.10";
msclient2.DeliveryMethod = SmtpDeliveryMethod.Network;
msclient2.Credentials = new System.Net.NetworkCredential("kp.ccz", "lan@2mail");
try
{
msclient2.Send(mmsg2);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
/*****/
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSM.Model.pms_Product_Info GetViewModel(int ProductInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from view_pms_Product_Info ");
strSql.Append(" where ProductInfoID=@ProductInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = ProductInfoID;
TSM.Model.pms_Product_Info model = new TSM.Model.pms_Product_Info();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ProductInfoID"].ToString() != "")
{
model.ProductInfoID = int.Parse(ds.Tables[0].Rows[0]["ProductInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductBatchID"].ToString() != "")
{
model.ProductBatchID = int.Parse(ds.Tables[0].Rows[0]["ProductBatchID"].ToString());
}
if (ds.Tables[0].Rows[0]["批次名称"].ToString() != "")
{
model.批次名称 = ds.Tables[0].Rows[0]["批次名称"].ToString();
}
model.产品名称 = ds.Tables[0].Rows[0]["产品名称"].ToString();
model.顾客类型 = ds.Tables[0].Rows[0]["顾客类型"].ToString();
model.顾客名称 = ds.Tables[0].Rows[0]["顾客名称"].ToString();
model.顾客要求 = ds.Tables[0].Rows[0]["顾客要求"].ToString();
model.产品结构 = ds.Tables[0].Rows[0]["产品结构"].ToString();
model.产品材质 = ds.Tables[0].Rows[0]["产品材质"].ToString();
model.所在行业 = ds.Tables[0].Rows[0]["所在行业"].ToString();
model.图号 = ds.Tables[0].Rows[0]["图号"].ToString();
model.规范 = ds.Tables[0].Rows[0]["规范"].ToString();
model.净重 = ds.Tables[0].Rows[0]["净重"].ToString();
model.日期 = ds.Tables[0].Rows[0]["日期"].ToString();
model.订单量 = ds.Tables[0].Rows[0]["订单量"].ToString();
model.备注 = ds.Tables[0].Rows[0]["备注"].ToString();
model.附件名称 = ds.Tables[0].Rows[0]["附件名称"].ToString();
model.附件地址 = ds.Tables[0].Rows[0]["附件地址"].ToString();
model.节点 = ds.Tables[0].Rows[0]["上传节点"].ToString();
model.时间 = ds.Tables[0].Rows[0]["上传时间"].ToString();
model.人 = ds.Tables[0].Rows[0]["上传人"].ToString();
model.商务联系人 = ds.Tables[0].Rows[0]["商务联系人"].ToString();
model.商务联系电话 = ds.Tables[0].Rows[0]["商务联系电话"].ToString();
model.商务联系邮箱 = ds.Tables[0].Rows[0]["商务联系邮箱"].ToString();
model.质量联系人 = ds.Tables[0].Rows[0]["质量联系人"].ToString();
model.质量联系电话 = ds.Tables[0].Rows[0]["质量联系电话"].ToString();
model.质量联系邮箱 = ds.Tables[0].Rows[0]["质量联系邮箱"].ToString();
model.ApprovalStatus = ds.Tables[0].Rows[0]["ApprovalStatus"].ToString();
model.QuotationInfoID = int.Parse(ds.Tables[0].Rows[0]["QuotationInfoID"].ToString());
model.最终客户 = ds.Tables[0].Rows[0]["最终客户"].ToString();
model.报价人 = ds.Tables[0].Rows[0]["报价人"].ToString();
model.报价邮箱 = ds.Tables[0].Rows[0]["报价邮箱"].ToString();
model.营销员邮箱 = ds.Tables[0].Rows[0]["营销员邮箱"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSM.Model.pms_Product_Info GetModel(int ProductInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ProductInfoID,ProductBatchID,CustomerRequireID,ProductTypeID,ProductStrucID,ProductMaterID,ProductIndustID,ProductInfoName,ProductPhotoNum,ProductStandard,ProductWeight,OrderQuantity,ContourSize,Remarks from pms_Product_Info ");
strSql.Append(" where ProductInfoID=@ProductInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = ProductInfoID;
TSM.Model.pms_Product_Info model = new TSM.Model.pms_Product_Info();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ProductInfoID"].ToString() != "")
{
model.ProductInfoID = int.Parse(ds.Tables[0].Rows[0]["ProductInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductBatchID"].ToString() != "")
{
model.ProductBatchID = int.Parse(ds.Tables[0].Rows[0]["ProductBatchID"].ToString());
}
if (ds.Tables[0].Rows[0]["CustomerRequireID"].ToString() != "")
{
model.CustomerRequireID = int.Parse(ds.Tables[0].Rows[0]["CustomerRequireID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductTypeID"].ToString() != "")
{
model.ProductTypeID = int.Parse(ds.Tables[0].Rows[0]["ProductTypeID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductStrucID"].ToString() != "")
{
model.ProductStrucID = int.Parse(ds.Tables[0].Rows[0]["ProductStrucID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductMaterID"].ToString() != "")
{
model.ProductMaterID = int.Parse(ds.Tables[0].Rows[0]["ProductMaterID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductIndustID"].ToString() != "")
{
model.ProductIndustID = int.Parse(ds.Tables[0].Rows[0]["ProductIndustID"].ToString());
}
model.ProductInfoName = ds.Tables[0].Rows[0]["ProductInfoName"].ToString();
model.ProductPhotoNum = ds.Tables[0].Rows[0]["ProductPhotoNum"].ToString();
model.ProductStandard = ds.Tables[0].Rows[0]["ProductStandard"].ToString();
if (ds.Tables[0].Rows[0]["ProductWeight"].ToString() != "")
{
model.ProductWeight = decimal.Parse(ds.Tables[0].Rows[0]["ProductWeight"].ToString());
}
model.OrderQuantity = ds.Tables[0].Rows[0]["OrderQuantity"].ToString();
model.ContourSize = ds.Tables[0].Rows[0]["ContourSize"].ToString();
model.Remarks = ds.Tables[0].Rows[0]["Remarks"].ToString();
return(model);
}
else
{
return(null);
}
}
private void sendMail_Final()
{
int ProID = GetQueryIntValue("id1");
TSM.Model.pms_Product_Info modelpms_Product_Info = m_bllpms_Product_Info.GetViewModel(ProID);
decimal UnitPrice = Math.Round(Convert.ToDecimal(lbPrice1.Text) / Convert.ToDecimal(modelpms_Product_Info.净重), 0);
/********发送审批结果通知邮件***/
MailMessage mmsg2 = new MailMessage();
mmsg2.From = new MailAddress("*****@*****.**", "生产管理系统", Encoding.UTF8);
mmsg2.CC.Add(new MailAddress(modelpms_Product_Info.报价邮箱));
mmsg2.CC.Add(new MailAddress(modelpms_Product_Info.营销员邮箱));
mmsg2.CC.Add(new MailAddress("*****@*****.**"));
mmsg2.CC.Add(new MailAddress("*****@*****.**"));
mmsg2.To.Add(new MailAddress(modelpms_Product_Info.商务联系邮箱));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.Subject = modelpms_Product_Info.图号 + "-" + modelpms_Product_Info.产品名称 + "-报价单";
mmsg2.Body = @"
<BODY style= margin:10px; width:1200px; height:900px>
<table style= width:1200px; height:900px>
<tr>
<td colspan=2 style= height:90px>
<img src=http://192.168.0.6/pms/res/images/bg_lft.gif alt=12 />
</td>
</tr>
<tr>
<td rowspan=2><img src= http://192.168.0.6/pms/res/images/bg_lft1.gif alt=22 />
<table style= ""width:570px; height:432px;"">
<tr style="" background-color:#FFB90F; font-weight:bolder; text-align:center ""><td>产品名称</td><td>图号</td><td>单重(T)</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>" + modelpms_Product_Info.产品名称
+ "</td><td>" + modelpms_Product_Info.图号 + "</td><td>" + modelpms_Product_Info.净重 + @"</td></tr>
<tr style="" background-color:#FFFFFF; text-align:center; font-weight:bold ""><td></td><td></td><td></td></tr>
<tr style="" background-color:#FFB90F; font-weight:bolder; text-align:center ""><td>序号</td><td>项目</td><td>报价(元)</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>1</td><td>加工费用</td><td>" + tbxChar.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>2</td><td>运输费用</td><td>" + tbxTrans.Text + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>3</td><td>检测费用</td><td>" + tbxTest.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>4</td><td>包装费用</td><td>" + tbxPack.Text + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>合计单价</td><td></td><td>" + lbPrice1.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>其它</td><td>特殊刀具</td><td>" + tbxKnife.Text + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>其它</td><td>特殊工装</td><td>" + tbxTool.Text + @"</td></tr>
<tr style="" background-color:#FFFFFF; text-align:center; font-weight:bold ""><td></td><td></td><td></td></tr>
<tr style="" background-color:#D1EEEE; text-align:center ""><td>说明</td><td colspan= 2 >本次报价有效期3个月,过期则需重新评估报价</td></tr>
</table></td>
<td><img src= http://192.168.0.6/pms/res/images/bg_rht2.gif alt= 22 /></td>
</tr>
<tr>
<td><img src= http://192.168.0.6/pms/res/images/bg_rht1.gif alt= 22 /></td>
</tr>
<tr>
<td colspan= 2 ><img src= http://192.168.0.6/pms/res/images/bg_btm.gif alt= 22 /></td>
</tr>
</table>
</BODY> ";
mmsg2.IsBodyHtml = true;
SmtpClient msclient2 = new SmtpClient();
msclient2.Host = "192.168.0.10";
msclient2.DeliveryMethod = SmtpDeliveryMethod.Network;
msclient2.Credentials = new System.Net.NetworkCredential("kp.ccz", "lan@2mail");
try
{
msclient2.Send(mmsg2);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
/****/
}
private void sendMail()
{
var uname = HttpUtility.UrlEncode("刘立");
var url1 = "http://192.168.0.6/pms/pms_Processing_Approval_Info.aspx?uname=" + uname + "&uid=4";
//var url1 = "http://*****:*****@kocel.com", "生产管理系统", Encoding.UTF8);
mmsg2.CC.Add(new MailAddress(modelpms_Product_Info.报价邮箱));
mmsg2.CC.Add(new MailAddress(modelpms_Product_Info.营销员邮箱));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.To.Add(new MailAddress("*****@*****.**"));
mmsg2.Subject = modelpms_Product_Info.图号 + "-" + modelpms_Product_Info.产品名称 + "-审批通知";
mmsg2.Body = @"
<BODY style= margin:10px; width:1200px; height:900px>
<table style= width:1200px; height:900px>
<tr>
<td colspan=2 style= height:90px>
<img src=http://192.168.0.6/pms/res/images/bg_lft.gif alt=12 />
</td>
</tr>
<tr>
<td rowspan=2><img src= http://192.168.0.6/pms/res/images/bg_lft3.gif alt=22 />
<table style= ""width:570px; height:432px;"">
<tr style="" background-color:#FFB90F; font-weight:bolder; text-align:center ""><td>产品名称</td><td>图号</td><td>单重(T)</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>" + modelpms_Product_Info.产品名称
+ "</td><td>" + modelpms_Product_Info.图号 + "</td><td>" + modelpms_Product_Info.净重 + @"</td></tr>
<tr style="" background-color:#FFFFFF; text-align:center; font-weight:bold ""><td></td><td></td><td></td></tr>
<tr style="" background-color:#FFB90F; font-weight:bolder; text-align:center ""><td>序号</td><td>项目</td><td>报价(元)</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>1</td><td>加工费用</td><td>" + tbxCharge.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>2</td><td>运输费用</td><td>" + tbxTrans.Text + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>3</td><td>检测费用</td><td>" + tbxTest.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>4</td><td>包装费用</td><td>" + tbxPack.Text + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>5</td><td>喷涂费用</td><td>" + tbxSpray.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>合计单价</td><td></td><td>" + Price + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>吨单价</td><td></td><td>" + lbUnitPrice.Text + @"</td></tr>
<tr style="" background-color:#EEEED1; text-align:center; font-weight:bold ""><td>其它</td><td>特殊刀具</td><td>" + tbxKnife.Text + @"</td></tr>
<tr style="" background-color:#D1EEEE; text-align:center; font-weight:bold ""><td>其它</td><td>特殊工装</td><td>" + tbxTool.Text + @"</td></tr>
<tr style="" background-color:#FFFFFF; text-align:center; font-weight:bold ""><td></td><td></td><td></td></tr>
<tr style="" background-color:#EEEED1; text-align:center ""><td colspan= 3 >刘部长您好,请您<a href=" + url1 + @"><span style="" font-weight:bolder; color:Red"">登录系统</span></a>进行报价审批!</td></tr>
</table></td>
<td><img src= http://192.168.0.6/pms/res/images/bg_rht2.gif alt= 22 /></td>
</tr>
<tr>
<td><img src= http://192.168.0.6/pms/res/images/bg_rht1.gif alt= 22 /></td>
</tr>
<tr>
<td colspan= 2 ><img src= http://192.168.0.6/pms/res/images/bg_btm.gif alt= 22 /></td>
</tr>
</table>
</BODY> ";
mmsg2.IsBodyHtml = true;
SmtpClient msclient2 = new SmtpClient();
msclient2.Host = "192.168.0.10";
msclient2.DeliveryMethod = SmtpDeliveryMethod.Network;
msclient2.Credentials = new System.Net.NetworkCredential("kp.ccz", "lan@2mail");
try
{
msclient2.Send(mmsg2);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
/*****/
}
