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
}
}