/*******************************************************************************
* iNethinkCMS - 网站内容管理系统
* Copyright (C) 2012-2013 inethink.com
*
* @author jackyang <69991000@qq.com>
* @website http://cms.inethink.com
* @version 1.3.6.0 (2013-08-14)
*
* This is licensed under the GNU LGPL, version 3.0 or later.
* For details, see: http://www.gnu.org/licenses/gpl-3.0.html
*******************************************************************************/
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using iNethinkCMS.Command;
using iNethinkCMS.Web.UI;
namespace iNethinkCMS.Web.admin.extend
{
public partial class extend_dict : Admin_BasePage
{
iNethinkCMS.BLL.BLL_iNethinkCMS_Dict bll = new iNethinkCMS.BLL.BLL_iNethinkCMS_Dict();
iNethinkCMS.Model.Model_iNethinkCMS_Dict model = new iNethinkCMS.Model.Model_iNethinkCMS_Dict();
private string vNavInfo = "当前位置：";
private string vAct = "";
private int vPage = 1;
private int vID = 0;
private string vSQL = "";
private string vKeyType = "";
private string vKey = "";
private int vDictType;
private string vDictName;
private int vDisplay;
private int vOrderNum;
protected void Page_Load(object sender, EventArgs e)
{
CheckUserPower("c");
#region
vAct = Request.QueryString["Act"] != null ? Request.QueryString["Act"] : "";
if (Request.QueryString["Page"] != null && Request.QueryString["Page"].Trim() != "")
{
if (!int.TryParse(Request.QueryString["Page"], out vPage))
{
vPage = 1;
}
}
vKeyType = Request.QueryString["sKeyType"] != null ? Request.QueryString["sKeyType"] : "";
vKey = Request.QueryString["sKey"] != null ? Request.QueryString["sKey"] : "";
vKey = vKey.Replace("'", "");
if (Request.QueryString["ID"] != null && Request.QueryString["ID"].Trim() != "")
{
if (!int.TryParse(Request.QueryString["ID"], out vID))
{
Response.Write("ID Error");
Response.End();
}
}
if (vKey.Length > 0)
{
if (vKeyType == "ID")
{
if (iNethinkCMS.Command.Command_Validate.IsNumber(vKey) == true)
{
vSQL += vKeyType + " = " + vKey + "";
}
else
{
vKey = "";
}
}
else
{
vSQL += vKeyType + " Like '%" + vKey + "%'";
}
}
#endregion
this.mainID.Visible = false;
this.guideID.Visible = false;
switch (vAct)
{
case "guide":
this.guideID.Visible = true;
if (vID == 0)
{
this.navInfoID.InnerText = vNavInfo + "数据字典添加";
this.Button_Submit.Click += new EventHandler(Button_Submit_Click_Add);
}
else
{
this.navInfoID.InnerText = vNavInfo + "数据字典修改";
this.Button_Submit.Click += new EventHandler(Button_Submit_Click_Edit);
}
if (!IsPostBack)
{
if (Request.UrlReferrer != null)
{
ViewState["reJumpUrl"] = Request.UrlReferrer.AbsoluteUri;
}
Fun_SetValue(vID); //获取frm基本信息
}
break;
case "delete":
Fun_Delete(vID);
break;
default:
this.navInfoID.InnerText = vNavInfo + "数据字典管理";
this.mainID.Visible = true;
if (!IsPostBack)
{
this.sKeyType.SelectedValue = vKeyType;
this.sKey.Text = vKey;
}
PageListInfo();
break;
}
}
#region mainID 列表
protected void PageListInfo()
{
int vPageSize = int.Parse(siteConfig.PageListNum);
int vRecordCount = bll.GetRecordCount(vSQL);
Repeater.DataSource = bll.GetListByPage(vSQL, "ID Desc", (vPage - 1) * vPageSize, vPage * vPageSize);
Repeater.DataBind();
string pTemp = "";
int vPageCount = 1;
if (vRecordCount > 0)
{
vPageCount = (int)Math.Ceiling((double)vRecordCount / (double)vPageSize);
pTemp = WebUI_PageList.GetPagingInfo_Manage(vPageCount, vRecordCount, vPage, vPageSize);
}
this.pagelist.InnerHtml = pTemp;
this.iNoInfo.Visible = vRecordCount == 0 ? true : false;
}
protected void Button_Search_Click(object sender, EventArgs e)
{
Response.Redirect(Request.Path + "?skeytype=" + this.sKeyType.SelectedValue + "&skey=" + this.sKey.Text);
}
#endregion
#region guideID 信息修改/添加
private void Fun_SetValue(int byID)
{
if (byID == 0)
{
//this.txtDictType.SelectedValue = "0";
this.txtDictName.Text = "";
this.txtDisplay.Checked = true;
this.txtOrderNum.Text = "0";
}
else
{
this.txtDictName.ReadOnly = true;
model = bll.GetModel(byID);
this.txtDictType.SelectedValue = model.DictType.ToString();
this.txtDictName.Text = model.DictName;
this.txtDisplay.Checked = model.Display == 1 ? true : false;
this.txtOrderNum.Text = model.OrderNum.ToString();
}
}
private bool Fun_GetValue()
{
if (this.txtDictType.Text.Trim().Length == 0)
{
MessageBox.Show(this, "请选择相应的字典类型!");
return false;
}
if (this.txtDictName.Text.Trim().Length == 0)
{
MessageBox.Show(this, "请输入字典名称!");
return false;
}
if (!Command_Validate.IsNumber(this.txtOrderNum.Text.Trim()))
{
MessageBox.Show(this, "排序权重只能输入数字!");
return false;
}
vDictType = int.Parse(this.txtDictType.SelectedValue);
vDictName = this.txtDictName.Text.Trim();
vDisplay = this.txtDisplay.Checked == true ? 1 : 0;
vOrderNum = int.Parse(this.txtOrderNum.Text.Trim());
return true;
}
protected void Button_Submit_Click_Add(object sender, EventArgs e)
{
if (Fun_GetValue() == true)
{
if (bll.GetRecordCount("DictType = " + vDictType + " And DictName = '" + vDictName + "'") > 0)
{
MessageBox.Show(this, "字典类型[" + this.txtDictType.Text + "]中的字典名称 [" + vDictName + "] 已经存在!");
return;
}
model.DictType = vDictType;
model.DictName = vDictName;
model.Display = vDisplay;
model.OrderNum = vOrderNum;
bll.Add(model);
Response.Redirect(Request.Path);
}
}
protected void Button_Submit_Click_Edit(object sender, EventArgs e)
{
if (Fun_GetValue() == true)
{
if (bll.GetRecordCount("ID = " + vID) == 0) //判断该ID是否被删除
{
MessageBox.ShowAndRedirect(this, "你所需要更新的记录 [" + vID + "] 不存在!", ViewState["reJumpUrl"].ToString());
return;
}
if (bll.GetRecordCount("ID <> " + vID + " And DictType = " + vDictType + " And DictName = '" + vDictName + "'") > 0)
{
MessageBox.Show(this, "字典类型[" + this.txtDictType.Text + "]中的字典名称 [" + vDictName + "] 已经存在!");
return;
}
model.ID = vID;
model.DictType = vDictType;
model.DictName = vDictName;
model.Display = vDisplay;
model.OrderNum = vOrderNum;
bll.Update(model);
Response.Redirect(ViewState["reJumpUrl"].ToString());
}
}
#endregion
#region Delete 数据删除
protected void Fun_Delete(int byID)
{
if (bll.Delete(byID) == true)
{
Response.Redirect(Request.UrlReferrer.AbsoluteUri);
}
}
#endregion
protected string Fun_DisplayInfo(object byDisplay)
{
return byDisplay.ToString() == "0" ? "<font color=\"#ff0000\">不显示</font>" : "显示";
}
}
}