/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Product_LimitedBuy_Area model)
{
var parameters = new List<SqlParameter>()
{
this.SqlServer.CreateSqlParameter(
"@ProductID",
SqlDbType.Int,
model.ProductID,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"@AreaID",
SqlDbType.NVarChar,
model.AreaID,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"@AreaType",
SqlDbType.Int,
model.AreaType,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"@CreateTime",
SqlDbType.DateTime,
DateTime.Now,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"@IsDelete",
SqlDbType.Int,
0,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"@ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output
)
};
var SqlStr = new StringBuilder();
SqlStr.Append(
"insert into Product_LimitedBuy_Area (ProductID,AreaID,AreaType,CreateTime,IsDelete) values(@ProductID,@AreaID,@AreaType,@CreateTime,@IsDelete)");
SqlStr.Append("select @ReferenceID=@@IDENTITY");
this.SqlServer.ExecuteNonQuery(CommandType.Text, SqlStr.ToString(), parameters, null);
return (int)parameters.Find(parameter => parameter.ParameterName == "@ReferenceID").Value;
}
public ActionResult SaveLimitedBuyArea(int productId, string AreaID, int AreaType)
{
if (string.IsNullOrEmpty(AreaID))
{
return Json(new AjaxResponse { State = 0, Message = "限购区域不能为空" });
}
var model = new Product_LimitedBuy_Area
{
ProductID = productId,
AreaID = AreaID,
AreaType = AreaType
};
var ProductLimitedBuyAreaService = new ProductLimitedBuyAreaService();
if (ProductLimitedBuyAreaService.SelectByProductId(productId).FirstOrDefault() != null)
{
if (ProductLimitedBuyAreaService.UpdateByProductId(AreaID, productId) > 0)
{
return Json(new AjaxResponse { State = 1, Message = "修改成功" });
}
}
else
{
if (ProductLimitedBuyAreaService.Insert(model) > 0)
return Json(new AjaxResponse { State = 1, Message = "添加成功" });
}
return Json(new AjaxResponse { State = 0, Message = "操作失败" });
}
public ActionResult BatchAddLimitedArea(string batchId, string content)
{
var ProductLimitedBuyAreaService = new ProductLimitedBuyAreaService();
if (string.IsNullOrEmpty(batchId) && string.IsNullOrEmpty(content))
{
return Json(new AjaxResponse { State = 0, Message = "请选择商品或地区" });
}
if (!string.IsNullOrEmpty(batchId))
{
string[] strId = batchId.Split(',');
var model = new Product_LimitedBuy_Area();
foreach (var s in strId)
{
if (ProductLimitedBuyAreaService.SelectByProductId(int.Parse(s)).FirstOrDefault() != null)
{
ProductLimitedBuyAreaService.UpdateByProductId(content, int.Parse(s));
}
else
{
model.ProductID = int.Parse(s);
model.AreaID = content;
model.AreaType = 1;
ProductLimitedBuyAreaService.Insert(model);
}
}
}
return Json(new AjaxResponse { State = 1, Message = "设置成功" });
}
/// <summary>
/// 插入一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Product_LimitedBuy_Area model)
{
return productLimited.Insert(model);
}
