private void Save(bool isHide)
{
User bll = new User();
BasUser model = new BasUser();
int count = 0;
string msg = "";
if (Exists(model))
{
return;
}
if (count > 0)
{
ShowNotification("" + msg + "保存成功！");
this.GridPanel1.Reload();
if (isHide)
{
this.winDetail.Hide();
}
}
else
{
ShowNotification(msg);
}
}
//屏蔽注册、登录时间 Edited By Liangsx 2011-01-24
public bool Update(BasUser model)
{
bool blFlag;
try
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_user ");
strb.Append(" Set ");
strb.Append("orgid = " + Hi.Common.Utils.IsNull(model.OrgId, "0") + ",");
strb.Append("orgname = '" + model.OrgName + "',");
strb.Append("usercode = '" + model.UserCode + "',");
//strb.Append("userpassword = '******',");
strb.Append("realname = '" + model.RealName + "',");
strb.Append("sex = '" + model.Sex + "',");
strb.Append("usertelephone = '" + model.UserTelephone + "',");
strb.Append("email = '" + model.Email + "',");
strb.Append("qq = '" + model.Qq + "',");
//strb.Append("regtime = '" + model.Regtime + "',");
strb.Append("address = '" + model.Address + "',");
strb.Append("IsLocked = " + model.IsLocked + ",");
//strb.Append("lastloginip = '" + model.Lastloginip + "',");
//strb.Append("logintimes = " + model.Logintimes + ",");
//strb.Append("lastlogintime = '" + model.Lastlogintime + "',");
strb.Append("remark = '" + model.Remark + "'");
strb.Append(" where userid = " + model.UserId.ToString());
blFlag = DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false;
}
catch (Exception ex)
{
throw ex;
}
return(blFlag);
}
public async Task <IActionResult> Login(AccountDto input)
{
var result = await _accountService.Login(input);
if (result.IfSuccess)
{
BasUser entity = result.Model;
//用Claim来构造一个ClaimsIdentity，然后调用 SignInAsync 方法。
var claims = new List <Claim>
{
new Claim(ClaimTypes.Name, entity.DisPlayName),
new Claim(ClaimTypes.Sid, entity.Id.ToString())
};
var claimsIdentity = new ClaimsIdentity(claims, "Cookies");
//登录
await HttpContext.SignInAsync("Cookies", new ClaimsPrincipal(claimsIdentity), new AuthenticationProperties
{
ExpiresUtc = DateTime.Now.AddHours(1),
IsPersistent = false,
AllowRefresh = false
});
}
return(Json(result));
}
public bool Add(BasUser model)
{
if (model == null)
{
return(false);
}
StringBuilder strb = new StringBuilder();
strb.Append(" Insert Into bas_user ");
strb.Append(" ( ");
//strb.Append("userid, ");//主键是自动增长列，请屏蔽赋值
strb.Append("orgid, ");
strb.Append("orgname,");
strb.Append("usercode, ");
strb.Append("userpassword, ");
strb.Append("realname, ");
strb.Append("sex, ");
strb.Append("usertelephone, ");
strb.Append("email, ");
strb.Append("qq, ");
strb.Append("regtime, ");
strb.Append("address, ");
strb.Append("islocked, ");
// strb.Append("lastloginip, ");
// strb.Append("logintimes, ");
// strb.Append("lastlogintime, ");
strb.Append("remark ");
strb.Append(" )");
strb.Append(" Values( ");
//strb.Append("'" + model.Userid + "', ");
strb.Append("" + Hi.Common.Utils.IsNull(model.OrgId, "0") + ", ");
strb.Append("'" + model.OrgName + "', ");
strb.Append("'" + model.UserCode + "', ");
strb.Append("'" + model.UserPassword + "', ");
strb.Append("'" + model.RealName + "', ");
strb.Append("'" + model.Sex + "', ");
strb.Append("'" + model.UserTelephone + "', ");
strb.Append("'" + model.Email + "', ");
strb.Append("'" + model.Qq + "', ");
strb.Append("'" + model.Regtime + "', ");
strb.Append("'" + model.Address + "', ");
strb.Append("" + model.IsLocked + ", ");
//strb.Append("'" + model.Lastloginip + "', ");
// strb.Append("" + model.Logintimes + ", ");
// strb.Append("'" + model.Lastlogintime + "', ");
strb.Append("'" + model.Remark + "' ");
strb.Append(" )");
try
{
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
catch
{
return(false);
}
}
/// <summary>
/// 唯一性验证
/// </summary>
/// <returns>true</returns>
private bool Exists(BasUser model)
{
User bll = new User();
bool blFlag = false;
string strWhere = "";
strWhere = " UserCode='" + model.UserCode + "'";
if (!string.IsNullOrEmpty(model.UserId.ToString()))
{
strWhere += " and userid<>" + model.UserId;
}
blFlag = bll.Exists(strWhere);
if (blFlag)
{
ShowNotification("保存失败：“" + model.UserCode + "”已存在");
}
return(blFlag);
}
public bool UpdateLogin(BasUser model)
{
try
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update bas_user ");
strb.Append(" Set ");
strb.Append("lastloginip = '" + model.LastLoginIp + "',");
strb.Append("logintimes = " + model.LoginTimes + ",");
strb.Append("lastlogintime = '" + model.LastLoginTime + "'");
strb.Append(" where userid = " + model.UserId.ToString());
DataBase.ExecuteNonQuery(strb.ToString());
}
catch
{
return(false);
}
return(true);
}
public BasUser Detail(string id)
{
DataRow dr = null;
if (Hi.Common.Utils.StrToInt(id) > 0)
{
dr = DetailFromId(id);
}
else
{
dr = DetailFromCode(id);
}
if (dr == null)
{
return(null);
}
BasUser model = new BasUser();
model.UserId = dr["user_id"].ToString().Trim();
model.OrgId = dr["user_orgid"].ToString().Trim();
model.OrgName = "";//dr["orgname"].ToString().Trim();
model.UserCode = dr["user_code"].ToString().Trim();
model.UserPassword = dr["user_password"].ToString().Trim();
model.RealName = dr["user_name"].ToString().Trim();
model.RoleId = dr["user_role"].ToString().Trim();
//model.Sex = dr["sex"].ToString().Trim();
//model.UserTelephone = dr["usertelephone"].ToString().Trim();
//model.Email = dr["email"].ToString().Trim();
//model.Qq = dr["qq"].ToString().Trim();
//model.Regtime = dr["regtime"].ToString().Trim();
//model.Address = dr["address"].ToString().Trim();
//model.IsLocked = dr["islocked"].ToString().Trim();
//model.LastLoginIp = dr["lastloginip"].ToString().Trim();
//model.LoginTimes = dr["logintimes"].ToString().Trim();
//model.LastLoginTime = dr["lastlogintime"].ToString().Trim();
//model.Remark = dr["remark"].ToString().Trim();
//model.Purview = dr["purview"].ToString().Trim();
//model.PurviewDetail = dr["purview_detail"].ToString().Trim();
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BasUser model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BasUser model)
{
return(dal.Add(model));
}
