protected void Page_PreRenderComplete(object sender, System.EventArgs e) //120302 修改,原本為Page_PreRender改成Page_PreRenderComplete, 如此一來仿多筆審核的連下關一起簽的mail才能正常
{
//發信測試------------------------------------------
//Response.Write(this.CurrentUser.LogonID.ToString());
if (_NotifyReview)
{
if (this.FIELD_QUICK.Text == "Y")
{
quick = " --急件";
}
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//Response.Write("select top 1 REPLACE(requesturl,'EDIT','VIEW') requesturl,b.name name,email,b.id bid from dgflowqueue a left join dguser b on revieweruid=b.id where requesturl like '%" + Request.QueryString["id"] + "' AND reviewdate IS NULL AND qseq is not null");
rss.Open("select top 1 REPLACE(requesturl,'EDIT','VIEW') requesturl,b.name name,email,b.id bid,revieweruid from dgflowqueue a left join dguser b on revieweruid=b.id where requesturl like '%" + Request.QueryString["id"] + "' AND reviewdate IS NULL AND qseq is not null ");
if (!rss.EOF)
{
MyLibrary_apmt420 Backsend = new MyLibrary_apmt420();
Backsend.RunMailProcess(rss["requesturl"].ToString(),
rss["name"].ToString(), rss["email"].ToString(), " 請購單號:" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + quick.ToString()); //link,name,who mail,titel
//DBTransfer actsql1 = new DBTransfer();
//actsql1.RunIUSql("insert into misbuffer2(caption)values('ann信裡面" + this.FIELD_pmk01.Text + "')");
#region 代理人
SmoothEnterprise.Database.DataSet rs2 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rs2.Open(" SELECT b.name name,email FROM dguserdeputy a left join dguser b on a.deputyuid=b.id left join dgflow c on a.sid=c.id " +
" where a.uid='" + rss["bid"].ToString() + "' " +
" and b.id not in ( select revieweruid from dgflowqueue a left join dguser b on revieweruid=b.id where requesturl like '%" + Request.QueryString["id"] + "' and revieweruid <> '00000000-0000-0000-0000-000000000000') and " +
" ((a.sid is null and sdate < GETDATE() and edate is null) or " +
" (c.typename like 'ERP_FLOW%' and sdate < GETDATE() and edate is null) or " +
" (c.typename like 'ERP_FLOW%' and sdate < GETDATE() and edate > GETDATE()) or " +
" a.sid is null and sdate < GETDATE() and edate > GETDATE()) group by b.name,email "); //20120302 增加" and b.id not in ( select revieweruid from dgflowqueue a left join dguser b on revieweruid=b.id where requesturl like '%" + Request.QueryString["id"] + "' and revieweruid <> '00000000-0000-0000-0000-000000000000') and " 因為仿多筆審核下一關時, 讓宋協理不要收到信
while (!rs2.EOF)
{
//MyLibrary_AXMT610 Backsend = new MyLibrary_AXMT610();
Backsend.RunMailProcess("/ERP_APMT420/APMT420view.aspx?id=" + Request.QueryString["id"],
rs2["name"].ToString(), rs2["email"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + quick.ToString()); //link,name,who mail,titel
rs2.MoveNext();
}
rs2.Close();
#endregion
}
}
//DBTransfer actsql3 = new DBTransfer();
//actsql3.RunIUSql("insert into misbuffer2(caption)values('ann信最外裡面" + this.FIELD_pmk01.Text + "')");
}
protected void FlowFeedback1_FlowStop(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowStopEventArgs e)
{
Utility.log(1, "ERP_APMT420", e.ResultType.ToString(), CurrentUser.Name);
if (e.ResultType == SmoothEnterprise.Flowwork.Control.ReviewResultType.Complete)
{
//審核通過要執行的程式碼
try
{
string sqlstr = "";
sqlstr = "SELECT * FROM APMT420_IN_HEAD where id='" + Request.QueryString["id"] + "'";
SmoothEnterprise.Database.DataSet ds;
ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
ds.Open(sqlstr);
if (!ds.EOF)
{
ds["STATUS"] = "Y";
ds.Update();
SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//Response.Write("select * from apmt420_in_head WHERE id='" + Request.QueryString["id"] + "' ");
rs.Open("select plantid,pmk01,b.empid purempid,c.name username,c.email usermail from apmt420_in_head a left join dguser b on pur=b.id left join dguser c on senduser=c.id WHERE a.id='" + Request.QueryString["id"] + "' ");
if (!rs.EOF)
{
FileStream fs = new FileStream(@"D:\APMT420_XML\4GL\" + rs["plantid"].ToString() + "_apmt420_" + rs["pmk01"].ToString() + ".txt", FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine("\"" + rs["plantid"].ToString() + "\",\"apmt420\",\"" + rs["pmk01"].ToString() + "\",\"Y\",\"" + rs["purempid"].ToString() + "\"");
sw.Close();
fs.Close();
Upload("D:\\APMT420_XML\\4GL\\" + rs["plantid"].ToString() + "_apmt420_" + rs["pmk01"].ToString() + ".txt", "ftp://192.168.0.250/" + rs["plantid"].ToString() + "_APMT420_" + rs["pmk01"].ToString() + ".txt", "4gl", "4gl");
//發信測試------------------------------------------
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//Response.Write("select * from apmt420_in_head WHERE id='" + Request.QueryString["id"] + "' ");
rss.Open("select * from dguser where name='" + this.FIELD_gen02_3.Text + "' ");
if (!rss.EOF)
{
if (rs["usermail"].ToString() == "" || rs["usermail"].ToString() == rss["email"].ToString())
{
MyLibrary_apmt420 Backsend = new MyLibrary_apmt420();
Backsend.RunMailProcess("/ERP_APMT420/APMT420view.aspx?id=" + Request.QueryString["id"],
rss["name"].ToString(), rss["email"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,結果為:完成審核"); //link,name,who mail,titel
//Response.Write("/ERP_APMT420/APMT420Edit.aspx?id=" + Request.QueryString["id"] + "<br>" + rss["name"].ToString() + "<br>" + rss["email"].ToString() + "<br>" + " 請購單號:" + this.FIELD_pmk01.Text + "<br>" + " 廠商:" + this.FIELD_pmc03.Text + "<br>");
}
else
{
MyLibrary_apmt420 Backsend = new MyLibrary_apmt420();
Backsend.RunMailProcess("/ERP_APMT420/APMT420view.aspx?id=" + Request.QueryString["id"],
rss["name"].ToString(), rss["email"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,結果為:完成審核"); //link,name,who mail,titel
MyLibrary_apmt420 Backsend1 = new MyLibrary_apmt420();
Backsend1.RunMailProcess("/ERP_APMT420/APMT420view.aspx?id=" + Request.QueryString["id"],
rs["username"].ToString(), rs["usermail"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,結果為:完成審核"); //link,name,who mail,titel
}
}
//發信測試------------------------------------------
if (this.FIELD_chemistry.Text == "Y")
{
SmoothEnterprise.Database.DataSet rsx = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rsx.Open("select b.name name,b.id id,b.email email from ERP_FLOW a left join dguser b on a.PID=b.id WHERE ERP_NAME='apmt420' and DEP_NAME='GAD'");
while (!rsx.EOF)
{
MyLibrary_apmt420 Backsenda = new MyLibrary_apmt420();
Backsenda.RunMailProcess("/ERP_APMT420/APMT420view.aspx?id=" + Request.QueryString["id"],
rsx["name"].ToString(), rsx["email"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,為化學氣體類或外包修繕類"); //link,name,who mail,titel
rsx.MoveNext();
}
rsx.Close();
}
}
}
else
{
ds["STATUS"] = " ";
ds.Update();
}
}
catch
{
//Response.Write("有問題");
}
}
if (e.ResultType == SmoothEnterprise.Flowwork.Control.ReviewResultType.Terminate ||
e.ResultType == SmoothEnterprise.Flowwork.Control.ReviewResultType.Return)
{
//被退回要執行的程式碼
try
{
string sqlstr = "";
sqlstr = "SELECT * FROM APMT420_IN_HEAD where id='" + Request.QueryString["id"] + "'";
SmoothEnterprise.Database.DataSet ds;
ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
ds.Open(sqlstr);
//ds.Open("SELECT * FROM emp_add WHERE id='" + Request.QueryString["id"] + "'");
//Response.Write(ds.EOF);
//Response.Write("SELECT * FROM bomheadbuffer WHERE TROWID='" + Request.QueryString["TROWID"] + "'");
if (!ds.EOF)
{
//Response.Write("有資料");
ds["STATUS"] = "退回"; //被退回
ds.Update();
SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//Response.Write("select * from apmt420_in_head WHERE id='" + Request.QueryString["id"] + "' ");
rs.Open("select plantid,pmk01,b.empid purempid,c.name username,c.email usermail from apmt420_in_head a left join dguser b on pur=b.id left join dguser c on senduser=c.id WHERE a.id='" + Request.QueryString["id"] + "' ");
if (!rs.EOF)
{
FileStream fs = new FileStream(@"D:\APMT420_XML\4GL\" + rs["plantid"].ToString() + "_apmt420_" + rs["pmk01"].ToString() + ".txt", FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine("\"" + rs["plantid"].ToString() + "\",\"apmt420\",\"" + rs["pmk01"].ToString() + "\",\"N\",\"\"");
sw.Close();
fs.Close();
Upload("D:\\APMT420_XML\\4GL\\" + rs["plantid"].ToString() + "_apmt420_" + rs["pmk01"].ToString() + ".txt", "ftp://192.168.0.250/" + rs["plantid"].ToString() + "_APMT420_" + rs["pmk01"].ToString() + ".txt", "4gl", "4gl");
//發信測試------------------------------------------
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//Response.Write("select * from apmt420_in_head WHERE id='" + Request.QueryString["id"] + "' ");
//rss.Open("select * from dguser where name='" + this.FIELD_gen02_3.Text + "' ");
rss.Open("select b.* from apmt420_in_head a " +
" left join dguser b on pmk12=erpid WHERE a.id='" + Request.QueryString["id"] + "'");
if (!rss.EOF)
{
if (rs["usermail"].ToString() == "" || rs["usermail"].ToString() == rss["email"].ToString())
{
MyLibrary_apmt420 Backsend = new MyLibrary_apmt420();
Backsend.RunMailProcess("/ERP_APMT420/APMT420edit.aspx?id=" + Request.QueryString["id"],
rss["name"].ToString(), rss["email"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,結果為:退回"); //link,name,who mail,titel
//Response.Write("/ERP_APMT420/APMT420Edit.aspx?id=" + Request.QueryString["id"] + "<br>" + rss["name"].ToString() + "<br>" + rss["email"].ToString() + "<br>" + " 請購單號:" + this.FIELD_pmk01.Text + "<br>" + " 廠商:" + this.FIELD_pmc03.Text + "<br>");
}
else
{
MyLibrary_apmt420 Backsend = new MyLibrary_apmt420();
Backsend.RunMailProcess("/ERP_APMT420/APMT420edit.aspx?id=" + Request.QueryString["id"],
rss["name"].ToString(), rss["email"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,結果為:退回"); //link,name,who mail,titel
MyLibrary_apmt420 Backsend1 = new MyLibrary_apmt420();
Backsend1.RunMailProcess("/ERP_APMT420/APMT420edit.aspx?id=" + Request.QueryString["id"],
rs["username"].ToString(), rs["usermail"].ToString(), "請購單" + this.FIELD_pmk01.Text + " 廠商:" + this.FIELD_pmc03.Text + " ,結果為:退回"); //link,name,who mail,titel
}
}
//發信測試------------------------------------------
}
}
else
{
ds["STATUS"] = "Y";
ds.Update();
}
}
catch
{
// Response.Write("有問題");
}
}
}