/// <summary> /// 增加一条数据 /// </summary> public bool Add(ITC_Userinfo_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ITC_Userinfo("); strSql.Append("User_ID,User_Mobile,User_Createdtime,User_Status,User_Oprt,User_Remark,Orga_ID,User_Account,User_Pwd,User_Name,User_Spelling,User_Sex,User_Email,User_Tel"); strSql.Append(") values ("); strSql.Append("@User_ID,@User_Mobile,@User_Createdtime,@User_Status,@User_Oprt,@User_Remark,@Orga_ID,@User_Account,@User_Pwd,@User_Name,@User_Spelling,@User_Sex,@User_Email,@User_Tel"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@User_ID", SqlDbType.Char, 8), new SqlParameter("@User_Mobile", SqlDbType.VarChar, 15), new SqlParameter("@User_Createdtime", SqlDbType.DateTime), new SqlParameter("@User_Status", SqlDbType.Int, 4), new SqlParameter("@User_Oprt", SqlDbType.VarChar, 50), new SqlParameter("@User_Remark", SqlDbType.VarChar, 500), new SqlParameter("@Orga_ID", SqlDbType.Char, 8), new SqlParameter("@User_Account", SqlDbType.VarChar, 50), new SqlParameter("@User_Pwd", SqlDbType.VarChar, 50), new SqlParameter("@User_Name", SqlDbType.VarChar, 50), new SqlParameter("@User_Spelling", SqlDbType.VarChar, 50), new SqlParameter("@User_Sex", SqlDbType.Bit, 1), new SqlParameter("@User_Email", SqlDbType.VarChar, 50), new SqlParameter("@User_Tel", SqlDbType.VarChar, 15) }; parameters[0].Value = model.User_ID; parameters[1].Value = model.User_Mobile; parameters[2].Value = model.User_Createdtime; parameters[3].Value = model.User_Status; parameters[4].Value = model.User_Oprt; parameters[5].Value = model.User_Remark; parameters[6].Value = model.Orga_ID; parameters[7].Value = model.User_Account; parameters[8].Value = model.User_Pwd; parameters[9].Value = model.User_Name; parameters[10].Value = model.User_Spelling; parameters[11].Value = model.User_Sex; parameters[12].Value = model.User_Email; parameters[13].Value = model.User_Tel; int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (result > 0) { return(true); } else { return(false); } }
/// <summary> /// 初始化用户信息、菜单操作权限 /// </summary> /// <param name="id"></param> public static void Init(string userid) { if (userid != null && userid != "") { ITC_Userinfo usr = new ITC_Userinfo(); ITC_Userinfo_M model_usr = usr.GetModel(userid); if (model_usr != null) { System.Web.HttpContext.Current.Session[SessionKeys.UserID.ToString()] = model_usr.User_ID; System.Web.HttpContext.Current.Session[SessionKeys.UserName.ToString()] = model_usr.User_Name; System.Web.HttpContext.Current.Session[SessionKeys.OrgaID.ToString()] = model_usr.Orga_ID; System.Web.HttpContext.Current.Session[SessionKeys.Power.ToString()] = usr.GetUserRoleOperater(model_usr.User_ID); System.Web.HttpContext.Current.Session[SessionKeys.Orgas.ToString()] = usr.GetOrgaIDs(model_usr.User_ID); } } }
private List <ITC_Userinfo_M> DsToList(DataSet ds) { List <ITC_Userinfo_M> list = new List <ITC_Userinfo_M>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { ITC_Userinfo_M model = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new ITC_Userinfo_M(); model.User_ID = ds.Tables[0].Rows[i]["User_ID"].ToString().Trim(); model.User_Mobile = ds.Tables[0].Rows[i]["User_Mobile"].ToString(); if (ds.Tables[0].Rows[i]["User_Createdtime"].ToString() != "") { model.User_Createdtime = DateTime.Parse(ds.Tables[0].Rows[i]["User_Createdtime"].ToString()); } if (ds.Tables[0].Rows[i]["User_Status"].ToString() != "") { model.User_Status = int.Parse(ds.Tables[0].Rows[i]["User_Status"].ToString()); } model.User_Oprt = ds.Tables[0].Rows[i]["User_Oprt"].ToString(); model.User_Remark = ds.Tables[0].Rows[i]["User_Remark"].ToString(); model.Orga_ID = ds.Tables[0].Rows[i]["Orga_ID"].ToString().Trim(); model.User_Account = ds.Tables[0].Rows[i]["User_Account"].ToString(); model.User_Pwd = ds.Tables[0].Rows[i]["User_Pwd"].ToString(); model.User_Name = ds.Tables[0].Rows[i]["User_Name"].ToString(); model.User_Spelling = ds.Tables[0].Rows[i]["User_Spelling"].ToString(); if (ds.Tables[0].Rows[i]["User_Sex"].ToString() != "") { if ((ds.Tables[0].Rows[i]["User_Sex"].ToString() == "1") || (ds.Tables[0].Rows[i]["User_Sex"].ToString().ToLower() == "true")) { model.User_Sex = true; } else { model.User_Sex = false; } } model.User_Email = ds.Tables[0].Rows[i]["User_Email"].ToString(); model.User_Tel = ds.Tables[0].Rows[i]["User_Tel"].ToString(); list.Add(model); } } return(list); }
/// <summary> /// 登录验证 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult DL(ITC_Userinfo_M model) { if (!string.IsNullOrEmpty(model.User_ID) && !string.IsNullOrEmpty(model.User_Pwd)) { ITC_Userinfo bll = new ITC_Userinfo(); model.User_Pwd = bll.pwEcncrystr(model.User_Pwd); if (bll.Exists(model.User_ID, model.User_Pwd)) { UserContext.Init(model.User_ID); //设置登录cookie,名称为:SdlCookie HttpCookie SdlCookie = new HttpCookie("SdlCookie"); //EmpNo:登录工号 SdlCookie["EmpNo"] = UserContext.UserID; //EmpName:姓名 SdlCookie["EmpName"] = System.Web.HttpContext.Current.Server.UrlEncode(UserContext.UserName); //LastLoginTime:上次登录日期 //LastLoginIP:上次登录IP if (false) { //SdlCookie["LastLoginTime"] = model_log_last.Entry.ToString(); //SdlCookie["LastLoginIP"] = model_log_last.IP; } else { SdlCookie["LastLoginTime"] = ""; SdlCookie["LastLoginIP"] = ""; } System.Web.HttpContext.Current.Response.Cookies.Add(SdlCookie); return(RedirectToAction("Index", "Home")); } else { ViewBag.message = "帐号和密码不正确!请重新输入!"; ViewBag.SysName = "盒子系统"; return(View("Index")); } } else { ViewBag.message = "请输入帐号和密码!"; ViewBag.SysName = "盒子系统"; return(View("Index")); } }
//保存用户角色 public ActionResult SaveRoles(FormCollection collection) { string userid = Request["userid"]; if (!string.IsNullOrEmpty(userid)) { //删除角色 部门范围 uifo.DeleteRoles(userid); uifo.DeleteRoleRange(userid); if (collection.Count > 0) { string roleid = ""; string orgaid = ""; for (int i = 0; i < collection.Count; i++) { string key = collection.Keys[i]; string value = collection[i]; roleid = key.Split('|')[0]; orgaid = key.Split('|')[1]; //添加角色 部门范围 if (value == "on") { uifo.AddRoles(userid, roleid); uifo.AddRoleRange(userid, roleid, orgaid); } } } ITC_Userinfo_M model = uifo.GetModel(userid); model.User_Oprt = Session["username"].ToString(); model.User_Createdtime = DateTime.Now; uifo.Update(model); EventContext.Add(MenuID, string.Format("分配角色:{0}", userid)); return(Content("保存成功!")); } else { return(Content("参数错误!")); } }
//编辑保存 public ActionResult SaveEdit(ITC_Userinfo_M model) { model.User_Createdtime = DateTime.Now; model.User_Account = model.User_ID.Trim(); model.User_Oprt = UserContext.UserName; if (uifo.Exists(model.User_ID)) { if (uifo.Update(model)) { EventContext.Add(MenuID, string.Format("修改:{0}", model.User_ID)); return(Content("保存成功!")); } else { return(Content("保存失败!")); } } else { return(Content("保存失败! 编码[" + model.User_ID + "]不存在!")); } }
//添加保存 public ActionResult SaveAdd(ITC_Userinfo_M model) { model.User_Createdtime = DateTime.Now; model.User_Pwd = uifo.pwEcncrystr("123456");//加密 model.User_Account = model.User_ID.Trim(); model.User_Oprt = UserContext.UserName; if (!uifo.Exists(model.User_ID)) { if (uifo.Add(model)) { EventContext.Add(MenuID, string.Format("添加:{0}", model.User_ID)); return(Content("保存成功!")); } else { return(Content("保存失败!")); } } else { return(Content("保存失败! 编码[" + model.User_ID + "]已存在!")); } }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(ITC_Userinfo_M model) { return(dal.Update(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(ITC_Userinfo_M model) { return(dal.Add(model)); }
/// <summary> /// 获取用户名称 /// </summary> /// <param name="userid"></param> /// <returns></returns> public string GetUserName(string userid) { ITC_Userinfo_M model = GetModel(userid); return(model != null ? model.User_Name : ""); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ITC_Userinfo_M model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ITC_Userinfo set "); strSql.Append(" User_Mobile = @User_Mobile , "); strSql.Append(" User_Createdtime = @User_Createdtime , "); strSql.Append(" User_Status = @User_Status , "); strSql.Append(" User_Oprt = @User_Oprt , "); strSql.Append(" User_Remark = @User_Remark , "); strSql.Append(" Orga_ID = @Orga_ID , "); strSql.Append(" User_Account = @User_Account , "); //strSql.Append(" User_Pwd = @User_Pwd , "); strSql.Append(" User_Name = @User_Name , "); strSql.Append(" User_Spelling = @User_Spelling , "); strSql.Append(" User_Sex = @User_Sex , "); strSql.Append(" User_Email = @User_Email , "); strSql.Append(" User_Tel = @User_Tel "); strSql.Append(" where User_ID=@User_ID "); SqlParameter[] parameters = { new SqlParameter("@User_ID", SqlDbType.Char, 8), new SqlParameter("@User_Mobile", SqlDbType.VarChar, 15), new SqlParameter("@User_Createdtime", SqlDbType.DateTime), new SqlParameter("@User_Status", SqlDbType.Int, 4), new SqlParameter("@User_Oprt", SqlDbType.VarChar, 50), new SqlParameter("@User_Remark", SqlDbType.VarChar, 500), new SqlParameter("@Orga_ID", SqlDbType.Char, 8), new SqlParameter("@User_Account", SqlDbType.VarChar, 50), new SqlParameter("@User_Pwd", SqlDbType.VarChar, 50), new SqlParameter("@User_Name", SqlDbType.VarChar, 50), new SqlParameter("@User_Spelling", SqlDbType.VarChar, 50), new SqlParameter("@User_Sex", SqlDbType.Bit, 1), new SqlParameter("@User_Email", SqlDbType.VarChar, 50), new SqlParameter("@User_Tel", SqlDbType.VarChar, 15) }; parameters[0].Value = model.User_ID; parameters[1].Value = model.User_Mobile; parameters[2].Value = model.User_Createdtime; parameters[3].Value = model.User_Status; parameters[4].Value = model.User_Oprt; parameters[5].Value = model.User_Remark; parameters[6].Value = model.Orga_ID; parameters[7].Value = model.User_Account; parameters[8].Value = model.User_Pwd; parameters[9].Value = model.User_Name; parameters[10].Value = model.User_Spelling; parameters[11].Value = model.User_Sex; parameters[12].Value = model.User_Email; parameters[13].Value = model.User_Tel; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
//获取模型 public ActionResult GetModel(string id) { ITC_Userinfo_M mo = uifo.GetModel(id); return(Json(mo, JsonRequestBehavior.AllowGet)); }