/// <summary>
/// 返回单个对象
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public T_AdminUser GetModel(int id)
{
T_AdminUser model = null;
string strSql = string.Format("SELECT [Id],[AdminLogName],[AdminLogPass],[AdminName],[AdminTel],[UnitCode],[AdminType],[AdminState],[AdminLogNum],[IsCheck],[Editor],[CreateDate],[EndDate],roleid FROM [T_AdminUser] where Id = {0}", id);
using (dynamic read = DbHelper.Factory().ExecuteReader(strSql))
{
if (read.Read())
{
model = new T_AdminUser();
model.Id = int.Parse(read["Id"].ToString());
model.AdminLogName = read["AdminLogName"].ToString();
model.AdminLogPass = read["AdminLogPass"].ToString();
model.AdminName = read["AdminName"].ToString();
model.AdminTel = read["AdminTel"].ToString();
model.UnitCode = read["UnitCode"].ToString();
model.AdminType = int.Parse(read["AdminType"].ToString());
model.AdminState = int.Parse(read["AdminState"].ToString());
model.AdminLogNum = int.Parse(read["AdminLogNum"].ToString());
model.IsCheck = int.Parse(read["IsCheck"].ToString());
model.Editor = read["Editor"].ToString();
model.CreateDate = DateTime.Parse(read["CreateDate"].ToString());
model.EndDate = DateTime.Parse(read["EndDate"].ToString());
model.Roleid = read["roleid"].ToString();
}
read.Dispose();
}
return(model);
}
//
public string ProcessRequest(HttpContext context)
{
try { adminUser = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "fun":
returnDate = GetSysFun();
break;
case "aname":
returnDate = GetAdminUserName();
break;
case "emp":
returnDate = GetEliminateUserSession(context);
break;
default:
returnDate = "请求错误!";
break;
}
return(returnDate);
}
/// <summary>
/// 保存用户信息
/// </summary>
/// <param name="user"></param>
public int SaveAccountInfo(T_AdminUser user, string newPwz)
{
if (user.id.Equals(Guid.Empty))
{
user.id = Guid.NewGuid();
using (var dbContext = new IPathDBEntities())
{
user.Pwz = AESHelper.Encrypt(user.Pwz);
dbContext.T_AdminUser.Add(user);
return(dbContext.SaveChanges());
}
}
else
{
using (var dbContext = new IPathDBEntities())
{
dbContext.T_AdminUser.Attach(user);
dbContext.Entry(user).Property("UserName").IsModified = true;
dbContext.Entry(user).Property("PermissionInfo").IsModified = true;
if (!string.IsNullOrEmpty(newPwz))
{
user.Pwz = AESHelper.Encrypt(newPwz);
dbContext.Entry(user).Property("Pwz").IsModified = true;
}
dbContext.Configuration.ValidateOnSaveEnabled = false;
return(dbContext.SaveChanges());
}
}
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "paging":
string str = "\"total\":" + CountNum(context) + ",";
returnDate = JsonHelper <T_News, int> .JsonDataTable(GetAllList(context), "rows").Insert(1, (str));
break;
case "del":
returnDate = Delete(context);
break;
case "add":
returnDate = Create(context);
break;
case "up":
returnDate = Update(context);
break;
case "top":
returnDate = JsonHelper <T_News, int> .JsonDataTable(GetTopPageShow(context));
break;
case "Home":
returnDate = JsonHelper <T_News, int> .JsonDataTable(GetHomeList(context));
break;
case "HomeCount":
returnDate = HomeCount(context);
break;
case "Id":
returnDate = JsonHelper <T_News, int> .JsonWriter(GetById(context));
break;
case "rs":
returnDate = RowsState(context);
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "paging":
returnDate = JsonHelper <T_NewsType, int> .JsonDataTable(GetAllList(context), "rows");
break;
case "tree":
returnDate = GetTree();
break;
case "node":
returnDate = AddNodes(context);
break;
case "list":
returnDate = GetAllList();
break;
case "add":
returnDate = Create(context);
break;
case "up":
returnDate = Update(context);
break;
case "del":
returnDate = Delete(context);
break;
case "id":
returnDate = JsonHelper <T_NewsType, int> .JsonWriter(GetById(context));
break;
case "upid":
string UpId = context.Request.QueryString["UpId"];
string order = " order by TypeLevel";
returnDate = GetAllList(UpId, order);
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
protected void btn_login_Click(object sender, EventArgs e)
{
string checkCode = Session["CheckCode"] as string;
string checkCodeImg = txt_CheckCodeImg.Text;
if (checkCode != null)
{
if (checkCode.ToLower().Equals(checkCodeImg.ToLower()))
{
if (txt_AdminLogName.Text.Trim() != "" || txt_AdminLogPass.Text.Trim() != "")
{
T_AdminUserBll adminUserBll = new T_AdminUserBll();
T_AdminUser AdminUser = adminUserBll.AdminUserLogin(txt_AdminLogName.Text.Trim(), txt_AdminLogPass.Text.Trim());
if (AdminUser.AdminLogName.Equals(txt_AdminLogName.Text.Trim()) || AdminUser.AdminLogPass.Equals(txt_AdminLogPass.Text.Trim()))
{
if (AdminUser.AdminState != 0)
{
AddCookie(AdminUser.Id);
adminUserBll.NumberLogin(AdminUser.Id);
Session["SuperAdminUser"] = AdminUser;
Session["AdminState"] = AdminUser.AdminState;
// Session["unitcode"] = AdminUser.UnitCode;
new T_SysLogBll().Create("登陆", "成功", ComFunction.GetClientIP(), txt_AdminLogName.Text, ComFunction.GetHostName());
Response.Redirect("Main.aspx");
}
else
{
showMessage("管理员账户信息处于禁用状态，请联系上级部门！");
}
}
else
{
showMessage("用户登录失败！请检查用户名和密码是否正确？");
new T_SysLogBll().Create("登陆", "失败", ComFunction.GetClientIP(), txt_AdminLogName.Text, ComFunction.GetHostName());
}
}
else
{
showMessage("用户名和密码不能为空！");
}
}
else
{
showMessage("验证码错误，请重新输入验证码！");
}
}
else
{
showMessage("登录超时请刷新页面重新登录！");
}
}
/// <summary>
/// 更新操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(T_AdminUser model)
{
object[] obj = { model.AdminLogName, model.AdminLogPass, model.AdminName, model.AdminTel, model.UnitCode, model.AdminType, model.AdminState, model.AdminLogNum, model.IsCheck, model.Editor, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.EndDate.ToString("yyyy-MM-dd HH:mm:ss"), model.Id, model.Roleid };
string strSql = string.Format(" update T_AdminUser set AdminLogName='{0}',AdminLogPass='******',AdminName='{2}',AdminTel='{3}',UnitCode='{4}',AdminType={5},AdminState={6},AdminLogNum={7},IsCheck={8},Editor='{9}',CreateDate='{10}',EndDate='{11}',roleid='{13}' where Id={12}", obj);
if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Create(T_AdminUser model)
{
object[] obj = { model.AdminLogName, model.AdminLogPass, model.AdminName, model.AdminTel, model.UnitCode, model.AdminType, model.AdminState, model.AdminLogNum, model.IsCheck, model.Editor, model.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), model.EndDate.ToString("yyyy-MM-dd HH:mm:ss"), model.Roleid };
string strSql = string.Format("insert into [T_AdminUser]([AdminLogName],[AdminLogPass],[AdminName],[AdminTel],[UnitCode],[AdminType],[AdminState],[AdminLogNum],[IsCheck],[Editor],[CreateDate],[EndDate],roleid) values ('{0}','{1}','{2}','{3}','{4}',{5},{6},{7},{8},'{9}','{10}','{11}','{12}')", obj);
if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0)
{
return(true);
}
else
{
return(false);
}
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "paging":
returnDate = JsonHelper <T_SysFun, int> .JsonDataTable(GetAllList(context), "rows");
break;
case "del":
returnDate = Delete(context);
break;
case "add":
returnDate = Create(context);
break;
case "up":
returnDate = Update(context);
break;
case "id":
returnDate = JsonHelper <T_SysFun, int> .JsonWriter(GetById(context));
break;
case "parent":
returnDate = ParentNode();
break;
case "tree":
returnDate = GetTree(context);
break;
case "node":
returnDate = AddNode(context);
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
/// <summary>
/// 根据id删除用户
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Remove(string id)
{
Guid _id = new Guid(id);
using (var dbContext = new IPathDBEntities())
{
var entity = new T_AdminUser()
{
id = _id
};
dbContext.T_AdminUser.Attach(entity);
dbContext.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
return(dbContext.SaveChanges());
}
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "list":
returnDate = GetAllList();
break;
case "node":
returnDate = AddNodes(context);
break;
case "easycom":
returnDate = GetLongList();
break;
case "orglist":
returnDate = GetOrglist(context);
break;
case "add":
returnDate = Create(context);
break;
case "edit":
returnDate = Edit(context);
break;
case "id":
returnDate = JsonHelper <T_Organization, int> .JsonWriter(GetById(context));
break;
case "del":
returnDate = Del(context);
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "paging":
returnDate = JsonHelper <Model.T_role, int> .JsonDataTable(GetAllList(context), "rows");
break;
case "del":
returnDate = Delete(context);
break;
case "add":
returnDate = Create(context);
break;
case "up":
returnDate = Update(context);
break;
case "Id":
returnDate = JsonHelper <Model.T_role, int> .JsonWriter(GetById(context));
break;
case "roleid":
returnDate = JsonHelper <T_RoleRight, int> .JsonWriter(GetById(context));
break;
case "rolecombox":
returnDate = GetRoleList();
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
private string Create(T_AdminUser model)
{
if (admin.AdminType == dal.HighestLevel())
{
if (dal.Create(model))
{
return("添加管理员登录账号成功！");
}
else
{
return("添加管理员登录账号失败，错误代码：500");
}
}
else
{
return("您没有添加管理员登录账号权限！");
}
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "paging":
string str = "\"total\":" + CountNum(context) + ",";
returnDate = JsonHelper <T_BusinessConsulting, int> .JsonDataTable(GetAllList(context), "rows").Insert(1, (str));
break;
case "tousu":
string strs = "\"total\":" + CountNumts(context) + ",";
returnDate = JsonHelper <T_BusinessConsulting, int> .JsonDataTable(GetAllListts(context), "rows").Insert(1, (strs));
break;
case "del":
returnDate = Delete(context);
break;
case "add":
returnDate = Create(GetModel(context));
break;
case "up":
returnDate = Update(GetModel(context));
break;
case "Id":
returnDate = JsonHelper <T_BusinessConsulting, int> .JsonWriter(GetById(context));
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="adminLogName"></param>
/// <param name="adminLogPass"></param>
/// <returns></returns>
public T_AdminUser AdminUserLogin(string adminLogName, string adminLogPass)
{
try
{
string strSql = string.Format("select top 1 Id,AdminLogName,AdminLogPass,AdminName,AdminTel,UnitCode,AdminType,AdminState,AdminLogNum,IsCheck,Editor,CreateDate,EndDate,roleid from T_AdminUser where AdminLogName='{0}' and AdminLogPass='******'", adminLogName, adminLogPass);
T_AdminUser model = new T_AdminUser();
using (dynamic read = DbHelper.Factory().ExecuteReader(strSql))
{
if (read.Read())
{
model.Id = (int)read["Id"];
model.AdminLogName = read["AdminLogName"];
model.AdminLogPass = read["AdminLogPass"];
model.AdminName = read["AdminName"];
model.AdminTel = read["AdminTel"];
model.UnitCode = read["UnitCode"];
try
{
model.Roleid = read["roleid"];
}
catch { model.Roleid = ""; }
try { model.AdminType = (int)read["AdminType"]; }
catch { model.AdminType = 0; }
try { model.AdminState = (int)read["AdminState"]; }
catch { model.AdminState = 0; }
try { model.AdminLogNum = (int)read["AdminLogNum"]; }
catch { model.AdminLogNum = 0; }
try { model.IsCheck = (int)read["IsCheck"]; }
catch { model.IsCheck = 0; }
model.Editor = read["Editor"];
try { model.CreateDate = (DateTime)read["CreateDate"]; }
catch { model.CreateDate = DateTime.Now; }
try { model.EndDate = (DateTime)read["EndDate"]; }
catch { model.EndDate = DateTime.Now; }
}
read.Dispose();
}
return(model);
}
catch (Exception) { throw; }
}
//
private T_AdminUser GetModel(HttpContext context)
{
T_AdminUser model = new T_AdminUser();
try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); }
catch { }
model.AdminLogName = context.Request.Form["AdminLogName"].ToString();
model.AdminLogPass = context.Request.Form["AdminLogPass"].ToString();
model.AdminName = context.Request.Form["AdminName"].ToString();
model.AdminTel = context.Request.Form["AdminTel"].ToString();
model.UnitCode = context.Request.Form["UnitCode"].ToString();
try { model.AdminType = new T_OrganizationDal().GetLevel(model.UnitCode); }
catch { }
try { model.AdminState = int.Parse(context.Request.Form["AdminState"].ToString()); }
catch { }
try { model.AdminLogNum = int.Parse(context.Request.Form["AdminLogNum"].ToString()); }
catch { }
try { model.IsCheck = int.Parse(context.Request.Form["IsCheck"].ToString()); }
catch { }
model.Editor = admin.AdminLogName;
model.Roleid = context.Request.Form["roleid"].ToString();
return(model);
}
public string ProcessRequest(HttpContext context)
{
try { admin = context.Session["SuperAdminUser"] as T_AdminUser; }
catch { }
string action = context.Request.QueryString["action"].ToString();
string returnDate;
switch (action)
{
case "paging":
returnDate = JsonHelper <T_ListedProjectType, int> .JsonDataTable(GetAllList(context), "rows");
break;
case "add":
returnDate = Create(context);
break;
case "up":
returnDate = Update(context);
break;
case "id":
returnDate = JsonHelper <T_ListedProjectType, int> .JsonWriter(GetById(context));
break;
case "list":
returnDate = GetAllList();
break;
default:
returnDate = null;
break;
}
return(returnDate);
}
