/// <summary>
/// 绑定父级模块的下拉列表
/// </summary>
private void BindDDL()
{
DataSet ds = common.GetList(" select id, menuName from tb_sys_sysmenu ");
Tools.WebControl.BindList(this.ddlParentMD, ds.Tables[0], "menuName", "Id");
this.ddlParentMD.Items.Insert(0, new ListItem("——请选中——", "-1"));
}
/// <summary>
/// 获得所有大类菜单
/// </summary>
private void DataBind_CheckBoxList()
{
DataTable dt = common.GetList("select id,menuName from tb_sys_sysmenu").Tables[0];
rpt_RoleList.DataSource = dt.DefaultView;
rpt_RoleList.DataBind();
}
private void BindProvince()
{
string strb = " select CapitalName,DomainID from tb_sys_capital ";
DataSet ds = common.GetList(strb.ToString());
Tools.WebControl.BindList(this.ddlProcince, ds.Tables[0], "CapitalName", "DomainID");
this.ddlProcince.Items.Insert(0, new ListItem("——请选中——", "-1"));
}
/// <summary>
/// 绑定角色类型
/// </summary>
private void BindRole()
{
System.Text.StringBuilder strb = new System.Text.StringBuilder(" select id,roleName FROM tb_sys_role ");
if (adminGetadminTag != Test_BUL.sysParam.AdministratorTagH)
{
strb.Append(" where roleName!='超级管理员' ");
}
DataSet ds = common.GetList(strb.ToString());
Tools.WebControl.BindList(this.ddlRole, ds.Tables[0], "roleName", "id");
this.ddlRole.Items.Insert(0, new ListItem("——请选中——", "-1"));
}
/// <summary>
/// 加载用户菜单
/// </summary>
/// <param name="ds">系统所有菜单</param>
/// <param name="FileItems">用户权限页面id集合</param>
/// <returns></returns>
public string GetSystemMenu(DataSet ds, string FileItems)
{
if (ds == null || string.IsNullOrEmpty(FileItems))
{
return("");
}
StringBuilder strbu = new StringBuilder("");
int tempCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < tempCount; i++)
{
Test_BUL.sys_Common common = new sys_Common();
DataSet tempChildDs = common.GetList(" select * from tb_sys_sysfiles where id in(" + FileItems + ") and showLeft=1 and ClassId=" + ds.Tables[0].Rows[i]["id"].ToString());
if (sysCheck.CheckDataSet(tempChildDs, 0))
{
strbu.Append(" <dl> ");//start nod
strbu.Append(" <dt><span style=\"background-image: url("
+ ds.Tables[0].Rows[i]["imgUrl"].ToString() + ");\">"
+ ds.Tables[0].Rows[i]["menuName"].ToString() + "</span></dt> ");
strbu.Append(" <dd class=\"hide\"><ul> ");
for (int j = 0; j < tempChildDs.Tables[0].Rows.Count; j++)//add Child Node
{
strbu.Append(" <li><a href=\"./" + tempChildDs.Tables[0].Rows[j]["filesUrl"].ToString()
+ "\" target=\"main_iframe\" >" + tempChildDs.Tables[0].Rows[j]["fielsName"].ToString() + "</a></li> ");
}
strbu.Append(" </ul></dd> ");
strbu.Append(" </dl> ");//end nod
}
}
return(strbu.ToString());
}
protected void btnSend_Click(object sender, EventArgs e)
{
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet ds = common.GetList(" select menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' ");
if (!Tools.Validator.CheckDataSet(ds, 0))
{
Test_Model.sys_sysmenu sysmenuModel = new Test_Model.sys_sysmenu();
sysmenuModel.menuName = this.txtMenuName.Value.Trim();
string imgUrl = this.txtMenuImg.Value.Trim();
sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif";
sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim());
sysmenuModel.addName = adminGetCount;
sysmenuModel.addTime = DateTime.Now;
Test_BUL.sys_sysmenu sysmenu = new Test_BUL.sys_sysmenu();
if (sysmenu.Add(sysmenuModel) > 0)
{
Response.Redirect("Manage_Menu.aspx");
}
else
{
FinalMessage("新增用户失败！", "Add_Menu.aspx", 1);
}
}
}
/// <summary>
/// 加载用户菜单
/// </summary>
/// <param name="ds">系统所有菜单</param>
/// <param name="FileItems">用户权限页面id集合</param>
/// <returns></returns>
public string GetSystemMenu(DataSet ds, string FileItems)
{
if (ds == null || string.IsNullOrEmpty(FileItems))
return "";
StringBuilder strbu = new StringBuilder("");
int tempCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < tempCount; i++)
{
Test_BUL.sys_Common common = new sys_Common();
DataSet tempChildDs = common.GetList(" select * from tb_sys_sysfiles where id in(" + FileItems + ") and showLeft=1 and ClassId=" + ds.Tables[0].Rows[i]["id"].ToString());
if (sysCheck.CheckDataSet(tempChildDs, 0))
{
strbu.Append(" <dl> ");//start nod
strbu.Append(" <dt><span style=\"background-image: url("
+ ds.Tables[0].Rows[i]["imgUrl"].ToString() + ");\">"
+ ds.Tables[0].Rows[i]["menuName"].ToString() + "</span></dt> ");
strbu.Append(" <dd class=\"hide\"><ul> ");
for (int j = 0; j < tempChildDs.Tables[0].Rows.Count; j++)//add Child Node
{
strbu.Append(" <li><a href=\"./" + tempChildDs.Tables[0].Rows[j]["filesUrl"].ToString()
+ "\" target=\"main_iframe\" >" + tempChildDs.Tables[0].Rows[j]["fielsName"].ToString() + "</a></li> ");
}
strbu.Append(" </ul></dd> ");
strbu.Append(" </dl> ");//end nod
}
}
return strbu.ToString();
}
private void BindProvince()
{
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
string strb = " select CapitalName,DomainID from tb_sys_capital ";
DataSet ds = common.GetList(strb.ToString());
Tools.WebControl.BindList(this.ddlProcince, ds.Tables[0], "CapitalName", "DomainID");
this.ddlProcince.Items.Insert(0, new ListItem("——请选中——", "-1"));
}
/// <summary>
/// 绑定城市
/// </summary>
private void BindProvince()
{
DataSet ds;
if (Tools.CacheUtil.IsExist(Test_BUL.sysParam.CacheCapital_info))
{
ds = (DataSet)Tools.CacheUtil.GetCache(Test_BUL.sysParam.CacheCapital_info);
}
else
{
string strb = " select CapitalName,DomainID from tb_sys_capital ";
ds = common.GetList(strb.ToString());
Tools.CacheUtil.InsertCach(Test_BUL.sysParam.CacheCapital_info, (object)ds, 60 * 60, 2);
}
Tools.WebControl.BindList(this.ddlProcince, ds.Tables[0], "CapitalName", "DomainID");
this.ddlProcince.Items.Insert(0, new ListItem("——请选中——", "-1"));
}
/// <summary>
/// 更新数据
/// </summary>
protected void btnCon_Click(object sender, EventArgs e)
{
string _name = this.txtName.Value.Trim();
string _value = this.txtValue.Value.Trim();
string _typetag = this.txtTypeTag.Value.Trim();
if (string.IsNullOrEmpty(_name) || string.IsNullOrEmpty(_typetag))
{
FinalMessage("请确认所填信息的完整性", "Add_SysParam.aspx", 1);
}
if (Tools.RequestCheck.CheckKeyWord(_name) || Tools.RequestCheck.CheckKeyWord(_typetag))
{
FinalMessage("参数名或类型标记含有非法字符", "Add_SysParam.aspx", 1);
}
if (!Tools.Validator.IsPositiveInt(_value))
{
FinalMessage("参数值应为正整数", "Add_SysParam.aspx", 1);
}
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet temds = common.GetList(" select id, name from tb_sys_paramcenter where name='" + (this.txtName.Value) + "' and typeTag='" + (this.txtTypeTag.Value) + "' ");
if (Tools.Validator.CheckDataSet(temds, 0))
{
if (temds.Tables[0].Rows.Count > 1)
{
FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1);
}
else if (temds.Tables[0].Rows[0]["id"].ToString() != ID)
{
FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1);
}
}
modelparma.id = Tools.StringHelp.GetInt(ID);
modelparma.name = _name;
modelparma.value = Tools.StringHelp.GetInt(_value);
modelparma.typeTag = Tools.StringHelp.CutStirngNormal(_typetag, 10, 0);
modelparma.addUserId = Tools.StringHelp.GetInt(adminGetId);
modelparma.addUserName = adminGetCount;
modelparma.addTime = DateTime.Now;
if (bulparam.Update(modelparma))
{
Response.Redirect("Manage_SysParam.aspx?p=" + p);
}
else
{
FinalMessage("保存失败", "Add_SysParam.aspx", 1);
}
}
/// <summary>
/// 获取菜单HTML
/// </summary>
private void LoadMenu()
{
//重新获取用户权限页面id集合，并写入缓存
DataSet SysAdminDS = common.GetList(" select pageId from tb_sys_role where id=" + adminGetRoleId);
Tools.CacheUtil.InsertCach(Test_BUL.sysParam.CachePageIdDs, (object)SysAdminDS, Test_BUL.sysParam.CachePageIdDsTimes, 2);
string FileItems = SysAdminDS.Tables[0].Rows[0]["pageId"].ToString();//1,2,3,4,5,6,7,8,9...
if (string.IsNullOrEmpty(FileItems))
{
return;
}
//获取所有系统菜单
DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc ");
if (Tools.Validator.CheckDataSet(ds, 0))
{
Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu();
_response = bulMenu.GetSystemMenu(ds, FileItems);
}
}
/// <summary>
/// 获取菜单HTML
/// </summary>
/// <returns></returns>
private string GetMenuHTML()
{
if (string.IsNullOrEmpty(FileItems))
return "";
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc ");
if (Tools.Validator.CheckDataSet(ds, 0))
{
Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu();
return bulMenu.GetSystemMenu(ds, FileItems);
}
return "";
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (!Tools.Validator.IsPositiveInt(q("menuId")) || Tools.RequestCheck.CheckKeyWord(q("menuId")))
{
FinalMessage("UTL解析错误，请勿在Url中添加非法关键词！", "Manage_Menu.aspx", 1);
}
sysmenuModel.menuName = this.txtMenuName.Value.Trim();
string imgUrl = this.txtMenuImg.Value.Trim();
sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif";
sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim());
sysmenuModel.addName = adminGetCount;
sysmenuModel.addTime = DateTime.Now;
sysmenuModel.id = int.Parse(q("menuId"));
DataSet ds = common.GetList(" select id, menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' ");
if (!Tools.Validator.CheckDataSet(ds, 0))
{
if (sysmenu.Update(sysmenuModel))
{
Response.Redirect("Manage_Menu.aspx");
}
else
{
FinalMessage("保存失败！", "Manage_Menu.aspx", 1);
}
}
else
{
if (ds.Tables[0].Rows[0]["id"].ToString() == q("menuId"))
{
if (sysmenu.Update(sysmenuModel))
{
Response.Redirect("Manage_Menu.aspx");
}
else
{
FinalMessage("保存失败！", "Manage_Menu.aspx", 1);
}
}
else
{
FinalMessage("此菜单模块已经存在！", "Manage_Menu.aspx", 1);
}
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void DataBind_role()
{
DataSet ds = common.GetList(" select id,roleName,addUser,addTime FROM tb_sys_role ");
if (Tools.Validator.CheckDataSet(ds, 0))
{
ds.Tables[0].Columns.Add("number");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["number"] = (i + 1).ToString();
}
this.rpt_roleList.DataSource = ds.Tables[0].DefaultView;
this.rpt_roleList.DataBind();
}
}
/// <summary>
/// 获取菜单HTML
/// </summary>
/// <returns></returns>
private string GetMenuHTML()
{
if (string.IsNullOrEmpty(FileItems))
{
return("");
}
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc ");
if (Tools.Validator.CheckDataSet(ds, 0))
{
Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu();
return(bulMenu.GetSystemMenu(ds, FileItems));
}
return("");
}
protected void btnSend_Click(object sender, EventArgs e)
{
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet ds = common.GetList(" select menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' ");
if (!Tools.Validator.CheckDataSet(ds, 0))
{
Test_Model.sys_sysmenu sysmenuModel = new Test_Model.sys_sysmenu();
sysmenuModel.menuName = this.txtMenuName.Value.Trim();
string imgUrl = this.txtMenuImg.Value.Trim();
sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif";
sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim());
sysmenuModel.addName = adminGetCount;
sysmenuModel.addTime = DateTime.Now;
Test_BUL.sys_sysmenu sysmenu = new Test_BUL.sys_sysmenu();
if (sysmenu.Add(sysmenuModel) > 0)
Response.Redirect("Manage_Menu.aspx");
else
FinalMessage("新增用户失败！", "Add_Menu.aspx", 1);
}
}
/// <summary>
/// 更新数据
/// </summary>
protected void btnCon_Click(object sender, EventArgs e)
{
string _name = this.txtName.Value.Trim();
string _value = this.txtValue.Value.Trim();
string _typetag = this.txtTypeTag.Value.Trim();
if (string.IsNullOrEmpty(_name) || string.IsNullOrEmpty(_typetag))
FinalMessage("请确认所填信息的完整性", "Add_SysParam.aspx", 1);
if (Tools.RequestCheck.CheckKeyWord(_name) || Tools.RequestCheck.CheckKeyWord(_typetag))
FinalMessage("参数名或类型标记含有非法字符", "Add_SysParam.aspx", 1);
if (!Tools.Validator.IsPositiveInt(_value))
FinalMessage("参数值应为正整数", "Add_SysParam.aspx", 1);
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet temds = common.GetList(" select id, name from tb_sys_paramcenter where name='" + (this.txtName.Value) + "' and typeTag='" + (this.txtTypeTag.Value) + "' ");
if (Tools.Validator.CheckDataSet(temds, 0))
{
if (temds.Tables[0].Rows.Count > 1)
FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1);
else if (temds.Tables[0].Rows[0]["id"].ToString() != ID)
FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1);
}
modelparma.id = Tools.StringHelp.GetInt(ID);
modelparma.name = _name;
modelparma.value = Tools.StringHelp.GetInt(_value);
modelparma.typeTag = Tools.StringHelp.CutStirngNormal(_typetag, 10, 0);
modelparma.addUserId = Tools.StringHelp.GetInt(adminGetId);
modelparma.addUserName = adminGetCount;
modelparma.addTime = DateTime.Now;
if (bulparam.Update(modelparma))
Response.Redirect("Manage_SysParam.aspx?p=" + p);
else
FinalMessage("保存失败", "Add_SysParam.aspx", 1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (CheckAdminLogin())
{
return;//已经登录过了
}
string validate = StringHelp.FilterSymbolStr(q("validate"));
if (string.IsNullOrEmpty(validate))
{
return; //参数丢失;
}
if (string.Compare(validate, Session["LVNum"].ToString(), true) == 0) //不区分大小写比较验证码
{
string count = q("paramName");
string pwd = q("paramPwd");
if (string.IsNullOrEmpty(count) || string.IsNullOrEmpty(pwd))
{
Response.Write("1|" + Test_BUL.sysParam.ErrorPageTip("1"));
}
if (RequestCheck.CheckKeyWord(count) || RequestCheck.CheckKeyWord(pwd))
{
Response.Write("3|" + Test_BUL.sysParam.ErrorPageTip("3"));
}
else
{
string strsql = common.GetCustomDSsql("tb_sys_admin", "id,count,password,loginIP,loginTime,telephone,email,sex,birthday,createTime,roleid,adminTag,AccountState,PowerLeave ", " count='" + count + "' ");
DataSet ds = common.GetList(strsql);
if (Tools.Validator.CheckDataSet(ds, 0))
{
if (ds.Tables[0].Rows[0]["password"].ToString() == EncryptAdmin(pwd))
{
string state = ds.Tables[0].Rows[0]["AccountState"].ToString();
//账号状态：10正常，20冻结，30禁用
if (state == "20")
{
Response.Write("20|" + Test_BUL.sysParam.ErrorPageTip("11"));
}
else if (state == "30")
{
Response.Write("30|" + Test_BUL.sysParam.ErrorPageTip("12"));
}
else
{
string tempRoleId = ds.Tables[0].Rows[0]["roleid"].ToString();
string tempAdminTag = ds.Tables[0].Rows[0]["adminTag"].ToString();
if (string.IsNullOrEmpty(tempRoleId) || state != "10" || string.IsNullOrEmpty(tempAdminTag))
{
Response.Write("14|" + Test_BUL.sysParam.ErrorPageTip("14"));
}
else
{
SetUserCookie(ds.Tables[0]); //用户信息写入Cookies
Test_BUL.sys_admin blladmin = new Test_BUL.sys_admin(); //更新登录IP和登录时间
blladmin.UpdateLogin(count, Tools.IPHelp.ClientIP, DateTime.Now);
Response.Write("10|" + Test_BUL.sysParam.ErrorPageTip("10"));
}
}
}
else
{
Response.Write("9|" + Test_BUL.sysParam.ErrorPageTip("9"));
}
}
else
{
Response.Write("8|" + Test_BUL.sysParam.ErrorPageTip("8"));
}
}
}
else
{
Response.Write("15|" + Test_BUL.sysParam.ErrorPageTip("15"));
}
}