/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public ERROR_CODE Update(sys_quote_email_tmpl tmpl, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.PARAMS_ERROR);
}
tmpl.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmpl.update_user_id = user.id;
if (!dal.Update(tmpl))
{
return(ERROR_CODE.ERROR);
}
//日志
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = tmpl.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = dal.CompareValue(dal.FindNoDeleteById(tmpl.id), tmpl),
remark = "修改邮件模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
protected string BodyContent; //主体部分内容
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(Request.QueryString["type"], out cate))
{
Response.Write("<script>alert('获取相关信息失败，返回上一页');window.close();</script>");
Response.End();
return;
}
if (!long.TryParse(Request.QueryString["id"], out id))
{
id = 0;
}
switch (cate)
{
case 1:
typename = "新增：报价邮件模板";
type = (int)QueryType.Quote_Email_Tmpl;
break;
case 2:
type = (int)QueryType.Invoice_Email_Tmpl;
typename = "新增：发票邮件模板";
break;
default:
Response.Write("<script>alert('获取相关信息失败，返回上一页');window.close();</script>");
Response.End();
break;
}
if (!IsPostBack)
{
//绑定下列框的变量
//报价邮件模板
if (type == (int)QueryType.Quote_Email_Tmpl)
{
//变量项
this.AlertVariableFilter.DataTextField = "show";
this.AlertVariableFilter.DataValueField = "val";
this.AlertVariableFilter.DataSource = qibll.GetVariableField(cate);
this.AlertVariableFilter.DataBind();
this.AlertVariableFilter.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
//对应的变量列表
var list = qibll.GetAllVariable(cate);
StringBuilder sb = new StringBuilder();
foreach (string va in list)
{
sb.Append("<option class='val' ondblclick='dbclick(this);'>" + va.Replace("'", "") + "</option>");
}
this.VariableList.Text = sb.ToString();
}
//发票邮件模板
else if (type == (int)QueryType.Invoice_Email_Tmpl)
{
this.AlertVariableFilter.DataTextField = "show";
this.AlertVariableFilter.DataValueField = "val";
this.AlertVariableFilter.DataSource = qibll.GetVariableField(cate);
this.AlertVariableFilter.DataBind();
this.AlertVariableFilter.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
//对应的变量列表
var list = qibll.GetAllVariable(cate);
StringBuilder sb = new StringBuilder();
foreach (string va in list)
{
sb.Append("<option class='val' ondblclick='dbclick(this);'>" + va.Replace("'", "") + "</option>");
}
this.VariableList.Text = sb.ToString();
}
//默认激活
this.Active.Checked = true;
//修改
if (id > 0)
{
typename = typename.Replace("新增", "修改");
emailtempl = qibll.GetEmailTemp(id);
if (emailtempl != null)
{
this.Name.Text = emailtempl.name;
if (!string.IsNullOrEmpty(emailtempl.description))
{
this.Description.Text = emailtempl.description;
}
if (emailtempl.status_id > 0)
{
this.Active.Checked = true;
}
else
{
this.Active.Checked = false;
}
if (emailtempl.email_attached_pdf > 0)
{
this.AttachPdf.Checked = true;
}
else
{
this.AttachPdf.Checked = false;
}
this.SendFromFirstName.Text = emailtempl.sender_first_name;
this.SendFromLastName.Text = emailtempl.sender_last_name;
this.SendFromEmail.Text = emailtempl.email_from_address;
this.CC.Text = emailtempl.email_cc_address;
this.BCC.Text = emailtempl.email_bcc_address;
if (emailtempl.is_account_owner_bcc > 0)
{
this.BccAccountManager.Checked = true;
}
else
{
this.BccAccountManager.Checked = false;
}
this.Email_Subject.Text = emailtempl.subject;
if (emailtempl.is_html_format == 1)
{
if (!string.IsNullOrEmpty(emailtempl.html_body))
{
BodyContent = HttpUtility.HtmlDecode(emailtempl.html_body).Replace("\"", "'");
}
}
else if (emailtempl.is_html_format == 2)
{
if (!string.IsNullOrEmpty(emailtempl.text_body))
{
BodyContent = emailtempl.text_body;
}
}
}
else
{
Response.Write("<script>alert('获取相关信息失败，返回上一页');window.close();</script>");
}
}
//新增
else
{
}
}
else
{
emailtempl.is_html_format = Convert.ToSByte(Request.Form["htmlformat"]);
}
}
protected void Save_Close_Click(object sender, EventArgs e)
{
if (id > 0)
{
emailtempl = qibll.GetEmailTemp(id);
}
//收集数据
string bodydata = Request.Form["bodydata"].Trim().ToString().Replace("\"", "'");
SByte k = Convert.ToSByte(Request.Form["htmlformat"]);
emailtempl.name = this.Name.Text.Trim().ToString();
emailtempl.description = this.Description.Text.Trim();
if (this.Active.Checked)
{
emailtempl.status_id = 1;
}
else
{
emailtempl.status_id = 0;
}
if (this.AttachPdf.Checked)
{
emailtempl.email_attached_pdf = 1;
}
else
{
emailtempl.email_attached_pdf = 0;
}
emailtempl.sender_first_name = this.SendFromFirstName.Text.Trim();
emailtempl.sender_last_name = this.SendFromLastName.Text.Trim();
emailtempl.email_from_address = this.SendFromEmail.Text.Trim();
emailtempl.email_cc_address = this.CC.Text.Trim();
emailtempl.email_bcc_address = this.BCC.Text.Trim();
if (this.BccAccountManager.Checked)
{
emailtempl.is_account_owner_bcc = 1;
}
else
{
emailtempl.is_account_owner_bcc = 0;
}
emailtempl.subject = this.Email_Subject.Text.Trim();
if (k == 1)
{
emailtempl.is_html_format = 1;
emailtempl.html_body = bodydata;
emailtempl.text_body = "";
}
else if (k == 2)
{
emailtempl.is_html_format = 2;
emailtempl.text_body = bodydata;
emailtempl.html_body = "";
}
switch (type)
{
case (int)QueryType.Quote_Email_Tmpl:
emailtempl.cate_id = 1;
break;
case (int)QueryType.Invoice_Email_Tmpl:
emailtempl.cate_id = 2;
break;
}
if (id > 0)//修改
{
var result = qibll.Update(emailtempl, GetLoginUserId());
if (result == ERROR_CODE.SUCCESS)
{
Response.Write("<script>alert('修改成功！');window.close();self.opener.location.reload();</script>");
}
else if (result == ERROR_CODE.USER_NOT_FIND) // 用户丢失
{
Response.Write("<script>alert('查询不到用户，请重新登陆');</script>");
Response.Redirect("Login.aspx");
}
else
{
Response.Write("<script>alert('修改失败！');</script>");
}
}
else//新增
{
var result = qibll.Insert(emailtempl, GetLoginUserId());
if (result == ERROR_CODE.SUCCESS) // 插入用户成功，刷新前一个页面
{
Response.Write("<script>alert('添加成功！');window.close();self.opener.location.reload();</script>"); // 关闭添加页面的同时，刷新父页面
}
else if (result == ERROR_CODE.USER_NOT_FIND) // 用户丢失
{
Response.Write("<script>alert('查询不到用户，请重新登陆');</script>");
Response.Redirect("Login.aspx");
}
}
}
