public void ProcessRequest(HttpContext context)
{
string id = context.Request.Form["id"];
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person person = bll.GetModel(Convert.ToInt32(id));
//删除区域关联
bll.ClearAllRegions(Convert.ToInt32(id));
//删除角色关联
bll.ClearAllRoles(Convert.ToInt32(id));
//删除用户
bool success = bll.Delete(Convert.ToInt32(id));
Hashtable ht = new Hashtable();
if (success)
{
ht.Add("success", true);
string clientip = context.Request.UserHostAddress;
SM.YuQing.BLL.Log.Add("操作", context.User.Identity.Name + " 删除用户[" + person.Code + "]", 0, 0, clientip);
}
else
{
ht.Add("errorMsg", "Some errors occured.");
}
context.Response.Write(JsonConvert.SerializeObject(ht));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string userName = SM.YuQing.Library.PageValidate.InputText(Request.Form["Code"].Trim(), 30);
string password = SM.YuQing.Library.PageValidate.InputText(Request.Form["Pwd"].Trim(), 30);
SM.YuQing.BLL.Log.Add("登录", userName + " 尝试登录", 0, 0, Request.UserHostAddress);
//验证登录信息，如果验证通过则返回当前用户对象的安全上下文信息
SM.YuQing.Accounts.AccountsPrincipal newUser = SM.YuQing.Accounts.AccountsPrincipal.ValidateLogin(userName, password);
if (newUser == null)//记录登录次数
{
if ((Session["PassErrorCountAdmin"] != null) && (Session["PassErrorCountAdmin"].ToString() != ""))
{
int PassErroeCount = Convert.ToInt32(Session["PassErrorCountAdmin"]);
Session["PassErrorCountAdmin"] = PassErroeCount + 1;
}
else
{
Session["PassErrorCountAdmin"] = 1;
}
lblMsg.Text = "用户名或密码错误！";
return;
}
else
{
SM.YuQing.BLL.Person userBLL = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person currentUser = userBLL.GetModel(((SM.YuQing.Accounts.SiteIdentity)newUser.Identity).FID);
Context.User = newUser;
if (currentUser.IsLock == 1)
{
lblMsg.Text = "您的用户名已被管理锁定！";
return;
}
FormsAuthentication.SetAuthCookie(userName, false);
//登录成功日志
string clientip = Request.UserHostAddress;
SM.YuQing.BLL.Log.Add("登录", currentUser.Code + " 登录成功", 0, 0, clientip);
userBLL.UpdateLoginInfo(currentUser.ID, DateTime.Now);
Session["UserInfo"] = currentUser;
if (Session["returnPage"] != null)
{
string returnpage = Session["returnPage"].ToString();
Session["returnPage"] = null;
Response.Redirect(returnpage);
}
else
{
if (string.IsNullOrEmpty(Request.QueryString["ReturnUrl"]))
{
Response.Redirect("Admin/Index.aspx");
}
else
{
Response.Redirect(Request.QueryString["ReturnUrl"].ToString());
}
}
}
}
public void ProcessRequest(HttpContext context)
{
string id = context.Request.Form["id"];
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person person = bll.GetModel(Convert.ToInt32(id));
if (person.IsLock == 0)
{
person.IsLock = 1;
}
else
{
person.IsLock = 0;
}
bool success = bll.Update(person);
Hashtable ht = new Hashtable();
if (success)
{
ht.Add("success", true);
string clientip = context.Request.UserHostAddress;
SM.YuQing.BLL.Log.Add("操作", context.User.Identity.Name + " " + (person.IsLock == 1 ? "锁定" : "解锁") + "用户[" + person.Code + "]", 0, 0, clientip);
}
else
{
ht.Add("errorMsg", "Some errors occured.");
}
context.Response.Write(JsonConvert.SerializeObject(ht));
}
public void AddRegions(SM.YuQing.Model.Person person, string[] ids)
{
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
foreach (string item in ids)
{
if (item != "" && item != "undefined")
{
bll.AddRegions(person.ID, Convert.ToInt32(item));
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SM.YuQing.Model.Person model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Person set ");
strSql.Append("Name=@Name,");
strSql.Append("Code=@Code,");
strSql.Append("Pwd=@Pwd,");
strSql.Append("IsLock=@IsLock,");
strSql.Append("LastLoginTime=@LastLoginTime,");
strSql.Append("LoginTimes=@LoginTimes,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("CreatePerson=@CreatePerson,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("UpdatePerson=@UpdatePerson");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Pwd", SqlDbType.NVarChar, 50),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@LoginTimes", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@ID", SqlDbType.Int)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Code;
parameters[2].Value = model.Pwd;
parameters[3].Value = model.IsLock;
parameters[4].Value = model.LastLoginTime;
parameters[5].Value = model.LoginTimes;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.CreatePerson;
parameters[8].Value = model.UpdateTime;
parameters[9].Value = model.UpdatePerson;
parameters[10].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public SiteIdentity(string currentCode)
{
SM.YuQing.BLL.Person bll = new BLL.Person();
SM.YuQing.Model.Person model = bll.GetModelFromCode(currentCode);
this._fid = model.ID;
this._fcode = model.Code;
this._fname = model.Name;
//this._fpermission = model.FPermission;
//this._ftenantcode = model.FTenantCode;
this._fpwd = model.Pwd;
//this._fstoreno = model.FStoreNo;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SM.YuQing.Model.Person model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Person(");
strSql.Append("Name,Code,Pwd,IsLock,LastLoginTime,LoginTimes,CreateTime,CreatePerson,UpdateTime,UpdatePerson)");
strSql.Append(" values (");
strSql.Append("@Name,@Code,@Pwd,@IsLock,@LastLoginTime,@LoginTimes,@CreateTime,@CreatePerson,@UpdateTime,@UpdatePerson)");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Pwd", SqlDbType.NVarChar, 50),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@LoginTimes", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Code;
parameters[2].Value = model.Pwd;
parameters[3].Value = model.IsLock;
parameters[4].Value = model.LastLoginTime;
parameters[5].Value = model.LoginTimes;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.CreatePerson;
parameters[8].Value = model.UpdateTime;
parameters[9].Value = model.UpdatePerson;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
int id = Convert.ToInt32(context.Request.QueryString["id"]);
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person person = bll.GetModel(id);
person.Pwd = "";
if (person.IsLock == 1)
{
person.Status = "on";
}
else
{
person.Status = "off";
}
context.Response.Write(JsonConvert.SerializeObject(person));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SM.YuQing.Model.Person GetModelFromCode(string code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,Code,Pwd,IsLock,LastLoginTime,LoginTimes,CreateTime,CreatePerson,UpdateTime,UpdatePerson from Person ");
strSql.Append(" where Code=@Code ");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.NVarChar)
};
parameters[0].Value = code;
SM.YuQing.Model.Person model = new SM.YuQing.Model.Person();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public string GetUserDisplayName()
{
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person person = bll.GetModelFromCode(Context.User.Identity.Name);
return(person.Name);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SM.YuQing.Model.Person DataRowToModel(DataRow row)
{
SM.YuQing.Model.Person model = new SM.YuQing.Model.Person();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["Pwd"] != null)
{
model.Pwd = row["Pwd"].ToString();
}
if (row["IsLock"] != null && row["IsLock"].ToString() != "")
{
model.IsLock = int.Parse(row["IsLock"].ToString());
switch (model.IsLock)
{
case 0:
model.Status = "正常";
break;
case 1:
model.Status = "锁定";
break;
default:
break;
}
}
if (row["LastLoginTime"] != null && row["LastLoginTime"].ToString() != "")
{
model.LastLoginTime = DateTime.Parse(row["LastLoginTime"].ToString());
}
if (row["LoginTimes"] != null && row["LoginTimes"].ToString() != "")
{
model.LoginTimes = int.Parse(row["LoginTimes"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreatePerson"] != null)
{
model.CreatePerson = row["CreatePerson"].ToString();
}
if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
if (row["UpdatePerson"] != null)
{
model.UpdatePerson = row["UpdatePerson"].ToString();
}
//加载角色
string sql = "SELECT [PersonId],r.* FROM [dbo].[PersonRole] pr inner join [Role] r on pr.RoleId=r.ID where [PersonId]='" + model.ID + "'";
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
foreach (DataRow item in dt.Rows)
{
model.Role += item["Name"].ToString() + ",";
model.RoleID += item["ID"].ToString() + ",";
}
if (!string.IsNullOrEmpty(model.Role))
{
model.Role = model.Role.Substring(0, model.Role.Length - 1);
model.RoleID = model.RoleID.Substring(0, model.RoleID.Length - 1);
}
//加载区域
List <Model.Regions> regions = GetRegions(model.ID);
foreach (Model.Regions item in regions)
{
model.Regions += item.Region + ",";
}
if (!string.IsNullOrEmpty(model.Regions))
{
model.Regions = model.Regions.Substring(0, model.Regions.Length - 1);
}
}
return(model);
}
public void ProcessRequest(HttpContext context)
{
string id = context.Request.QueryString["id"];
string Name = context.Request.Form["Name"];
string Code = context.Request.Form["Code"];
string Pwd = context.Request.Form["Pwd"];
string RoleID = context.Request.Form["RoleID"];
bool success;
string errorMsg = "";
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
string clientip = context.Request.UserHostAddress;
if (id == null)
{
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person p = bll.GetModelFromCode(Code);
if (p == null)
{
SM.YuQing.Model.Person person = new SM.YuQing.Model.Person();
person.Name = Name;
person.Code = Code;
person.Pwd = AccountsPrincipal.EncryptPassword(Pwd);
person.CreatePerson = context.User.Identity.Name;
person.CreateTime = DateTime.Now;
person.UpdatePerson = context.User.Identity.Name;
person.UpdateTime = DateTime.Now;
person.IsLock = 0;
person.LastLoginTime = DateTime.Now;
person.LoginTimes = 0;
success = bll.Add(person);
SM.YuQing.BLL.Log.Add("操作", context.User.Identity.Name + " 创建用户[" + person.Code + "]", 0, 0, clientip);
}
else
{
success = false;
errorMsg = "此用户名已存在！";
}
}
else
{
string[] ids = context.Request.Form["ids"].Split(',');
SM.YuQing.BLL.Person bll = new SM.YuQing.BLL.Person();
SM.YuQing.Model.Person person = bll.GetModel(Convert.ToInt32(id));
person.Name = Name;
if (Pwd != "")
{
person.Pwd = AccountsPrincipal.EncryptPassword(Pwd);
}
person.UpdatePerson = context.User.Identity.Name;
person.UpdateTime = DateTime.Now;
success = bll.Update(person);
bll.ClearAllRegions(person.ID);
AddRegions(person, ids);
bll.ClearAllRoles(person.ID);
if (!string.IsNullOrEmpty(RoleID))
{
bll.AddRoles(person.ID, Convert.ToInt32(RoleID));
}
SM.YuQing.BLL.Log.Add("操作", context.User.Identity.Name + " 修改用户[" + person.Code + "]", 0, 0, clientip);
}
Hashtable ht = new Hashtable();
if (success)
{
ht.Add("success", true);
}
else
{
if (errorMsg == "")
{
ht.Add("errorMsg", "Some errors occured.");
}
else
{
ht.Add("errorMsg", errorMsg);
}
}
context.Response.Write(JsonConvert.SerializeObject(ht));
}
