在新增和编辑记录时不允许userName重复的逻辑判断

逻辑点:

新增时有userName存在,直接return

但是在编辑时,会有userName存在且允许编辑情况,即当前人是自己,需要对此逻辑进行判断

if(IsAddNew && userName不存在)//能新增: 即新增 + 用户名不存在
{

}
else if(IsUpdate) //运行到这里的情况:1.是更新; 2.userName存在,
{  
   //方式一:当前人是自己允许Update
   //方式二:当前人不是自己不允许Update
   //在编辑时,对UserName唯一性判断的处理逻辑
}
else  //运行到这里的情况:没有新增成功
{

}

tbiz_UserInfoBLL userInfoBLL = new tbiz_UserInfoBLL();
tbiz_UserInfoEntity userInfoItem = null;
if (string.IsNullOrEmpty(Request.Form["userName"]))//UserName 不允许为空
{
    return Json(new { result = "error", msg = "添加失败,个人帐号/手机号为空" });
}
if (!string.IsNullOrEmpty(Request.Form["userInfoID"]))
{
    userInfoItem = userInfoBLL.Gettbiz_UserInfoEntityById(Request.Form["userInfoID"]);
}
//UserName 不允许重复
string userName = Request.Form["userName"].Trim();
List<SqlDbParameter> parms = new List<SqlDbParameter>();
SqlDbParameter para = new SqlDbParameter();
para.ColumnName = tbiz_UserInfoEntity.FieldName_UserName;
para.ParameterName = tbiz_UserInfoEntity.FieldName_UserName;
para.ParameterValue = userName;
para.ColumnType = DbType.String;
para.QualificationType = SqlDbParameter.QualificationSymbol.Equal;
parms.Add(para);
tbiz_UserInfoBLL userbll = new tbiz_UserInfoBLL();
tbiz_UserInfoEntity userInfoByName = userbll.Gettbiz_UserInfoEntity(parms);

if (userInfoItem == null && userInfoByName == null)//Do Insert
{
    userInfoItem = new tbiz_UserInfoEntity();
    userInfoItem.UserName = Request.Form["userName"];
    int _companyID = 0;
    int.TryParse(Request.Form["companyID"], out _companyID);
    userInfoItem.CompanyID = _companyID;
    userInfoItem.Contract = Request.Form["contract"];
    userInfoItem.Mobile = Request.Form["mobile"];
    userInfoItem.Email = Request.Form["email"];
    userInfoItem.RoleID = Convert.ToInt32(Request.Form["roleID"]);
    userInfoItem.State = Convert.ToInt32(Request.Form["state"]);
    userInfoItem.Enabled = 1;
    userInfoItem.CreatedTime = DateTime.Now;
    userInfoBLL.Addtbiz_UserInfoEntity(userInfoItem);
    //.....
}
else if (userInfoItem != null) //Do Update
{
    if (userInfoItem.UserID == userInfoByName.UserID)//是自己
    {
        userInfoItem.UserName = Request.Form["userName"];
        int _companyID = 0;
        int.TryParse(Request.Form["companyID"], out _companyID);
        userInfoItem.CompanyID = _companyID;
        userInfoItem.Contract = Request.Form["contract"];
        userInfoItem.Mobile = Request.Form["mobile"];
        userInfoItem.Email = Request.Form["email"];
        userInfoItem.RoleID = Convert.ToInt32(Request.Form["roleID"]);
        userInfoItem.State = Convert.ToInt32(Request.Form["state"]);
        //userInfoItem.AuthFee = Convert.ToInt16(Request.Form["authFee"]); //费用分配权限
        userInfoBLL.Updatetbiz_UserInfoEntity(userInfoItem);
        return Json(new { result = "", msg = "记录更新成功" });
    }
    return Json(new { result = "error", msg = "个人帐号/手机号已注册过" });
}
else{
    return Json(new { result = "error", msg = "个人帐号/手机号已注册过" });
}