public static bool InsertVIPAuthorizationRuleConfig(VIPAuthorizationRuleConfig model)
{
const string sql = @" INSERT INTO Configuration..SE_VIPAuthorizationRuleConfig
( RuleName ,
Description ,
ValidityDay ,
PrivilegeType ,
CreateTime ,
UpdateTime
)
VALUES ( @RuleName ,
@Description ,
@ValidityDay ,
@PrivilegeType ,
GETDATE() ,
GETDATE()
)";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@RuleName", model.RuleName ?? string.Empty),
new SqlParameter("@Description", model.Description ?? string.Empty),
new SqlParameter("@ValidityDay", model.ValidityDay),
new SqlParameter("@PrivilegeType", model.PrivilegeType)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
public ActionResult Edit(VIPAuthorizationRuleConfig model)
{
if (model.Id != 0)
{
return(Json(VIPAuthorizationRuleConfigManager.UpdateVIPAuthorizationRuleConfig(model)));
}
else
{
return(Json(VIPAuthorizationRuleConfigManager.InsertVIPAuthorizationRuleConfig(model)));
}
}
public ActionResult Edit(int id = 0)
{
if (id == 0)
{
VIPAuthorizationRuleConfig model = new VIPAuthorizationRuleConfig();
model.ValidityDay = 1;
return(View(model));
}
else
{
return(View(VIPAuthorizationRuleConfigManager.GetVIPAuthorizationRuleConfig(id)));
}
}
public bool InsertVIPAuthorizationRuleConfig(VIPAuthorizationRuleConfig model)
{
try
{
return(DALVIPAuthorizationRuleConfig.InsertVIPAuthorizationRuleConfig(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new VIPAuthorizationRuleConfigException(1, "InsertVIPAuthorizationRuleConfig", ex);
Logger.Log(Level.Error, exception, "InsertVIPAuthorizationRuleConfig");
throw ex;
}
}
public static bool UpdateVIPAuthorizationRuleConfig(VIPAuthorizationRuleConfig model)
{
const string sql = @"UPDATE Configuration..SE_VIPAuthorizationRuleConfig SET
RuleName=@RuleName ,
Description=@Description ,
ValidityDay=@ValidityDay ,
PrivilegeType=@PrivilegeType ,
UpdateTime=GETDATE()
WHERE Id=@Id";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@Description", model.Description ?? string.Empty),
new SqlParameter("@Id", model.Id),
new SqlParameter("@PrivilegeType", model.PrivilegeType),
new SqlParameter("@RuleName", model.RuleName ?? string.Empty),
new SqlParameter("@ValidityDay", model.ValidityDay)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
