/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateProductLimitCount(ProductLimitCountEntity model)
{
using (var conn = new SqlConnection(StrConn))
{
const string sql = @"UPDATE [Tuhu_productcatalog]..ProductLimitCount
SET PID = @PID,
ProductName = @ProductName,
CategoryCode = @CategoryCode,
CategoryName = @CategoryName,
CategoryLevel = @CategoryLevel,
LimitCount = @LimitCount,
LastUpdateTime = GETDATE()
WHERE PKID = @PKID;";
var sqlPrams = new[]
{
new SqlParameter("@PID", model.Pid),
new SqlParameter("@ProductName", model.ProductName?.Trim()),
new SqlParameter("@CategoryCode", model.CategoryCode?.Trim()),
new SqlParameter("@CategoryName", model.CategoryName?.Trim()),
new SqlParameter("@CategoryLevel", model.CategoryLevel),
new SqlParameter("@LimitCount", model.LimitCount),
new SqlParameter("@PKID", model.PKID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0);
}
}
/// <summary>
/// 插入限购数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertProductLimitCount(ProductLimitCountEntity model)
{
try
{
return(DALProductLimit.InsertProductLimitCount(model));
}
catch (Exception ex)
{
logger.Error("InsertProductLimitCount", ex);
}
return(0);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ProductLimitCountEntity FetchProductLimitCount(ProductLimitCountEntity model)
{
try
{
return(DALProductLimit.FetchProductLimitCount(model));
}
catch (Exception ex)
{
logger.Error("FetchProductLimitCount", ex);
return(new ProductLimitCountEntity());
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateProductLimitCount(ProductLimitCountEntity model)
{
try
{
return(DALProductLimit.UpdateProductLimitCount(model));
}
catch (Exception ex)
{
logger.Error("UpdateProductLimitCount", ex);
}
return(false);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static ProductLimitCountEntity FetchProductLimitCount(ProductLimitCountEntity model)
{
using (var conn = new SqlConnection(StrConn))
{
const string sql = @"SELECT *
FROM [Tuhu_productcatalog]..ProductLimitCount(NOLOCK)
WHERE Pid = @Pid AND CategoryCode = @CategoryCode;";
return(conn.Query <ProductLimitCountEntity>(sql, new ProductLimitCountEntity {
CategoryCode = model.CategoryCode?.Trim(), Pid = model.Pid
}).FirstOrDefault() ?? new ProductLimitCountEntity());
}
}
public JsonResult FetchCategoryLimitCount(string name, string code, int level)
{
var model = new ProductLimitCountEntity
{
CategoryName = name,
CategoryCode = code,
CategoryLevel = level
};
var result = _manager.FetchCategoryLimitCount(model);
return(Json(new { success = true, data = result }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 保存限购信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult SaveCategoryLimitCount(ProductLimitCountEntity model)
{
var dbResult = _manager.FetchCategoryLimitCount(model);
if (dbResult == null || dbResult.PKID <= 0)
{
var result = _manager.InsertProductLimitCount(model);
using (var client = new ConfigLogClient())
{
client.InsertDefaultLogQueue("CommonConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = result,
ObjectType = "CategoryLimitCount",
BeforeValue = 0,
AfterValue = model.LimitCount,
Remark = "初次设置类目限购",
Creator = User.Identity.Name
}));
}
return(Json(new { success = result > 0 }));
}
else
{
var oldVal = dbResult.LimitCount;
dbResult.LimitCount = model.LimitCount;
var result = _manager.UpdateProductLimitCount(dbResult);
using (var client = new ConfigLogClient())
{
client.InsertDefaultLogQueue("CommonConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = dbResult.PKID,
ObjectType = "CategoryLimitCount",
BeforeValue = oldVal,
AfterValue = model.LimitCount,
Remark = "编辑类目限购数量",
Creator = User.Identity.Name
}));
}
return(Json(new { success = result }));
}
}
/// <summary>
/// 添加产品限购
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertProductLimitCount(ProductLimitCountEntity model)
{
using (var conn = new SqlConnection(StrConn))
{
const string sql = @"INSERT INTO Tuhu_productcatalog.dbo.ProductLimitCount
(
PID ,
ProductName ,
CategoryCode ,
CategoryName ,
CategoryLevel ,
LimitCount ,
CreateTime ,
LastUpdateTime
)
VALUES (
@PID ,
@ProductName ,
@CategoryCode ,
@CategoryName ,
@CategoryLevel ,
@LimitCount ,
@CreateTime ,
@LastUpdateTime
);
SELECT ISNULL(@@IDENTITY,0)";
var sqlPrams = new[] {
new SqlParameter("@PID", model.Pid),
new SqlParameter("@ProductName", model.ProductName?.Trim()),
new SqlParameter("@CategoryCode", model.CategoryCode?.Trim()),
new SqlParameter("@CategoryName", model.CategoryName?.Trim()),
new SqlParameter("@CategoryLevel", model.CategoryLevel),
new SqlParameter("@LimitCount", model.LimitCount),
new SqlParameter("@CreateTime", DateTime.Now),
new SqlParameter("@LastUpdateTime", DateTime.Now)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlPrams)));
}
}
