protected void Page_Load(object sender, EventArgs e)
{
if (Session["IsLogin"] == "false")
{
Response.Redirect("Login.aspx");
}
userDAL = new User_DAL();
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Session["IsLogin"] == "false")
//{
// Response.Redirect("Login.aspx");
//}
dal = new User_DAL();
}
//public DataTable ViewByDistributer_ID(int DistributerID)
//{
// objUserDAL = new User_DAL(objCompanyProperty);
// return objUserDAL.SelectByDistributerID(DistributerID);
//}
public DataTable ViewAll(string xmlpath)
{
// load your xml file (this one is named people and it is in my App_Data folder)
XElement x = XElement.Load(xmlpath);//get your file
// declare a new DataTable and pass your XElement to it
objUserDAL = new User_DAL(objUserProperty);
return(objUserDAL.XElementToDataTable(x));
}
protected void Page_Load(object sender, EventArgs e)
{
// creating object of User_DAL class
dal = new User_DAL();
// control will go inside if block when postback happens for the 1st time
if (!IsPostBack)
{
if (Request.Cookies["UserID"] != null)
{
txtUserID.Text = Request.Cookies["UserID"].Value;
chkRememberMe.Checked = true;
}
}
}
public ActionResult Login(Models.User user)
{
if (ModelState.IsValid)
{
IUser_DAL dalUser = new User_DAL();
user = dalUser.IsValid(user.UserName, user.Password);
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.UserName, false);
if (user.CUId <= 0 & user.DelId <= 0)
{
Session["UserRole"] = 0;
}
else
{
if (user.CUId > 0)
{
Session["UserRole"] = 1;
}
else
{
Session["UserRole"] = 2;
}
}
Session["userid"] = user.id;
Session["cuid"] = user.CUId;
Session["dealerid"] = user.DelId;
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Login data is incorrect!");
}
}
return(View(user));
}
public ActionResult LoginUser(string UserName, string Password)
{
IUser_DAL dalUser = new User_DAL();
User user = dalUser.IsValid(UserName, Password);
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.UserName, false);
if (user.CUId <= 0 & user.DelId <= 0)
{
Session["UserRole"] = 0;
Session["userid"] = user.id;
Session["cuid"] = 0;
Session["dealerid"] = 0;
}
else
{
if (user.CUId > 0)
{
Session["UserRole"] = 1;
}
else
{
Session["UserRole"] = 2;
}
Session["userid"] = user.id;
Session["cuid"] = user.CUId;
Session["dealerid"] = user.DelId;
}
}
else
{
ModelState.AddModelError("", "Social Security number and last name both required information!");
}
return(RedirectToAction("Index", "Home"));
}
/// <summary>
/// 按指定条件删除用户
/// </summary>
/// <param name="sql"></param>
public static void Delete_UserByCondition(string sql)
{
User_DAL.Delete_UserByCondition(sql);
}
/// <summary>
/// 删除用户对象
/// </summary>
/// <param name="uo"></param>
/// <returns></returns>
public static int DeleteUserByObject(UsersObject uo)
{
int a = User_DAL.DeleteUserByObject(uo);
return a;
}
public DataTable GetById()
{
objUserDAL = new User_DAL(objUserProperty);
return(objUserDAL.SelectById());
}
public DataTable ViewAll()
{
objUserDAl = new User_DAL(objUserProperty);
return(objUserDAl.SelectAll());
}
public bool Insert()
{
objUserDAl = new User_DAL(objUserProperty);
return(objUserDAl.Insert());
}
/// <summary>
/// 获取用户权限
/// </summary>
/// <param name="sql"></param>
public static DataTable GetUserPower(string sql)
{
DataTable dt = User_DAL.GetUserPower(sql);
return dt;
}
/// <summary>
/// 根据条件查询多个用户
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static List<UsersObject> GetUserByCondition(string sql)
{
List<UsersObject> uo = User_DAL.GetUserByCondition(sql);
return uo;
}
public DataTable CheckUser(string Name, string Password)
{
User_DAL user = new User_DAL();
return(user.CheckUser(Name, Password));
}
/// <summary>
/// 保存用户的权限
/// </summary>
public static void Save_Power(string sql_power, string sql_name)
{
User_DAL.Save_Power(sql_name, sql_power);
}
public DataTable SelectBranch()
{
objUserDAL = new User_DAL(objUserProperty);
return(objUserDAL.SelectByBranchId());
}
public bool Delete(int?id)
{
objUserDAL = new User_DAL(objUserProperty);
return(objUserDAL.Delete(id));
}
public bool Update()
{
objUserDAL = new User_DAL(objUserProperty);
return(objUserDAL.Update());
}
/// <summary>
/// 增加用户
/// </summary>
/// <param name="uo"></param>
/// <returns></returns>
public static int AddUser(UsersObject uo)
{
int a = User_DAL.AddUser(uo);
return a;
}
/// <summary>
/// 设置用户身份为管理员
/// </summary>
/// <param name="sql"></param>
public static void SetUserAdmin(string sql)
{
User_DAL.SetUserPower(sql);
}
/// <summary>
/// 更新员工
/// </summary>
/// <param name="uo"></param>
/// <returns></returns>
public static int UpdateUser(UsersObject uo)
{
int a = User_DAL.UpdateUser(uo);
return a;
}
/// <summary>
/// 设置用户身份为普通用户
/// </summary>
/// <param name="sql"></param>
public static void SetUserNormal(string sql)
{
User_DAL.SetUserNormal(sql);
}
/// <summary>
/// 根据条件查询单个用户
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static UsersObject GetOneUserByCondition(string sql)
{
UsersObject uo = User_DAL.GetOneUserByCondition(sql);
return uo;
}
public User_BLL()
{
_objUserDAL = new User_DAL();
_objUserLoginVM = null;
}
public DataTable GetAllUsers()
{
objUserDAl = new User_DAL(objUserProperty);
return(objUserDAl.GetAllUsers());
}
/// <summary>
/// 查询所有用户除超级管理员
/// </summary>
/// <returns></returns>
public static DataTable GetAllUserX()
{
DataTable dt = User_DAL.GetAllUsersX();
return dt;
}
public DataTable CheckUserExistance()
{
objUserDAl = new User_DAL(objUserProperty);
return(objUserDAl.CheckUserExistance());
}
/// <summary>
/// 根据条件删除用户
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static int DeleteUser(string sql)
{
int a= User_DAL.DeleteUserByCondition(sql);
return a;
}
/// <summary>
/// 查询所有用户
/// </summary>
/// <returns></returns>
public static List<UsersObject> GetAllUser()
{
IEnumerable<UsersObject> userObjects = User_DAL.GetAllUsers();
return userObjects.ToList();
}
//public DataTable MainBranch()
//{
// objUserDAL = new User_DAL(objUserProperty);
// return objUserDAL.SelectAllMainBranch();
//}
public DataTable SelectByIDPassword()
{
objUserDAL = new User_DAL(objUserProperty);
return(objUserDAL.SelectByIDPassword());
}
