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
}