private void StopProcess(string rowid) { string snmemo = FIELD_sn.Text + "-" + FIELD_tc_cba00.Text + "-" + FIELD_ver.Text + "-" + FIELD_tc_cba01.Text; 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 like '%" + rowid + "%'" + " and resulttype is null and revieweruid!='00000000-0000-0000-0000-000000000000'"); if (!ds.EOF) { string MId = "{bb281614-d041-46f9-bee2-76370f440053}"; string PapCaption = "固定資產預算申請單"; string PID = snmemo; string receivername = ds["name"].ToString(); string requesturl = "http://eip.minaik.com.tw/ERP_CBGI014/CBGI014Edit.aspx?rowid=" + Request.QueryString[0]; string AppMail = ds["email"].ToString(); string body = ""; string requestername = this.CurrentUser.Name.ToString(); ShrFlowMail ActRem = new ShrFlowMail(); ActRem.StopApprove(MId, PID, PapCaption, receivername, requestername, requesturl, "中止", body, "*****@*****.**"); ActRem.StopApprove(MId, PID, PapCaption, receivername, requestername, requesturl, "中止", body, AppMail); } }
protected void FlowFeedback1_FlowStop(object sender, SmoothEnterprise.Flowwork.UI.WebControl.FlowStopEventArgs e) { DBTransfer RunCommand = new DBTransfer(); ShrFlowMail Usemail = new ShrFlowMail(); SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead); string Sql = ""; string requesturl = ""; #region 流程 Complete if (e.ResultType == SmoothEnterprise.Flowwork.Control.ReviewResultType.Complete) { //寫回 status 為 C 表示 Complete //恢復staus flag Sql = "update [EIPB].[dbo].[CBGI014_Head] set status='C' where rowid='" + Request.QueryString["rowid"] + "'"; RunCommand.RunIUSql(Sql); //發信通知送審者,表示單據已經簽核完畢 AppDate ,[Appuser] ds.Open("select top 1 email,name from dgflowqueue a " + " left join dguser b on a.inituid=b.id where " + " requesturl='" + Request.RawUrl.ToString().Trim().ToLower().Replace("view", "edit") + "' order by a.initdate asc "); if (!ds.EOF) { string MId = "{c294bd9b-ebbd-4c6a-a608-c5175f3a3de2}"; requesturl = "http://eip.minaik.com.tw/" + Request.RawUrl.ToString().Trim(); Usemail.FinishApprove(MId, "固定資產預算申請單", FIELD_sn.Text, ds["email"].ToString(), "", this.CurrentUser.Name, requesturl, "審核完成"); Usemail.FinishApprove(MId, "固定資產預算申請單", FIELD_sn.Text, "*****@*****.**", "", this.CurrentUser.Name, requesturl, "審核完成"); } ResTxt(); Response.Redirect("http://" + Request.Url.Authority.ToString() + "/Flowwork/MyApproval.aspx"); ds.Close(); } #endregion #region 流程 Reject if ((e.ResultType == SmoothEnterprise.Flowwork.Control.ReviewResultType.Terminate) || (e.ResultType == SmoothEnterprise.Flowwork.Control.ReviewResultType.Return)) { Sql = "update [EIPB].[dbo].[CBGI014_Head] set status='T' where rowid='" + Request.QueryString["rowid"] + "'"; RunCommand.RunIUSql(Sql); // SmoothEnterprise.Database.DataSet ds = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead); ds.Open("SELECT top 1 name,email from EIPA.dbo.dgflowqueue a " + " left join dguser b on a.inituid=b.id where requesturl " + " like '%" + Request.QueryString[0] + "%' order by a.initdate asc"); // " left join [dguser] b on a.IniUser=b.id where rowid='" + Request.QueryString[0] + "'"); if (!ds.EOF) { string MId = "{5a3f8c87-e0dc-4bbb-8116-661521bfc6c7}"; string PapCaption = "固定資產預算申請單"; string PID = FIELD_sn.Text; string receivername = ds["name"].ToString(); string requestername = this.CurrentUser.Name; string sendername = this.CurrentUser.Name; requesturl = "http://eip.minaik.com.tw" + Request.RawUrl.ToString().Trim().ToLower().Replace("view", "edit"); string AppMail = ds["email"].ToString(); string reviewresult = "退回"; string body = ""; Usemail.StopApprove(MId, PID, PapCaption, receivername, requestername, requesturl, reviewresult, body, "*****@*****.**"); Usemail.StopApprove(MId, PID, PapCaption, receivername, requestername, requesturl, reviewresult, body, AppMail); } } #endregion }