public ActionResult Create(string Id = null) { var resultMsg = string.Empty; var model = new ModelUser(); if (!string.IsNullOrWhiteSpace(Id)) { LogicUser logic = new LogicUser(); model = logic.UserDetail(out resultMsg,base.AuthorizeInfo, int.Parse(Id)); ViewBag.Orgs = GetOrgs(model.Organization.ToString()); } else { ViewBag.Orgs = GetOrgs(); } return View(model); }
public ActionResult Login(ModelUser user) { var resultMsg = string.Empty; var logic = new LogicUser(); var model = logic.UserDetail(out resultMsg,base.AuthorizeInfo, user.Account); if (model != null && user.Account.ToLower().Equals("admin") && model.Account.ToLower().Equals(user.Account.ToLower()) && model.Password.Equals(user.Password)) { Session["admin"] = model.Account; ViewBag.CustomScript = UtilityScript.ShowMessage("登录成功!", isCreate: true, isSuccess: true, funName: "Goto"); } else { Session["admin"] = null; ViewBag.CustomScript = UtilityScript.ShowMessage("登录失败!", isCreate: true, isSuccess: false); } return View(user); }
public ActionResult Create(ModelUser model) { var resultMsg = string.Empty; var result = new ResultBase(); ViewBag.Orgs = GetOrgs(model.Organization.ToString()); var logic = new LogicUser(); model.Status = 1; var res = logic.UserInsertUpdate(out resultMsg,base.AuthorizeInfo, model); if (res > 0 || resultMsg.Contains(BaseDict.SuccessPrefix)) { resultMsg = "操作成功!"; ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true, funName: "Goto"); } else { resultMsg = string.IsNullOrWhiteSpace(resultMsg) ? "操作失败,请检查数据是否正确后重新操作!" : resultMsg.Replace(BaseDict.ErrorPrefix,""); ViewBag.CustomScript = UtilityScript.ShowMessage(resultMsg, isCreate: true, isSuccess: true, funName: "BtnShow"); } return View(model); }
/// <summary> /// Model ��ֵ IDataReader /// </summary> private IList<ModelUser> GetModel(IDataReader dr) { var modelList = new List<ModelUser>(); while (dr.Read()) { var model = new ModelUser(); model.Id = dr["Id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Id"]); model.Name = dr["Name"] == DBNull.Value ? string.Empty : dr["Name"].ToString(); model.Account = dr["Account"] == DBNull.Value ? string.Empty : dr["Account"].ToString(); model.Password = dr["PassWord"] == DBNull.Value ? string.Empty : dr["PassWord"].ToString(); model.Organization = dr["Organization"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Organization"]); model.Status = dr["Status"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Status"]); model.Permissions = dr["Permissions"] == DBNull.Value ? string.Empty : dr["Permissions"].ToString(); model.Createdate = dr["CreateDate"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["CreateDate"]); modelList.Add(model); } return modelList; }
/// <summary> /// ���� ���/���� /// </summary> /// <param name="user">ʵ��</param> /// <returns>ִ�н��</returns> public int UserInsertUpdate(out string resultMsg, ModelUser user, DbTransaction tran = null) { resultMsg = string.Empty; int res = 0; try { //�洢�������� string sql = "USP_USER_INSERT_UPDATE"; //������� IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = user.Id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "NAME", ParameterValue = user.Name, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "ACCOUNT", ParameterValue = user.Account, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "PASSWORD", ParameterValue = user.Password, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "ORGANIZATION", ParameterValue = user.Organization, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "STATUS", ParameterValue = user.Status, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); parm.Add(new DBParameter() { ParameterName = "PERMISSIONS", ParameterValue = user.Permissions, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "resultMsg", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String }); //����/����ִ�� res = DBHelper.ExecuteNonQuery(sql, true, parm, tran); foreach (var item in parm) { //��ȡ�������ֵ if (item.ParameterName == "resultMsg") { resultMsg = item.ParameterValue.ToString(); if (resultMsg.Contains(BaseDict.ErrorPrefix)) res = -1; break; } } } catch (Exception ex) { if (tran != null) tran.Rollback(); resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString()); } return res; }
/// <summary> /// ��ѯʵ�� /// </summary> /// <param name="id">ModelId ���</param> /// <returns>ModelUser</returns> public ModelUser UserDetail(out string resultMsg, Int32 id) { resultMsg = string.Empty; var model = new ModelUser(); try { //�洢�������� string sql = "usp_user_select_detail_by_id"; //������� IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 }); //��ѯִ�� using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm)) { IList<ModelUser> list = GetModel(dr); model = list.First(); } } catch (Exception ex) { resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString()); } return model; }