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); } } }