public string Save(ProductStatusHistory save)
{
try
{
return _historyDao.Save(save);
}
catch (Exception ex)
{
throw new Exception("ProductStatusHistoryMgr-->SaveNoProductId" + ex.Message, ex);
}
}
public string InsertIntoProductStatusHistory(ProductStatusHistory psh)
{
try
{
return _iproductRemoveReason.InsertIntoProductStatusHistory(psh);
}
catch (Exception ex)
{
throw new Exception("ProductRemoveReasonMgr-->InsertIntoProductStatusHistory-->" + ex.Message, ex);
}
}
public HttpResponseBase vaiteVerifyBack()
{
string resultStr = "{success:false}";
bool result = true;
try
{
string productIds = Request.Params["productIds"];
string backReason = Request.Params["backReason"];
Caller _caller = (Session["caller"] as Caller);
_applyMgr = new ProductStatusApplyMgr(connectionString);
_statusHistoryMgr = new ProductStatusHistoryMgr(connectionString);
_prodMgr = new ProductMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
string[] products = productIds.Split(',');
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/ProductList/VerifyList");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid, kuser = (Session["caller"] as Caller).user_email };
string batchNo = CommonFunction.GetPHPTime().ToString() + "_" + (Session["caller"] as Caller).user_id + "_";
foreach (string item in products)
{
Product product = _prodMgr.Query(new Product { Product_Id = uint.Parse(item) }).FirstOrDefault();
ArrayList sqls = new ArrayList();
if (_applyMgr.Query(new ProductStatusApply { product_id = uint.Parse(item) }) != null)
{
ProductStatusApply queryApply = _applyMgr.Query(new ProductStatusApply { product_id = uint.Parse(item) });
uint prev_status = queryApply.prev_status;
product.Product_Status = prev_status;
sqls.Add(_prodMgr.Update(product, _caller.user_id));
ProductStatusHistory save = new ProductStatusHistory();
save.product_id = product.Product_Id;
save.user_id = uint.Parse(_caller.user_id.ToString());
save.type = 3; //操作類型(駁回)
save.product_status = int.Parse(product.Product_Status.ToString());
save.remark = backReason;
sqls.Add(_statusHistoryMgr.Save(save));
batch.batchno = batchNo + product.Product_Id;
sqls.Add(_applyMgr.Delete(queryApply));
if (!_tableHistoryMgr.SaveHistory<Product>(product, batch, sqls))
{
result = false;
break;
}
}
else
{
result = false;
break;
}
}
resultStr = "{success:" + result.ToString().ToLower() + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
Response.Clear();
Response.Write(resultStr);
Response.End();
return this.Response;
}
public HttpResponseBase vaiteVerifyPass()
{
string resultStr = "{success:false}";
bool result = true;
try
{
Caller _caller = (Session["caller"] as Caller);
_applyMgr = new ProductStatusApplyMgr(connectionString);
_statusHistoryMgr = new ProductStatusHistoryMgr(connectionString);
_prodMgr = new ProductMgr(connectionString);
_pMaster = new PriceMasterMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
string productIds = Request.Params["prodcutIdStr"];
string[] products = productIds.Split(',');
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/ProductList/VerifyList");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid, kuser = (Session["caller"] as Caller).user_email };
string batchNo = CommonFunction.GetPHPTime().ToString() + "_" + (Session["caller"] as Caller).user_id + "_";
foreach (string item in products)
{
Product product = _prodMgr.Query(new Product { Product_Id = uint.Parse(item) }).FirstOrDefault();
ArrayList sqls = new ArrayList();
if (_applyMgr.Query(new ProductStatusApply { product_id = uint.Parse(item) }) != null)
{
batch.batchno = batchNo + product.Product_Id;
//更改商品价格之状态
PriceMaster pmQuery = new PriceMaster();
if (product.Combination != 0 && product.Combination != 1) //组合商品
{
pmQuery.child_id = int.Parse(item);
}
else
{
pmQuery.child_id = 0;
}
pmQuery.product_id = uint.Parse(item);
pmQuery.price_status = 2; //只更改价格状态为申请审核的商品价格
List<PriceMaster> pmResultList = _pMaster.PriceMasterQuery(pmQuery);
if (pmResultList != null && pmResultList.Count() > 0)
{
_pHMgr = new PriceUpdateApplyHistoryMgr(connectionString);
List<PriceUpdateApplyHistory> pHList = new List<PriceUpdateApplyHistory>();
foreach (var pm in pmResultList)
{
ArrayList priceUpdateSqls = new ArrayList();
pm.price_status = 1; //价格状态为上架
pm.apply_id = 0;
priceUpdateSqls.Add(_pMaster.Update(pm));
if (!_tableHistoryMgr.SaveHistory<PriceMaster>(pm, batch, priceUpdateSqls))
{
result = false;
break;
}
//价格异动记录（price_update_apply_history）
PriceUpdateApplyHistory pH = new PriceUpdateApplyHistory();
pH.apply_id = int.Parse(pm.apply_id.ToString());
pH.user_id = (Session["caller"] as Caller).user_id;
pH.price_status = 1;
pH.type = 1;
pHList.Add(pH);
}
if (!_pHMgr.Save(pHList))
{
result = false;
break;
}
}
//更改商品之状态
ProductStatusApply queryApply = _applyMgr.Query(new ProductStatusApply { product_id = uint.Parse(item) });
uint online_mode = queryApply.online_mode;
//申請狀態為審核後立即上架時將上架時間改為當前時間，商品狀態改為上架
if (online_mode == 2)
{
product.Product_Status = 5;
product.Product_Start = uint.Parse(BLL.gigade.Common.CommonFunction.GetPHPTime(DateTime.Now.ToLongTimeString()).ToString());
}
else
{
product.Product_Status = 2;
//product.Product_Start = online_mode;
}
sqls.Add(_prodMgr.Update(product, _caller.user_id));
ProductStatusHistory save = new ProductStatusHistory();
save.product_id = product.Product_Id;
save.user_id = uint.Parse(_caller.user_id.ToString());
save.type = 2; //操作類型(核可)
save.product_status = int.Parse(product.Product_Status.ToString());
sqls.Add(_statusHistoryMgr.Save(save)); //保存历史记录
sqls.Add(_applyMgr.Delete(queryApply)); //刪除審核申請表中的數據
if (!_tableHistoryMgr.SaveHistory<Product>(product, batch, sqls))
{
result = false;
break;
}
}
else
{
result = false;
break;
}
}
resultStr = "{success:" + result.ToString().ToLower() + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
Response.Clear();
Response.Write(resultStr);
Response.End();
return this.Response;
}
public HttpResponseBase verifyApply()
{
List<QueryandVerifyCustom> resultList = new List<QueryandVerifyCustom>();
string result = "{success:false}";
bool resl = true;
try
{
string prodcutIdStr = Request.Params["prodcutIdStr"];
string[] productIds = prodcutIdStr.Split(',');
string method = Request.Params["method"];
Caller _caller = (Session["caller"] as Caller);
_prodMgr = new ProductMgr(connectionString);
_applyMgr = new ProductStatusApplyMgr(connectionString);
_statusHistoryMgr = new ProductStatusHistoryMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/ProductList") ?? _functionMgr.QueryFunction(function, "/ProductList/ReplaceVerify");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid, kuser = (Session["caller"] as Caller).user_email };
string batchNo = CommonFunction.GetPHPTime().ToString() + "_" + (Session["caller"] as Caller).user_id + "_";
string msg = "";
foreach (string item in productIds.Distinct())
{
ArrayList sqls = new ArrayList();
Product update = _prodMgr.Query(new Product { Product_Id = uint.Parse(item) }).FirstOrDefault();
//選擇自動上架時間時更改商品上架時間為選定時間
if (method.Equals("3"))
{
update.Product_Start = uint.Parse(BLL.gigade.Common.CommonFunction.GetPHPTime(Request.Params["product_start"]).ToString());
method = "1";
}
//若當前商品狀態不是新建商品或下架,則跳過申請
if (update.Product_Status != 0 && update.Product_Status != 6 && update.Product_Status!=7)
{
break;
}
//判斷商品是否失格 則 直接取消申請 add by zhuoqin0830w 20105/07/01
if (update.off_grade == 1)
{
msg += "【" + update.Product_Id + "】商品是失格商品，不可申請審核！</br>";
break;
}
ProductStatusApply apply = new ProductStatusApply();
apply.product_id = uint.Parse(item);
apply.prev_status = update.Product_Status;
apply.online_mode = uint.Parse(method);
sqls.Add(_applyMgr.Save(apply));
ProductStatusHistory history = new ProductStatusHistory();
history.product_id = uint.Parse(item);
history.user_id = uint.Parse(_caller.user_id.ToString());
history.type = 1; //操作類型 ???????????????????
history.product_status = 1; //操作後狀態
//edit by zhuoqin0830w 2015/06/30 添加備註欄位
history.remark = Request.Form["Remark"];
sqls.Add(_statusHistoryMgr.Save(history));
batch.batchno = batchNo + update.Product_Id;
update.Product_Status = 1; //狀態 -> 申請審核
sqls.Add(_prodMgr.Update(update, _caller.user_id));
if (!_tableHistoryMgr.SaveHistory<Product>(update, batch, sqls))
{
resl = false;
}
//若當前商品為單一商品並且商品狀態為新建商品,則將product_item.export_flag改為1
if (resl && update.Combination == 1 && apply.prev_status == 0)
{
_productItemMgr = new ProductItemMgr(connectionString);
ProductItem proItem = new ProductItem() { Product_Id = update.Product_Id, Export_flag = 1 };
_productItemMgr.UpdateExportFlag(proItem);
}
}
result = "{success:" + resl.ToString().ToLower() + ",'msg':'" + msg + "'}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
Response.Clear();
Response.Write(result);
Response.End();
return this.Response;
}
public HttpResponseBase ProductUp()
{
string json = "{success:true}";
try
{
if (!string.IsNullOrEmpty(Request.Form["Product_Id"]))
{
string[] pro_Ids = Request.Form["Product_Id"].Split('|');
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/ProductList");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid, kuser = (Session["caller"] as Caller).user_email };
string batchNo = CommonFunction.GetPHPTime().ToString() + "_" + (Session["caller"] as Caller).user_id + "_";
_prodMgr = new ProductMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
_productStatusHistoryMgr = new ProductStatusHistoryMgr("");
ProductStatusHistory proStatusHistory = new ProductStatusHistory { product_status = 5, type = 6, user_id = Convert.ToUInt32((Session["caller"] as Caller).user_id) };
ArrayList sqls;
foreach (string str in pro_Ids.Distinct())
{
if (!string.IsNullOrEmpty(str))
{
uint product_id = uint.Parse(str);
Product pro = _prodMgr.Query(new Product { Product_Id = product_id }).FirstOrDefault();
//上架商品不能為失格商品 eidt by zhuoqin0830w 20105/07/01 pro.off_grade != 1
string msg = "";
if (pro.off_grade == 1)
{
msg += "【" + pro.Product_Id + "】商品是失格商品，不可上架！</br>";
json = "{success:false,'msg':'" + msg + "'}";
break;
}
if (pro != null && pro.Product_Status == 2)//&& pro.user_id == (Session["caller"] as Caller).user_id
{
pro.Product_Status = 5;//上架
pro.Product_Start = Convert.ToUInt32(CommonFunction.GetPHPTime());
sqls = new ArrayList();
sqls.Add(_prodMgr.Update(pro));
batch.batchno = batchNo + pro.Product_Id;
proStatusHistory.product_id = product_id;
//edit by zhuoqin0830w 2015/06/26 添加備註欄位
proStatusHistory.remark = Request.Form["Remark"];
sqls.Add(_productStatusHistoryMgr.Save(proStatusHistory));
if (!_tableHistoryMgr.SaveHistory<Product>(pro, batch, sqls))
{
json = "{success:false}";
}
}
}
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase ProductDown(int type = 1)
{
string json = "{success:true}";
try
{
if (!string.IsNullOrEmpty(Request.Form["Product_Id"]))
{
string[] pro_Ids = Request.Form["Product_Id"].Split('|');
uint product_end =0 ;
if (!string.IsNullOrEmpty(Request.Form["Product_End"]))
{
product_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Form["Product_End"]));
}
//立即下架不改變下架時間
//else
//{
// product_end = Convert.ToUInt32(CommonFunction.GetPHPTime());
//}
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/ProductList");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid, kuser = (Session["caller"] as Caller).user_email };
string batchNo = CommonFunction.GetPHPTime().ToString() + "_" + (Session["caller"] as Caller).user_id + "_";
_prodMgr = new ProductMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
_productStatusHistoryMgr = new ProductStatusHistoryMgr("");
ProductStatusHistory proStatusHistory = new ProductStatusHistory { product_status = 6, type = 4, user_id = Convert.ToUInt32((Session["caller"] as Caller).user_id) };
ArrayList sqls;
foreach (string str in pro_Ids.Distinct())
{
if (!string.IsNullOrEmpty(str))
{
uint product_id = uint.Parse(str);
Product pro = _prodMgr.Query(new Product { Product_Id = product_id }).FirstOrDefault();
if (type == 1 && product_end == 0)//說明是立即下架,就用原來的時間
{
product_end = pro.Product_End;
}
//edit by zhuoqin0830w 2015/06/26 添加備註欄位
string remark = "";
if (pro != null && pro.Product_Status == 5)// && pro.user_id == (Session["caller"] as Caller).user_id
{
switch (type)
{
case 1:
pro.Product_Status = 6;//下架
remark = Request.Form["UnShelve"]; //edit by zhuoqin0830w 2015/06/26 添加備註欄位
pro.Product_End = product_end; //將 pro.Product_End = product_end 代碼提前 避免下架不販售的時候沒有下架時間 edit by zhuoqin0830w 2015/07/15
break;
case 2:
pro.Product_Status = 99;//下架不販售
remark = Request.Form["Remark"]; //edit by zhuoqin0830w 2015/06/26 添加備註欄位
IProductExtImplMgr _prodExtMgr = new ProductExtMgr(connectionString);
_prodExtMgr.UpdatePendDel(product_id, true);
break;
}
sqls = new ArrayList();
sqls.Add(_prodMgr.Update(pro));
batch.batchno = batchNo + pro.Product_Id;
proStatusHistory.product_id = product_id;
//edit by zhuoqin0830w 2015/06/26 添加備註欄位
proStatusHistory.remark = remark;
sqls.Add(_productStatusHistoryMgr.Save(proStatusHistory));
if (!_tableHistoryMgr.SaveHistory<Product>(pro, batch, sqls))
{
json = "{success:false}";
}
}
}
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public string SetProductRmoveDown()
{
int resultone = 0;
int resulttwo = 0;
int resultthree = 0;
string startRunInfo = "";
string endRunInfo = "";
try
{
//if (Request.Url.Host == "mng.gigade100.com")//判断是否为正式线
//{
// return "{success:false,data:'',msg:'未驗收，暫不執行！'}";
//}
//else
//{
startRunInfo = DateTime.Now.ToString() + ": SetProductRmoveDown Start";
_proRemoveMgr = new ProductRemoveReasonMgr(connectionString);
ProductRemoveReason prr = new ProductRemoveReason();
ProductRemoveReason prrtwo = new ProductRemoveReason();
Product pt = new Product();
ProductStatusHistory psh = new ProductStatusHistory();
#region 往临时表中插入数据/或者更新数据 sql可以统一执行
//獲取到上架商品庫存<=0,並且排除掉庫存為0可販賣機暫停售賣的商品
DataTable _dt = _proRemoveMgr.GetStockLessThanZero();
//获取到临时表中的数据
DataTable _dttwo = _proRemoveMgr.GetProductRemoveReasonList();
//判断临时表是否存在,如果不存在,则插入数据
StringBuilder str = new StringBuilder();
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
DataRow[] dr = _dttwo.Select("product_id=" + _dt.Rows[i]["product_id"]);
if (dr.Length <= 0)//小于等于0 无需处理编辑数据,因为获取的库存都是等于或者小于0的
{
prr.create_name = "system";
prr.create_time = Convert.ToInt32(CommonFunction.GetPHPTime(CommonFunction.DateTimeToString(DateTime.Now)));
prr.product_id = Convert.ToUInt32(_dt.Rows[i]["product_id"]);
prr.product_num = Convert.ToInt32(_dt.Rows[i]["item_stock"]);
str.AppendFormat(_proRemoveMgr.InsertProductRemoveReason(prr));
}
}
}
//获取出临时表中要删除的数据
DataTable _dtthree = _proRemoveMgr.GetDeleteProductRemoveReasonList();
for (int b = 0; b < _dtthree.Rows.Count; b++)
{
prr.product_id = Convert.ToUInt32(_dtthree.Rows[b]["product_id"]);
str.AppendFormat(_proRemoveMgr.DeleteProductRemoveReason(prr));
}
if (str.ToString().Length > 0)
{
resultone = _proRemoveMgr.ProductRemoveReasonTransact(str.ToString());
}
else
{
resultone = 1;
}
#endregion
#region 缺货商品下架
DataTable _dtNew = _proRemoveMgr.GetStockMsg();
StringBuilder strsql = new StringBuilder();
if (_dtNew.Rows.Count > 0)
{
for (int j = 0; j < _dtNew.Rows.Count; j++)
{
int time = Convert.ToInt32(_dtNew.Rows[j]["create_time"]);
DateTime dttime = CommonFunction.GetNetTime(time);
TimeSpan ts = DateTime.Now - dttime;
prrtwo.product_id = Convert.ToUInt32(_dtNew.Rows[j]["product_id"]);
pt.Product_Id = Convert.ToUInt32(_dtNew.Rows[j]["product_id"]);
pt.Product_Status = 7;//7为缺货系统下架
psh.product_id = Convert.ToUInt32(_dtNew.Rows[j]["product_id"]);
psh.user_id = 2;
psh.create_time = DateTime.Now;
psh.type = 9;//缺货系统下架
psh.product_status = 7;
psh.remark = "系统账号插入";
if (ts.Days >= (_dtNew.Rows[j]["outofstock_days_stopselling"] == "" ? 0 : Convert.ToInt32(_dtNew.Rows[j]["outofstock_days_stopselling"])))//表示可以下架,执行下架工作
{
//改变product表中商品的状态
strsql.AppendFormat(_proRemoveMgr.UpdateProductStatus(pt));
//网记录表中插入一条数据
strsql.AppendFormat(_proRemoveMgr.InsertIntoProductStatusHistory(psh));
//删除临时表中的数据
strsql.AppendFormat(_proRemoveMgr.DeleteProductRemoveReason(prrtwo));
}
}
}
if (strsql.ToString().Length > 0)
{
resulttwo = _proRemoveMgr.ProductRemoveReasonTransact(strsql.ToString());
}
else
{
resulttwo = 1;
}
#endregion
#region 缺货商品状态改为申请审核
DataTable _dtOutofStock = _proRemoveMgr.GetOutofStockMsg();
StringBuilder strslqmsg = new StringBuilder();
StringBuilder strslqmsgtwo = new StringBuilder();
if (_dtOutofStock.Rows.Count > 0)
{
for (int z = 0; z < _dtOutofStock.Rows.Count; z++)
{
if (Convert.ToInt32(_dtOutofStock.Rows[z]["item_stock"]) > 0)
{
pt.Product_Id = Convert.ToUInt32(_dtOutofStock.Rows[z]["product_id"]);
pt.Product_Status = 1;//1表示申请审核
_proRemoveMgr.UpdateProductStatus(pt);
psh.product_id = Convert.ToUInt32(_dtOutofStock.Rows[z]["product_id"]);
psh.user_id = 2;
psh.create_time = DateTime.Now;
psh.type = 1;//1表示申请审核
psh.product_status = 1;//申请审核
psh.remark = "系统账号插入";
strslqmsg.AppendFormat(_proRemoveMgr.UpdateProductStatus(pt));
strslqmsg.AppendFormat(_proRemoveMgr.InsertIntoProductStatusHistory(psh));
}
prr.product_id = Convert.ToUInt32(_dtOutofStock.Rows[z]["product_id"]);//根据product_id删除数据
strslqmsgtwo.AppendFormat(_proRemoveMgr.DeleteProductRemoveReason(prr));
}
}
if (strslqmsg.ToString().Length > 0)
{
resultthree = _proRemoveMgr.ProductRemoveReasonTransact(strslqmsg.ToString() + strslqmsgtwo.ToString());
}
else
{
if (strslqmsgtwo.ToString().Length > 0)
{
_proRemoveMgr.ProductRemoveReasonTransact(strslqmsgtwo.ToString());
}
resultthree = 1;
}
#endregion
if (resultone > 0 && resulttwo > 0 && resultthree > 0)
{
SaleStatus();
//DataTable _excelMsg = _proRemoveMgr.GetStockMsg();
//ExeclProductRmoveDownMsg(_excelMsg);
endRunInfo = DateTime.Now.ToString() + ": SetProductRmoveDown End ";
WriterInfo("SetProductRmoveDown-Success", startRunInfo, endRunInfo);
return "{success:true}";
}
else
{
endRunInfo = DateTime.Now.ToString() + ": SetProductRmoveDown End ";
WriterInfo("SetProductRmoveDown-Fail", startRunInfo, endRunInfo);
return "{success:false}";
}
//}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
endRunInfo = DateTime.Now.ToString() + "SetProductRmoveDown: " + ex.Message;
WriterInfo("SetProductRmoveDown", startRunInfo, endRunInfo);
return "{success:false,data:'',msg:" + ex.Message + "}";
}
}
public string InsertIntoProductStatusHistory(ProductStatusHistory psh)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"insert into product_status_history (`product_id`,`user_id`,`create_time`,`type`,`product_status`,`remark`)");
sb.AppendFormat(" values ({0},{1},now(),{2},{3},'{4}');",psh.product_id,2, psh.type,psh.product_status,psh.remark);
if (psh.product_status == 1)
{
sb.AppendFormat(@"insert into product_status_apply(`product_id`,`prev_status`,`apply_time`,`online_mode`)");
sb.AppendFormat("values('{0}','{1}',now(),'{2}');", psh.product_id, 7, 2);//在这里online_mode为审核之后直接下架
}
try
{
return sb.ToString();
}
catch (Exception ex)
{
throw new Exception("ProductRemoveReasonDao.InsertIntoProductStatusHistory-->" + ex.Message + sb.ToString(), ex);
}
}
