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