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;
}