/// <summary>
/// 插入作者信息
/// </summary>
/// <param name="userExpert"></param>
/// <returns></returns>
public static int InsertUserExpert(UserAuthor userAuthor)
{
string sql = "proc_InserIntoAuthor";
//连接数据库，执行SQL语句
DBVisit.ObjDBAccess.CmdParas.Clear();
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_RoleID", SqlDbType.Int).Value = userAuthor.RoleInfo.Id;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Name", SqlDbType.VarChar, 100).Value = userAuthor.Name;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Pwd", SqlDbType.VarChar).Value = userAuthor.Pwd;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_CreateTime", SqlDbType.DateTime).Value = userAuthor.CreateTime;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_RealName", SqlDbType.VarChar, 100).Value = userAuthor.RealName;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Sex", SqlDbType.Bit).Value = userAuthor.Sex;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Birthday", SqlDbType.DateTime).Value = userAuthor.Birthday;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Tel", SqlDbType.VarChar, 20).Value = userAuthor.Tel;
DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Email", SqlDbType.VarChar, 50).Value = userAuthor.Email;
DBVisit.ObjDBAccess.CmdParas.Add("@Author_TypeName", SqlDbType.VarChar, 50).Value = userAuthor.TypeName;
DBVisit.ObjDBAccess.CmdParas.Add("@IsSuccess", SqlDbType.Bit).Direction = ParameterDirection.Output;
DBVisit.ObjDBAccess.ExcuteProcReturnInt(sql);
bool result = bool.Parse(DBVisit.ObjDBAccess.CmdParas["@IsSuccess"].Value.ToString());
if (result)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 用户点击提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//设置用户信息
UserAuthor user = new UserAuthor();
user.Id = -1;
user.Name = txtUserName.Text; //用户名称
user.Pwd = txtPassword.Text; //密码
user.RealName = txtRealName.Text; //真实姓名
user.RoleInfo.Id = 6; //权限（作者）
//用户性别
if (ddlSex.SelectedValue == "1")
{
user.Sex = true;
}
else
{
user.Sex = false;
}
if (txtBirthday.Text == "")
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('生日必填')", true);
return;
}
user.CreateTime = DateTime.Now; //创建时间
user.Birthday = Convert.ToDateTime(txtBirthday.Text); //生日
user.Email = txtEMail.Text; //邮箱
user.Tel = txtTel.Text; //联系电话
user.TypeName = "一般作者"; //作者类别
if (UserManager.IsUserExist(user.Name))
{
ClientScript.RegisterStartupScript(GetType(), "UserIsExist", "alert('用户名已存在！')", true);
return;
}
if (UserManager.AddNewAuthor(user) == 1)
{ //添加成功
ClientScript.RegisterStartupScript(GetType(), "UserIsExist", "alert('注册成功！');location.href='UserLogin.aspx'", true);
}
else
{//添加失败
ClientScript.RegisterStartupScript(GetType(), "UserIsExist", "alert('注册失败！')", true);
}
}
/// <summary>
/// 查询所有作者id
/// </summary>
/// <returns></returns>
public static List <UserAuthor> GetUserAuthorAll()
{
string sql = "proc_GetUserAuthorAll";
//连接数据库，执行SQL语句
DataTable dt = DBVisit.ObjDBAccess.ExecuteProc(sql).Tables[0];
//作者信息列表
List <UserAuthor> userAuthorList = new List <UserAuthor>(dt.Rows.Count);
UserAuthor userAuthor = null;
//创建作者信息对象并添加到作者信息列表中
foreach (DataRow dr in dt.Rows)
{
userAuthor = CreateUserAuthor(dr);
userAuthorList.Add(userAuthor);
}
return(userAuthorList);
}
/// <summary>
/// 修改用户密码
/// </summary>
/// <param name="user">要修改的用户信息</param>
/// <returns>操作结果</returns>
public static int UpdateUserPassword(GeneralUser user)
{
int result = -1;
//修改用户编号
switch (user.RoleInfo.Id)
{
case UserRoleConst.Administrator: //系统管理员
result = GeneralUserService.UpdateGeneralUser(user);
break;
//更新一般用户信息
case UserRoleConst.ChiefEditor: //主编
result = GeneralUserService.UpdateGeneralUser(user);
break;
case UserRoleConst.LayoutEditor: //排版编辑
result = GeneralUserService.UpdateGeneralUser(user);
break;
case UserRoleConst.ResponsibleEditor: //责任编辑
result = GeneralUserService.UpdateGeneralUser(user);
break;
case UserRoleConst.SubEditor: //副主编
result = GeneralUserService.UpdateGeneralUser(user);
break;
//更新特殊用户信息
case UserRoleConst.Author: //作者
UserAuthor auther = user as UserAuthor;
result = UserAuthorService.UpdateUserAuthor(auther);
break;
case UserRoleConst.Expert: //专家
UserExpert expert = user as UserExpert;
result = UserExpertService.UpdateUserExpert(expert);
break;
}
return(result);
}
/// <summary>
/// 创建作者信息对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static UserAuthor CreateUserAuthor(DataRow dr)
{
UserAuthor userAuthor = new UserAuthor();
userAuthor.Id = int.Parse(dr["Author_ID"].ToString());
userAuthor.TypeName = dr["Author_TypeName"].ToString();
userAuthor.Name = dr["UserInfo_Name"].ToString();
userAuthor.Pwd = dr["UserInfo_Pwd"].ToString();
userAuthor.CreateTime = DateTime.Parse(dr["UserInfo_CreateTime"].ToString());
userAuthor.RealName = dr["UserInfo_RealName"].ToString();
userAuthor.Sex = bool.Parse(dr["UserInfo_Sex"].ToString());
userAuthor.Birthday = DateTime.Parse(dr["UserInfo_Birthday"].ToString());
userAuthor.Tel = dr["UserInfo_Tel"].ToString();
userAuthor.Email = dr["UserInfo_Email"].ToString();
//角色信息
userAuthor.RoleInfo.Id = int.Parse(dr["Role_ID"].ToString());
userAuthor.RoleInfo.Name = dr["Role_Name"].ToString();
userAuthor.RoleInfo.NavTreeNodeID = int.Parse(dr["Role_NavTreeNodeID"].ToString());
return(userAuthor);
}
/// <summary>
/// 创建作者信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int AddNewAuthor(UserAuthor user)
{
return(UserAuthorService.InsertUserExpert(user));
}
