public JsonResult AddSuperMan(ClienterListModel clienter) { if (cliterProvider.CheckClienterExistPhone(clienter.PhoneNo)) //判断该手机号是否已经注册过 { return(Json(new ResultModel(false, "手机号已被注册"))); } if (string.IsNullOrWhiteSpace(clienter.Password)) { clienter.Password = "******"; } clienter.Password = MD5Helper.MD5(clienter.Password); clienter.Status = (byte)ClienteStatus.Status1.GetHashCode(); return(Json(new ResultModel(iDistributionProvider.AddClienter(clienter), ""))); }
/// <summary> /// 添加骑士 /// danny-20150318 /// </summary> /// <param name="clienter"></param> /// <returns></returns> public bool AddClienter(ClienterListModel clienter) { return(dao.AddClienter(clienter)); }
/// <summary> /// 添加骑士 /// danny-20150318 /// </summary> /// <param name="clienter"></param> /// <returns></returns> public bool AddClienter(ClienterListModel clienter) { try { string sql = @" INSERT INTO clienter ([PhoneNo] ,[LoginName] ,[recommendPhone] ,[Password] ,[TrueName] ,[IDCard] ,[PicWithHandUrl] ,[PicUrl] ,[Status] ,[AccountBalance] ,[InsertTime] ,[InviteCode] ,[City] ,[CityId] ,[GroupId] ,[HealthCardID] ,[InternalDepart] ,[ProvinceCode] ,[AreaCode] ,[CityCode] ,[Province] ,[BussinessID] ,[WorkStatus]) VALUES (@PhoneNo ,@LoginName ,@recommendPhone ,@Password ,@TrueName ,@IDCard ,@PicWithHandUrl ,@PicUrl ,@Status ,@AccountBalance ,@InsertTime ,@InviteCode ,@City ,@CityId ,@GroupId ,@HealthCardID ,@InternalDepart ,@ProvinceCode ,@AreaCode ,@CityCode ,@Province ,@BussinessID ,@WorkStatus)SELECT @@IDENTITY "; IDbParameters parm = DbHelper.CreateDbParameters(); parm.AddWithValue("@PhoneNo", clienter.PhoneNo); parm.AddWithValue("@LoginName", clienter.LoginName); parm.AddWithValue("@recommendPhone", clienter.recommendPhone); parm.AddWithValue("@Password", clienter.Password); parm.AddWithValue("@TrueName", clienter.TrueName); parm.AddWithValue("@IDCard", clienter.IDCard); parm.AddWithValue("@PicWithHandUrl", clienter.PicWithHandUrl); parm.AddWithValue("@PicUrl", clienter.PicUrl); parm.AddWithValue("@Status", clienter.Status); parm.AddWithValue("@AccountBalance", clienter.AccountBalance); parm.AddWithValue("@InsertTime", clienter.InsertTime); parm.AddWithValue("@InviteCode", clienter.InviteCode); parm.AddWithValue("@City", clienter.City); parm.AddWithValue("@GroupId", clienter.GroupId); parm.AddWithValue("@HealthCardID", clienter.HealthCardID); parm.AddWithValue("@InternalDepart", clienter.InternalDepart); parm.AddWithValue("@ProvinceCode", clienter.ProvinceCode); parm.AddWithValue("@AreaCode", clienter.AreaCode); parm.AddWithValue("@CityCode", clienter.CityCode); parm.AddWithValue("@Province", clienter.Province); parm.AddWithValue("@BussinessID", clienter.BussinessID); parm.AddWithValue("@WorkStatus", clienter.WorkStatus); return(ParseHelper.ToInt(DbHelper.ExecuteScalar(SuperMan_Write, sql, parm)) > 0 ? true : false); } catch (Exception ex) { LogHelper.LogWriter("添加骑士异常", new { ex = ex, clienter = clienter }); return(false); throw; } }