/// <summary>
/// 修改SKU折扣活动
/// </summary>k
/// <param name="requestData"></param>
/// <returns></returns>
public int UpdateSkuSale(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
SaleActivity product = JsonConvert.DeserializeObject <SaleActivity>(query);
EntityState statebefore = db.Entry(product).State;
db.Entry(product).State = EntityState.Modified;
return(db.SaveChanges());
}
public string FindSkuSale(int skuId = 0)
{
if (skuId <= 0)
{
return("Request Error");
}
SaleActivity salemodel = (from o in db.SaleActivity
where o.SkuId == skuId
select o).FirstOrDefault();
string result = JsonConvert.SerializeObject(salemodel);
return(result);
}
public string AddSaleActivity(dynamic requestData)
{
try
{
string query = JsonConvert.SerializeObject(requestData);
SaleActivity model = JsonConvert.DeserializeObject <SaleActivity>(query);
//db.SaleActivity.Add(model);
string sql = string.Format("Insert into SaleActivity Values({0}, '{1}','{2}', {3},{4})", model.SkuId, model.StartTime, model.EndTime, model.SalePrice, model.Limit);
int q = dataContext.ExecuteNonQuery(CommandType.Text, sql);
return(q.ToString());
}
catch (Exception ex)
{
return(ex.Message);
}
}
