/// <summary>
/// 得到 tb_user 数据实体
/// </summary>
/// <param name="row">row</param>
/// <returns>tb_user 数据实体</returns>
public tb_UserEntity Populate_tb_UserEntity_FromDr(DataRow row)
{
tb_UserEntity Obj = new tb_UserEntity();
if (row != null)
{
Obj.UserId = ((row["UserId"]) == DBNull.Value)?0:Convert.ToInt32(row["UserId"]);
Obj.SchoolId = ((row["SchoolId"]) == DBNull.Value)?0:Convert.ToInt32(row["SchoolId"]);
Obj.DepartmentId = ((row["DepartmentId"]) == DBNull.Value)?0:Convert.ToInt32(row["DepartmentId"]);
Obj.Path = row["Path"].ToString();
Obj.RoleId = ((row["RoleId"]) == DBNull.Value)?0:Convert.ToInt32(row["RoleId"]);
Obj.Name = row["Name"].ToString();
Obj.Pwd = row["Pwd"].ToString();
Obj.RealName = row["RealName"].ToString();
Obj.Sex = ((row["Sex"]) == DBNull.Value)?0:Convert.ToInt32(row["Sex"]);
Obj.Position = row["Position"].ToString();
Obj.Mail = row["Mail"].ToString();
Obj.IdentityCard = row["IdentityCard"].ToString();
Obj.Phone = row["Phone"].ToString();
Obj.Description = row["Description"].ToString();
Obj.Status = ((row["Status"]) == DBNull.Value)?0:Convert.ToInt32(row["Status"]);
Obj.Addtime = ((row["Addtime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["Addtime"]);
}
else
{
return(null);
}
return(Obj);
}
/// <summary>
/// 向数据库中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_tb_UserModel">tb_User实体</param>
/// <returns>新插入记录的编号</returns>
public int Insert(SqlTransaction sp, tb_UserEntity _tb_UserModel)
{
string sqlStr = "insert into tb_User([UserID],[PWD],[RealName],[Status],[WeiXinCode],[Interface],[Token],[AppID],[AppSecret],[AddTime],[UpdateTime]) values(@UserID,@PWD,@RealName,@Status,@WeiXinCode,@Interface,@Token,@AppID,@AppSecret,@AddTime,@UpdateTime) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@UserID", SqlDbType.VarChar),
new SqlParameter("@PWD", SqlDbType.VarChar),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@WeiXinCode", SqlDbType.VarChar),
new SqlParameter("@Interface", SqlDbType.VarChar),
new SqlParameter("@Token", SqlDbType.VarChar),
new SqlParameter("@AppID", SqlDbType.VarChar),
new SqlParameter("@AppSecret", SqlDbType.VarChar),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
};
_param[0].Value = _tb_UserModel.UserID;
_param[1].Value = _tb_UserModel.PWD;
_param[2].Value = _tb_UserModel.RealName;
_param[3].Value = _tb_UserModel.Status;
_param[4].Value = _tb_UserModel.WeiXinCode;
_param[5].Value = _tb_UserModel.Interface;
_param[6].Value = _tb_UserModel.Token;
_param[7].Value = _tb_UserModel.AppID;
_param[8].Value = _tb_UserModel.AppSecret;
_param[9].Value = _tb_UserModel.AddTime;
_param[10].Value = _tb_UserModel.UpdateTime;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param));
return(res);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (identity != null)
{
txtdomain.Text = "@agents.com";
txtdomain.Enabled = false;
ddlRole.Enabled = false;
if (UserId > 0)
{
txtname.Enabled = false;
tb_UserEntity model = tb_UserBLL.GetInstance().GetAdminSingle(UserId);
if (model != null)
{
this.txtname.Text = model.Name;
this.txtrealname.Text = model.RealName;
this.ddlstatus.SelectedValue = model.Status.ToString();
this.txtposition.Text = model.Position;
this.txtemail.Text = model.Mail;
this.txtphone.Text = model.Phone;
this.txtnotice.Text = model.Description;
this.ddlRole.SelectedValue = model.RoleId.ToString();
ddlRole.Enabled = false;
sex = model.Sex;
}
}
}
}
}
/// <summary>
/// 向数据表tb_User更新一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_tb_UserModel">_tb_UserModel</param>
/// <returns>影响的行数</returns>
public int Update(SqlTransaction sp, tb_UserEntity _tb_UserModel)
{
string sqlStr = "update tb_User set [UserID]=@UserID,[PWD]=@PWD,[RealName]=@RealName,[Status]=@Status,[WeiXinCode]=@WeiXinCode,[Interface]=@Interface,[Token]=@Token,[AppID]=@AppID,[AppSecret]=@AppSecret,[AddTime]=@AddTime,[UpdateTime]=@UpdateTime where ID=@ID";
SqlParameter[] _param =
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.VarChar),
new SqlParameter("@PWD", SqlDbType.VarChar),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@WeiXinCode", SqlDbType.VarChar),
new SqlParameter("@Interface", SqlDbType.VarChar),
new SqlParameter("@Token", SqlDbType.VarChar),
new SqlParameter("@AppID", SqlDbType.VarChar),
new SqlParameter("@AppSecret", SqlDbType.VarChar),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
};
_param[0].Value = _tb_UserModel.ID;
_param[1].Value = _tb_UserModel.UserID;
_param[2].Value = _tb_UserModel.PWD;
_param[3].Value = _tb_UserModel.RealName;
_param[4].Value = _tb_UserModel.Status;
_param[5].Value = _tb_UserModel.WeiXinCode;
_param[6].Value = _tb_UserModel.Interface;
_param[7].Value = _tb_UserModel.Token;
_param[8].Value = _tb_UserModel.AppID;
_param[9].Value = _tb_UserModel.AppSecret;
_param[10].Value = _tb_UserModel.AddTime;
_param[11].Value = _tb_UserModel.UpdateTime;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param));
}
/// <summary>
/// 得到 tb_user 数据实体
/// </summary>
/// <param name="row">row</param>
/// <returns>tb_user 数据实体</returns>
public tb_UserEntity Populate_tb_UserEntity_FromDr(DataRow row)
{
tb_UserEntity Obj = new tb_UserEntity();
if (row != null)
{
Obj.ID = ((row["ID"]) == DBNull.Value)?0:Convert.ToInt32(row["ID"]);
Obj.UserID = row["UserID"].ToString();
Obj.PWD = row["PWD"].ToString();
Obj.RealName = row["RealName"].ToString();
Obj.Status = ((row["Status"]) == DBNull.Value)?0:Convert.ToInt32(row["Status"]);
Obj.WeiXinCode = row["WeiXinCode"].ToString();
Obj.Interface = row["Interface"].ToString();
Obj.Token = row["Token"].ToString();
Obj.AppID = row["AppID"].ToString();
Obj.AppSecret = row["AppSecret"].ToString();
Obj.AddTime = ((row["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["AddTime"]);
Obj.UpdateTime = ((row["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["UpdateTime"]);
}
else
{
return(null);
}
return(Obj);
}
public UserIdentity(string username, string password)
{
//wx_UsersEntity user = Agents.BLL.wx_UsersBLL.GetInstance().GetModelByOpenId(username,password);
string[] arr = username.Split('@');
tb_UserEntity user = Exam.BLL.tb_UserBLL.GetInstance().loginCheck(arr[0], "@" + arr[1]);
if (user != null)
{
if (user.Pwd == password)
{
tb_SchoolEntity school = tb_SchoolBLL.GetInstance().GetAdminSingle(user.SchoolId);
if (school.Domain == "@" + arr[1])
{
this._name = user.Name;
this._userID = user.UserId;
this._schoolID = user.SchoolId;
this._roleID = user.RoleId;
this._realName = user.RealName;
this._domain = school.Domain;
}
}
else
{
Flag = 2;
}
}
else//用户名不正确
{
Flag = 1;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
UserIdentity identity = this.Page.User.Identity as UserIdentity;
if (identity != null)
{
Exam.Entity.tb_UserEntity list = Exam.BLL.tb_UserBLL.GetInstance().GetModelByNameSchoolId(identity.Name, identity._schoolID);
if (list != null)
{
pass = list.Pwd;
if (pass != this.txtpass.Text.Trim())
{
MessageBox.ShowMsg(this, "原始密码不正确！");
return;
}
string newpass = "";
newpass = this.txtnewpass.Text.Trim();
if (newpass == "")
{
MessageBox.ShowMsg(this, "新密码不能为空！");
return;
}
if (txtpasswordSafe.Text.Trim() != newpass)
{
MessageBox.ShowMsg(this, "两次密码不同！");
return;
}
int userid = list.UserId;
tb_UserEntity model = tb_UserBLL.GetInstance().GetAdminSingle(userid);
if (model != null)
{
model.Pwd = newpass;
model.Addtime = DateTime.Now;
tb_UserBLL.GetInstance().Update(model);
MessageBox.ShowAndRedirect(this, "修改成功！", "Center.aspx");
}
else
{
MessageBox.ShowAndRedirect(this, "修改失败！", "Center.aspx");
}
}
}
}
catch (Exception ex)
{
throw;
}
}
public UserIdentity(string username, string password)
{
//wx_UsersEntity user = Agents.BLL.wx_UsersBLL.GetInstance().GetModelByOpenId(username,password);
string schoolid = username.Substring(1, 4);
schoolid = schoolid.TrimStart('0');
tb_SchoolEntity model = tb_SchoolBLL.GetInstance().GetAdminSingle(int.Parse(schoolid));
if (model != null)
{
tb_UserEntity user = Exam.BLL.tb_UserBLL.GetInstance().GetStudentByNameAndPwd(username, model.Domain);
if (user != null)
{
if (user.Pwd == password)
{
tb_SchoolEntity school = tb_SchoolBLL.GetInstance().GetAdminSingle(user.SchoolId);
if (school.Domain == model.Domain)
{
this._name = user.Name;
this._userID = user.UserId;
this._schoolID = user.SchoolId;
this._roleID = user.RoleId;
this._realName = user.RealName;
this._domain = school.Domain;
}
}
else
{
Flag = 2;
}
}
else//用户名不正确
{
Flag = 1;
}
}
else//用户名不正确
{
Flag = 1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (identity != null)
{
txtdomain.Text = identity._domain;
txtdomain.Enabled = false;
if (UserId > 0)
{
radselect2.Checked = true;
txtname.Enabled = false;
tb_UserEntity model = tb_UserBLL.GetInstance().GetAdminSingle(UserId);
this.txtname.Text = model.Name;
this.txtrealname.Text = model.RealName;
this.ddlstatus.SelectedValue = model.Status.ToString();
this.txtposition.Text = model.Position;
this.txtemail.Text = model.Mail;
this.txtphone.Text = model.Phone;
this.txtnotice.Text = model.Description;
this.ddlrole.SelectedValue = model.RoleId.ToString();
if (model.Sex == 1)
{
male.Checked = true;
}
else
{
female.Checked = true;
}
Exam.Entity.tb_DepartmentEntity temp = Exam.BLL.tb_DepartmentBLL.GetInstance().GetAdminSingle(model.DepartmentId);
if (temp != null)
{
Exam.Entity.tb_DepartmentEntity ttemp = Exam.BLL.tb_DepartmentBLL.GetInstance().GetAdminSingle(temp.ParentId);
if (ttemp != null)
{
labdepartment.Text = ttemp.Name + temp.Name;
}
}
hiddepartmentId.Text = model.DepartmentId.ToString();
}
}
}
}
/// <summary>
/// 得到 tb_user 数据实体
/// </summary>
/// <param name="dr">dr</param>
/// <returns>tb_user 数据实体</returns>
public tb_UserEntity Populate_tb_UserEntity_FromDr(IDataReader dr)
{
tb_UserEntity Obj = new tb_UserEntity();
Obj.ID = ((dr["ID"]) == DBNull.Value)?0:Convert.ToInt32(dr["ID"]);
Obj.UserID = dr["UserID"].ToString();
Obj.PWD = dr["PWD"].ToString();
Obj.RealName = dr["RealName"].ToString();
Obj.Status = ((dr["Status"]) == DBNull.Value)?0:Convert.ToInt32(dr["Status"]);
Obj.WeiXinCode = dr["WeiXinCode"].ToString();
Obj.Interface = dr["Interface"].ToString();
Obj.Token = dr["Token"].ToString();
Obj.AppID = dr["AppID"].ToString();
Obj.AppSecret = dr["AppSecret"].ToString();
Obj.AddTime = ((dr["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["AddTime"]);
Obj.UpdateTime = ((dr["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["UpdateTime"]);
return(Obj);
}
public tb_UserEntity GetModel(DataRow row)
{
tb_UserEntity Obj = new tb_UserEntity();
if (row != null)
{
if (row["*角色"].ToString() == "学生")
{
Obj.RoleId = 3;
}
else if (row["*角色"].ToString() == "教师")
{
Obj.RoleId = 2;
}
if (row["年级"].ToString() != "" && row["班级"].ToString() != "")
{
Obj.Description = row["年级"].ToString() + row["班级"].ToString();
}
else
{
Obj.Description = "";
}
Obj.UserId = 0;
Obj.SchoolId = 0;
Obj.DepartmentId = 0;
Obj.Pwd = row["*密码"].ToString();
Obj.RealName = row["*姓名"].ToString();
Obj.Sex = ((row["*性别"].ToString() == "男") ? 1 : 0);
Obj.Position = row["职位"].ToString();
Obj.Mail = row["电子邮箱"].ToString();
Obj.IdentityCard = row["证件号码"].ToString();
Obj.Phone = row["手机号码"].ToString();
//Obj.Description = row["备注"].ToString();
Obj.Status = 1;
Obj.Addtime = Convert.ToDateTime("1900-1-1");
}
else
{
return(null);
}
return(Obj);
}
/// <summary>
/// 根据ID,返回一个tb_User对象
/// </summary>
/// <param name="iD">iD</param>
/// <returns>tb_User对象</returns>
public tb_UserEntity Get_tb_UserEntity(int iD)
{
tb_UserEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@ID", SqlDbType.Int)
};
_param[0].Value = iD;
string sqlStr = "select * from tb_User with(nolock) where ID=@ID";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.weixinRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UserEntity_FromDr(dr);
}
}
return(_obj);
}
/// <summary>
/// 向数据表tb_User更新一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_tb_UserModel">_tb_UserModel</param>
/// <returns>影响的行数</returns>
public int Update(SqlTransaction sp, tb_UserEntity _tb_UserModel)
{
string sqlStr = "update tb_User set [SchoolId]=@SchoolId,[DepartmentId]=@DepartmentId,[Path]=@Path,[RoleId]=@RoleId,[Name]=@Name,[Pwd]=@Pwd,[RealName]=@RealName,[Sex]=@Sex,[Position]=@Position,[Mail]=@Mail,[IdentityCard]=@IdentityCard,[Phone]=@Phone,[Description]=@Description,[Status]=@Status,[Addtime]=@Addtime where UserId=@UserId";
SqlParameter[] _param =
{
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@SchoolId", SqlDbType.Int),
new SqlParameter("@DepartmentId", SqlDbType.Int),
new SqlParameter("@Path", SqlDbType.VarChar),
new SqlParameter("@RoleId", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@Pwd", SqlDbType.VarChar),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Sex", SqlDbType.Int),
new SqlParameter("@Position", SqlDbType.VarChar),
new SqlParameter("@Mail", SqlDbType.VarChar),
new SqlParameter("@IdentityCard", SqlDbType.VarChar),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime)
};
_param[0].Value = _tb_UserModel.UserId;
_param[1].Value = _tb_UserModel.SchoolId;
_param[2].Value = _tb_UserModel.DepartmentId;
_param[3].Value = _tb_UserModel.Path;
_param[4].Value = _tb_UserModel.RoleId;
_param[5].Value = _tb_UserModel.Name;
_param[6].Value = _tb_UserModel.Pwd;
_param[7].Value = _tb_UserModel.RealName;
_param[8].Value = _tb_UserModel.Sex;
_param[9].Value = _tb_UserModel.Position;
_param[10].Value = _tb_UserModel.Mail;
_param[11].Value = _tb_UserModel.IdentityCard;
_param[12].Value = _tb_UserModel.Phone;
_param[13].Value = _tb_UserModel.Description;
_param[14].Value = _tb_UserModel.Status;
_param[15].Value = _tb_UserModel.Addtime;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param));
}
/// <summary>
/// 向数据库中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_tb_UserModel">tb_User实体</param>
/// <returns>新插入记录的编号</returns>
public int Insert(SqlTransaction sp, tb_UserEntity _tb_UserModel)
{
string sqlStr = "insert into tb_User([SchoolId],[DepartmentId],[Path],[RoleId],[Name],[Pwd],[RealName],[Sex],[Position],[Mail],[IdentityCard],[Phone],[Description],[Status],[Addtime]) values(@SchoolId,@DepartmentId,@Path,@RoleId,@Name,@Pwd,@RealName,@Sex,@Position,@Mail,@IdentityCard,@Phone,@Description,@Status,@Addtime) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@SchoolId", SqlDbType.Int),
new SqlParameter("@DepartmentId", SqlDbType.Int),
new SqlParameter("@Path", SqlDbType.VarChar),
new SqlParameter("@RoleId", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@Pwd", SqlDbType.VarChar),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Sex", SqlDbType.Int),
new SqlParameter("@Position", SqlDbType.VarChar),
new SqlParameter("@Mail", SqlDbType.VarChar),
new SqlParameter("@IdentityCard", SqlDbType.VarChar),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime)
};
_param[0].Value = _tb_UserModel.SchoolId;
_param[1].Value = _tb_UserModel.DepartmentId;
_param[2].Value = _tb_UserModel.Path;
_param[3].Value = _tb_UserModel.RoleId;
_param[4].Value = _tb_UserModel.Name;
_param[5].Value = _tb_UserModel.Pwd;
_param[6].Value = _tb_UserModel.RealName;
_param[7].Value = _tb_UserModel.Sex;
_param[8].Value = _tb_UserModel.Position;
_param[9].Value = _tb_UserModel.Mail;
_param[10].Value = _tb_UserModel.IdentityCard;
_param[11].Value = _tb_UserModel.Phone;
_param[12].Value = _tb_UserModel.Description;
_param[13].Value = _tb_UserModel.Status;
_param[14].Value = _tb_UserModel.Addtime;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param));
return(res);
}
public tb_UserEntity GetModelByWeiXin(string weixin)
{
tb_UserEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@weixin", SqlDbType.VarChar, 50)
};
_param[0].Value = weixin;
string sqlStr = "select * from tb_User with(nolock) where WeiXinCode=@weixin ";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.weixinRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UserEntity_FromDr(dr);
}
}
return(_obj);
}
public tb_UserEntity GetModelByNameSchoolId(string name, int schoolid)
{
tb_UserEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@SchoolId", SqlDbType.Int)
};
_param[0].Value = name;
_param[1].Value = schoolid;
string sqlStr = "select * from tb_User with(nolock) where Name=@name and schoolid=@SchoolId";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UserEntity_FromDr(dr);
}
}
return(_obj);
}
/// <summary>
/// 学生PC端登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <param name="domain"></param>
/// <returns></returns>
public tb_UserEntity GetStudentByNameAndPwd(string name, string domain)
{
tb_UserEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@domain", SqlDbType.VarChar, 50)
};
_param[0].Value = name;
_param[1].Value = domain;
string sqlStr = "select a.* from tb_User a inner join tb_School b on a.SchoolId=b.SchoolId where a.Name=@name and a.Status=1 and b.Status=1 and a.RoleId=3 and b.domain=@domain";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UserEntity_FromDr(dr);
}
}
return(_obj);
}
/// <summary>
/// 根据用户名和密码,返回一个tb_User对象
/// </summary>
/// <param name="name">name</param>
/// <param name="pwd">pwd</param>
/// <returns>tb_User对象</returns>
public tb_UserEntity Get_tb_UserEntity(string name, string pwd)
{
tb_UserEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@pwd", SqlDbType.VarChar, 50)
};
_param[0].Value = name;
_param[1].Value = pwd;
string sqlStr = "select * from tb_User with(nolock) where UserID=@name and PWD=@pwd";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.weixinRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_UserEntity_FromDr(dr);
}
}
return(_obj);
}
/// <summary>
/// 得到 tb_user 数据实体
/// </summary>
/// <param name="dr">dr</param>
/// <returns>tb_user 数据实体</returns>
public tb_UserEntity Populate_tb_UserEntity_FromDr(IDataReader dr)
{
tb_UserEntity Obj = new tb_UserEntity();
Obj.UserId = ((dr["UserId"]) == DBNull.Value)?0:Convert.ToInt32(dr["UserId"]);
Obj.SchoolId = ((dr["SchoolId"]) == DBNull.Value)?0:Convert.ToInt32(dr["SchoolId"]);
Obj.DepartmentId = ((dr["DepartmentId"]) == DBNull.Value)?0:Convert.ToInt32(dr["DepartmentId"]);
Obj.Path = dr["Path"].ToString();
Obj.RoleId = ((dr["RoleId"]) == DBNull.Value)?0:Convert.ToInt32(dr["RoleId"]);
Obj.Name = dr["Name"].ToString();
Obj.Pwd = dr["Pwd"].ToString();
Obj.RealName = dr["RealName"].ToString();
Obj.Sex = ((dr["Sex"]) == DBNull.Value)?0:Convert.ToInt32(dr["Sex"]);
Obj.Position = dr["Position"].ToString();
Obj.Mail = dr["Mail"].ToString();
Obj.IdentityCard = dr["IdentityCard"].ToString();
Obj.Phone = dr["Phone"].ToString();
Obj.Description = dr["Description"].ToString();
Obj.Status = ((dr["Status"]) == DBNull.Value)?0:Convert.ToInt32(dr["Status"]);
Obj.Addtime = ((dr["Addtime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["Addtime"]);
return(Obj);
}
public UserIdentity(string username, string password)
{
//wx_UsersEntity user = Weifenxiao.BLL.wx_UsersBLL.GetInstance().GetModelByNameAndPwd(username, password);
tb_UserEntity user = Jnwf.BLL.tb_UserBLL.GetInstance().GetModelByNameAndPwd(username, password);
if (user != null)
{
wx_Shop_UserEntity shop = Weifenxiao.BLL.wx_Shop_UserBLL.GetInstance().GetModelByUserId(user.ID);
//user.LastLoginTime = DateTime.Now;
//user.LastLoginIP = HttpContext.Current.Request.UserHostAddress;
//User_Account.Update(user);
this._name = user.UserID;
this._appID = user.AppID;
this._userID = user.ID;
this._weixinCode = user.WeiXinCode;
this._appSecret = user.AppSecret;
if (shop != null)
{
this._shopID = shop.ShopId;
}
}
}
public void Update(tb_UserEntity tb_UserEntity)
{
//HttpContext.Current.Cache[key] = null;
tb_Userdal.Update(tb_UserEntity);
}
public int Insert(tb_UserEntity tb_UserEntity)
{
//HttpContext.Current.Cache[key] = null;
return(tb_Userdal.Insert(tb_UserEntity));
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string name = SqlInject(this.txtname.Text.Trim()); //用户名
string pwd = "";
string realname = SqlInject(this.txtrealname.Text.Trim()); //姓名
int sex = 0; //性别
if (this.male.Checked)
{
sex = 1;
}
else if (this.female.Checked)
{
sex = 0;
}
string status = SqlInject(ddlstatus.SelectedValue); //状态
string position = SqlInject(this.txtposition.Text.Trim()); //职位
string mail = SqlInject(this.txtemail.Text.Trim()); //邮箱
string phone = SqlInject(this.txtphone.Text.Trim()); //电话
string notice = SqlInject(this.txtnotice.Text.Trim()); //备注
int departmentId = 0; //部门
if (hiddepartmentId.Text != "")
{
departmentId = int.Parse(SqlInject(hiddepartmentId.Text));
}
if (identity != null)
{
//添加
if (UserId == 0)
{
pwd = SqlInject(this.txtpassword.Text.Trim());
Exam.Entity.tb_UserEntity temp = Exam.BLL.tb_UserBLL.GetInstance().GetModelByNameSchoolId(name, identity._schoolID);
if (temp != null)
{
MessageBox.ShowMsg(this, "登入名已存在！");
return;
}
Exam.Entity.tb_DepartmentEntity department = null;
if (departmentId > 0)
{
department = Exam.BLL.tb_DepartmentBLL.GetInstance().GetAdminSingle(departmentId);
}
else
{
department = Exam.BLL.tb_DepartmentBLL.GetInstance().Get_DepartmentEntityBySchoold(identity.SchoolID);
}
tb_UserEntity model = new tb_UserEntity();
model.SchoolId = identity._schoolID;
model.DepartmentId = departmentId;//部门id
//path
if (department != null)
{
if (department.RoleId == 1)
{
model.Path = "/" + department.DepartmentId + "/";
}
else if (department.RoleId == 2)
{
model.Path = "/" + department.ParentId + "/" + department.DepartmentId + "/";
}
else
{
Exam.Entity.tb_DepartmentEntity tempdepartment = Exam.BLL.tb_DepartmentBLL.GetInstance().GetAdminSingle(department.ParentId);
if (tempdepartment != null)
{
model.Path = "/" + tempdepartment.ParentId + "/" + department.ParentId + "/" + department.DepartmentId + "/";
}
else
{
model.Path = "";
}
}
}
else
{
model.Path = "";
}
model.Name = name;
model.Pwd = pwd;
model.RealName = realname;
model.Sex = sex;
model.Position = position;
model.Mail = mail;
model.IdentityCard = "";
model.Phone = phone;
model.Description = notice;
model.Status = int.Parse(status);
model.Addtime = DateTime.Now;
model.RoleId = int.Parse(SqlInject(ddlrole.SelectedValue));
int num = tb_UserBLL.GetInstance().Insert(model);
if (num > 0)
{
MessageBox.ShowAndRedirect(this, "添加成功！", "listname.aspx");
}
else
{
MessageBox.ShowMsg(this, "保存失败！");
labdepartment.Text = SqlInject(hidname.Text.Trim());
}
}
//修改
else
{
if (radselect.Checked)
{
pwd = SqlInject(this.txtpassword.Text.Trim());
if (pwd == "")
{
MessageBox.ShowMsg(this, "密码不能为空！");
return;
}
if (txtpasswordSafe.Text.Trim() != pwd)
{
MessageBox.ShowMsg(this, "两次密码不同！");
return;
}
}
Exam.Entity.tb_DepartmentEntity department = null;
if (departmentId > 0)
{
department = Exam.BLL.tb_DepartmentBLL.GetInstance().GetAdminSingle(departmentId);
}
else
{
department = Exam.BLL.tb_DepartmentBLL.GetInstance().Get_DepartmentEntityBySchoold(identity.SchoolID);
}
tb_UserEntity model = tb_UserBLL.GetInstance().GetAdminSingle(UserId);
//model.Name = name;
if (radselect.Checked)
{
model.Pwd = pwd;
}
model.RealName = realname;
model.Sex = sex;
model.Position = position;
model.Mail = mail;
model.Phone = phone;
model.Description = notice;
model.DepartmentId = departmentId;
if (department != null)
{
if (department.RoleId == 1)
{
model.Path = "/" + department.DepartmentId + "/";
}
else if (department.RoleId == 2)
{
model.Path = "/" + department.ParentId + "/" + department.DepartmentId + "/";
}
else
{
Exam.Entity.tb_DepartmentEntity tempdepartment = Exam.BLL.tb_DepartmentBLL.GetInstance().GetAdminSingle(department.ParentId);
if (tempdepartment != null)
{
model.Path = "/" + tempdepartment.ParentId + "/" + department.ParentId + "/" + department.DepartmentId + "/";
}
else
{
model.Path = "";
}
}
}
else
{
model.Path = "";
}
model.RoleId = int.Parse(ddlrole.SelectedValue);
model.Pwd = pwd;
tb_UserBLL.GetInstance().Update(model);
Response.Redirect("listname.aspx");
}
}
}
catch (Exception ex)
{
}
}
public void Update(tb_UserEntity tb_UserEntity)
{
tb_Userdal.Update(tb_UserEntity);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
IList <tb_UserEntity> agentList = tb_UserBLL.GetInstance().GetAgentList();
tb_UserEntity userModel = new tb_UserEntity();
userModel.UserId = 0;
userModel.Name = "选择代理商";
agentList.Insert(0, userModel);
if (agentList != null && agentList.Count > 0)
{
dllagent.DataSource = agentList;
dllagent.DataTextField = "name";
dllagent.DataValueField = "userid";
dllagent.DataBind();
}
//省
IList <tb_LocationEntity> list = Exam.BLL.tb_LocationBLL.GetInstance().GetProvinceByCache();
this.ddlprovince.DataSource = list;
this.ddlprovince.DataTextField = "LocationName";
this.ddlprovince.DataValueField = "LocationId";
this.ddlprovince.DataBind();
if (identity != null)
{
if (schoolId > 0)
{
Exam.Entity.tb_SchoolEntity model = Exam.BLL.tb_SchoolBLL.GetInstance().GetAdminSingle(schoolId);
if (model != null)
{
string str = model.Domain;
string[] arr = str.Split('.');
this.txtname.Text = model.Name;
this.txtdomain.Text = arr[0];
this.txtdomain.Enabled = false;
this.ddldomain.SelectedItem.Text = arr[1];
this.ddldomain.Enabled = false;
this.txtrealname.Text = model.Linkman;
this.txtphone.Text = model.Phone;
this.ddlstatus.SelectedValue = model.Status.ToString();
this.txtemail.Text = model.Mail;
DataSet ds = Exam.BLL.tb_LocationBLL.GetInstance().GetLocationInfo(model.LocationId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
//城市
if (int.Parse(ds.Tables[0].Rows[0]["ProvinceID"].ToString()) == 0)
{
for (int i = 0; i < ddlprovince.Items.Count; i++)
{
if (ddlprovince.Items[i].Value == ds.Tables[0].Rows[0]["CityID"].ToString())
{
ddlprovince.Items[i].Selected = true;
IList <tb_LocationEntity> tlist = Exam.BLL.tb_LocationBLL.GetInstance().GetCityByCache(int.Parse(ds.Tables[0].Rows[0]["CityID"].ToString()));
this.ddlcity.DataSource = tlist;
this.ddlcity.DataTextField = "LocationName";
this.ddlcity.DataValueField = "LocationId";
this.ddlcity.DataBind();
}
}
//城市选中
for (int k = 0; k < ddlcity.Items.Count; k++)
{
if (ddlcity.Items[k].Value == ds.Tables[0].Rows[0]["LocationId"].ToString())
{
ddlcity.Items[k].Selected = true;
}
}
}
else if (int.Parse(ds.Tables[0].Rows[0]["ProvinceID"].ToString()) > 0)
{
for (int i = 0; i < ddlprovince.Items.Count; i++)
{
if (ddlprovince.Items[i].Value == ds.Tables[0].Rows[0]["ProvinceID"].ToString())
{
//省选中
ddlprovince.Items[i].Selected = true;
//市赋值
IList <tb_LocationEntity> tlist = Exam.BLL.tb_LocationBLL.GetInstance().GetCityByCache(int.Parse(ds.Tables[0].Rows[0]["ProvinceID"].ToString()));
if (tlist != null)
{
this.ddlcity.DataSource = tlist;
this.ddlcity.DataTextField = "LocationName";
this.ddlcity.DataValueField = "LocationId";
this.ddlcity.DataBind();
}
}
}
for (int y = 0; y < ddlcity.Items.Count; y++)
{
if (ddlcity.Items[y].Value == ds.Tables[0].Rows[0]["CityID"].ToString())
{
//市选中
ddlcity.Items[y].Selected = true;
//区赋值
IList <tb_LocationEntity> templist = Exam.BLL.tb_LocationBLL.GetInstance().GetEurozoneList(int.Parse(ddlcity.Value));
if (templist != null)
{
this.ddleurozone.DataSource = templist;
this.ddleurozone.DataTextField = "LocationName";
this.ddleurozone.DataValueField = "LocationId";
this.ddleurozone.DataBind();
}
}
}
for (int k = 0; k < ddleurozone.Items.Count; k++)
{
//区选择
if (ddleurozone.Items[k].Value == ds.Tables[0].Rows[0]["LocationId"].ToString())
{
ddleurozone.Items[k].Selected = true;
}
}
}
}
}
}
}
}
}
public int Insert(tb_UserEntity tb_UserEntity)
{
return(tb_Userdal.Insert(tb_UserEntity));
}
