public static bool UpdateBaoYangRecommendServiceConfig(BaoYangRecommendServiceConfig model)
{
const string sql = @"UPDATE Configuration..BaoYangRecommendServiceConfig SET
[ServiceType]=@ServiceType
,[ServiceName]=@ServiceName
,[GetRuleGUID]=@GetRuleGUID
,[CouponNames]=@CouponNames
,[Recommend]=@Recommend
,Tag=@Tag
,[Status]=@Status
,[UpdateTime]=GETDATE()
WHERE Id=@Id";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@ServiceType", model.ServiceType ?? string.Empty),
new SqlParameter("@ServiceName", model.ServiceName ?? string.Empty),
new SqlParameter("@GetRuleGUID", model.GetRuleGUID ?? string.Empty),
new SqlParameter("@CouponNames", model.CouponNames ?? string.Empty),
new SqlParameter("@Recommend", model.Recommend),
new SqlParameter("@Status", model.Status),
new SqlParameter("@Id", model.Id),
new SqlParameter("@Tag", model.Tag ?? string.Empty)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
/// <summary>
/// 服务不能重复
/// </summary>
/// <returns></returns>
public static bool CheckService(BaoYangRecommendServiceConfig model)
{
const string sql = @"SELECT COUNT(0)
FROM [Configuration].[dbo].[BaoYangRecommendServiceConfig] WITH (NOLOCK) WHERE ServiceType=@ServiceType";
return((int)SqlHelper.ExecuteScalar(connOnRead, CommandType.Text, sql, new SqlParameter("@ServiceType", model.ServiceType)) > 0);
}
public bool CheckService(BaoYangRecommendServiceConfig model)
{
var result = false;
try
{
result = DALBaoYangRecommendServiceConfig.CheckService(model);
}
catch (Exception ex)
{
Logger.Error("CheckService", ex);
}
return(result);
}
public bool CheckService(BaoYangRecommendServiceConfig model)
{
try
{
return(DALBaoYangRecommendServiceConfig.CheckService(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new BaoYangRecommendServiceConfigException(1, "CheckService", ex);
Logger.Log(Level.Error, "CheckService", exception);
throw ex;
}
}
public ActionResult Edit(int id = 0)
{
List <BaoYangPackage> packages = GetBaoYangPackage();
packages.Add(new BaoYangPackage {
Type = "tire", Name = "保养轮胎"
});
ViewBag.BaoYangPack = packages;
if (id == 0)
{
BaoYangRecommendServiceConfig model = new BaoYangRecommendServiceConfig();
return(View(model));
}
else
{
return(View(BaoYangRecommendServiceConfigManager.GetBaoYangRecommendServiceConfig(id)));
}
}
public static bool InsertBaoYangRecommendServiceConfig(BaoYangRecommendServiceConfig model)
{
const string sql = @"INSERT INTO Configuration..BaoYangRecommendServiceConfig
(
[Number]
,[ServiceType]
,[ServiceName]
,[GetRuleGUID]
,[CouponNames]
,[Recommend]
,[Status]
,[CreateTime]
,[UpdateTime]
,[Tag]
)
VALUES(
NEWID()
,@ServiceType
,@ServiceName
,@GetRuleGUID
,@CouponNames
,@Recommend
,@Status
,GETDATE()
,GETDATE()
,@Tag
)";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@GetRuleGUID", model.GetRuleGUID ?? string.Empty),
new SqlParameter("@CouponNames", model.CouponNames ?? string.Empty),
new SqlParameter("@Recommend", model.Recommend),
new SqlParameter("@ServiceName", model.ServiceName ?? string.Empty),
new SqlParameter("@ServiceType", model.ServiceType ?? string.Empty),
new SqlParameter("@Status", model.Status),
new SqlParameter("@Tag", model.Tag ?? string.Empty)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
public bool InsertBaoYangRecommendServiceConfig(BaoYangRecommendServiceConfig model)
{
var result = false;
try
{
if (DALBaoYangRecommendServiceConfig.InsertBaoYangRecommendServiceConfig(model))
{
using (var client = new CacheClient())
{
client.UpdateTuhuRecommendConfigAsync();
}
result = true;
}
}
catch (Exception ex)
{
Logger.Error("InsertBaoYangRecommendServiceConfig", ex);
}
return(result);
}
public ActionResult Edit(BaoYangRecommendServiceConfig model)
{
if (model.Id != 0)
{
//if (BaoYangRecommendServiceConfigManager.CheckService(model))
//{
// return Json(-100);
//}
return(Json(BaoYangRecommendServiceConfigManager.UpdateBaoYangRecommendServiceConfig(model)));
}
else
{
if (BaoYangRecommendServiceConfigManager.CheckService(model))
{
return(Json(-100));
}
return(Json(BaoYangRecommendServiceConfigManager.InsertBaoYangRecommendServiceConfig(model)));
}
}
