private void Complete()
{
SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
StringBuilder sql = new StringBuilder();
string head_id = Request.QueryString["rowid"].ToString();
string lab_id = Request.QueryString["lab_id"];
string requesturl = string.Format("IPQC_Ra/Lab/LabEdit.aspx?rowid={0}&lab_id={1}", head_id, lab_id);
Inspect lab = new Inspect();
lab.GetInfo(lab_id);
lab.UpdateStatus(lab_id, status.Complete);
using (SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate))
{
StringBuilder sb = new StringBuilder();
sb.Append(" select requestuid from eipa.dbo.dgflowqueue a ");
sb.AppendFormat(" where a.requesturl like '%{0}' ", requesturl);
sb.Append(" and revieweruid <>'00000000-0000-0000-0000-000000000000' ");
sb.Append(" order by a.initdate desc ");
rs.Open(sb.ToString());
SendMail(head_id, lab_id, rs["requestuid"].ToString(), lab_Ra_no.Text, lab.send_date.ToShortDateString());
}
// Response.Redirect("http://" + Request.Url.Authority.ToString() + "/Flowwork/MyApproval.aspx");//回到個人待審頁面
}
private void Back()
{
string head_id = Request.QueryString["rowid"].ToString();
string lab_id = Request.QueryString["lab_id"];
Inspect lab = new Inspect();
lab.GetInfo(lab_id);
lab.UpdateStatus(lab_id, status.Back);
string requesturl = string.Format("IPQC_Ra/Lab/LabEdit.aspx?rowid={0}&lab_id={1}", head_id, lab_id);
using (SmoothEnterprise.Database.DataSet rs = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenUpdate))
{
StringBuilder sb = new StringBuilder();
sb.Append(" select top 1 requestuid from eipa.dbo.dgflowlog a ");
sb.AppendFormat(" where a.requesturl like '%{0}' ", requesturl);
sb.Append(" and revieweruid='00000000-0000-0000-0000-000000000000' ");
rs.Open(sb.ToString());
SendMail(head_id, lab_id, rs["requestuid"].ToString(), lab_Ra_no.Text, lab.send_date.ToShortDateString());
DBTransfer fs = new DBTransfer();
if (!string.IsNullOrEmpty(lab_id))
{
fs.RunIUSql("delete dgflowqueue where requesturl like '%" + lab_id + "%'");
}
}
}
protected void Btn_Stop_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
string head_id = Request.QueryString["rowid"].ToString();
_status = status.Stop;
string lab_id = Request.QueryString["lab_id"];
Inspect lab = new Inspect();
lab.GetInfo(lab_id);
lab.UpdateStatus(lab_id, status.Stop);
setDisplay();
UpdateGV();
//發通知給目前審核者,說已經中止了
SendMail(head_id, lab_id, _leader, lab_Ra_no.Text, lab.send_date.ToShortDateString());
DBTransfer fs = new DBTransfer();
if (!string.IsNullOrEmpty(lab_id))
{
fs.RunIUSql("delete dgflowqueue where requesturl like '%" + lab_id + "%'");
}
}
protected void Btn_fail_Click(object sender, EventArgs e)
{
string guid = Request.QueryString["lab_id"].ToString();
_status = status.Fial;
Inspect lab = new Inspect();
lab.UpdateStatus(guid, status.Fial);
setDisplay();
Response.Write("<script>alert('已經作廢完畢');</script>");
}
protected void Btn_SendRequest_Click(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowButtonEventArgs e)
{
string head_id = Request.QueryString["rowid"];
string lab_id = Request.QueryString["lab_id"];
Inspect lab = new Inspect();
if (this.IsValid)
{
try
{
this.Btn_SendRequest.Flow = this.FlowClient1;
_status = status.Send;
lab.UpdateStatus(lab_id, status.Send);
setDisplay();
UpdateGV();
// 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/Lab/LabView.aspx";
FirstApprove(managerid[0].ToString());
}
catch (Exception ex)
{
this.AddError(this, "BUTTON_save_Click()", "", ex.Message);
}
}
}
