public ERROR_CODE update(sys_quote_tmpl sqt, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var old = GetQuoteTemplate(sqt.id);
sqt.update_user_id = user_id;
sqt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (!_dal.Update(sqt))
{
return(ERROR_CODE.ERROR);
}
//写个操作日志
var add_account_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 = sqt.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, sqt),
remark = "更新报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE Add(sys_quote_tmpl sqt, long user_id, out int id)
{
id = sqt.id = (int)(_dal.GetNextIdCom());
sqt.update_user_id = sqt.create_user_id;
sqt.create_time = sqt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
_dal.Insert(sqt);//把数据保存到数据库表
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_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 = sqt.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(sqt),
remark = "新增报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE default_quote_template(long user_id, long id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.PARAMS_ERROR);
}
var sq = _dal.FindById(id);
var old = sq;
if (sq == null)
{
return(ERROR_CODE.ERROR);
}
if (sq.is_default == 1)
{
return(ERROR_CODE.DEFAULT);
}
sys_quote_tmpl sqt = _dal.FindSignleBySql <sys_quote_tmpl>($"select * from sys_quote_tmpl where is_default=1 and cate_id='{sq.cate_id}'");
if (sqt != null)
{
sqt.is_default = 0;
sqt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sqt.update_user_id = user_id;
if (_dal.Update(sqt) == false)
{
return(ERROR_CODE.ERROR);
}
}
sq.is_default = 1;
sq.update_user_id = user_id;
sq.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (_dal.Update(sq) == false)
{
return(ERROR_CODE.ERROR);
}
var add_account_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 = sq.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, sq),
remark = "修改报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
data = qtb.GetQuoteTemplate(id);
if (!IsPostBack)
{
if (data == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('获取数据错误！');history.go(-1);</script>");
}
Bind();
}
}
/// <summary>
/// 报价模板的删除
/// </summary>
/// 报价模板
public ERROR_CODE quote_template_delete(long user_id, long id)
{
sys_quote_tmpl sqt = GetQuoteTemplate(id);
if (sqt != null)
{
if (sqt.is_system == 1 || sqt.is_custom == 1 || sqt.is_default == 1)
{
return(ERROR_CODE.ERROR);//以下模板不能删除：
}
else
{
sqt.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sqt.delete_user_id = id;
_dal.Update(sqt);
#region 添加日志
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
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 = sqt.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(sqt),
remark = "删除报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
#endregion
return(ERROR_CODE.SUCCESS);
}
}
return(ERROR_CODE.ERROR);//获取数据失败，不能删除
}
protected void AddQuoteTemplate(object sender, EventArgs e)
{
//this.DateFormat.
sys_quote_tmpl sqt = new sys_quote_tmpl();
sqt.name = this.Name.Text.Trim().ToString();
if (this.Active.Checked)
{
sqt.is_active = 1;
}
else
{
sqt.is_active = 0;
}
sqt.description = this.Description.Text.Trim().ToString();
sqt.paper_size_id = paper_size_id();
sqt.page_number_location_id = page_number_location_id();
sqt.create_user_id = LoginUserId;
sqt.currency_negative_format_id = Convert.ToInt32(this.CurrencyNegativePattern.SelectedValue.Trim().ToString());
sqt.currency_positive_format_id = Convert.ToInt32(this.CurrencyPositivePattern.SelectedValue.Trim().ToString());
sqt.number_display_format_id = Convert.ToInt32(this.NumberFormat.SelectedValue.Trim().ToString());
sqt.date_display_format_id = Convert.ToInt32(this.DateFormat.SelectedValue.Trim().ToString());
sqt.cate_id = 1;
if (this.show_each_tax_in_tax_group.Checked)
{
sqt.show_each_tax_in_tax_group = 1;
}
else
{
sqt.show_each_tax_in_tax_group = 0;
}
if (this.show_each_tax_in_tax_period.Checked)
{
sqt.show_each_tax_in_tax_period = 1;
}
else
{
sqt.show_each_tax_in_tax_period = 0;
}
if (this.show_tax_cate.Checked)
{
sqt.show_tax_cate = 1;
}
else
{
sqt.show_tax_cate = 0;
}
if (this.show_tax_cate_superscript.Checked)
{
sqt.show_tax_cate_superscript = 1;
}
else
{
sqt.show_tax_cate_superscript = 0;
}
sqt.tax_total_disp = tax_total_disp();
// sqt.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
QuoteTemplateBLL qtbll = new QuoteTemplateBLL();
if (string.IsNullOrEmpty(sqt.name))
{
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('模板名称未填写！');</script>");
}
if (id > 0)
{
var result = qtbll.update(sqt, 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
{
int id1;
var result = qtbll.Add(sqt, GetLoginUserId(), out id1);
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");
}
}
}
protected void Save_Close_Click(object sender, EventArgs e)
{
sys_quote_tmpl data = new sys_quote_tmpl();
if (id > 0)
{
data = temp.GetQuoteTemplate(id);
}
data.name = this.Name.Text.Trim().ToString();
if (this.Active.Checked)
{
data.is_active = 1;
}
else
{
data.is_active = 0;
}
data.description = this.Description.Text.Trim().ToString();
data.paper_size_id = paper_size_id();
data.page_number_location_id = page_number_location_id();
data.currency_negative_format_id = Convert.ToInt32(this.CurrencyNegativePattern.SelectedValue.Trim().ToString());
data.currency_positive_format_id = Convert.ToInt32(this.CurrencyPositivePattern.SelectedValue.Trim().ToString());
data.number_display_format_id = Convert.ToInt32(this.NumberFormat.SelectedValue.Trim().ToString());
data.date_display_format_id = Convert.ToInt32(this.DateFormat.SelectedValue.Trim().ToString());
data.payment_term_id = Convert.ToInt32(this.Payment_terms.SelectedValue.Trim().ToString());
data.show_each_tax_in_tax_group = 1;
data.show_tax_cate_superscript = 1;
data.show_tax_cate = 1;
data.show_each_tax_in_tax_period = 0;
data.cate_id = 2;
if (id > 0)
{
var result = temp.update(data, 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 = temp.Add(data, GetLoginUserId(), out id);
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");
}
}
}
