protected void Btn_RemindReviewer_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
string rowid = Request.QueryString["rowid"];
head.GetInfo(rowid);
SendMail(rowid, _leader, lab_Ra_NO.Text, head.send_dt, "催審");
}
protected void BUTTON_RemindReviewer_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
ds.Open("SELECT revieweruid,name,email FROM dgflowqueue a left join dguser b " +
" on revieweruid=b.id where requesturl='" + Request.RawUrl.ToString().ToLower().Replace("view", "edit") + "'" +
" and resulttype is null and revieweruid!='00000000-0000-0000-0000-000000000000'");
//"SELECT top 1 revieweruid,name,email FROM dgflowqueue a left join dguser b " +
//" on revieweruid=b.id where requesturl like '%" + Request.QueryString[0] + "%' order by a.initdate desc");
while (!ds.EOF)
{
string MId = "{ca9348c8-504a-4454-9acc-18c03cfc8189}";
string PapCaption = "供應商代號申請單(催)";
string PID = FIELD_pmcsn.Text;
string receivername = ds["name"].ToString();
string requesturl = "http://eip.minaik.com.tw/" + Request.RawUrl.ToString().ToLower().Replace("edit", "view");
string AppMail = ds["email"].ToString();
string body = "";
string requestername = this.CurrentUser.Name.ToString();
ShrFlowMail ActRem = new ShrFlowMail();
ActRem.RemindApprove(MId, PID, receivername, requesturl, AppMail, PapCaption, body, requestername);
// ActRem.RemindApprove(MId, PID, receivername, requesturl, "*****@*****.**", PapCaption, body, requestername);
// DeputyApprove(ds[0].ToString());
Response.Write("<script>alert('已經發信請" + receivername + "儘快審核!');</script>");
ds.MoveNext();
}
}
protected void BUTTON_StopRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet rs0 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rs0.Open("SELECT ID,Pkey,IsStatus FROM Forwarder WHERE ID='" + Request.QueryString["ID"] + "'");
if (!rs0.EOF)
{
rs0["IsStatus"] = "waiting";
rs0.Update();
}
rs0.Close();
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
//
FlowClient1.TypeName = "sharflow12.Flowwork.sharflow121";
FlowClient1.Text = "ShppingFlow";
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managernm = new ArrayList();
managerid.Add(PopupUser1.Text); //主管id arraylist
managernm.Add("船務"); //主管職稱 arraylist
sharflow12.Flowwork.sharflow121 flow = new sharflow12.Flowwork.sharflow121();
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12Node1;
break;
case 2:
e.NextNode = flow.sharflow12Node2;
break;
}
e.NextNode.ReviewerURL = "/Shipping/Forwarderview.aspx";
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER0", i);
}
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE0", i);
}
SmoothEnterprise.Database.DataSet rs0 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rs0.Open("SELECT ID,Pkey,IsStatus FROM Forwarder WHERE ID='" + Request.QueryString["ID"] + "'");
if (!rs0.EOF)
{
rs0["IsStatus"] = "isSend";
rs0.Update();
}
rs0.Close();
}
protected void BUTTON_StopRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
this.InputButton2.Enabled = true;
this.InputButton1.Enabled = false;
this.BUTTON_save.Enabled = true;
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM EngineeringTest_head WHERE id='" + Request.QueryString["id"] + "' ");
while (!rb.EOF)
{
rb["STATUS"] = "N";
rb.Update();
rb.MoveNext();
}
rb.Close();
}
protected void BUTTON_StopRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM " + db1 + "cxmt310_in_head WHERE id='" + Request.QueryString["id"] + "' ");
if (!rb.EOF)
{
rb["STATUS"] = "N";
rb.Update();
}
rb.Close();
//讓更新能顯示------------------------------------------------------------------------------------
Response.Write("<script type=\"text/javascript\">");
Response.Write("location.href='cxmt310Edit.aspx?id=" + Request.QueryString["ID"] + "';");
Response.Write("</script>");
//-------------------------------------------------------------------------------------------------
}
protected void BUTTON_StopRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM " + db1 + "cimi100_main WHERE id='" + Request.QueryString["id"] + "' ");
while (!rb.EOF)
{
rb["STATUS"] = "N";
rb.Update();
rb.MoveNext();
}
rb.Close();
this.Button_UpdateItem.Enabled = true;
this.Button_AddItem.Enabled = true;
this.InputButton2.Enabled = true;
this.InputButton1.Enabled = false;
this.BUTTON_save.Enabled = true;
gridviewchange(this.FIELD_NO.Text);
}
protected void Btn_Stop_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
string guid = Request.QueryString["rowid"].ToString();
_cStatus = status.Stop;
head.UpdataStatus(guid, status.Stop);
setDisplay();
//發通知給目前審核者,說已經中止了
string rowid = Request.QueryString["rowid"];
head.GetInfo(rowid);
SendMail(rowid, _leader, lab_Ra_NO.Text, head.send_dt, "中止");
DBTransfer fs = new DBTransfer();
if (!string.IsNullOrEmpty(guid))
{
fs.RunIUSql("delete dgflowqueue where requesturl like '%" + guid + "%'");
}
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
svaedata();
int levid = 0;
DBTransfer takedata = new DBTransfer();
SmoothEnterprise.Database.DataSet js = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//string idnm = "";
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managernm = new ArrayList(); //主管職稱 arraylist
string gid = "";
string[,] data = new string[1, 5];
int count = 0;
string firapp = "";
string buf = "";
managerid.Add(PopupUser1.Text);
managernm.Add("直屬主管");
buf = PopupUser1.Text;
int t = 0;
js.Open("select gid from eipa.dbo.dguser where id='" + PopupUser1.Text + "'");
// Response.Write("select gid from eipa.dbo.dguser where id='" + PopupUser1.Text + "'");
if (!js.EOF)
{
gid = js["gid"].ToString();
while (levid < 10)
{
//t++;
if (gid.Length > 10)
{
data = GetResGroup(gid);
}
if (data[0, 2] == null)
{
break;
}
else
{
if (data[0, 2].ToString().ToUpper() == "63D0329E-F4C2-44C6-950C-92174D233BED")
{
}
else
{
if (buf != data[0, 2].ToString())
{
managerid.Add(data[0, 2].ToString());
managernm.Add(data[0, 1].ToString());
}
buf = data[0, 2].ToString();
}
// Response.Write(data[0, 1].ToString() + "--" + data[0, 2].ToString() + "--" + data[0, 0].ToString() + "--" + data[0, 0].ToString() + "<br>");
gid = data[0, 0].ToString();
levid = Int32.Parse(data[0, 4].ToString());
}
count++;
if (count > 8)
{
break;
}
}
//firapp = managerid[0].ToString();
}
js.Close();
/*
* managerid.Add("FF0678EA-3EAF-4F1F-A012-1C54F93B48E2");
* managernm.Add("會計一");
*
*
* managerid.Add("D22FD429-E1EC-431D-99E6-1D7041F8A452");
* managernm.Add("會計主管");
*
*
*
* managerid.Add("AB70A6C0-D106-4636-B1E1-15DFFF9A83C5");
* managernm.Add("財務長");
*/
//---test --------------------
// managerid.Clear();
// managernm.Clear();
// managerid.Add(PopupUser1.Text);
// managernm.Add("主管1");
string T1 = "";
string T2 = "";
string T3 = "";
string par1 = "";
js.Open("SELECT SUBSTRING(pmca00,1,1)T1, SUBSTRING(pmca00,1,1)+datadiff T2,datadiff T3 " +
" FROM [EIPB].[dbo].[APMI610_IN] where rowid='" + Request.QueryString[0] + "'");
if (!js.EOF)
{
T1 = js["T1"].ToString();
T2 = js["T2"].ToString();
T3 = js["T3"].ToString();
}
//if ((T1 != "I") || (T1 != "V")) par1 = T1;
//else par1 = T2;
switch (T1)
{
case "I":
case "V":
par1 = T1;
break;
case "U":
par1 = T2;
break;
}
// managerid.Add("D45938A7-3430-42EC-8BE6-0E1F391329E0");
// managernm.Add("TEST");
js.Close();
if (par1 == "V")
{
if (addmemo() == "1")
{
js.Open("SELECT PID,isnull(content1,'test') title FROM ERP_FLOW where ERP_NAME='APMI610Edit'" +
" and DEP_NAME='UY' order by No asc ");
}
else
{
js.Open("SELECT PID,isnull(content1,'test') title FROM ERP_FLOW where ERP_NAME='APMI610Edit'" +
" and DEP_NAME='" + par1 + "' order by No asc ");
}
}
else
{
js.Open("SELECT PID,isnull(content1,'test') title FROM ERP_FLOW where ERP_NAME='APMI610Edit'" +
" and DEP_NAME='" + par1 + "' order by No asc ");
}
// Response.Write("SELECT PID,isnull(content1,'test') title FROM ERP_FLOW where ERP_NAME='APMI610Edit'" +
// " and DEP_NAME='" + par1 + "' order by No asc ");
while (!js.EOF)
{
managerid.Add(js["PID"].ToString());
managernm.Add(js["title"].ToString());
js.MoveNext();
}
//managerid.Add("13FEB136-9F48-416A-B495-7C2BE8C3B548");
//managernm.Add("會計1");
//managerid.Add("9D78E1CF-ED8E-47E0-8963-9534EF1FF3C3");
//managernm.Add("會計2");
//managerid.Add("13FEB136-9F48-416A-B495-7C2BE8C3B548");
//managernm.Add("會計3");
//managerid.Add("ab70a6c0-d106-4636-b1e1-15dfff9a83c5");
//managernm.Add("財務長");
//----------------------------
FlowClient1.TypeName = "sharflow12_2.Flowwork.sharflow12_21";
sharflow12_2.Flowwork.sharflow12_21 flow = new sharflow12_2.Flowwork.sharflow12_21();
FlowClient1.Text = "供應商代號申請單"; //更改流程名稱
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12_2Node1;
break;
case 2:
e.NextNode = flow.sharflow12_2Node2;
break;
case 3:
e.NextNode = flow.sharflow12_2Node4;
break;
case 4:
e.NextNode = flow.sharflow12_2Node7;
break;
case 5:
e.NextNode = flow.sharflow12_2Node11;
break;
case 6:
e.NextNode = flow.sharflow12_2Node16;
break;
case 7:
e.NextNode = flow.sharflow12_2Node22;
break;
case 8:
e.NextNode = flow.sharflow12_2Node29;
break;
case 9:
e.NextNode = flow.sharflow12_2Node37;
break;
case 10:
e.NextNode = flow.sharflow12_2Node46;
break;
case 11:
e.NextNode = flow.sharflow12_2Node56;
break;
}
// e.NextNode.ReviewerURL = "/PManagement/DocControlView.aspx";
e.NextNode.ReviewerURL = "/ERP_APMI610/APMI610View.aspx";
count = 0;
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
count++;
}
count = 0;
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
count++;
}
//回寫單據狀泰
string Sql = "update [EIPB].[dbo].[APMI610_IN] set status='Y' where rowid='" + Request.QueryString["rowid"] + "'";
takedata.RunIUSql(Sql);
//建立審核人員
Sql = "insert into [EIPB].[dbo].[doulog](rowid,appid,appdate )values('" + Request.QueryString["rowid"] + "','" +
PopupUser1.Text + "',getdate())";
takedata.RunIUSql(Sql);
//通知審核者
js.Open("select name,email from dguser where id='" + PopupUser1.Text + "'");
if (!js.EOF)
{
string snmemo = "";
if (T1 == "U")
{
if (T3 == "N")
{
snmemo = FIELD_pmcsn.Text + "類別" + FIELD_pmca00.Text + "無異動";
}
else
{
snmemo = FIELD_pmcsn.Text + "類別" + FIELD_pmca00.Text + "有異動";
}
}
else
{
if (Labpmcaud01.Text == "Y")
{
snmemo = FIELD_pmcsn.Text + "類別" + FIELD_pmca00.Text + "->失效";
}
else
{
snmemo = FIELD_pmcsn.Text + "類別" + FIELD_pmca00.Text + "->有效";
}
}
MailLayout SenReq = new MailLayout();
string purl = "http://eip.minaik.com.tw" + Request.RawUrl.ToLower().Replace("edit", "view");
ShrFlowMail Backsend = new ShrFlowMail();
// Backsend.SendMail("{166f4599-5482-4137-8060-eb1b2b82bbdb}", this.FlowClient1.Text, snmemo,
// js[0].ToString(), "*****@*****.**", purl, FlowClient1.Text);
Backsend.SendMail("{166f4599-5482-4137-8060-eb1b2b82bbdb}", this.FlowClient1.Text, snmemo,
js[0].ToString(), js[1].ToString(), purl, FlowClient1.Text);
}
js.Close();
//通知代理人機制
// DeputyApprove(managerid[0].ToString());
displayfile(false);
BUTTON_save.Enabled = false;
//ButCancel.Enabled = false;
ButStop.Visible = true;
PopupUser1.Visible = false;
Label9.Visible = false;
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
int levid = 0;
DBTransfer takedata = new DBTransfer();
SmoothEnterprise.Database.DataSet js = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
//string idnm = "";
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managernm = new ArrayList(); //主管職稱 arraylist
string gid = "";
string[,] data = new string[1, 5];
int count = 0;
string firapp = "";
string buf = "";
int t = 0;
js.Open("select pid from ERP_FLOW WHERE ERP_NAME='apmt420' and dep_name='acc' " +
" and NO in ('2','2_2') and company='MINAIK' order by no asc ");
while (!js.EOF)
{
t++;
managerid.Add(js[0].ToString());
managernm.Add("會計" + t.ToString());
js.MoveNext();
}
managerid.Add(PopupUser1.Text);
managernm.Add("直屬主管");
t = 0;
#region
js.Open("select gid from eipa.dbo.dguser where id='" + PopupUser1.Text + "'");
if (!js.EOF)
{
gid = js["gid"].ToString();
while (levid <= 10)
{
//t++;
data = GetResGroup(gid);
if (data[0, 2] == null)
{
break;
}
else
{
if (data[0, 2].ToString().ToUpper() == "63D0329E-F4C2-44C6-950C-92174D233BED")
{
managerid.Add("63D0329E-F4C2-44C6-950C-92174D233BED");
managernm.Add("CEO");
}
else
{
if (buf != data[0, 2].ToString())
{
managerid.Add(data[0, 2].ToString());
managernm.Add(data[0, 1].ToString());
}
buf = data[0, 2].ToString();
}
// Response.Write(data[0, 1].ToString() + "--" + data[0, 2].ToString() + "--" + data[0, 0].ToString() + "--" + data[0, 0].ToString() + "<br>");
gid = data[0, 0].ToString();
levid = Int32.Parse(data[0, 4].ToString());
}
count++;
if (count > 8)
{
break;
}
}
//firapp = managerid[0].ToString();
}
js.Close();
#endregion
/*
* managerid.Add("FF0678EA-3EAF-4F1F-A012-1C54F93B48E2");
* managernm.Add("會計一");
*
*
* managerid.Add("D22FD429-E1EC-431D-99E6-1D7041F8A452");
* managernm.Add("會計主管");
*
*
*
* managerid.Add("AB70A6C0-D106-4636-B1E1-15DFFF9A83C5");
* managernm.Add("財務長");
*/
//---test --------------------
// 1 代表是MIS 的單子
if (FIELD_tc_cba01.Text.Substring(0, 1) == "1")
{
//MIS 主管
//managerid.Add("B76FC2D3-7910-4641-A51B-8B6023C567AE");
//managernm.Add("MIS 主管");
//加SI
string siid = takedata.GetTopfile("SELECT ISNULL(b.si_id,'0DC215C7-0043-4CD6-AC6E-659ECDC88994') FROM eipb.dbo.CBGI014_Head " +
" left join [EIPB].[dbo].[Sta_erpdep] b on tc_cba01=b.tip_depno " +
" WHERE rowid='" + Request.QueryString[0] + "'");
managerid.Add(siid);
managernm.Add("SI");
//MIS 主管 Review
managerid.Add("B76FC2D3-7910-4641-A51B-8B6023C567AE");
managernm.Add("MIS 主管");
//判斷有沒有連簽兩次
#region
for (int i = managerid.Count - 1; i >= 0; i--)
{
for (int k = 0; k < i; k++)
{
if (managerid[i].ToString().ToUpper() == managerid[k].ToString().ToUpper())
{
managerid[k] = "";
}
}
}
//砍掉57334E67-59A6-4147-B447-DBCCBC90909A
for (int i = managerid.Count - 1; i >= 0; i--)
{
if (managerid[i].ToString().ToUpper() == "57334E67-59A6-4147-B447-DBCCBC90909A")
{
managerid[i] = "";
}
}
for (int i = managerid.Count - 1; i >= 0; i--)
{
if (managerid[i] == "")
{
managerid.RemoveAt(i);
managernm.RemoveAt(i);
//Response.Write("-----<br>");
}
}
#endregion
siid = takedata.GetTopfile("SELECT bossApp FROM eipb.dbo.CBGI014_Head " +
" left join [EIPB].[dbo].[Sta_erpdep] b on tc_cba01=b.tip_depno " +
" WHERE rowid='" + Request.QueryString[0] + "'");
if (siid == "Y")
{
managerid.Add("57334E67-59A6-4147-B447-DBCCBC90909A");
managernm.Add("副營運長");
}
}
else
{
//判斷有沒有連簽兩次
#region
for (int i = managerid.Count - 1; i >= 0; i--)
{
for (int k = 0; k < i; k++)
{
if (managerid[i].ToString().ToUpper() == managerid[k].ToString().ToUpper())
{
managerid[k] = "";
}
}
}
//砍掉57334E67-59A6-4147-B447-DBCCBC90909A
//for (int i = managerid.Count - 1; i >= 0; i--)
//{
// if (managerid[i].ToString().ToUpper() == "57334E67-59A6-4147-B447-DBCCBC90909A") managerid[i] = "";
//}
for (int i = managerid.Count - 1; i >= 0; i--)
{
if (managerid[i] == "")
{
managerid.RemoveAt(i);
managernm.RemoveAt(i);
//Response.Write("-----<br>");
}
}
#endregion
}
FlowClient1.TypeName = "sharflow12_2.Flowwork.sharflow12_21";
sharflow12_2.Flowwork.sharflow12_21 flow = new sharflow12_2.Flowwork.sharflow12_21();
FlowClient1.Text = "固定資產預算申請單"; //更改流程名稱
string Sqlc = "insert into [EIPB].[dbo].[doulog](rowid,appid,appdate )values('" + Request.QueryString["rowid"] + "','" +
managerid[0].ToString() + "',getdate())";
takedata.RunIUSql(Sqlc);
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12_2Node1;
break;
case 2:
e.NextNode = flow.sharflow12_2Node2;
break;
case 3:
e.NextNode = flow.sharflow12_2Node4;
break;
case 4:
e.NextNode = flow.sharflow12_2Node7;
break;
case 5:
e.NextNode = flow.sharflow12_2Node11;
break;
case 6:
e.NextNode = flow.sharflow12_2Node16;
break;
case 7:
e.NextNode = flow.sharflow12_2Node22;
break;
case 8:
e.NextNode = flow.sharflow12_2Node29;
break;
case 9:
e.NextNode = flow.sharflow12_2Node37;
break;
case 10:
e.NextNode = flow.sharflow12_2Node46;
break;
}
string purl = "";
// e.NextNode.ReviewerURL = "/PManagement/DocControlView.aspx";
if (FIELD_tc_cba01.Text.Substring(0, 1) == "1")
{
e.NextNode.ReviewerURL = "/ERP_CBGI014/CBGI014View.aspx";
purl = "http://eip.minaik.com.tw" + Request.RawUrl.ToLower().Replace("edit", "view");
}
else
{
e.NextNode.ReviewerURL = "/ERP_CBGI014/CBGI014_AccView.aspx";
purl = "http://eip.minaik.com.tw/ERP_CBGI014/CBGI014_AccView.aspx";
}
count = 0;
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
count++;
}
count = 0;
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
count++;
}
//回寫單據狀泰
string Sql = "update [EIPB].[dbo].[CBGI014_Head] set status='Y' where rowid='" + Request.QueryString["rowid"] + "'";
takedata.RunIUSql(Sql);
// Response.Write("select name,email from dguser where id='" + managerid[0].ToString() + "'");
//通知審核者
js.Open("select name,email from dguser where id='" + managerid[0].ToString() + "'");
if (!js.EOF)
{
string snmemo = FIELD_sn.Text + "-" + FIELD_tc_cba00.Text + "-" + FIELD_ver.Text + "-" + FIELD_tc_cba01.Text;
//Response.Write("<br>" + snmemo);
MailLayout SenReq = new MailLayout();
//Response.Write("<br>" + purl);
ShrFlowMail Backsend = new ShrFlowMail();
Backsend.SendMail("{166f4599-5482-4137-8060-eb1b2b82bbdb}", FlowClient1.Text, FIELD_sn.Text,
js[0].ToString(), js[1].ToString(), purl, "");
}
js.Close();
//通知代理人機制
// DeputyApprove(managerid[0].ToString());
displayfile(false);
BUTTON_save.Enabled = false;
ButStop.Visible = true;
PopupUser1.Visible = false;
Label3.Visible = false;
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM EngineeringTest_head WHERE id='" + Request.QueryString["id"] + "' ");
while (!rb.EOF)
{
rb["STATUS"] = "Y";
rb.Update();
rb.MoveNext();
}
rb.Close();
this.InputButton2.Enabled = false;
this.BUTTON_SendRequest.Flow = this.FlowClient1;
this.InputButton1.Enabled = true;
this.BUTTON_save.Enabled = false;
managerlevel aa = new managerlevel(); //引用managerlevel class
ArrayList all = new ArrayList(); //all arraylist
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managerlv = new ArrayList(); //主管階級 arraylist
ArrayList managernm = new ArrayList(); //主管職稱 arraylist
//if (aa.manager(this.CurrentUser.ID.ToString()).Split('@')[0] == this.FIELD_lsend.Text.ToString().ToUpper())
//{
//}
//else
//{
// managerid.Add(this.FIELD_lsend.Text);
// managernm.Add("自訂審核人");
// managerid.Add(aa.manager(this.CurrentUser.ID.ToString()).Split('@')[0]);
// managernm.Add("直屬主管");
//}
if (this.flow_type.Text == "1")
{
managerid.Add(this.FIELD_lsend.Text);
managernm.Add("直屬主管");
managerid.Add(this.FIELD_pmcsend.Text);
managernm.Add("資材單位");
}
if (this.flow_type.Text == "2")
{
managerid.Add(this.FIELD_lsend.Text);
managernm.Add("直屬主管");
managerid.Add(this.FIELD_pmcsend.Text);
managernm.Add("資材單位");
managerid.Add(this.FIELD_makesend.Text);
managernm.Add("製造單位");
}
if (this.flow_type.Text == "3")
{
managerid.Add(this.FIELD_lsend.Text);
managernm.Add("直屬主管");
managerid.Add(this.FIELD_pmcsend.Text);
managernm.Add("資材單位");
managerid.Add(this.FIELD_workssend.Text);
managernm.Add("工程單位");
}
if (this.flow_type.Text == "4")
{
managerid.Add(this.FIELD_lsend.Text);
managernm.Add("直屬主管");
managerid.Add(this.FIELD_pmcsend.Text);
managernm.Add("資材單位");
managerid.Add(this.FIELD_workssend.Text);
managernm.Add("工程單位");
managerid.Add(this.FIELD_makesend.Text);
managernm.Add("製造單位");
}
if (this.flow_type.Text == "5")
{
managerid.Add(this.FIELD_pmcsend.Text);
managernm.Add("資材單位");
managerid.Add(this.FIELD_workssend.Text);
managernm.Add("工程單位");
managerid.Add(this.FIELD_makesend.Text);
managernm.Add("製造單位");
managerid.Add(this.FIELD_lsend.Text);
managernm.Add("直屬主管");
}
sharflow12_3.Flowwork.sharflow12_31 flow = new sharflow12_3.Flowwork.sharflow12_31();
// sharflow12.Flowwork.sharflow121 flow = new sharflow12.Flowwork.sharflow121();
FlowClient1.Text = "工程試作單電子簽核"; //更改流程名稱
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12_3Node1;
break;
case 2:
e.NextNode = flow.sharflow12_3Node2;
break;
case 3:
e.NextNode = flow.sharflow12_3Node4;
break;
case 4:
e.NextNode = flow.sharflow12_3Node7;
break;
case 5:
e.NextNode = flow.sharflow12_3Node11;
break;
case 6:
e.NextNode = flow.sharflow12_3Node16;
break;
case 7:
e.NextNode = flow.sharflow12_3Node22;
break;
case 8:
e.NextNode = flow.sharflow12_3Node29;
break;
case 9:
e.NextNode = flow.sharflow12_3Node37;
break;
case 10:
e.NextNode = flow.sharflow12_3Node46;
break;
case 11:
e.NextNode = flow.sharflow12_3Node56;
break;
case 12:
e.NextNode = flow.sharflow12_3Node67;
break;
}
e.NextNode.ReviewerURL = "/EngineeringTest/EngineeringTestView.aspx";
int count = 0;
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
//Response.Write("USER" + count.ToString() + ")" + i + "<br>");
count++;
}
count = 0;
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
//Response.Write("USERTITLE" + count.ToString() + ")" + i + "<br>");
count++;
}
//寄mail------------------------------------------------------------------
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
string sendermail = "";
if (this.flow_type.SelectedValue == "5")
{
sendermail = this.FIELD_pmcsend.Text;
}
else
{
sendermail = this.FIELD_lsend.Text;
}
rss.Open("select id bid,name,email from dguser where id = '" + sendermail + "' ");
if (!rss.EOF)
{
ArrayList email_list = new ArrayList(); //email list
email_list.Add(rss["name"].ToString() + '#' + rss["email"].ToString());
#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 " +
" ((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 ");
while (!rs2.EOF)
{
//MyLibrary_AXMT610 Backsend = new MyLibrary_AXMT610();
email_list.Add(rs2["name"].ToString() + '#' + rs2["email"].ToString());
rs2.MoveNext();
}
rs2.Close();
#endregion
foreach (string i in email_list)
{
//Response.Write( i + "<br>");
//Response.Write(i.Split('#')[0] + "<br>"); //人員姓名
//Response.Write(i.Split('#')[1] + "<br>"); //人員email
String ques;
MailAddress from = new MailAddress("*****@*****.**", "ePortal(員工入口網站)");
MailAddress to = new MailAddress(i.Split('#')[1]);
//MailAddress bcc = new MailAddress("*****@*****.**");
//MailAddress bccrage = new MailAddress("*****@*****.**");
MailMessage message = new MailMessage(from, to);
//message.Bcc.Add(bcc);
//message.Bcc.Add(bccrage);
DateTime de = Convert.ToDateTime(this.FIELD_expect_date.Text);
ques = i.Split('#')[0] + " 您好:" + "<br>" +
"<br>" +
"EIP工程試作單系統現有一筆，正等待您的處理:" + "<br>" +
"<br>" +
"單號 : " + this.no.Text + "<br>" +
"申請日期 : " + de.ToString("yyyy/MM/dd") + "<br>" +
"申請內容 : " + "<a href=\"http://eip.minaik.com.tw/EngineeringTest/EngineeringTestView.aspx?id=" + Request.QueryString["id"] + "\" >至EIP工程試作單系統審核</a>" +
"<br>" +
"如您想了解更多有關員工入口網站的資訊請點選以下連結進入" + "<br>" +
"<a href=\"http://eip.minaik.com.tw/\">員工入口網站</a>" + "<br>" +
"感謝您對員工入口網站的支持與愛護，<font Color='red'>。因本信件為系統自動發送,請勿直接以此郵件回覆。</font>";
message.Subject = "EIP工程試作單號 - " + this.no.Text + " 成品料號-" + this.cima01.Text + "正在待您審核中";
message.IsBodyHtml = true;
message.Body = ques;
SmtpClient client = new SmtpClient("192.168.0.12");
client.Send(message);
}
}
}
protected void SendRequestButton1_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM " + db + "apmi255_in_head WHERE id='" + Request.QueryString["id"] + "' ");
if (!rb.EOF)
{
rb["STATUS"] = "Y";
rb["senduser"] = this.CurrentUser.ID.ToString();
rb.Update();
}
rb.Close();
this.BUTTON_SendRequest.Flow = this.FlowClient1;
managerlevel aa = new managerlevel(); //引用managerlevel class
ArrayList all = new ArrayList(); //all arraylist
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managerlv = new ArrayList(); //主管階級 arraylist
ArrayList managernm = new ArrayList(); //主管職稱 arraylist
managerid.Add(this.FIELD_lsend.Text);
managernm.Add("直屬主管");
if (this.FIELD_lsend.Text != aa.manager(this.CurrentUser.ID.ToString()).Split('@')[0])
{
managerid.Add(aa.manager(this.CurrentUser.ID.ToString()).Split('@')[0]);
managernm.Add("直屬主管");
}
if (this.FIELD_pmiuser.Text.Substring(0, 2) == "EF" && this.FIELD_flowstatus.Text.Trim().Substring(0, 1) == "1") //MAY人員且簽核流程為1 送跨廠即可
{
SmoothEnterprise.Database.DataSet rsA = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rsA.Open("select * from ERP_FLOW where ERP_NAME='apmi255' and DEP_NAME='PUR' AND NO='MAT審核的採購' AND PID='" + this.FIELD_mpru.Text + "' "); //確認MAY選的採購是否為MAT人員
if (!rsA.EOF)
{
managerid.Add(this.FIELD_mpru.Text);
managernm.Add("跨廠採購人員");
}
else
{
managerid.Add("43AB27FF-E6C8-4A46-83AA-AB4590F252D3");
managernm.Add("跨廠採購人員");
}
}
sharflow12.Flowwork.sharflow121 flow = new sharflow12.Flowwork.sharflow121();
FlowClient1.Text = "採購核價單電子簽核 ERP單號:" + this.FIELD_pmi01.Text.ToString(); //更改流程名稱
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12Node1;
break;
case 2:
e.NextNode = flow.sharflow12Node2;
break;
case 3:
e.NextNode = flow.sharflow12Node4;
break;
case 4:
e.NextNode = flow.sharflow12Node7;
break;
case 5:
e.NextNode = flow.sharflow12Node11;
break;
case 6:
e.NextNode = flow.sharflow12Node16;
break;
case 7:
e.NextNode = flow.sharflow12Node22;
break;
case 8:
e.NextNode = flow.sharflow12Node29;
break;
case 9:
e.NextNode = flow.sharflow12Node37;
break;
case 10:
e.NextNode = flow.sharflow12Node46;
break;
case 11:
e.NextNode = flow.sharflow12Node56;
break;
case 12:
e.NextNode = flow.sharflow12Node67;
break;
}
e.NextNode.ReviewerURL = "/ERP_APMI255/ERP_APMI255VIEW.aspx";
int count = 0;
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
//Response.Write("USER" + count.ToString() + ")" + i + "<br>");
count++;
}
count = 0;
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
//Response.Write("USERTITLE" + count.ToString() + ")" + i + "<br>");
count++;
}
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open("select id bid,name,email from dguser where id = '" + this.FIELD_lsend.Text + "' ");
if (!rss.EOF)
{
ArrayList email_list = new ArrayList(); //email list
email_list.Add(rss["name"].ToString() + '#' + rss["email"].ToString());
#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 " +
" ((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 ");
while (!rs2.EOF)
{
//MyLibrary_AXMT610 Backsend = new MyLibrary_AXMT610();
email_list.Add(rs2["name"].ToString() + '#' + rs2["email"].ToString());
rs2.MoveNext();
}
rs2.Close();
#endregion
foreach (string i in email_list)
{
//Response.Write( i + "<br>");
//Response.Write(i.Split('#')[0] + "<br>"); //人員姓名
//Response.Write(i.Split('#')[1] + "<br>"); //人員email
String ques;
MailAddress from = new MailAddress("*****@*****.**", "ePortal(員工入口網站)");
MailAddress to = new MailAddress(i.Split('#')[1]);
MailAddress bcc = new MailAddress("*****@*****.**");
MailMessage message = new MailMessage(from, to);
ques = i.Split('#')[0] + " 您好:" + "<br>" +
"<br>" +
"ERP採購核價電子簽核申請單現有一筆，正等待您的處理:" + "<br>" +
"<br>" +
"申請單號 : " + this.FIELD_no.Text + "<br>" +
"ERP單號 : " + this.FIELD_pmi01.Text + "<br>" +
"申請日期 : " + this.FIELD_pmi02.Text + "<br>" +
"申請人員 : " + this.FIELD_gen02_1.Text + "<br>" +
"申請內容 : " + "<a href=\"http://eip.minaik.com.tw/ERP_APMI255/ERP_APMI255View.aspx?id=" + Request.QueryString["id"] + "\" >至ERP採購核價電子簽核系統檢視並編輯內容</a>" +
"<br>" +
"如您想了解更多有關員工入口網站的資訊請點選以下連結進入" + "<br>" +
"<a href=\"http://eip.minaik.com.tw/\">員工入口網站</a>" + "<br>" +
"感謝您對員工入口網站的支持與愛護，<font Color='red'>。因本信件為系統自動發送,請勿直接以此郵件回覆。</font>";
if (this.FIELD_quick.Text.Trim() == "Y")
{
message.Subject = "(急件)核價單號 - " + this.FIELD_no.Text + " ERP單號-" + this.FIELD_pmi01.Text + "等待您的處理";
}
else
{
message.Subject = "核價單號 - " + this.FIELD_no.Text + " ERP單號-" + this.FIELD_pmi01.Text + "等待您的處理";
}
message.IsBodyHtml = true;
message.Body = ques;
SmtpClient client = new SmtpClient("192.168.0.12");
client.Credentials = new NetworkCredential("eip", "eip1106");
client.Send(message);
}
}
//讓更新能顯示------------------------------------------------------------------------------------
Response.Write("<script type=\"text/javascript\">");
Response.Write("location.href='erp_apmi255Edit.aspx?id=" + Request.QueryString["ID"] + "';");
Response.Write("</script>");
//-------------------------------------------------------------------------------------------------
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
//如果是 變更 單class_no=3 ,且是 MAY 的單子, 若有廠牌名稱,且要有廠牌ID
string er = "0";
//DBTransfer hs = new DBTransfer();//&& (this.FIELD_plantid.Text=="MAY")
//if(Request.QueryString["class_no"]=="3"){
// er=hs.GetTopfile("select COUNT(*) as a1 from [EIPB].[dbo].[cimi100_turn] where no='"+this.FIELD_NO.Text+"'"+
// " and tc_imi031 is not null and ISNULL(tc_imi03,'NA')<6 ");
// }
//if (er == "0")
//{
this.Button_AddItem.Enabled = false;
this.Button_UpdateItem.Enabled = false;
this.InputButton1.Enabled = true;
this.InputButton2.Enabled = false;
this.BUTTON_save.Enabled = true;
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM " + db1 + "cimi100_main WHERE id='" + Request.QueryString["id"] + "' ");
while (!rb.EOF)
{
rb["STATUS"] = "Y";
rb.Update();
rb.MoveNext();
}
rb.Close();
this.BUTTON_SendRequest.Flow = this.FlowClient1;
this.InputButton1.Enabled = true;
this.BUTTON_save.Enabled = false;
this.InputButton2.Enabled = false;
managerlevel aa = new managerlevel(); //引用managerlevel class
ArrayList all = new ArrayList(); //all arraylist
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managerlv = new ArrayList(); //主管階級 arraylist
ArrayList managernm = new ArrayList(); //主管職稱 arraylist
#region 找集團文管id
string LDCC = "";
SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rs.Open("SELECT PID FROM " + db2 + "erp_flow where erp_name='cimi100' and dep_name='DCC' and no='MAT'");
if (!rs.EOF)
{
LDCC = rs["PID"].ToString();
}
rs.Close();
#endregion
if (this.FIELD_plantid.Text.Trim() == "MAT")
{
managerid.Add(LDCC.ToString());
managernm.Add("集團文管中心");
}
else
{
managerid.Add(this.FIELD_DCC.Text.ToString());
managernm.Add("子廠文管中心");
managerid.Add(LDCC.ToString());
managernm.Add("集團文管中心");
}
sharflow12_2.Flowwork.sharflow12_21 flow = new sharflow12_2.Flowwork.sharflow12_21();
if (class_no.ToString() == "2")
{
FlowClient1.Text = "料件拋轉流程";
}
else
{
FlowClient1.Text = "料件變更流程";
}
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12_2Node1;
break;
case 2:
e.NextNode = flow.sharflow12_2Node2;
break;
case 3:
e.NextNode = flow.sharflow12_2Node4;
break;
case 4:
e.NextNode = flow.sharflow12_2Node7;
break;
case 5:
e.NextNode = flow.sharflow12_2Node11;
break;
case 6:
e.NextNode = flow.sharflow12_2Node16;
break;
case 7:
e.NextNode = flow.sharflow12_2Node22;
break;
case 8:
e.NextNode = flow.sharflow12_2Node29;
break;
case 9:
e.NextNode = flow.sharflow12_2Node37;
break;
case 10:
e.NextNode = flow.sharflow12_2Node46;
break;
case 11:
e.NextNode = flow.sharflow12_2Node56;
break;
case 12:
e.NextNode = flow.sharflow12_2Node67;
break;
}
e.NextNode.ReviewerURL = "/erp_cimi100/cimi100_turnView.aspx";
int count = 0;
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
// Response.Write("USER" + count.ToString() + ")" + i + "<br>");
count++;
}
count = 0;
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
count++;
}
ShrFlowMail Backsend = new ShrFlowMail();
rs.Open("select name,email,id from " + db2 + "dguser where id='" + this.FIELD_DCC.Text.ToString() + "' ");
if (!rs.EOF)
{
Backsend.SendMail("{166f4599-5482-4137-8060-eb1b2b82bbdb}", this.FlowClient1.Text, this.FIELD_NO.Text, rs["name"].ToString(), rs["email"].ToString(), "http://eip.minaik.com.tw/ERP_Cimi100/Cimi100_turnView.aspx?id=" + Request.QueryString["id"] + "&class_no=" + Request.QueryString["class_no"], "--廠區:" + this.FIELD_plantid.Text + "<BR>--申請人員:" + this.FIELD_add_user.Text.Trim()); Dguserdeputy(rs["id"].ToString());
}
gridviewchange(this.FIELD_NO.Text);
// }
//else
//{
//hs.RunIUSql("delete from EIPA.dbo.dgflowqueue where requesturl='"+Request.RawUrl+"'") ;
// Response.Write("<script>alert('輸入的廠牌名稱/ID 是有問題!');</script>");
// /ERP_CIMI100/CIMI100_TurnEdit.aspx?id=34ea9fc2-14a7-411b-bfa9-6840ce49f7c5&class_no=3
//string urlc="
// Response.Write("delete from EIPA.dbo.dgflowqueue where requesturl='" + Request.RawUrl + "'");
//}
}
protected void Btn_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
string rowid = Request.QueryString["rowid"];
IPQC_Ra_Head db = new IPQC_Ra_Head();
if (this.IsValid)
{
try
{
this.Btn_SendRequest.Flow = this.FlowClient1;
_cStatus = status.Send;
db.UpdataStatus(rowid, status.Send);
setDisplay();
// lab_InspectNO.Text = AddONumber(Request.QueryString["rowid"]);
// Response.Write("<script>alert('執行送審');</script>");
//執行送審程序
ArrayList managerid = new ArrayList(); //主管id
ArrayList managernm = new ArrayList(); //主管 Text
managerid.Add(_leader);
managernm.Add("確認");
int count = 0;
foreach (string i in managerid)
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
count++;
}
count = 0;
foreach (string i in managernm)
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
count++;
}
sharflow12_2.Flowwork.sharflow12_21 flow = new sharflow12_2.Flowwork.sharflow12_21();
FlowClient1.Text = "IPQC Ra檢驗單 單號：" + lab_Ra_NO.Text;
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12_2Node1;
break;
case 2:
e.NextNode = flow.sharflow12_2Node1;
break;
case 3:
e.NextNode = flow.sharflow12_2Node1;
break;
case 4:
e.NextNode = flow.sharflow12_2Node1;
break;
case 5:
e.NextNode = flow.sharflow12_2Node1;
break;
case 6:
e.NextNode = flow.sharflow12_2Node1;
break;
case 7:
e.NextNode = flow.sharflow12_2Node1;
break;
case 8:
e.NextNode = flow.sharflow12_2Node1;
break;
case 9:
e.NextNode = flow.sharflow12_2Node1;
break;
case 10:
e.NextNode = flow.sharflow12_2Node1;
break;
case 11:
e.NextNode = flow.sharflow12_2Node1;
break;
case 12:
e.NextNode = flow.sharflow12_2Node1;
break;
case 13:
e.NextNode = flow.sharflow12_2Node1;
break;
case 14:
e.NextNode = flow.sharflow12_2Node1;
break;
case 15:
e.NextNode = flow.sharflow12_2Node1;
break;
}
e.NextNode.ReviewerURL = "/IPQC_Ra/IPQC_RaView.aspx";
FirstApprove(managerid[0].ToString());
}
catch (Exception ex)
{
this.AddError(this, "BUTTON_save_Click()", "", ex.Message);
}
}
}
protected void BUTTON_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
SmoothEnterprise.Database.DataSet rb = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rb.Open("SELECT * FROM " + db1 + "cxmt310_in_head WHERE id='" + Request.QueryString["id"] + "' ");
if (!rb.EOF)
{
rb["STATUS"] = "Y";
rb["senduser"] = this.CurrentUser.ID.ToString();
rb.Update();
}
rb.Close();
this.BUTTON_SendRequest.Flow = this.FlowClient1;
managerlevel aa = new managerlevel(); //引用managerlevel class
ArrayList all = new ArrayList(); //all arraylist
ArrayList managerid = new ArrayList(); //主管id arraylist
ArrayList managerlv = new ArrayList(); //主管階級 arraylist
ArrayList managernm = new ArrayList(); //主管職稱 arraylist
SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rs.Open("select b.id bid,b.name bname from " + db1 + "cxmt310_in_head a LEFT JOIN " + db2 + "DGUSER b ON oqa07=erpid WHERE a.id='" + Request.QueryString["id"] + "' ");
if (!rs.EOF)
{
if (this.FIELD_plantid.Text.Trim() == "MAY") //MAY業務=業務主管, 故只簽一次
{
managerid.Add(rs["bid"].ToString());
managernm.Add("業務主管");
}
else
{
managerid.Add(rs["bid"].ToString());
managernm.Add("業務");
managerid.Add(aa.manager(rs["bid"].ToString()).Split('@')[0]);
managernm.Add("業務主管");
// 如組織圖中無官副總, 要加-----------------------------------------
string vinc = "4A2805A5-6BDB-446B-B1CA-6D181E222B3E"; //官副總id
string checkvinc = "";
foreach (string i in managerid) //將簽核人員id塞進flow
{
if (i.ToString().ToUpper() == vinc)
{
checkvinc = "1";
}
}
if (checkvinc == "")
{
managerid.Add(vinc);
managernm.Add("業務最高主管");
}
//----------------------------------------------------------------------
}
}
sharflow12.Flowwork.sharflow121 flow = new sharflow12.Flowwork.sharflow121();
FlowClient1.Text = "報價單電子簽核 ERP單號:" + this.FIELD_oqa01.Text; //更改流程名稱
switch (managerid.Count) //依舊arraylist裡面有幾個,來判斷走那條flow
{
case 1:
e.NextNode = flow.sharflow12Node1;
break;
case 2:
e.NextNode = flow.sharflow12Node2;
break;
case 3:
e.NextNode = flow.sharflow12Node4;
break;
case 4:
e.NextNode = flow.sharflow12Node7;
break;
case 5:
e.NextNode = flow.sharflow12Node11;
break;
case 6:
e.NextNode = flow.sharflow12Node16;
break;
case 7:
e.NextNode = flow.sharflow12Node22;
break;
case 8:
e.NextNode = flow.sharflow12Node29;
break;
case 9:
e.NextNode = flow.sharflow12Node37;
break;
case 10:
e.NextNode = flow.sharflow12Node46;
break;
case 11:
e.NextNode = flow.sharflow12Node56;
break;
case 12:
e.NextNode = flow.sharflow12Node67;
break;
}
e.NextNode.ReviewerURL = "/ERP_CXMT310/CXMT310VIEW.aspx";
#region 刪除簽核人員pur_risk_sign
SmoothEnterprise.Database.DataSet delrs = new SmoothEnterprise.Database.DataSet();
delrs.ExecuteNonQuery("delete " + db1 + "CXMT310_sign where mid='" + Request.QueryString["id"] + "'");
#endregion
int count = 0;
foreach (string i in managerid) //將簽核人員id塞進flow
{
this.FlowClient1.AddParameter("USER" + count.ToString(), i);
//Response.Write("USER" + count.ToString() + ")" + i + "<br>");
count++;
#region 新增簽核人員至pur_risk_sign
delrs.ExecuteNonQuery("INSERT INTO " + db1 + "CXMT310_sign (mid,user_id,number) VALUES ('" + Request.QueryString["id"] + "','" + i.ToString() + "','" + count.ToString() + "')");
#endregion
}
count = 0;
foreach (string i in managernm) //將簽核人員職稱塞進flow
{
this.FlowClient1.AddParameter("USERTITLE" + count.ToString(), i);
count++;
}
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open("select id bid,name,email from " + db2 + "dguser where id = '" + this.CurrentUser.ID + "' ");
if (!rss.EOF)
{
ArrayList email_list = new ArrayList(); //email list
email_list.Add(rss["name"].ToString() + '#' + rss["email"].ToString());
#region 代理人
SmoothEnterprise.Database.DataSet rs2 = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate);
rs2.Open(" SELECT b.name name,email FROM " + db2 + "dguserdeputy a left join " + db2 + "dguser b on a.deputyuid=b.id left join " + db2 + "dgflow c on a.sid=c.id " +
" where a.uid='" + rss["bid"].ToString() + "' " +
" 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 ");
while (!rs2.EOF)
{
email_list.Add(rs2["name"].ToString() + '#' + rs2["email"].ToString());
rs2.MoveNext();
}
rs2.Close();
#endregion
foreach (string i in email_list)
{
String ques;
MailAddress from = new MailAddress("*****@*****.**", "ePortal(員工入口網站)");
MailAddress to = new MailAddress(i.Split('#')[1]);
MailAddress bcc = new MailAddress("*****@*****.**");
MailMessage message = new MailMessage(from, to);
ques = i.Split('#')[0] + " 您好:" + "<br>" +
"<br>" +
"ERP報價電子簽核申請單現有一筆，正等待您的處理:" + "<br>" +
"<br>" +
"申請單號 : " + this.FIELD_no.Text + "<br>" +
"ERP單號 : " + this.FIELD_oqa01.Text + "<br>" +
"申請日期 : " + this.FIELD_oqa02.Text + "<br>" +
"申請人員 : " + this.FIELD_g_name.Text + "<br>" +
"申請內容 : " + "<a href=\"http://eip.minaik.com.tw/ERP_CXMT310/CXMT310View.aspx?id=" + Request.QueryString["id"] + "\" >至ERP報價電子簽核系統檢視並編輯內容</a>" +
"<br>" +
"如您想了解更多有關員工入口網站的資訊請點選以下連結進入" + "<br>" +
"<a href=\"http://eip.minaik.com.tw/\">員工入口網站</a>" + "<br>" +
"感謝您對員工入口網站的支持與愛護，<font Color='red'>。因本信件為系統自動發送,請勿直接以此郵件回覆。</font>";
message.Subject = "報價單號 - " + this.FIELD_no.Text + " ERP單號-" + this.FIELD_oqa01.Text + "等待您的處理";
message.IsBodyHtml = true;
message.Body = ques;
SmtpClient client = new SmtpClient("192.168.0.12");
client.Credentials = new NetworkCredential("eip", "eip1106");
client.Send(message);
}
}
//讓更新能顯示------------------------------------------------------------------------------------
Response.Write("<script type=\"text/javascript\">");
Response.Write("location.href='CXMT310Edit.aspx?id=" + Request.QueryString["ID"] + "';");
Response.Write("</script>");
//-------------------------------------------------------------------------------------------------
}
protected void BUTTON_RemindReviewer_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
}
