protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
string json = e.Json;
XmlNode xml = e.Xml;
List <Country> countries = e.Object <Country>();
StringBuilder sb = new StringBuilder(255);
sb.Append("<h3>Selected Countries</h3>");
foreach (Country country in countries)
{
sb.AppendFormat("{0}<br />", country.Name);
}
this.Label1.Html = sb.ToString();
}
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
string json = e.Json;
XmlNode xml = e.Xml;
List<Country> countries = e.Object<Country>();
StringBuilder sb = new StringBuilder(255);
sb.Append("<h3>Selected Countries</h3>");
foreach (Country country in countries)
{
sb.AppendFormat("{0}<br />", country.Name);
}
this.Label1.Html = sb.ToString();
}
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
string json = e.Json;
XmlNode xml = e.Xml;
List<Country> countries = e.Object<Country>();
StringBuilder sb = new StringBuilder(255);
sb.Append("Selected:");
foreach (Country country in countries)
{
sb.AppendFormat("{0},", country.ID);
}
this.txtTo1.Text = sb.ToString().Substring(0, sb.ToString().Length - 1);
}
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
string json = e.Json;
XmlNode xml = e.Xml;
List <Country> countries = e.Object <Country>();
StringBuilder sb = new StringBuilder(255);
sb.Append("Selected:");
foreach (Country country in countries)
{
sb.AppendFormat("{0},", country.ID);
}
this.txtTo1.Text = sb.ToString().Substring(0, sb.ToString().Length - 1);
}
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
try
{
PostRequest <ProcessNotification> request = new PostRequest <ProcessNotification>();
PostResponse <ProcessNotification> r;
List <ProcessNotification> PN = e.Object <ProcessNotification>();
PN.ForEach(x =>
{
if (x.templateId != null)
{
request.entity = x;
r = _administrationService.ChildAddOrUpdate <ProcessNotification>(request);
}
else
{
request.entity = x;
r = _administrationService.ChildDelete <ProcessNotification>(request);
}
if (!r.Success) //it maybe be another condition
{
//Show an error saving...
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
Common.errorMessage(r);
throw new Exception();
}
});
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordSavingSucc
});
}
catch
{
}
}
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
try
{
if (string.IsNullOrEmpty(currentWorkFlowId.Text))
{
return;
}
deleteAllWorkSequence(currentWorkFlowId.Text);
List <WorkSequence> PN = e.Object <WorkSequence>();
PostRequest <WorkSequence> req = new PostRequest <WorkSequence>();
int counter = 1;
PN.ForEach(x =>
{
req.entity = x;
req.entity.seqNo = counter;
req.entity.wfId = currentWorkFlowId.Text;
counter++;
PostResponse <WorkSequence> resp1 = _companyStructureRepository.ChildAddOrUpdate <WorkSequence>(req);
if (!resp1.Success)
{
Common.errorMessage(resp1);
throw new Exception();
}
});
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordSavingSucc
});
}
catch (Exception exp)
{
X.MessageBox.Alert(Resources.Common.Error, exp.Message).Show();
}
}
//用于保存差旅费明细
protected void SubmitData(object sender, StoreSubmitDataEventArgs e)
{
DateTime dtnull = new DateTime(1, 1, 1, 0, 0, 0);
cs.DBCommand dbc = new cs.DBCommand();
//检查是否已经被该人设置过审批人
string sqlCheckFlow = "select * from GroupFlow where GID=(select GID from GroupUsers where UserID='" + cbxOwner.Text + "')";
DataTable dtCheckFlow = dbc.GetData("eReimbursement", sqlCheckFlow);
if (dtCheckFlow.Rows.Count < 1)
{
return;
}
string json = e.Json;
XmlNode xml = e.Xml;
List<Detail> Details = e.Object<Detail>();
//删除现有数据
string deletesql = "delete from ETraveleDetail where [No]='" + hdTravelRequestID.Value.ToString() + "'";
string newid1 = dbc.UpdateData("eReimbursement", deletesql, "Update");
foreach (Detail detail in Details)
{
if (newid1 == "-1")
{
ErrorHandle("Data Error.");
return;
}
//新增
string word = "[No],[Tocity],[AccountName],[AccountCode],[AccountDes],[Cur],[Pamount],[Camount],[TSation],[Createdby],[CreadedDate],[Tdate]";
string value = "";
value += "'" + hdTravelRequestID.Value.ToString() + "',";
value += "'" + detail.Tocity + "',";
value += "'" + detail.AccountName + "',";
value += "'" + detail.AccountCode + "',";
value += "'" + detail.AccountDes + "',";
value += "'" + detail.Cur + "',";
value += detail.Pamount == "" ? "null," : detail.Pamount + ",";
value += detail.Camount == "" ? "null," : detail.Camount + ",";
value += "'" + detail.TSation + "',";
value += "'" + cbxOwner.Text + "',";//edit
value += "'" + DateTime.Now.ToString() + "',";
value += detail.Tdate == "" ? "null" : "'" + detail.Tdate + "'";
string updatesql = "insert into ETraveleDetail (" + word + ") values(" + value + ");select [ID]=@@IDENTITY from ETraveleDetail";
string newid = dbc.UpdateData("eReimbursement", updatesql, "Insert");
if (newid == "-1")
{
ErrorHandle("Data Error."); return;
}
}
//发送提醒邮件
string sql = "select * from V_Eflow_ETravel where [Type]='T' and Step!=0 and RequestID=" + hdTravelRequestID.Value.ToString() + " order by Step,FlowID";
DataTable dtMail = new DataTable();
dtMail = dbc.GetData("eReimbursement", sql);
if (dtMail != null && dtMail.Rows.Count > 0)
{
DIMERCO.SDK.MailMsg mail = new DIMERCO.SDK.MailMsg();
mail.Title = "Dimerco eReimbursement (" + dtMail.Rows[0]["Person"].ToString() + ") - Seek For Your Approval";
mail.FromDispName = "eReimbursement";
mail.From = "*****@*****.**";
string mailto = "";
DataSet dsTo = DIMERCO.SDK.Utilities.LSDK.getUserProfilebyUserList(dtMail.Rows[0]["ApproverID"].ToString());
if (dsTo.Tables[0].Rows.Count == 1)
{
mailto += dsTo.Tables[0].Rows[0]["eMail"].ToString() + ",";
}
else
{
ErrorHandle("Error mail address of Approver."); return;
}
string mailcc = "";
DataSet dsCC = DIMERCO.SDK.Utilities.LSDK.getUserProfilebyUserList(dtMail.Rows[0]["PersonID"].ToString());
if (dsCC.Tables[0].Rows.Count == 1)
{
mailcc += dsCC.Tables[0].Rows[0]["eMail"].ToString() + ",";
}
else
{
ErrorHandle("Error mail address of Owner."); return;
}
if (dtMail.Rows[0]["CreadedByID"].ToString() != "" && dtMail.Rows[0]["CreadedByID"].ToString() != dtMail.Rows[0]["PersonID"].ToString())//代理人
{
dsCC = DIMERCO.SDK.Utilities.LSDK.getUserProfilebyUserList(dtMail.Rows[0]["CreadedByID"].ToString());
mailcc += dsCC.Tables[0].Rows[0]["eMail"].ToString() + ",";
}
mail.To = mailto;
mail.Cc = mailcc;
string divstyle = "style='font-size:small;'";
string divstyleCurrent = "style='font-size:small;color:blue;'";
string tdstyle = "style='border:silver 1px ridge; font-size:small;background-color: #FFFFFF'";
StringBuilder sb = new StringBuilder();
sb.Append("<div>");
sb.Append("<div " + divstyle + "> Dear " + dtMail.Rows[0]["Approver"].ToString() + ",</div><br />");
sb.Append("<div " + divstyle + ">The following eReimbursement application for your approval:</div><br /><br />");
sb.Append("<div " + divstyle + ">eReimbursement Approval Remarks :</div><br />");
sb.Append("<div " + divstyle + ">Owner:" + dtMail.Rows[0]["Person"].ToString() + "</div>");
sb.Append("<div " + divstyle + ">Station:" + dtMail.Rows[0]["Station"].ToString() + "</div>");
sb.Append("<div " + divstyle + ">Department:" + dtMail.Rows[0]["Department"].ToString() + "</div>");
string period = "";
period += dtMail.Rows[0]["Bdate"].ToString() == "" ? "From NA " : ("From " + Convert.ToDateTime(dtMail.Rows[0]["Bdate"].ToString()).ToString("yyyy/MM/dd") + " ");
period += dtMail.Rows[0]["Edate"].ToString() == "" ? "To NA" : "To " + Convert.ToDateTime(dtMail.Rows[0]["Edate"].ToString()).ToString("yyyy/MM/dd");
sb.Append("<div " + divstyle + ">Period:" + period + "</div><br />");
sb.Append("<div><table><thead><tr><th colspan=\"9\" " + tdstyle + ">Expense Detail</th></tr><tr>");
sb.Append("<th " + tdstyle + "></th>");
sb.Append("<th " + tdstyle + ">Location</th>");
sb.Append("<th " + tdstyle + ">Date</th>");
sb.Append("<th " + tdstyle + ">Expense Type</th>");
sb.Append("<th " + tdstyle + ">Currency</th>");
sb.Append("<th " + tdstyle + ">Employee Pay</th>");
sb.Append("<th " + tdstyle + ">Company Pay</th>");
sb.Append("<th " + tdstyle + ">Collection Station</th>");
sb.Append("<th " + tdstyle + ">Remark</th></tr></thead>");
sb.Append("<tbody>");
decimal ptotal = 0; decimal ctotal = 0;
string sqldetail = "select t2.SAccountName,t1.* from ETraveleDetail t1 left join AccoundCode t2 on t2.SAccountCode=t1.AccountCode where t1.[No]='" + hdTravelRequestID.Value.ToString() + "'";
DataTable dtdetail = new DataTable();
dtdetail = dbc.GetData("eReimbursement", sqldetail);
for (int i = 0; i < dtdetail.Rows.Count; i++)
{
sb.Append("<tr><th " + tdstyle + ">" + (i + 1).ToString() + "</th>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["Tocity"].ToString() + "</td>");
string tdate = dtdetail.Rows[i]["Tdate"].ToString() == "" ? "" : Convert.ToDateTime(dtdetail.Rows[i]["Tdate"].ToString()).ToString("yyyy/MM/dd");
sb.Append("<td " + tdstyle + ">" + tdate + "</td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["SAccountName"].ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["Cur"].ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["Pamount"].ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["Camount"].ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["TSation"].ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[i]["AccountDes"].ToString() + "</td></tr>");
ptotal += dtdetail.Rows[i]["Pamount"].ToString() == "" ? 0 : Convert.ToDecimal(dtdetail.Rows[i]["Pamount"].ToString());
ctotal += dtdetail.Rows[i]["Camount"].ToString() == "" ? 0 : Convert.ToDecimal(dtdetail.Rows[i]["Camount"].ToString());
}
sb.Append("</tbody>");
sb.Append("<tfoot><tr>");
sb.Append("<th " + tdstyle + ">Total:</th>");
sb.Append("<td " + tdstyle + "></td>");
sb.Append("<td " + tdstyle + "></td>");
sb.Append("<td " + tdstyle + "></td>");
sb.Append("<td " + tdstyle + ">" + dtdetail.Rows[0]["Cur"].ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + ptotal.ToString() + "</td>");
sb.Append("<td " + tdstyle + ">" + ctotal.ToString() + "</td>");
sb.Append("<td " + tdstyle + "></td>");
sb.Append("<td " + tdstyle + "></td>");
sb.Append("</tr></tfoot></table></div><br />");
StringBuilder sb1 = new StringBuilder();
sb1.Append("<div><span " + divstyle + ">Approval Flow:</span>");
for (int i = 0; i < dtMail.Rows.Count; i++)
{
if (i == 0)
{
sb1.Append("<div " + divstyleCurrent + ">" + (i + 1).ToString() + ".Current Approver:" + dtMail.Rows[i]["Approver"].ToString() + "</div>");
}
else
{
sb1.Append("<div " + divstyle + ">" + (i + 1).ToString() + ".Approver:" + dtMail.Rows[i]["Approver"].ToString() + "</div>");
}
}
sb1.Append("</div><br />");
sb.Append(sb1.ToString());
string url = "http://" + Request.Url.Authority + "/Approve.aspx";
sb.Append("<div><a href=\"" + url + "?FlowID=" + dtMail.Rows[0]["FlowID"].ToString() + "\" style=\"color: #0000FF\">Click here to visit Dimerco eReimbursement.</a></div>");
sb.Append("</div>");
mail.Body = sb.ToString();
mail.Send();
}
}
