123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273 |
- /*******************************************************************************
- * 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>" : "显示";
- }
- }
- }
|