using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using GThinking.N_MISPRO; using GThinking.N_MISPRO.Data; using GThinking.N_MODEL.Page; using GThinking.N_MISPRO.Utility; using GThinking.N_PUBLIC; using System.Collections.Generic; namespace GThinking.N_XLXSBJ { public partial class JGBML_YJFZInfo : SingleCardBase { [TableMap(DB = "DBERP", DbTableName = "XLXSBJD", Umid = 100860000, IsWorkFlow = false, IsAttach = false, UseWhr = false)] public class JGBML_YJFZ : EntityManager { } JGBML_YJFZ entity = new JGBML_YJFZ(); protected void Page_Load(object sender, EventArgs e) { this.UMID = 100860018; this.UMName = "线缆销售报价价格目录"; this.CurMaster = Master; this.CurEntity = entity; this.PageHeight = 180; this.PageWidth = 420; Master.EnableAttachBtn = false; Master.EnableCancelBtn = false; Master.EnableCopyBtn = false; Master.EnableDeleteBtn = false; Master.EnableEditBtn = false; Master.EnableInsertBtn = false; Master.EnablePrintBtn = false; Master.EnableRefreshBtn = false; Master.EnableSaveBtn = false; base.InitPage(); if (!IsPostBack) { InitControl(); } } private void InitControl() { txtTJ.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal; txtLJ.DecimalPlaces = XLBJDUtils.BJCLPriceDecimal; txtTJ.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("TJ")); txtLJ.Value = CMISproConvert.StrToFloat(PageParam.GetRTrimString("LJ")); trJLDW1.Visible = false; trJLDW2.Visible = false; trJLDW3.Visible = false; if (PageParam.ContainsKey("FromJGBMX")) { this.Title = "调整计量单位"; cbxTZFW.ClearItems(); if (PageParam.GetRTrimString("PLSZAll").Equals("N")) cbxTZFW.Items.Add(new ListItem("勾选记录", "N")); else cbxTZFW.Items.Add(new ListItem("整单记录", "Y")); if (cbxTZFW.ItemsCount == 1) cbxTZFW.SelectedIndex = 0; cbxJLDW.ClearItems(); cbxJLDW.Items.Add(new ListItem("米", "米")); cbxJLDW.Items.Add(new ListItem("千米", "千米")); cbxJLDW.Items.Add(new ListItem("M", "M")); cbxJLDW.Items.Add(new ListItem("Km", "Km")); cbxJLDW.Items.Add(new ListItem("Kg", "Kg")); cbxJLDW.Items.Add(new ListItem("千克", "千克")); cbxJLDW.Items.Add(new ListItem("公斤", "公斤")); cbxJLDW.Items.Add(new ListItem("吨", "吨")); cbxJLDW.Items.Add(new ListItem("T", "T")); cbxJLDW.SelectedIndex = 0; trJLDW1.Visible = true; trJLDW2.Visible = true; trJLDW3.Visible = true; trYJFZ.Visible = false; } } protected void btnQR_Click(object sender, EventArgs e) { if (PageParam.ContainsKey("FromJGBMX")) { if (cbxJLDW.SelectedValue.Trim().Equals("")) { ShowMessage("计量单位不允许为空!"); return; } string sJGBID = PageParam.GetRTrimString("JGBID"); string sXHList = PageParam.GetRTrimString("XHs"); TDatabase dberp = TContextDatabases.GetDatabase("DBERP"); TSQL SQL = new TSQL(dberp); SQL.Clear(); if (cbxTZFW.SelectedValue.Equals("Y")) { SQL.Add("update XLXSJGBMX set XLXSJGBMX_JLDW=:pJLDW "); SQL.Add(" where XLXSJGBMX_JGBID=:pJGBID "); SQL.ParamByName("pJGBID").Value = sJGBID; SQL.ParamByName("pJLDW").Value = cbxJLDW.SelectedValue.Trim(); } else { SQL.Add("update XLXSJGBMX set XLXSJGBMX_JLDW=:pJLDW "); SQL.Add(" where XLXSJGBMX_JGBID=:pJGBID "); SQL.Add(" and " + CMISproDataBase.GetWhereEqual("XLXSJGBMX_XH", sXHList)); SQL.ParamByName("pJGBID").Value = sJGBID; SQL.ParamByName("pJLDW").Value = cbxJLDW.SelectedValue.Trim(); } dberp.ExecSQL(SQL); ShowMessage("调整成功,若要重新计算价格,请手动同步价格表!"); CloseWindow(); } else { CopyJGBID3Data objOUT = XLBJDUtils.CopyJGBID3(txtTJ.Value, txtLJ.Value, PageParam.GetRTrimString("JGBID"), GetOption(100860001, "BJU002"), "", GetOption(102579000, "XLJGU007")); if (objOUT.Success) { if (string.IsNullOrEmpty(objOUT.ErrorMessage)) ShowMessage("一键复制完成,已生成新价格目录【" + objOUT.NewJGBID + "】"); else ShowMessage("一键复制完成,已生成新价格目录【" + objOUT.NewJGBID + "】" + objOUT.ErrorMessage); CloseWindow(); } else { ShowMessage("一键复制失败:" + objOUT.ErrorMessage); } } } protected void btnQX_Click(object sender, EventArgs e) { CloseWindow(); } } }