/// <summary> /// 编辑途虎管理员信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult UpdateCarFriendsAdministrator(CarFriendsAdministratorsModel model) { var manager = new CarFriendsGroupManager(); model.CreateBy = User.Identity.Name; model.LastUpdateBy = User.Identity.Name; bool isSuccess = manager.UpdateCarFriendsAdministrator(model); if (isSuccess) { return(Json(new { status = isSuccess, msg = "编辑成功!" })); } else { return(Json(new { status = isSuccess, msg = "编辑失败!" })); } }
/// <summary> /// 编辑途虎管理员信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateCarFriendsAdministrator(CarFriendsAdministratorsModel model) { bool isSuccess = false; try { using (var conn = ProcessConnection.OpenGungnir) { isSuccess = dal.UpdateCarFriendsAdministrator(conn, model); } } catch (Exception e) { Logger.Error($"UpdateCarFriendsAdministrator -> {JsonConvert.SerializeObject(model)}", e); throw; } return(isSuccess); }
/// <summary> /// 新增途虎管理员 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public bool AddCarFriendsAdministrator(SqlConnection conn, CarFriendsAdministratorsModel model) { string sql = @" INSERT INTO Activity.[dbo].[CarFriendsAdministrators] ( [WeChatNickName] , [WeChatNumber] , [WeChatHeadPortrait] , [WeChatQRCode] , [Is_Deleted] , [CreateDatetime] , [LastUpdateDateTime] , [CreateBy] , [LastUpdateBy] ) VALUES ( @WeChatNickName , @WeChatNumber , @WeChatHeadPortrait , @WeChatQRCode , @Is_Deleted , GETDATE() , GETDATE() , @CreateBy , @LastUpdateBy ); SELECT SCOPE_IDENTITY();"; var parameters = new[] { new SqlParameter("@WeChatNickName", model.WeChatNickName ?? ""), new SqlParameter("@WeChatNumber", model.WeChatNumber ?? ""), new SqlParameter("@WeChatHeadPortrait", model.WeChatHeadPortrait ?? ""), new SqlParameter("@WeChatQRCode", model.WeChatQRCode ?? ""), new SqlParameter("@Is_Deleted", model.Is_Deleted), new SqlParameter("@CreateBy", model.CreateBy ?? ""), new SqlParameter("@LastUpdateBy", model.LastUpdateBy ?? "") }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)) > 0); }
/// <summary> /// 编辑途虎管理员信息 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public bool UpdateCarFriendsAdministrator(SqlConnection conn, CarFriendsAdministratorsModel model) { string sql = @" UPDATE Activity.[dbo].[CarFriendsAdministrators] WITH ( ROWLOCK ) SET [WeChatNickName] = @WeChatNickName , [WeChatNumber] = @WeChatNumber , [WeChatHeadPortrait] = @WeChatHeadPortrait , [WeChatQRCode] = @WeChatQRCode , [LastUpdateDateTime] = GETDATE() , [LastUpdateBy] = @LastUpdateBy WHERE PKID = @PKID;"; var parameters = new[] { new SqlParameter("@WeChatNickName", model.WeChatNickName ?? ""), new SqlParameter("@WeChatNumber", model.WeChatNumber ?? ""), new SqlParameter("@WeChatHeadPortrait", model.WeChatHeadPortrait ?? ""), new SqlParameter("@WeChatQRCode", model.WeChatQRCode ?? ""), new SqlParameter("@LastUpdateBy", model.LastUpdateBy ?? ""), new SqlParameter("@PKID", model.PKID) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0); }