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 InputButton1_Click(object sender, EventArgs e)
{
ShrFlowMail Backsend = new ShrFlowMail();
SmoothEnterprise.Database.DataSet rss = new SmoothEnterprise.Database.DataSet(SmoothEnterprise.Database.DataSetType.OpenRead);
rss.Open("select a.*, b.id bid,b.name name, b.email email,c.no no from " + db2 + "dgflowqueue a left join " + db2 + "dguser b on a.revieweruid = b.id " +
"left join " + db1 + "cimi100_main c on c.id= '" + Request.QueryString["id"] + "' " +
"where requesturl like '%" + Request.QueryString["id"] + "%' and revieweruid <> " +
"'" + System.Guid.Empty.ToString() + "' and reviewdate is null ");
while (!rss.EOF)
{
Backsend.RemindApprove("{ca9348c8-504a-4454-9acc-18c03cfc8189}", this.FIELD_NO.Text, rss["name"].ToString(), "http://eip.minaik.com.tw/ERP_Cimi100/cimi100_turnView.aspx?id=" + Request.QueryString["id"] + "&class_no=" + Request.QueryString["class_no"], rss["email"].ToString(), this.FlowClient1.Text, "--廠區:" + this.FIELD_plantid.Text + "<BR>--申請人員:" + this.FIELD_add_user.Text.Trim(), "員工入口網站");
Dguserdeputy(rss["bid"].ToString());
rss.MoveNext();
}
rss.Close();
}