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