public void Bind()
{
#region 拉框赋值
var dic = new QuoteTemplateBLL().GetField();
// 日期格式
this.DateFormat.DataTextField = "show";
this.DateFormat.DataValueField = "val";
this.DateFormat.DataSource = dic.FirstOrDefault(_ => _.Key == "DateFormat").Value;
this.DateFormat.DataBind();
this.DateFormat.SelectedIndex = 0;
//数字格式
this.NumberFormat.DataTextField = "show";
this.NumberFormat.DataValueField = "val";
this.NumberFormat.DataSource = dic.FirstOrDefault(_ => _.Key == "NumberFormat").Value;
this.NumberFormat.DataBind();
//货币格式（正数）
this.CurrencyPositivePattern.DataTextField = "show";
this.CurrencyPositivePattern.DataValueField = "val";
this.CurrencyPositivePattern.DataSource = dic.FirstOrDefault(_ => _.Key == "CurrencyPositivePattern").Value;
this.CurrencyPositivePattern.DataBind();
//货币格式（负数）
this.CurrencyNegativePattern.DataTextField = "show";
this.CurrencyNegativePattern.DataValueField = "val";
this.CurrencyNegativePattern.DataSource = dic.FirstOrDefault(_ => _.Key == "CurrencyNegativePattern").Value;
this.CurrencyNegativePattern.DataBind();
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["item"] != null && !string.IsNullOrEmpty(Request.QueryString["item"].ToString()))
{
body_item = Request.QueryString["item"].ToString();
}
else
{
body_item = "";
}
this.AlertVariableFilter.DataTextField = "show";
this.AlertVariableFilter.DataValueField = "val";
this.AlertVariableFilter.DataSource = new QuoteTemplateBLL().GetBodyVariableField();
this.AlertVariableFilter.DataBind();
this.AlertVariableFilter.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
var list = new QuoteTemplateBLL().GetBodyAllVariable();
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
if (!IsPostBack)
{
if (Session["quote_head"] != null && !string.IsNullOrEmpty(Session["quote_head"].ToString()))
{
quote_head = HttpUtility.HtmlDecode(Session["quote_head"].ToString()).Replace("\"", "'");
}
this.AlertVariableFilter.DataTextField = "show";
this.AlertVariableFilter.DataValueField = "val";
this.AlertVariableFilter.DataSource = new QuoteTemplateBLL().GetVariableField();
this.AlertVariableFilter.DataBind();
this.AlertVariableFilter.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
//
var list = new QuoteTemplateBLL().GetAllVariable();
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();
}
//quote_head = HttpUtility.HtmlDecode(data.quote_header_html).Replace("\"", "'");
}
protected void AlertVariableFilter_SelectedIndexChanged(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
if (this.AlertVariableFilter.SelectedValue == "0")
{
sb.Clear();
var list = new QuoteTemplateBLL().GetAllVariable();
foreach (string va in list)
{
sb.Append("<option class='val' ondblclick='dbclick(this);'>" + va.Replace("'", "") + "</option>");
}
this.VariableList.Text = sb.ToString();
}
else
{
int id = Convert.ToInt32(this.AlertVariableFilter.SelectedValue.ToString());
sb.Clear();
var list = new QuoteTemplateBLL().GetVariable(id);
foreach (string va in list)
{
sb.Append("<option class='val' ondblclick='dbclick(this);' >" + va.Replace("'", "") + "</option>");
}
this.VariableList.Text = sb.ToString();
}
}
public void Bind()
{
var dic = new QuoteTemplateBLL().GetField();
//分组
this.GroupBy.DataTextField = "show";
this.GroupBy.DataValueField = "val";
this.GroupBy.DataSource = dic.FirstOrDefault(_ => _.Key == "GroupBy").Value;
this.GroupBy.DataBind();
this.GroupBy.SelectedIndex = 0;
//显示
this.Itemize.DataTextField = "show";
this.Itemize.DataValueField = "val";
this.Itemize.DataSource = dic.FirstOrDefault(_ => _.Key == "Itemize").Value;
this.Itemize.DataBind();
//排序字段
this.SortBy.DataTextField = "show";
this.SortBy.DataValueField = "val";
this.SortBy.DataSource = dic.FirstOrDefault(_ => _.Key == "SortBy").Value;
this.SortBy.DataBind();
//可选变量
this.Variable.DataTextField = "show";
this.Variable.DataValueField = "val";
this.Variable.DataSource = new QuoteTemplateBLL().GetInvoiceBodyVariableField();
this.Variable.DataBind();
this.Variable.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
var list = new QuoteTemplateBLL().GetBodyAllInvoiceVariable();
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.GetVaild.DataTextField = "show";
this.GetVaild.DataValueField = "val";
this.GetVaild.DataSource = new QuoteTemplateBLL().GetInvoiceBodyVariableField();
this.GetVaild.DataBind();
this.GetVaild.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
this.GetVaildlist.Text = sb.ToString();
}
/// <summary>
/// 设置发票模板为默认
/// </summary>
/// <param name="context"></param>
/// <param name="invoiceTmplId"></param>
public void DefaultInvoiceTemplate(HttpContext context, long invoiceTmplId)
{
var result = new QuoteTemplateBLL().default_quote_template(LoginUserId, invoiceTmplId);
if (result == DTO.ERROR_CODE.SUCCESS)
{
context.Response.Write("设为默认发票模板成功！");
}
else if (result == DTO.ERROR_CODE.DEFAULT)
{
context.Response.Write("已经是默认状态，无需再操作！");
}
else
{
context.Response.Write("设为默认发票模板失败！");
}
}
//转PDF,还没有完成9-26
protected void ToPdf_Click(object sender, EventArgs e)
{
var data = new QuoteTemplateBLL().GetQuoteTemplate(id);
string savepath = string.Format("C:\\DoneNowNET" + "\\" + data.name + ".pdf");//最终保存
string url = Request.Url.ToString();
try
{
if (!string.IsNullOrEmpty(url) || !string.IsNullOrEmpty(savepath))
{
Process p = new Process();
string dllstr = string.Format("C:\\Program Files (x86)\\wkhtmltopdf\\bin\\wkhtmltopdf.exe");
if (File.Exists(dllstr))
{
p.StartInfo.FileName = dllstr;
p.StartInfo.Arguments = " \"" + url + "\" \"" + savepath + "\"";
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardInput = true;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.RedirectStandardError = true;
p.StartInfo.CreateNoWindow = true;
p.Start();
p.WaitForExit();
try
{
FileStream fs = new FileStream(savepath, FileMode.Open);
byte[] file = new byte[fs.Length];
fs.Read(file, 0, file.Length);
fs.Close();
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + data.name + ".pdf");//強制下載
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(file);
}
catch (Exception ee)
{
throw new Exception(ee.ToString());
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
public void ActiveQuoteTemplate(HttpContext context, long QuoteTemp_id)
{
var result = new QuoteTemplateBLL().active_quote_template(LoginUserId, QuoteTemp_id);
if (result == DTO.ERROR_CODE.SUCCESS)
{
context.Response.Write("设为激活状态报价模板成功！");
}
else if (result == DTO.ERROR_CODE.ACTIVATION)
{
context.Response.Write("已经是激活状态，无需再操作！");
}
else
{
context.Response.Write("设为激活状态报价模板失败！");
}
}
/// <summary>
/// 停用发票模板
/// </summary>
/// <param name="context"></param>
/// <param name="invoiceTmplId"></param>
public void NoActiveInvoiceTemplate(HttpContext context, long invoiceTmplId)
{
var result = new QuoteTemplateBLL().no_active_quote_template(LoginUserId, invoiceTmplId);
if (result == DTO.ERROR_CODE.SUCCESS)
{
context.Response.Write("设为停用状态发票模板成功！");
}
else if (result == DTO.ERROR_CODE.NO_ACTIVATION)
{
context.Response.Write("已经是停用状态，无需再操作！");
}
else
{
context.Response.Write("设为停用状态发票模板失败！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
if (!IsPostBack)
{
tempinfo = Session["tempinfo"] as InvioceTempDto.TempContent;
if (tempinfo != null && tempinfo.id == id)
{
if (!string.IsNullOrEmpty(tempinfo.bottom))
{
bottom = HttpUtility.HtmlDecode(tempinfo.bottom).Replace("\"", "'");
}
if (!string.IsNullOrEmpty(tempinfo.Invoice_text))
{
bottomttt = new EMT.Tools.Serialize().DeserializeJson <InvioceTempDto.Invoice_ext>(tempinfo.Invoice_text);
if (tempinfo.tax_cat == 1)
{
this.tax_cate.Checked = true;
}
if (tempinfo.tax_group == 1)
{
this.tax_group.Checked = true;
}
if (tempinfo.tax_sup == 1)
{
this.tax_sup.Checked = true;
}
}
}
this.AlertVariableFilter.DataTextField = "show";
this.AlertVariableFilter.DataValueField = "val";
this.AlertVariableFilter.DataSource = new QuoteTemplateBLL().GetInvoiceVariableField();
this.AlertVariableFilter.DataBind();
this.AlertVariableFilter.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
var list = new QuoteTemplateBLL().GetAllVariable();
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();
}
}
private void save()
{
QuoteTemplateBLL qtbll = new QuoteTemplateBLL();
var sqt = qtbll.GetQuoteTemplate(id);
if (sqt == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('获取数据错误！');history.go(-1);</script>");
}
tempinfo = Session["tempinfo"] as InvioceTempDto.TempContent;
if (tempinfo != null && tempinfo.id == id)
{
sqt.page_header_html = tempinfo.head; //页眉
sqt.quote_header_html = tempinfo.top; //头部
sqt.body_html = tempinfo.body; //主体
sqt.quote_footer_html = tempinfo.bottom; //底部
sqt.page_footer_html = tempinfo.foot; //页脚
//bottom税相关
sqt.show_tax_cate = (SByte)tempinfo.tax_cat;
sqt.show_each_tax_in_tax_group = (SByte)tempinfo.tax_group;
sqt.show_tax_cate_superscript = (SByte)tempinfo.tax_sup;
//body分组
sqt.body_group_by_id = tempinfo.body_group_by;
sqt.body_itemize_id = tempinfo.body_itemize_id;
sqt.body_order_by_id = tempinfo.body_order_by;
sqt.show_labels_when_grouped = (SByte)tempinfo.show_labels_when_grouped;
//bottom 合计
sqt.tax_total_disp = tempinfo.Invoice_text;
//底部备注
sqt.quote_footer_notes = tempinfo.foot_note;
}
//更新保存
var result = qtbll.update(sqt, GetLoginUserId());
if (result == ERROR_CODE.SUCCESS) // 更新用户成功，刷新前一个页面
{
Response.Write("<script>alert('发票模板修改成功！');</script>"); //关闭添加页面的同时，刷新父页面
}
else if (result == ERROR_CODE.USER_NOT_FIND) // 用户丢失
{
Response.Write("<script>alert('查询不到用户，请重新登陆');</script>");
Response.Redirect("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
// quote_group_by
groupBy.DataTextField = "show";
groupBy.DataValueField = "val";
groupBy.DataSource = dic.FirstOrDefault(_ => _.Key == "quote_group_by").Value;
groupBy.DataBind();
isShow = Request.QueryString["isShow"];
IssaleOrder = !string.IsNullOrEmpty(Request.QueryString["isSaleOrder"]);
var sid = Request.QueryString["sale_order_id"];
if (!string.IsNullOrEmpty(sid))
{
sale_order_id = long.Parse(sid);
}
var quote_id = Request.QueryString["quote_id"];
if (!string.IsNullOrEmpty(quote_id))
{
quote = new QuoteBLL().GetQuote(Convert.ToInt64(quote_id));
if (quote.quote_tmpl_id != null)
{
var sys_quote_temp = new QuoteTemplateBLL().GetQuoteTemplate((long)quote.quote_tmpl_id);
if (sys_quote_temp != null)
{
// 获取到该报价的报价模板用于设置税的显示方式和汇总名称
show_each_tax_in_tax_group.Value = sys_quote_temp.show_each_tax_in_tax_group.ToString();
show_each_tax_in_tax_period.Value = sys_quote_temp.show_each_tax_in_tax_period.ToString(); // 选中第一个：按照周期分组时起作用，每个周期后显示税 最后的汇总也有税）
// var a3 =sys_quote_temp.show_labels_when_grouped; // 预留字段
show_tax_cate.Value = sys_quote_temp.show_tax_cate.ToString();
show_tax_cate_superscript.Value = sys_quote_temp.show_tax_cate_superscript.ToString();
}
}
}
var opportunity_id = Request.QueryString["opportunity_id"]; // 这里是通过商机查看报价项的情况
if (!string.IsNullOrEmpty(opportunity_id))
{
var oppoQuoteList = new crm_quote_dal().GetQuoteByWhere($" and opportunity_id = {opportunity_id} ");
if (oppoQuoteList != null && oppoQuoteList.Count > 0)
{
quote = oppoQuoteList.FirstOrDefault(_ => _.is_primary_quote == 1); // 如果该商机下有报价则一定会有主报价
}
}
if (quote != null)
{
quoteItemList = new crm_quote_item_dal().GetQuoteItems($" and quote_id={quote.id} ");
// quoteItemList.Sort(SortCycle); // 自定义排序测试
quoteItemList = quoteItemList.OrderBy(_ => SortQuoteItem(_.period_type_id)).ToList();
quoteList = new crm_quote_dal().GetQuoteByWhere($" and opportunity_id = {quote.opportunity_id} ");
var primaryQuote = quoteList.FirstOrDefault(_ => _.is_primary_quote == 1);
if (primaryQuote != null)
{
var thisQuoteItemList = new crm_quote_item_dal().GetQuoteItems($" and quote_id={primaryQuote.id} ");
var thisDiscountQIList = thisQuoteItemList.Where(_ => _.type_id == (int)DTO.DicEnum.QUOTE_ITEM_TYPE.DISCOUNT && _.optional == 0).ToList();
var thisOneTimeQTList = thisQuoteItemList.Where(_ => _.period_type_id == (int)DTO.DicEnum.QUOTE_ITEM_PERIOD_TYPE.ONE_TIME && _.optional == 0).ToList();
var thisOptionalItemList = thisQuoteItemList.Where(_ => _.optional == 1).ToList();
var totalPrice = ((decimal)((thisQuoteItemList.Sum(_ => (_.unit_discount != null && _.unit_price != null && _.quantity != null) ? (_.unit_price - _.unit_discount) * _.quantity : 0) - thisDiscountQIList.Where(_ => _.discount_percent != null).ToList().Sum(_ => (_.unit_discount != null && _.quantity != null) ? _.unit_discount * _.quantity : 0) - (thisOneTimeQTList != null && thisOneTimeQTList.Count > 0 ? thisDiscountQIList.Where(_ => _.discount_percent != null).ToList().Sum(_ => thisOneTimeQTList.Sum(one => (one.unit_discount != null && one.unit_price != null && one.quantity != null) ? (one.unit_price - one.unit_discount) * one.quantity : 0) * _.discount_percent) : 0)))).ToString("#0.00");
quoteList.Remove(primaryQuote);
primaryQuote.name = "PRIMARY:" + primaryQuote.name + "(" + totalPrice + ")";
quoteList.Add(primaryQuote);
}
#region // 为报价下拉框赋值
quoteDropList.DataValueField = "id";
quoteDropList.DataTextField = "name";
quoteDropList.DataSource = quoteList;
quoteDropList.DataBind();
quoteDropList.SelectedValue = quote.id.ToString();
#endregion
if (quoteItemList != null && quoteItemList.Count > 0)
{
// 用户需要添加折扣类型的报价项，然后可以针对付费周期类型为一次性的报价项进行折扣
// 折扣只针对一次性周期的报价项折扣
oneTimeList = quoteItemList.Where(_ => _.period_type_id == (int)DTO.DicEnum.QUOTE_ITEM_PERIOD_TYPE.ONE_TIME && _.optional == 0 && _.type_id != (int)DTO.DicEnum.QUOTE_ITEM_TYPE.DISCOUNT && _.type_id != (int)DTO.DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES).ToList();
discountQIList = quoteItemList.Where(_ => _.type_id == (int)DTO.DicEnum.QUOTE_ITEM_TYPE.DISCOUNT && _.optional == 0).ToList();
// 获取到可选的报价项，
optionalItemList = quoteItemList.Where(_ => _.optional == 1).ToList(); // 获取到可选的报价项
// optionalItemList.Sort();
// &&optionalItemList.Any(op=>op.id!=_.id)&&oneTimeList.Any(one=>one.id!=_.id) 满足多个报价项过滤条件的，选择其中的一个
distributionList = quoteItemList.Where(_ => _.type_id == (int)DTO.DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES && _.optional == 0).ToList(); // 配送类型的报价项
// 配送，一次性，可选的配置项独立显示，所以在这里分离出来，传到前台后单独处理
// 获取到筛选后报价项列表方便分组管理 筛选后的列表不包括可选，一次性的折扣和配送
var screenList = quoteItemList.Where(_ => _.type_id != (int)EMT.DoneNOW.DTO.DicEnum.QUOTE_ITEM_TYPE.DISTRIBUTION_EXPENSES && _.optional != 1 && _.type_id != (int)DTO.DicEnum.QUOTE_ITEM_TYPE.DISCOUNT).ToList();
if (!string.IsNullOrEmpty(Request.QueryString["group_by"]))
{
groupByType = Request.QueryString["group_by"];
}
else
{
if (quote.group_by_id != null)
{
groupByType = ((long)quote.group_by_id).ToString();
}
}
// groupByType = ?((long)quote.group_by_id).ToString():Request.QueryString["group_by"];
if (groupByType == ((int)EMT.DoneNOW.DTO.DicEnum.QUOTE_GROUP_BY.CYCLE).ToString()) // 按周期分组
{
groupList = screenList.GroupBy(_ => _.period_type_id == null ? "" : _.period_type_id.ToString()).ToDictionary(_ => (object)_.Key, _ => _.ToList()); // as Dictionary<long?,
new QuoteBLL().UpdateGroup(quote.id, (int)QUOTE_GROUP_BY.CYCLE, GetLoginUserId());
groupBy.SelectedValue = ((int)QUOTE_GROUP_BY.CYCLE).ToString();
}
else if (groupByType == ((int)QUOTE_GROUP_BY.PRODUCT).ToString()) // 按产品分组
{
groupList = screenList.GroupBy(_ => _.object_id == null ? "" : ReturnProductID((long)_.object_id)).ToDictionary(_ => (object)_.Key, _ => _.ToList());
new QuoteBLL().UpdateGroup(quote.id, (int)QUOTE_GROUP_BY.PRODUCT, GetLoginUserId());
groupBy.SelectedValue = ((int)QUOTE_GROUP_BY.PRODUCT).ToString();
}
else if (groupByType == ((int)QUOTE_GROUP_BY.CYCLE_PRODUCT).ToString()) // 按周期产品分组
{
new QuoteBLL().UpdateGroup(quote.id, (int)QUOTE_GROUP_BY.CYCLE_PRODUCT, GetLoginUserId());
groupBy.SelectedValue = ((int)QUOTE_GROUP_BY.CYCLE_PRODUCT).ToString();
doubleGroupList = screenList.GroupBy(d => d.period_type_id == null ? "" : d.period_type_id.ToString()).ToDictionary(_ => (object)_.Key, _ => _.ToList().GroupBy(d => d.object_id == null ? "" : ReturnProductID((long)d.object_id)).ToDictionary(d => (object)d.Key, d => d.ToList()));
}
else if (groupByType == ((int)QUOTE_GROUP_BY.PRODUCT_CYCLE).ToString()) // 按产品周期分组
{
new QuoteBLL().UpdateGroup(quote.id, (int)QUOTE_GROUP_BY.PRODUCT_CYCLE, GetLoginUserId());
groupBy.SelectedValue = ((int)QUOTE_GROUP_BY.PRODUCT_CYCLE).ToString();
doubleGroupList = screenList.GroupBy(_ => _.object_id == null ? "" : ReturnProductID((long)_.object_id)).ToDictionary(_ => (object)_.Key, _ => _.ToList().GroupBy(d => d.period_type_id == null ? "" : d.period_type_id.ToString()).ToDictionary(d => (object)d.Key, d => d.ToList()));
}
else // 不分组
{
new QuoteBLL().UpdateGroup(quote.id, (int)QUOTE_GROUP_BY.NO, GetLoginUserId());
groupBy.SelectedValue = ((int)QUOTE_GROUP_BY.NO).ToString();
}
//switch (groupByType)
//{
// case "cycle":
// // 按照周期分组
// break;
// case "product":
// break;
// default:
// groupByType = "no";
// break;
//}
// ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script> $(\"#groupBy\").val('"+groupBy+"')</script>");
if (discountQIList != null && discountQIList.Count > 0)
{
discountQIList.ForEach(_ => { if (_.discount_percent != null)
{
_.discount_percent = _.discount_percent / 100;
}
});
}
}
}
else
{
Response.End();
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void Bind()
{
#region 拉框赋值
var dic = new QuoteTemplateBLL().GetField();
// 日期格式
this.DateFormat.DataTextField = "show";
this.DateFormat.DataValueField = "val";
this.DateFormat.DataSource = dic.FirstOrDefault(_ => _.Key == "DateFormat").Value;
this.DateFormat.SelectedValue = data.date_display_format_id.ToString();
this.DateFormat.DataBind();
//数字格式
this.NumberFormat.DataTextField = "show";
this.NumberFormat.DataValueField = "val";
this.NumberFormat.DataSource = dic.FirstOrDefault(_ => _.Key == "NumberFormat").Value;
this.NumberFormat.SelectedValue = data.number_display_format_id.ToString();
this.NumberFormat.DataBind();
//货币格式（正数）
this.CurrencyPositivePattern.DataTextField = "show";
this.CurrencyPositivePattern.DataValueField = "val";
this.CurrencyPositivePattern.DataSource = dic.FirstOrDefault(_ => _.Key == "CurrencyPositivePattern").Value;
this.CurrencyPositivePattern.SelectedValue = data.currency_positive_format_id.ToString();
this.CurrencyPositivePattern.DataBind();
//货币格式（负数）
this.CurrencyNegativePattern.DataTextField = "show";
this.CurrencyNegativePattern.DataValueField = "val";
this.CurrencyNegativePattern.DataSource = dic.FirstOrDefault(_ => _.Key == "CurrencyNegativePattern").Value;
this.CurrencyNegativePattern.SelectedValue = data.currency_negative_format_id.ToString();
this.CurrencyNegativePattern.DataBind();
this.Name.Text = data.name;
this.Description.Text = data.description;
if (data.is_active != 1)
{
this.Active.Checked = false;
}
if (data.show_each_tax_in_tax_group == 1)
{
this.show_each_tax_in_tax_group.Checked = true;
}
if (data.show_each_tax_in_tax_period == 1)
{
this.show_each_tax_in_tax_period.Checked = true;
k = 1;
}
if (data.show_tax_cate == 1)
{
this.show_tax_cate.Checked = true;
}
if (data.show_tax_cate_superscript == 1)
{
this.show_tax_cate_superscript.Checked = true;
}
var data_tax = new EMT.Tools.Serialize().DeserializeJson <QuoteTemplateAddDto.Tax_Total_Disp>(data.tax_total_disp);
this.SemiAnnualTotal.Text = data_tax.Semi_Annual_Total;
this.IncludingOptionalQuoteItems.Text = data_tax.Including_Optional_Quote_Items;
this.ItemTotal.Text = data_tax.Item_Total;
this.Subtotal.Text = data_tax.Subtotal;
this.Total.Text = data_tax.Total;
this.TotalTaxes.Text = data_tax.Total_Taxes;
this.YearlySubtotal.Text = data_tax.Yearly_Subtotal;
this.YearlyTotal.Text = data_tax.Yearly_Total;
this.ShippingTotal.Text = data_tax.Shipping_Total;
this.ShippingSubtotal.Text = data_tax.Shipping_Subtotal;
this.SemiAnnualSubtotal.Text = data_tax.Semi_Annual_Subtotal;
this.QuarterlySubtotal.Text = data_tax.Quarterly_Subtotal;
this.QuarterlyTotal.Text = data_tax.Quarterly_Total;
this.MonthlySubtotal.Text = data_tax.Monthly_Subtotal;
this.OptionalSubtotal.Text = data_tax.Optional_Subtotal;
this.OptionalTotal.Text = data_tax.Optional_Total;
this.MonthlyTotal.Text = data_tax.Monthly_Total;
this.OneTimeDiscountSubtotal.Text = data_tax.One_Time_Discount_Subtotal;
this.OneTimeDiscountTotal.Text = data_tax.One_Time_Discount_Total;
this.OneTimeSubtotal.Text = data_tax.One_Time_Subtotal;
this.OneTimeTotal.Text = data_tax.One_Time_Total;
switch (data.page_number_location_id)
{
case (int)PAGE_NUMBER_LOCATION.NO: this.showNO.Checked = true; break;
case (int)PAGE_NUMBER_LOCATION.BOTTOMLEFT: this.showLeft.Checked = true; break;
case (int)PAGE_NUMBER_LOCATION.BOTTOMCENTER: this.showCenter.Checked = true; break;
case (int)PAGE_NUMBER_LOCATION.BOTTOMRIGHT: this.showRight.Checked = true; break;
}
switch (data.paper_size_id)
{
case (int)PAGE_SIZE.LETTER: this.Letter.Checked = true; break;
case (int)PAGE_SIZE.A4: this.A4.Checked = true; break;
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
id = Convert.ToInt64(Request.QueryString["id"]);
if (!IsPostBack)
{
Bind();
if (id > 0) //修改
{
var data = new QuoteTemplateBLL().GetQuoteTemplate(id);
if (data == null)
{
Response.Write("<script>alert('获取相关数据失败，返回上一个页面');window.close();self.opener.location.reload();</script>");
}
else
{
this.Name.Text = data.name;
this.Description.Text = data.description;
if (data.is_active == 1)
{
this.Active.Checked = true;
}
if (data.show_each_tax_in_tax_group == 1)
{
this.show_each_tax_in_tax_group.Checked = true;
}
if (data.show_each_tax_in_tax_period == 1)
{
this.show_each_tax_in_tax_period.Checked = true;
}
if (data.show_tax_cate == 1)
{
this.show_tax_cate.Checked = true;
}
if (data.show_tax_cate_superscript == 1)
{
this.show_tax_cate_superscript.Checked = true;
}
var data_tax = new EMT.Tools.Serialize().DeserializeJson <QuoteTemplateAddDto.Tax_Total_Disp>(data.tax_total_disp);
this.SemiAnnualTotal.Text = data_tax.Semi_Annual_Total;
this.IncludingOptionalQuoteItems.Text = data_tax.Including_Optional_Quote_Items;
this.ItemTotal.Text = data_tax.Item_Total;
this.Subtotal.Text = data_tax.Subtotal;
this.Total.Text = data_tax.Total;
this.TotalTaxes.Text = data_tax.Total_Taxes;
this.YearlySubtotal.Text = data_tax.Yearly_Subtotal;
this.YearlyTotal.Text = data_tax.Yearly_Total;
this.ShippingTotal.Text = data_tax.Shipping_Total;
this.ShippingSubtotal.Text = data_tax.Shipping_Subtotal;
this.SemiAnnualSubtotal.Text = data_tax.Semi_Annual_Subtotal;
this.QuarterlySubtotal.Text = data_tax.Quarterly_Subtotal;
this.QuarterlyTotal.Text = data_tax.Quarterly_Total;
this.MonthlySubtotal.Text = data_tax.Monthly_Subtotal;
this.OptionalSubtotal.Text = data_tax.Optional_Subtotal;
this.OptionalTotal.Text = data_tax.Optional_Total;
this.MonthlyTotal.Text = data_tax.Monthly_Total;
this.OneTimeDiscountSubtotal.Text = data_tax.One_Time_Discount_Subtotal;
this.OneTimeDiscountTotal.Text = data_tax.One_Time_Discount_Total;
this.OneTimeSubtotal.Text = data_tax.One_Time_Subtotal;
this.OneTimeTotal.Text = data_tax.One_Time_Total;
switch (data.page_number_location_id)
{
case (int)PAGE_NUMBER_LOCATION.NO: this.showNO.Checked = true; break;
case (int)PAGE_NUMBER_LOCATION.BOTTOMLEFT: this.showLeft.Checked = true; break;
case (int)PAGE_NUMBER_LOCATION.BOTTOMCENTER: this.showCenter.Checked = true; break;
case (int)PAGE_NUMBER_LOCATION.BOTTOMRIGHT: this.showRight.Checked = true; break;
}
switch (data.paper_size_id)
{
case (int)PAGE_SIZE.LETTER: this.Letter.Checked = true; break;
case (int)PAGE_SIZE.A4: this.A4.Checked = true; break;
}
}
}
}
}
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 Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
if (!IsPostBack)
{
if (Session["cancel"] != null && (int)Session["cancel"] != 1)
{
Cancel1();
}
Session["cancel"] = 0;
QuoteTemplateBLL qtb = new QuoteTemplateBLL();
if (Request.QueryString["op"] == null || string.IsNullOrEmpty(Request.QueryString["op"].ToString()))
{
if (qtb.is_quote(id) == DTO.ERROR_CODE.ERROR)//判断报价模板是否被引用
{
Response.Write("<script>if(confirm('模板被报价引用，如果修改会影响到这些报价。你如果你不想影响这些报价，可以复制一个新的模板，然后对新模板进行修改。是否继续?')==true){}else{window.close();}</script>");
}
}
//填充数据
var data = qtb.GetQuoteTemplate(id);
if (data == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('获取数据错误！');history.go(-1);</script>");
}
else
{
tempname = data.name;
//页眉
if (Session["page_head"] != null && !string.IsNullOrEmpty(Session["page_head"].ToString()))
{
this.head.Text = HttpUtility.HtmlDecode(Session["page_head"].ToString()).Replace("\"", "'");
}
else
{
if (string.IsNullOrEmpty(data.page_header_html))
{
Session["page_head"] = this.head.Text = " ";
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
}
else
{
Session["page_head"] = this.head.Text = HttpUtility.HtmlDecode(data.page_header_html).Replace("\"", "'");
}
}
}
//头部
if (Session["quote_head"] != null)
{
this.top.Text = HttpUtility.HtmlDecode(Session["quote_head"].ToString()).Replace("\"", "'");
}
else
{
if (string.IsNullOrEmpty(data.quote_header_html))
{
Session["quote_head"] = this.top.Text = " ";
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
}
else
{
Session["quote_head"] = this.top.Text = HttpUtility.HtmlDecode(data.quote_header_html).Replace("\"", "'");
}
}
}
//正文body
//正在进行中
string body_json = string.Empty;
if (Session["quote_body"] == null || string.IsNullOrEmpty(Session["quote_body"].ToString()))
{
if (string.IsNullOrEmpty(data.body_html))
{
//Session["quote_body"] = ";
//填充默认
StringBuilder sb = new StringBuilder();
sb.Append("<table class='ReadOnlyGrid_Table'>");
sb.Append("<tr>");
sb.Append("<td class='ReadOnlyGrid_TableHeader' style='text-align: Left;' width='40px;'>序列号</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>数量</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Left;'>报价项名称</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>单价</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>单元折扣t</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>折后价</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>总价</td>");
sb.Append("</tr>");
for (int i = 0; i < 8; i++)
{
sb.Append("<tr><td style='text - align: Left; '>[Quote Item:Number]</td><td class='ReadOnlyGrid_TableHeader' style='text - align: Left; '>[Quote Item:Quantity]</td><td class='ReadOnlyGrid_TableHeader' style='text - align: Left; '>[Quote Item:Name]<br/>[Quote Item:Item Description]</td><td class='ReadOnlyGrid_TableHeader' style='text - align: Left; '>[Quote Item:Unit Price]</td><td class='ReadOnlyGrid_TableHeader' style='text - align: Left; '>[Quote Item:Unit Discount]</td><td class='ReadOnlyGrid_TableHeader' style='text - align: Left; '>[Quote Item:Adjusted Unit Price]</td><td class='ReadOnlyGrid_TableHeader' style='text - align: Left; '>[Quote Item:Extended Price]</td></tr>");
}
sb.Append("</table>");
this.body.Text = sb.ToString();
sb.Clear();
}
else
{
Session["quote_body"] = HttpUtility.HtmlDecode(data.body_html).Replace("\"", "'");
body_json = Session["quote_body"].ToString();
}
}
else
{
body_json = Session["quote_body"].ToString();
}
if (!string.IsNullOrEmpty(body_json))
{
var quote_body = new EMT.Tools.Serialize().DeserializeJson <QuoteTemplateAddDto.BODY>(body_json.Replace("'", "\"")); //正文主体
int i = 0; //统计显示的列数
StringBuilder table = new StringBuilder();
table.Append("<table class='ReadOnlyGrid_Table'>");
table.Append("<tr>");
foreach (var coulmn in quote_body.GRID_COLUMN)//获取需要显示的列名
{
if (coulmn.Display == "yes")
{
table.Append("<td class='ReadOnlyGrid_TableHeader' style='text-align: Left; '>" + coulmn.Column_label + "</td>");
i++;
}
}
table.Append("</tr>");
for (int j = 0; j < 8; j++)
{
table.Append("<tr>");
foreach (var coulmn in quote_body.GRID_COLUMN)//获取需要显示的列名
{
if (coulmn.Display == "yes" && coulmn.Column_Content != "报价项名称")
{
table.Append("<td style='text-align: Left;' class='bord'>" + coulmn.Column_Content + "</td>");
}
if (coulmn.Display == "yes" && coulmn.Column_Content == "报价项名称")
{
table.Append("<td style='text-align: Left;'class='bord'>" + quote_body.CUSTOMIZE_THE_ITEM_COLUMN[j].Display_Format + "</td>");
}
if (quote_body.GRID_OPTIONS[0].Show_vertical_lines == "yes")
{
Response.Write("<style>.bord{border-left: 1px solid #eaeaea;border-right: 1px solid #eaeaea;}</style>");
}
}
table.Append("</tr>");
}
table.Append("</table>");
this.body.Text = table.ToString();
table.Clear();
}
//底部
if (Session["quote_foot"] != null)
{
this.bottom.Text = HttpUtility.HtmlDecode(Session["quote_foot"].ToString()).Replace("\"", "'");
}
else
{
if (string.IsNullOrEmpty(data.quote_footer_html))
{
Session["quote_foot"] = this.bottom.Text = " ";
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
}
else
{
Session["quote_foot"] = this.bottom.Text = HttpUtility.HtmlDecode(data.quote_footer_html).Replace("\"", "'");
}
}
}
//页脚
if (Session["page_foot"] != null)
{
this.foot.Text = HttpUtility.HtmlDecode(Session["page_foot"].ToString()).Replace("\"", "'");
}
else
{
if (string.IsNullOrEmpty(data.page_footer_html))
{
Session["page_foot"] = this.foot.Text = " ";
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
}
else
{
Session["page_foot"] = this.foot.Text = HttpUtility.HtmlDecode(data.page_footer_html).Replace("\"", "'");
}
}
}
if (Session["page_appendix"] == null || string.IsNullOrEmpty(Session["page_appendix"].ToString()))
{
if (string.IsNullOrEmpty(data.quote_footer_notes))
{
Session["page_appendix"] = " ";
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
}
else
{
Session["page_appendix"] = HttpUtility.HtmlDecode(data.quote_footer_notes).Replace("\"", "'");
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
// id = 1475;
if (!IsPostBack)
{
if (Session["cancel"] != null && (int)Session["cancel"] != 1)
{
Session.Remove("tempinfo");
}
Session["cancel"] = 0;
QuoteTemplateBLL qtb = new QuoteTemplateBLL();
if (Request.QueryString["op"] == null || string.IsNullOrEmpty(Request.QueryString["op"].ToString()))
{
if (qtb.invoice_used(id) == DTO.ERROR_CODE.ERROR)//判断报价模板是否被引用
{
Response.Write("<script>if(confirm('模板被发票引用，如果修改会影响到这些发票。你如果你不想影响这些发票，可以复制一个新的模板，然后对新模板进行修改。是否继续?')==true){}else{window.close();}</script>");
}
}
//填充数据
var data = qtb.GetQuoteTemplate(id);
if (data == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('获取数据错误！');history.go(-1);</script>");
}
else
{
var tempppp = Session["tempinfo"] as InvioceTempDto.TempContent;
if (tempppp == null || tempppp.id != id)
{
tempinfo.id = data.id;
tempinfo.name = data.name;
//五大部分
tempinfo.head = data.page_header_html; //页眉
tempinfo.top = data.quote_header_html; //头部
tempinfo.body = data.body_html; //主体
tempinfo.bottom = data.quote_footer_html; //底部
tempinfo.foot = data.page_footer_html; //页脚
//bottom税相关
tempinfo.tax_cat = data.show_tax_cate;
tempinfo.tax_group = data.show_each_tax_in_tax_group;
tempinfo.tax_sup = data.show_tax_cate_superscript;
//body分组
tempinfo.body_group_by = data.body_group_by_id == null ? 0 : (int)data.body_group_by_id;
tempinfo.body_itemize_id = data.body_itemize_id == null ? 0 : (int)data.body_itemize_id;
tempinfo.body_order_by = data.body_order_by_id == null ? 0 : (int)data.body_order_by_id;
tempinfo.show_labels_when_grouped = data.show_labels_when_grouped == null ? 0 : (int)data.show_labels_when_grouped;
//bottom 合计
if (data.tax_total_disp != null || !string.IsNullOrEmpty(data.tax_total_disp))
{
tempinfo.Invoice_text = data.tax_total_disp.Replace("'", "\"");//正文主体
}
//底部备注
tempinfo.foot_note = data.quote_footer_notes;
Session["tempinfo"] = tempinfo;
}
else
{
tempinfo = tempppp;
}
//页眉
if (!string.IsNullOrEmpty(tempinfo.head))
{
this.head.Text = HttpUtility.HtmlDecode(tempinfo.head).Replace("\"", "'");
}
//头部
if (!string.IsNullOrEmpty(tempinfo.top))
{
this.top.Text = HttpUtility.HtmlDecode(tempinfo.top).Replace("\"", "'");
}
//正文body
if (string.IsNullOrEmpty(tempinfo.body))
{
//填充默认
StringBuilder sb = new StringBuilder();
sb.Append("<table class='ReadOnlyGrid_Table'>");
sb.Append("<tr>");
sb.Append("<td class='ReadOnlyGrid_TableHeader' style='text-align: Left;' width='40px;'>序列号</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>条目创建日期</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Left;'>类型</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>员工姓名</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>计费时间</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>数量</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>费率/成本</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>税率</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>税</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>计费总额</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>小时费率</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>角色</td><td class='ReadOnlyGrid_TableHeader' style='text-align: Right;'>工作类型</td>");
sb.Append("</tr>");
for (int i = 0; i < 8; i++)
{
sb.Append("<tr><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td><td style='text-align:Left;'>占位</td></tr>");
}
sb.Append("</table>");
this.body.Text = sb.ToString();
sb.Clear();
}
else
{
var Invoice_Body = new EMT.Tools.Serialize().DeserializeJson <InvioceTempDto.Invoice_Body>(tempinfo.body.Replace("'", "\"")); //正文主体
int i = 0; //统计显示的列数
StringBuilder table = new StringBuilder();
table.Append("<table class='ReadOnlyGrid_Table'>");
table.Append("<tr>");
foreach (var coulmn in Invoice_Body.GRID_COLUMN)//获取需要显示的列名
{
if (coulmn.Display == "yes")
{
table.Append("<td class='ReadOnlyGrid_TableHeader' style='text-align: Left; '>" + coulmn.Column_label + "</td>");
i++;
}
}
table.Append("</tr>");
for (int j = 0; j < 8; j++)
{
table.Append("<tr>");
foreach (var coulmn in Invoice_Body.GRID_COLUMN)//获取需要显示的列名
{
if (coulmn.Display == "yes" && coulmn.Column_Content != "条目描述")
{
table.Append("<td style='text-align: Left;' class='bord'>" + coulmn.Column_Content + "</td>");
}
if (coulmn.Display == "yes" && coulmn.Column_Content == "条目描述")
{
table.Append("<td style='text-align: Left;'class='bord'>" + Invoice_Body.CUSTOMIZE_THE_ITEM_COLUMN[j].Display_Format + "</td>");
}
if (Invoice_Body.GRID_OPTIONS[0].Show_vertical_lines == "yes")
{
Response.Write("<style>.bord{border-left: 1px solid #eaeaea;border-right: 1px solid #eaeaea;}</style>");
}
}
table.Append("</tr>");
}
table.Append("</table>");
this.body.Text = table.ToString();
table.Clear();
}
//底部
if (!string.IsNullOrEmpty(tempinfo.bottom))
{
this.bottom.Text = HttpUtility.HtmlDecode(tempinfo.bottom.ToString()).Replace("\"", "'");
}
//页脚
if (!string.IsNullOrEmpty(tempinfo.foot))
{
this.foot.Text = HttpUtility.HtmlDecode(tempinfo.foot.ToString()).Replace("\"", "'");
}
}
}
}
private void save()
{
QuoteTemplateBLL qtbll = new QuoteTemplateBLL();
var sqt = qtbll.GetQuoteTemplate(id);
if (sqt == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('获取数据错误！');history.go(-1);</script>");
}
//sys_quote_tmpl sqt = new sys_quote_tmpl();
if (Session["page_head"] != null)
{
sqt.page_header_html = Session["page_head"].ToString();
}
if (Session["quote_head"] != null)
{
sqt.quote_header_html = Session["quote_head"].ToString();
}
if (Session["quote_body"] != null)
{
sqt.body_html = Session["quote_body"].ToString();
}
if (Session["quote_foot"] != null)
{
sqt.quote_footer_html = Session["quote_foot"].ToString();
}
if (Session["page_foot"] != null)
{
sqt.page_footer_html = Session["page_foot"].ToString();
}
if (Session["page_appendix"] != null)
{
sqt.quote_footer_notes = Session["page_appendix"].ToString();
}
//if (Session["copy"] != null)
//{
// string name = Session["copy"].ToString();
// Session.Remove("copy");
// //保存副本
// //sqt.id = (int)(_dal.GetNextIdCom());
// sqt.is_system = 0;
// sqt.is_default = 0;
// sqt.name = name+sqt.name+Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
// var result = qtbll.Add(sqt, GetLoginUserId(), out id);
// if (result == ERROR_CODE.SUCCESS) //
// {
// //id 获取副本插入时的id
// Response.Write("<script>alert('报价模板副本成功添加成功！');</script>"); // 刷新页面
// }
// else if (result == ERROR_CODE.USER_NOT_FIND) // 用户丢失
// {
// Response.Write("<script>alert('查询不到用户，请重新登陆');</script>");
// Response.Redirect("Login.aspx");
// }
//}
//else
//{
//更新保存
var result = qtbll.update(sqt, GetLoginUserId());
if (result == ERROR_CODE.SUCCESS) // 更新用户成功，刷新前一个页面
{
Response.Write("<script>alert('报价模板修改成功！');</script>"); // 关闭添加页面的同时，刷新父页面
}
else if (result == ERROR_CODE.USER_NOT_FIND) // 用户丢失
{
Response.Write("<script>alert('查询不到用户，请重新登陆');</script>");
Response.Redirect("Login.aspx");
}
//}
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
op = Request.QueryString["op"];
switch (op)
{
case "head": opop = "页眉"; break;
case "top": opop = "头部"; break;
case "foot": opop = "页脚"; break;
case "appendix": opop = "附录"; break;
}
if (!IsPostBack)
{
tempinfo = Session["tempinfo"] as InvioceTempDto.TempContent;
if (tempinfo != null && tempinfo.id == id)
{
switch (op)
{
case "head":
if (!string.IsNullOrEmpty(tempinfo.head))
{
head = HttpUtility.HtmlDecode(tempinfo.head).Replace("\"", "'");
}
; break;
case "top": if (!string.IsNullOrEmpty(tempinfo.top))
{
head = HttpUtility.HtmlDecode(tempinfo.top).Replace("\"", "'");
}
; break;
case "foot":
if (!string.IsNullOrEmpty(tempinfo.foot))
{
head = HttpUtility.HtmlDecode(tempinfo.foot).Replace("\"", "'");
}
; break;
case "appendix":
if (!string.IsNullOrEmpty(tempinfo.foot_note))
{
head = HttpUtility.HtmlDecode(tempinfo.foot).Replace("\"", "'");
}
; break;
}
}
this.AlertVariableFilter.DataTextField = "show";
this.AlertVariableFilter.DataValueField = "val";
this.AlertVariableFilter.DataSource = new QuoteTemplateBLL().GetInvoiceVariableField();
this.AlertVariableFilter.DataBind();
this.AlertVariableFilter.Items.Insert(0, new ListItem()
{
Value = "0", Text = "显示全部变量", Selected = true
});
var list = new QuoteTemplateBLL().GetAllInvoiceVariable();
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();
}
}
