using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using HySoft.Common; namespace HySoft.BaseCallCenter.Web.sysmanage { public partial class basedataedit : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hfAddFlage.Value = Request.QueryString["Flasge"].ToString(); if (Request.QueryString["Flasge"].ToString() == "AddData") { getDataType(); } if (Request.QueryString["Flasge"].ToString() == "Edit") { getDataTypeEdit(); } if (Request.QueryString["Flasge"].ToString() == "EditGrid") { getDataGridEdit(); } } } private void getDataGridEdit() { if (!string.IsNullOrEmpty(Request.QueryString["ClickSingId"])) { DataTable dt = DBUtility.DbHelperSQL.Query("select * from T_Sys_DictionaryValue where F_DictionaryValueId='" + Request.QueryString["ClickSingId"].ToString() + "'").Tables[0]; if (dt.Rows.Count > 0) { DataTable dt1 = DBUtility.DbHelperSQL.Query("select * from T_Sys_DictionaryBase where F_DictionaryFlag='" + dt.Rows[0]["F_DictionaryFlag"].ToString() + "'").Tables[0]; if (dt1.Rows.Count > 0) { txtDictionaryFlag.Text = dt1.Rows[0]["F_DictionaryFlag"].ToString(); txtDictionaryName.Text = dt1.Rows[0]["F_DictionaryName"].ToString(); } txtValueCode.Text = dt.Rows[0]["F_ValueCode"].ToString(); txtName.Text = dt.Rows[0]["F_Name"].ToString(); txtSort.Text = dt.Rows[0]["F_Sort"].ToString(); txtId.Value = dt.Rows[0]["F_DictionaryValueId"].ToString(); } } } /// /// 修改类型的时候的初始化方法 /// private void getDataTypeEdit() { if (!string.IsNullOrEmpty(Request.QueryString["NodeidEdit"])) { DataTable dt = DBUtility.DbHelperSQL.Query("select * from T_Sys_DictionaryBase where F_DictionaryFlag='" + Request.QueryString["NodeidEdit"].ToString() + "'").Tables[0]; if (dt.Rows.Count > 0) { txtDictionaryFlag.Text = dt.Rows[0]["F_DictionaryFlag"].ToString(); txtDictionaryName.Text = dt.Rows[0]["F_DictionaryName"].ToString(); txtSort.Text = dt.Rows[0]["F_Sort"].ToString(); } } } /// /// 初始化数据类型 /// private void getDataType() { if(!string.IsNullOrEmpty(Request.QueryString["Nodeid"])){ DataTable dt= DBUtility.DbHelperSQL.Query("select * from T_Sys_DictionaryBase where F_DictionaryFlag='" + Request.QueryString["Nodeid"].ToString() + "'").Tables[0]; if (dt.Rows.Count > 0) { txtDictionaryFlag.Text = dt.Rows[0]["F_DictionaryFlag"].ToString(); txtDictionaryName.Text = dt.Rows[0]["F_DictionaryName"].ToString(); } } } protected void btnSubmit_Click(object sender, EventArgs e) { int res = 0; bool relut = false; try{ HySoft.BaseCallCenter.Model.T_Sys_DictionaryBase dictionaryBaseModel = new Model.T_Sys_DictionaryBase(); HySoft.BaseCallCenter.BLL.T_Sys_DictionaryBase dictionaryBaseBll = new BLL.T_Sys_DictionaryBase(); HySoft.BaseCallCenter.Model.T_Sys_DictionaryValue dictionaryValueModel = new Model.T_Sys_DictionaryValue(); HySoft.BaseCallCenter.BLL.T_Sys_DictionaryValue dictionaryValueBll = new BLL.T_Sys_DictionaryValue(); if (Request.QueryString["Flasge"].ToString() == "Add" || Request.QueryString["Flasge"].ToString() == "AddData") { if (Request.QueryString["Flasge"].ToString() == "Add") { DataTable dt = DBUtility.DbHelperSQL.Query("select * from T_Sys_DictionaryBase where F_DictionaryFlag='" + txtDictionaryFlag.Text + "'").Tables[0]; if (dt.Rows.Count > 0) { MessageBoxToWindow("当前标识名称存在,请更换!", "提示", "error"); } else { if (string.IsNullOrEmpty(txtDictionaryFlag.Text) || string.IsNullOrEmpty(txtDictionaryName.Text)) { MessageBoxToWindow("当前有为空信息,请填写!", "提示", "error"); }else{ dictionaryBaseModel.F_DictionaryFlag = txtDictionaryFlag.Text; dictionaryBaseModel.F_DictionaryName = txtDictionaryName.Text; if (!string.IsNullOrEmpty(txtSort.Text)) { dictionaryBaseModel.F_Sort = Convert.ToInt32(txtSort.Text); } dictionaryBaseModel.F_State = "0"; dictionaryBaseModel.F_Describe = "ZH"; //res = dictionaryBaseBll.Add(dictionaryBaseModel); } } } if (Request.QueryString["Flasge"].ToString() == "AddData") { if (string.IsNullOrEmpty(txtValueCode.Text) || string.IsNullOrEmpty(txtName.Text)) { MessageBoxToWindow("当前有为空信息,请填写!", "提示", "error"); } else { dictionaryValueModel.F_DictionaryFlag = txtDictionaryFlag.Text; dictionaryValueModel.F_ValueCode = txtValueCode.Text; dictionaryValueModel.F_Name = txtName.Text; dictionaryValueModel.F_State = "0"; if (!string.IsNullOrEmpty(txtSort.Text)) { dictionaryValueModel.F_Sort = Convert.ToInt32(txtSort.Text); } res = dictionaryValueBll.Add(dictionaryValueModel); } } if (res > 0) { MessageBoxToWindow("新增成功", "新增提示", "success"); } else { MessageBoxToWindow("新增失败", "新增提示!", "error"); } } #region 修改信息 if (Request.QueryString["Flasge"].ToString() == "Edit" || Request.QueryString["Flasge"].ToString() == "EditGrid") { if (Request.QueryString["Flasge"].ToString() == "Edit") { dictionaryBaseModel.F_DictionaryFlag = txtDictionaryFlag.Text; dictionaryBaseModel.F_DictionaryName = txtDictionaryName.Text; dictionaryBaseModel.F_State = "0"; dictionaryBaseModel.F_Describe = "ZH"; if (!string.IsNullOrEmpty(txtSort.Text)) { dictionaryBaseModel.F_Sort = Convert.ToInt32(txtSort.Text); } relut = dictionaryBaseBll.Update(dictionaryBaseModel); } if (Request.QueryString["Flasge"].ToString() == "EditGrid") { dictionaryValueModel.F_DictionaryFlag = txtDictionaryFlag.Text; dictionaryValueModel.F_ValueCode = txtValueCode.Text; dictionaryValueModel.F_Name = txtName.Text; dictionaryValueModel.F_State = "0"; if (!string.IsNullOrEmpty(txtSort.Text)) { dictionaryValueModel.F_Sort = Convert.ToInt32(txtSort.Text); } dictionaryValueModel.F_DictionaryValueId = Convert.ToInt32(txtId.Value); relut = dictionaryValueBll.Update(dictionaryValueModel); } if (relut) { MessageBoxToWindow("修改成功", "修改提示", "success"); } else { MessageBoxToWindow("修改失败", "修改提示!", "error"); } } #endregion } catch(Exception ex){ SysLog.WriteLog(ex); MessageBoxToWindow("异常提示!" + ex.Message, "提示", "catch"); } } #region 弹出对话框 /// /// 弹出对话框 /// /// /// /// public void MessageBoxToWindow(string title, string content, string type) { string script = ""; switch (type) { case "error"://失败 type = "error"; script = ""; break; case "success"://成功 type = "info"; script = ""; break; case "catch"://异常 type = "warning"; script = ""; break; default: type = "question"; break; } ClientScript.RegisterClientScriptBlock(this.GetType(), "", script); } #endregion } }