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;
}
}
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["userid"].ToString().Trim();
model.OrgId = dr["orgid"].ToString().Trim();
model.OrgName = dr["orgname"].ToString().Trim();
model.UserCode = dr["usercode"].ToString().Trim();
model.UserPassword = dr["userpassword"].ToString().Trim();
model.RealName = dr["realname"].ToString().Trim();
model.RoleId = dr["roleid"].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;
}
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;
}
//屏蔽注册、登录时间 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;
}
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);
}
}
/// <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;
}
/// <summary>
/// ����һ������
/// </summary>
public bool Add(BasUser model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(BasUser model)
{
return dal.Update(model);
}