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;
}
