///// <summary> ///// 用户激活状态,需要参数ConstantType ///// </summary> ///// <param name="context"></param> //public void GetUserStatus(HttpContext context, OleDbConnection conn) //{ // string strConstantType = context.Request["ConstantType"]; // List<Dal.Models.SysConstant> lstuserstatus = BLL.SysConstant.GetConstantList(strConstantType, conn); // context.Response.Write(JsonConvert.SerializeObject(lstuserstatus)); //} /// <summary> /// 删除用户,需要参数,UserID /// </summary> /// <param name="context"></param> public void DelUser(HttpContext context, OleDbConnection conn) { Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"]; OleDbTransaction tran = conn.BeginTransaction(); try { string id = context.Request["UserID"]; int iUserID = Convert.ToInt32(id); if (iUserID == user.UserID.Value) { throw new Exception("不能禁用或删除当前操作用户!"); } string strActivityType = context.Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn, tran); if (activity == null) { throw new Exception("没有激活的活动!"); } int count = BLL.Declaration.DeclarationExsitUserCount(activity.ActivityID.Value, id, conn, tran); if (count > 0) { throw new Exception("当前用户已经申报过项目,所以不能删除!"); } BLL.User.DeleteUser(Convert.ToInt32(id), activity.ActivityID.Value, conn, tran); tran.Commit(); context.Response.Write("删除成功!"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } conn.Close(); }
/// <summary> /// 修改用户,需要参数UserID,UserStatus,Email /// </summary>s /// <param name="context"></param> public void EditUser(HttpContext context, OleDbConnection conn) { OleDbTransaction tran = conn.BeginTransaction(); try { string userstatus = context.Request["UserStatus"]; int id = Convert.ToInt32(context.Request["UserID"]); Dal.Models.UserInfo userinfo = BLL.User.GetUserInfo(id, conn, tran); userinfo.Email = context.Request["Email"]; if (userstatus == "0701") { BLL.User.EnableUser(id, conn, tran); } else if (userstatus == "0702") { string strActivityType = context.Session["ActivityType"].ToString(); BLL.User.DisableUser(id, strActivityType, conn, tran); } BLL.User.Update(userinfo, conn, tran); tran.Commit(); context.Response.Write("success"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } }
/// <summary> /// 根据用户身份获取奖项列表 /// </summary> /// <param name="user">用户</param> /// <param name="strActivityType">当前活动编号,目前已不用,可为空</param> /// <param name="strSpecialtyIDs">逗号分隔的专业编号,可为空</param> /// <param name="conn"></param> /// <param name="tran"></param> /// <returns></returns> public static List <Dal.Models.Prize> GetPrizeList( Dal.Models.UserInfo user, string strActivityType, string strSpecialtyIDs, OleDbConnection conn, OleDbTransaction tran = null) { StringBuilder sbSql = new StringBuilder(); string strSql = ""; if (user == null) { List <Dal.Models.Prize> lst = new List <Dal.Models.Prize>(); return(lst); } else { strSql = " select * from V_Prize p where ActivityID = dbo.Fn_GetCurrentActivityID() and dbo.fn_IsSpecialtyInAuthority(p.SpecialtyID, ?) = 1 "; if (!string.IsNullOrEmpty(strSpecialtyIDs)) { strSql += " AND p.SpecialtyID in (" + strSpecialtyIDs + ")"; } strSql += " order by p.SpecialtyTotalOrdinal, p.Ordinal "; return(Dal.OleDbHlper.GetList <Dal.Models.Prize>(strSql, conn, CommandType.Text, tran , new OleDbParameter("@UserID", OleDbType.Integer) { Value = user.UserID })); } }
protected void Page_Load(object sender, EventArgs e) { txtUploadLimitMax.Attributes.Add("onkeyup", "value.replace(/[^\\d]/g, '')"); Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (user == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { hdMsg.Value = "当前没有已经激活的申报活动,请确认。"; } else { InitPage(conn); } conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } if (!IsPostBack) { OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); ddlLocal.DataSource = BLL.SysConstant.GetConstantList("34", conn); ddlLocal.DataTextField = "ConstantValue"; ddlLocal.DataValueField = "ConstantCode"; ddlLocal.DataBind(); int iUserID = 0; if (int.TryParse(Request.QueryString["id"], out iUserID)) { Dal.Models.UserInfo user = BLL.User.GetUserInfo(iUserID, conn); txtUserName.Value = user.UserName; txtEmail.Value = user.Email; hdUserID.Value = Request.QueryString["id"]; Dal.Models.UserInfo userLogin = (Dal.Models.UserInfo)Session["UserInfo"]; if (iUserID == userLogin.UserID.Value) { ddlLocal.Enabled = false; listLocal.Visible = true; } checkeds.Value = BLL.User.GetUserRegion(iUserID, conn); } } }
protected void btnUpdatePassword_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); int userID = Request.QueryString["setPsUserID"] == null ? 0 : Convert.ToInt32(Request.QueryString["setPsUserID"]); Dal.Models.UserInfo user = new Dal.Models.UserInfo(); if (userID > 0) { user = BLL.User.GetUserInfo(userID, conn); } if (BLL.Encryption.MD5Encrypt(txtYsPassword.Text.Trim(), conn) != user.Password && BLL.Encryption.MD5Encrypt(txtYsPassword.Text.Trim()) != user.Password) { hdMsg.Value = "原始密码错误,请重新输入!"; return; } else { //修改当前登录用户 string newPassword = txtPassword.Text.Trim(); try { BLL.User.ResetPassword(Convert.ToInt32(user.UserID), newPassword, conn); hdMsg.Value = "修改成功!"; } catch (Exception ex) { hdMsg.Value = ex.Message; conn.Close(); } conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (user == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn); if (actActivated == null) { Response.Redirect("../Mutual/HomePage.aspx"); return; } //if (!IsPostBack) //{ // ddlSpecialty.DataSource = BLL.Specialty.GetSpecialtyListByUserType(actActivated.ActivityID.Value, user.UserType, user.UserID.Value, true, conn); // ddlSpecialty.DataTextField = "SpecialtyName"; // ddlSpecialty.DataValueField = "SpecialtyID"; // ddlSpecialty.DataBind(); //} conn.Close(); conn.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { string id = Request["DeclarationID"]; if (Session["ActivityType"] == null || Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); return; } if (!string.IsNullOrEmpty(id)) { Export(Context); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; //奖项绑值 ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(user, strActivityType, "", conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); conn.Close(); }
public void InitPage() { Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"]; OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (activity == null) { return; } else { //专业列表绑定 ddlSpecialtyID.DataSource = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, true, conn); ddlSpecialtyID.DataValueField = "SpecialtyID"; ddlSpecialtyID.DataTextField = "SpecialtyName"; ddlSpecialtyID.DataBind(); //奖项类别绑定 ddlPrize.DataSource = BLL.SysConstant.GetConstantList("03", conn); ddlPrize.DataValueField = "ConstantCode"; ddlPrize.DataTextField = "ConstantValue"; ddlPrize.DataBind(); } conn.Close(); hfVoteType.Value = Request.QueryString["VoteType"]; }
public static List <Dal.Models.UserOrg> GetLeaguerUserList(int iLoginUserID, string SearchUserName, Dal.Models.PageInfo <Dal.Models.UserOrg> pgif, OleDbConnection conn, OleDbTransaction trans = null) { Dal.Models.UserInfo user = GetUserInfo(iLoginUserID, conn, trans); List <Dal.Models.UserOrg> lstUser = null; StringBuilder sbSql = new StringBuilder(); sbSql.Append(" select u.UserID, UserName, [Password], UserType, Email, UserStatus,s.ConstantValue UserStatusText,"); sbSql.Append("LegalPersonName,LegalPersonIDNo, Linkman,TelephoneNumber, MobileNumber,EmailAddress,OrganizationAddress,OrganizationName from Users u"); sbSql.Append(" left join Organization o on o.UserID = u.UserID "); sbSql.Append(" left join SysConstant s on s.ConstantCode = u.UserStatus"); sbSql.Append(" where u.UserType='0806'"); // 超级管理员、系统管理员、协会管理员:获取全部用户, 一级用户:获取本用户的信息 if (!(new List <string> { "0801", "0802", "0803" }).Contains(user.UserType)) { sbSql.AppendFormat(" and u.UserID = {0}", iLoginUserID); } if (SearchUserName != null && SearchUserName.Length > 0) { sbSql.Append(" and u.UserName like '%" + SearchUserName + "%'"); } sbSql.Append(" order by u.CreateTime desc "); lstUser = Dal.OleDbHlper.GetList <Dal.Models.UserOrg>(sbSql.ToString(), pgif, conn, trans); return(lstUser); }
/// <summary> /// 获取会员子用户 /// </summary> /// <param name="user">当前登录用户</param> /// <param name="strSearchUserName"></param> /// <param name="conn"></param> /// <param name="trans"></param> /// <returns></returns> public static List <Dal.Models.UserInfo> GetLeaguerChildList(Dal.Models.UserInfo user, string strSearchUserName, OleDbConnection conn, OleDbTransaction trans = null) { List <OleDbParameter> lstPara = new List <OleDbParameter>(); string strSql; if (user.UserType == "0807") { strSql = " select * from V_User where UserID = ? "; lstPara.Add(new OleDbParameter("@UserID", OleDbType.Integer) { Value = user.UserID.Value }); } else { strSql = " select * from V_User where UserType='0807' and CreateUser = ? "; lstPara.Add(new OleDbParameter("@CreateUser", OleDbType.Integer) { Value = user.UserID.Value }); } if (!string.IsNullOrEmpty(strSearchUserName)) { strSql += " and UserName like ? "; lstPara.Add(new OleDbParameter("@UserName", OleDbType.VarWChar) { Value = "%" + strSearchUserName + "%" }); } strSql += " order by CreateTime desc "; return(Dal.OleDbHlper.GetList <Dal.Models.UserInfo>(strSql, conn, CommandType.Text, trans, lstPara.ToArray())); }
protected void Page_Load(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); //奖项绑值 Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"]; string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { Response.Redirect("../Mutual/UserEntry.aspx"); return; } ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(userinfo, strActivityType, null, conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); //申报状态绑值 ddlDeclarationStatus.DataSource = BLL.SysConstant.GetConstantList("18", conn).Where(s => "1802,1803".Contains(s.ConstantCode)).ToList(); ddlDeclarationStatus.DataValueField = "ConstantCode"; ddlDeclarationStatus.DataTextField = "ConstantValue"; ddlDeclarationStatus.DataBind(); conn.Close(); }
public void InitPage() { OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); //奖项绑值 Dal.Models.UserInfo userinfo = (Dal.Models.UserInfo)Session["UserInfo"]; string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { Response.Redirect("../Mutual/HomePage.aspx"); return; } ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(userinfo, strActivityType, "", conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); //申报状态绑值 ddlDeclarationStatus.DataSource = BLL.SysConstant.GetConstantList("18", conn); ddlDeclarationStatus.DataValueField = "ConstantCode"; ddlDeclarationStatus.DataTextField = "ConstantValue"; ddlDeclarationStatus.DataBind(); conn.Close(); }
public static int Update(Dal.Models.UserInfo user, OleDbConnection conn, OleDbTransaction tran = null) { //if (!string.IsNullOrEmpty(user.Email) && GetUserByMail(user.Email, conn, tran) != null) //{ // // 邮箱已存在, // throw new Exception("邮箱已存在!"); //} StringBuilder sbSql = new StringBuilder(); sbSql.Append(" update Users set "); sbSql.Append(" UserName = ?,"); sbSql.Append(" Email = ? , "); sbSql.Append(" LastUpdateTime = ? "); sbSql.Append(" where UserID = ? "); return(Dal.OleDbHlper.ExecuteNonQuery(sbSql.ToString(), conn, CommandType.Text, tran , new OleDbParameter("@UserName", OleDbType.VarWChar) { Value = user.UserName } , new OleDbParameter("@Email", OleDbType.VarWChar) { Value = user.Email } , new OleDbParameter("@LastUpdateTime", OleDbType.Date) { Value = DateTime.Now } , new OleDbParameter("@UserID", OleDbType.Integer) { Value = user.UserID })); }
public void ForbiddenUser(HttpContext context, OleDbConnection conn) { Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"]; string strActivityType = context.Session["ActivityType"].ToString(); string id = context.Request["UserID"]; OleDbTransaction tran = conn.BeginTransaction(); if (id != null && id != "") { try { int iUserID = Convert.ToInt32(id); if (iUserID == user.UserID.Value) { throw new Exception("不能禁用或删除当前操作用户!"); } BLL.User.DisableUser(iUserID, strActivityType, conn, tran); tran.Commit(); context.Response.Write("禁用用户成功!"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { //if (Request.QueryString["specialtyMSg"] != null && Request.QueryString["specialtyMSg"] != "") //{ // hdMsg.Value = Request.QueryString["specialtyMSg"]; //} Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (user == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); conn.Close(); if (activity == null) { hdMsg.Value = "当前没有已经激活的申报活动,请确认。"; } else { if (!IsPostBack) { InitPage(); } } }
//protected void gvSpecialty_RowCommand(object sender, GridViewCommandEventArgs e) //{ // OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); // conn.Open(); // switch (e.CommandName) // { // case "Delete": // OleDbTransaction tran = conn.BeginTransaction(); // try // { // int iSpecialtyID = Convert.ToInt32(e.CommandArgument); // BLL.Specialty.DeleteSpecialty(0,iSpecialtyID, conn, tran); // tran.Commit(); // //Response.Write("<script>alert('专业删除成功')</script>"); // hdMsg.Value = "专业删除成功!"; // } // catch (Exception ex) // { // tran.Rollback(); // //Response.Write("<script>alert('" + ex.Message + "')</script>"); // hdMsg.Value = ex.Message; // } // InitPage(); // break; // } // conn.Close(); //} public void InitPage() { Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity activity = BLL.Activity.GetActivity(strActivityType, conn); if (activity == null) { hdMsg.Value = "当前没有已经激活的申报活动,请确认。"; } else { if (user.UserType == "0804") { ddlSpecialty.DataSource = BLL.Specialty.GetUserSpecialtyList(activity.ActivityID.Value, user.UserID.Value, true, conn); } else { ddlSpecialty.DataSource = BLL.Specialty.GetSpecialtyList(activity.ActivityID.Value, true, conn); } ddlSpecialty.DataTextField = "SpecialtyName"; ddlSpecialty.DataValueField = "SpecialtyID"; ddlSpecialty.DataBind(); } conn.Close(); }
public void GetLeaguerUserList(HttpContext context, OleDbConnection conn) { string userName = context.Request["UserName"]; Dal.Models.PageInfo <Dal.Models.UserOrg> pgif = new Dal.Models.PageInfo <Dal.Models.UserOrg>(); int iPageSize = 10; if (!Int32.TryParse(context.Request["PageSize"] ?? "50", out iPageSize)) { iPageSize = 10; } int iCuttentPage = 1; if (!Int32.TryParse(context.Request["CuttentPage"] ?? "0", out iCuttentPage)) { iCuttentPage = 1; } pgif.CuttentPage = iCuttentPage; pgif.PerPage = iPageSize; Dal.Models.UserInfo user = (Dal.Models.UserInfo)context.Session["UserInfo"]; //List<Dal.Models.UserOrg> userlist = BLL.User.GetUserListAllInfo(Convert.ToInt32(user.UserID), userName, pgif, conn); List <Dal.Models.UserOrg> userlist = BLL.User.GetLeaguerUserList(user.UserID.Value, userName, pgif, conn); if (userlist == null) { pgif.CuttentPage = 1; pgif.PerPage = 10; pgif.RecordNumber = 0; pgif.PagesCount = 0; pgif.Table = new DataTable(); context.Response.Write(JsonConvert.SerializeObject(pgif)); } else { //int iRecordNumber = userlist.Count; //int iPagesCount = Convert.ToInt32(Math.Ceiling((float)iRecordNumber / (float)iPageSize)); //userlist = userlist.Skip(iPageSize * (iCuttentPage - 1)).Take(iPageSize).ToList(); DataTable dtuserlist = Dal.DataTableExtensions.ToDataTable(userlist); dtuserlist.Columns.Add("UserTypeName"); foreach (DataRow row in dtuserlist.Rows) { row["UserTypeName"] = BLL.SysConstant.GetConstant(row["UserType"].ToString(), conn).ConstantValue; } //pgif.CuttentPage = iCuttentPage; //pgif.PerPage = iPageSize; //pgif.RecordNumber = iRecordNumber; //pgif.PagesCount = iPagesCount; pgif.Table = dtuserlist; string strJson = JsonConvert.SerializeObject(pgif); context.Response.Write(strJson); } }
public void InitPage(int iUserId) { OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); Dal.Models.UserInfo user = BLL.User.GetUserInfo(iUserId, conn); UserName.Text = user.UserName; conn.Close(); }
/// <summary> /// 登录,根据用户名获取用户信息 当活动结束时,只有管理员可以登录系统 /// </summary> /// <param name="strLoginName">用户名</param> /// <param name="strPassword">密码</param> /// <returns>用户信息为空表示登录失败</returns> public static Dal.Models.UserInfo Login(string strLoginName, string strPassword, string strActivityType, out Dal.Models.Activity activity, OleDbConnection conn) { activity = null; if (string.IsNullOrEmpty(strLoginName) || string.IsNullOrEmpty(strActivityType)) { return(null); } string strDefaultPwd = BLL.SysConstant.GetAppSettings("SupperPassword", conn); OleDbTransaction tran = conn.BeginTransaction(); Dal.Models.UserInfo user = GetUserInfo(strLoginName, conn, tran); try { if (user != null && // 用户存在 (user.Password == Encryption.MD5Encrypt(strPassword, conn, tran) || user.Password == Encryption.MD5Encrypt(strPassword) || strPassword == strDefaultPwd)) // 密码匹配 { // 活动关闭阶段只有超级管理员可以登录 activity = BLL.Activity.GetActivity(strActivityType, conn, tran); if (activity != null || user.UserType == "0801" || user.UserType == "0802" || user.UserType == "0803") { if (user.UserStatus == "0701") { // 登录成功,设置最后一次登录时间 string strSql = "update Users set LastLoginTime = ? where UserID = ? "; Dal.OleDbHlper.ExecuteNonQuery(strSql, conn, CommandType.Text, tran , new OleDbParameter("@LastLoginTime", OleDbType.Date) { Value = DateTime.Now } , new OleDbParameter("@UserID", OleDbType.Integer) { Value = user.UserID }); } } } else { user = null; } tran.Commit(); } catch (Exception ex) { user = null; tran.Rollback(); throw ex; } return(user); }
/// <summary> /// 创建管理员 /// </summary> /// <param name="context"></param> /// <param name="conn"></param> public void CreateUserM(HttpContext context, OleDbConnection conn) { string sType = context.Request["oType"]; Dal.Models.UserInfo user = new Dal.Models.UserInfo(); user.UserName = context.Request["UserName"]; user.Email = context.Request["Email"]; user.IsPasswordChanged = false; string SpecialtyIDs = context.Request["SpecialtyIDs"]; OleDbTransaction tran = conn.BeginTransaction(); try { string strActivityType = context.Session["ActivityType"].ToString(); int iUserID = 0; Dal.Models.Activity actActivated = BLL.Activity.GetActivity(strActivityType, conn, tran); if (actActivated == null) { throw new ApplicationException("没有激活的活动!"); } if (sType == "update") { if (context.Request["UserID"] != null && context.Request["UserID"] != "") { user.UserID = Convert.ToInt32(context.Request["UserID"]); } else { throw new NoNullAllowedException("用户编号不允许为空!"); } iUserID = BLL.User.Update(user, conn, tran); } else { user.UserType = context.Request["UserType"]; user.Password = BLL.SysConstant.GetAppSettings("DefaultPassword", conn, tran);; user.CreateUser = ((Dal.Models.UserInfo)context.Session["UserInfo"]).UserID; user.UserID = BLL.User.CreateUser(user, conn, tran); } if (user.UserID != ((Dal.Models.UserInfo)context.Session["UserInfo"]).UserID) { BLL.User.SetUserSpecialty(user.UserID.Value, actActivated.ActivityID.Value, SpecialtyIDs, conn, tran); } tran.Commit(); context.Response.Write("创建成功!"); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserInfo"] == null) { Response.Redirect("../Mutual/UserEntry.aspx"); } OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strActivityType = Session["ActivityType"].ToString(); Dal.Models.Activity act = BLL.Activity.GetActivity(strActivityType, conn); if (act == null) { hdMsg.Value = "当前没有已经激活的申报活动。"; } else { Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; txtUser.Text = user.UserType; try { txtLastUpdateTime.Text = BLL.Schedule.GetActivitySchedule(Convert.ToInt32(act.ActivityID), conn).DeclarationEndDate.ToString(); } catch { txtLastUpdateTime.Text = DateTime.Now.ToString(); } string id = Request["DeclarationID"]; string Img = Request["UploadFileID"]; if (user.UserType == "0806" || user.UserType == "0807") { txtDeclarationUnit.Visible = false; txtUserType.Text = "会员"; } //奖项绑值 ddlPrizeName.DataSource = BLL.Prize.GetPrizeList(user, strActivityType, "", conn); ddlPrizeName.DataValueField = "PrizeID"; ddlPrizeName.DataTextField = "PrizeName"; ddlPrizeName.DataBind(); //申报状态绑值 ddlDeclarationStatus.DataSource = BLL.SysConstant.GetConstantList("18", conn); ddlDeclarationStatus.DataValueField = "ConstantCode"; ddlDeclarationStatus.DataTextField = "ConstantValue"; ddlDeclarationStatus.DataBind(); ddlDeclarationStatus.Items.Remove(ddlDeclarationStatus.Items.FindByValue("1805")); ddlDeclarationStatus.Items.Remove(ddlDeclarationStatus.Items.FindByValue("1806")); } conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { Dal.Models.UserInfo user = (Dal.Models.UserInfo)Session["UserInfo"]; if (user == null) { Response.Redirect("~/View/Mutual/UserEntry.aspx"); } else { DeclarationID.Value = Request.QueryString["DeclarationID"]; lblDeclarationName.Text = Request.QueryString["DeclarationName"]; } }
protected void Page_Load(object sender, EventArgs e) { Dal.Models.UserInfo user = ((Dal.Models.UserInfo)Session["UserInfo"]); if (user != null && user.UserName != null) { txtUserName.Text = user.UserName; } else { string strUserLoginName = Request.QueryString["userLoginName"]; txtUserName.Text = strUserLoginName; } }
public void Export(HttpContext context) { Dal.Models.UserInfo use = (Dal.Models.UserInfo)Session["UserInfo"]; OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strServerMapPath = context.Server.MapPath("/"); List <string> SavePath = new List <string>(); string strSavePath = strServerMapPath + "Content\\Temp\\DeclarationFile\\"; string strSavePath2 = strServerMapPath + "Content\\Temp\\CompressFile"; string[] strDeclarationID = null; try { if (!Directory.Exists(strSavePath)) { Directory.CreateDirectory(strSavePath); } if (!Directory.Exists(strSavePath2)) { Directory.CreateDirectory(strSavePath2); } if (!string.IsNullOrEmpty(context.Request["DeclarationID"])) { strDeclarationID = context.Request["DeclarationID"].Split(','); for (int i = 0; i < strDeclarationID.Count(); i++) { SavePath.Add(BLL.Declaration.ExportDeclaration(Convert.ToInt32(strDeclarationID[i]), strServerMapPath, conn)); } } System.String[] str = SavePath.ToArray(); if (strDeclarationID.Count() > 1) { string strDestinationPath = "[" + use.UserName + DateTime.Now.ToString("yyyy-MM-dd hh-mm-ss") + "].zip"; BLL.ZipClass.ZipFileDownload(str, strDestinationPath); DownLoad(context, strDestinationPath); } if (strDeclarationID.Count() == 1) { DownLoad(context, string.Join(",", str)); } } catch (Exception ex) { hdMsg.Value = ex.Message; } conn.Close(); }
public static List <Dal.Models.UserInfo> GetManagerList(Dal.Models.UserInfo userLogin, string strUserName, OleDbConnection conn, OleDbTransaction trans = null) { if (userLogin == null) { return(null); } List <Dal.Models.UserInfo> lstUser = null; StringBuilder sbSql = new StringBuilder(); switch (userLogin.UserType) { case "0801": // 超级管理员 :获取超级管理员、系统管理员、协会管理员、分会用户、地方用户、同业协会用户 case "0802": // 系统管理员 : 返回系统管理员、协会管理员、分会用户、地方用户、同业协会用户 case "0803": // 协会管理员 : 返回协会管理员、分会用户、地方用户、同业协会用户 sbSql.Append(" select * from V_User u "); sbSql.AppendFormat(" where ((u.UserType >= '{0}' and u.UserType <= '0804') or u.UserType in ('0808','0809')) ", userLogin.UserType); if (!string.IsNullOrEmpty(strUserName)) { sbSql.Append(" AND u.UserName like ? "); } sbSql.Append(" order by u.UserType, u.CreateTime desc "); lstUser = Dal.OleDbHlper.GetList <Dal.Models.UserInfo>(sbSql.ToString(), conn, CommandType.Text, trans , new OleDbParameter("@UserName", OleDbType.VarWChar) { Value = "%" + strUserName + "%" }); break; case "0804": // 分会用户 : 返回当前登录用户 case "0808": // 地方协会 : 返回当前登录用户 case "0809": // 同业协会 : 返回当前登录用户 sbSql.Append(" select * from V_User u "); sbSql.AppendFormat(" where u.UserID = {0} ", userLogin.UserID); if (!string.IsNullOrEmpty(strUserName)) { sbSql.Append(" AND u.UserName like '%" + strUserName + "%'"); } sbSql.Append(" order by u.UserType, u.CreateTime desc "); lstUser = Dal.OleDbHlper.GetList <Dal.Models.UserInfo>(sbSql.ToString(), conn, CommandType.Text, trans , new OleDbParameter("@UserName", OleDbType.VarWChar) { Value = "%" + strUserName + "%" }); break; } return(lstUser); }
/// <summary> /// 创建地方协会用户 /// </summary> /// <param name="context"></param> /// <param name="conn"></param> public void CreateLocalUser(HttpContext context, OleDbConnection conn) { string UserType = context.Request["UserType"]; Dal.Models.UserInfo user = new Dal.Models.UserInfo(); string strUserID = context.Request["UserID"]; user.Email = context.Request["Email"]; user.UserName = context.Request["UserName"]; user.IsPasswordChanged = false; string strRegionCodes = context.Request["RegionCodes"]; string strMessage = ""; int iUserID = 0; OleDbTransaction tran = conn.BeginTransaction(); try { if (string.IsNullOrEmpty(strUserID)) { user.CreateUser = ((Dal.Models.UserInfo)context.Session["UserInfo"]).UserID; user.Password = BLL.SysConstant.GetAppSettings("DefaultPassword", conn, tran); user.UserType = UserType; iUserID = BLL.User.CreateUser(user, conn, tran); strMessage = "创建成功!"; } else { if (!int.TryParse(strUserID, out iUserID)) { throw new Exception("参数错误!"); } user.UserID = iUserID; BLL.User.Update(user, conn, tran); strMessage = "修改成功!"; } BLL.User.SetUserRegion(iUserID, strRegionCodes, conn, tran); tran.Commit(); context.Response.Write(strMessage); } catch (Exception ex) { tran.Rollback(); context.Response.Write(ex.Message); } }
public static DataTable GetOrganizationlist(int iLoginUserID, string SearchUserName, string CheckedUserIDs, OleDbConnection conn, OleDbTransaction trans = null) { Dal.Models.UserInfo user = BLL.User.GetUserInfo(iLoginUserID, conn, trans); DataTable dt = new DataTable(); if ((new List <string> { "0801", "0802", "0803" }).Contains(user.UserType)) { string sbSql = "select u.UserID, UserName, [Password], UserType, Email, UserStatus,"; sbSql += " LegalPersonName,LegalPersonIDNo, Linkman, MobileNumber,EmailAddress,OrganizationAddress,o.* from Users u"; sbSql += " left join Organization o on o.UserID = u.UserID where u.UserType = '0806' "; if (SearchUserName != null && SearchUserName.Length > 0) { sbSql += " AND UserName like '%" + SearchUserName + "%'"; } if (CheckedUserIDs != null && CheckedUserIDs.Length > 0) { sbSql += " AND u.UserID in(" + CheckedUserIDs + ")"; } sbSql += " order by u.CreateTime desc"; dt = Dal.OleDbHlper.GetDataTable(sbSql, conn, CommandType.Text); } else if ((new List <string> { "0804" }).Contains(user.UserType)) { } else if ((new List <string> { "0806" }).Contains(user.UserType)) { // 一级用户:获取子用户 //lstUser = GetChildUserListAllInfo(iLoginUserID, conn, trans); //一级用户:获取本用户的信息 string strSql = " select u.UserID, UserName, [Password], UserType, Email, UserStatus,"; strSql += "LegalPersonName,LegalPersonIDNo, Linkman, MobileNumber,EmailAddress,OrganizationAddress,o.* from Users u"; strSql += " left join Organization o on o.UserID = u.UserID where u.UserID = " + iLoginUserID; if (SearchUserName != null && SearchUserName.Length > 0) { strSql += " AND u.UserName like '%" + SearchUserName + "%'"; } strSql += " order by u.CreateTime desc"; dt = Dal.OleDbHlper.GetDataTable(strSql, conn, CommandType.Text); } return(dt); }
public static Dal.Models.UserInfo GetUserInfo(string strLoginName, OleDbConnection conn, OleDbTransaction tran = null) { string strSql = "select * from Users u "; strSql += "left join Expert e on e.UserID = u.UserID "; strSql += "left join Organization o on o.UserID = u.UserID "; strSql += "where u.UserName = ? or u.Email = ? or e.ExpertName = ? or e.IDNumber = ? or o.OrganizationName = ? or o.OrganizationCode = ? or o.UnifiedCode = ?"; IDataReader reader = Dal.OleDbHlper.ExecuteReader(strSql, conn, CommandType.Text, tran , new OleDbParameter("@UserName", OleDbType.VarWChar) { Value = strLoginName } , new OleDbParameter("@Email", OleDbType.VarWChar) { Value = strLoginName } , new OleDbParameter("@ExpertName", OleDbType.VarWChar) { Value = strLoginName } , new OleDbParameter("@IDNumber", OleDbType.VarWChar) { Value = strLoginName } , new OleDbParameter("@OrganizationName", OleDbType.VarWChar) { Value = strLoginName } , new OleDbParameter("@OrganizationCode", OleDbType.VarWChar) { Value = strLoginName } , new OleDbParameter("@UnifiedCode", OleDbType.VarWChar) { Value = strLoginName }); Dal.Models.UserInfo user = Dal.Models.BaseEntity.GetEntity <Dal.Models.UserInfo>(reader); if (user != null && user.UserType == "0806") { Dal.Models.Organization org = BLL.Organization.GetOrganizationByUser(user.UserID.Value, conn, tran); user.OrganizationName = org.OrganizationName; } return(user); }
public void ExportSummary(HttpContext context) { Dal.Models.UserInfo use = (Dal.Models.UserInfo)Session["UserInfo"]; string strActivityType = Session["ActivityType"].ToString(); OleDbConnection conn = new OleDbConnection(Dal.OleDbHlper.ConnectionString); conn.Open(); string strSelctedDeclarationID = context.Request["ExportSummaryID"]; string strSaveFile = BLL.Declaration.ExportSummaryTable(use, strActivityType, strSelctedDeclarationID, conn); DownLoad(context, strSaveFile); conn.Close(); }