///// <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();
}
