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