/// <summary>
/// 修改or新增
/// </summary>
/// <param name="sc"></param>
/// <returns></returns>
public ActionResult SaveProdname(string prodNameExtend)
{
bool result = false;
_prodnameExtendMgr = new ProdNameExtendMgr(connectionString);
try
{
Caller caller = Session["caller"] as Caller;
DateTime now = DateTime.Now;
List<ProdNameExtendCustom> list = JsonConvert.DeserializeObject<List<ProdNameExtendCustom>>(prodNameExtend);//將前臺信息序列化
foreach (var prod in list)
{
if (!PriceMaster.CheckProdName(prod.Product_Prefix) || !PriceMaster.CheckProdName(prod.Product_Suffix)) //判斷添加的前後綴是否是"〖","〗"這種類型
{
return Json(new { success = false, msg = Resources.Product.FORBIDDEN_CHARACTER });
}
prod.Kuser = caller.user_email;
prod.Kdate = now;
}
result = _prodnameExtendMgr.SaveByList(list, caller);
}
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);
}
return Json(new { success = result });
}
public ActionResult QueryProdname(ProdNameExtendCustom pron, bool isOverdue)
{
string ids = Request["Ids"];
try
{
int state = 0;//判斷是否需要重新查詢的依據
_prodnameExtendMgr = new ProdNameExtendMgr(connectionString);
IPriceMasterImplMgr pmMgr = new PriceMasterMgr(connectionString);
MySqlDao _mySqlDao = new MySqlDao(connectionString);
ArrayList sqlList = new ArrayList();
List<ProdNameExtendCustom> list = _prodnameExtendMgr.Query(pron, ids);//根據條件查詢商品信息
//判斷過期商品 和 審核商品 中是否存在錯誤數據 edit by zhuoqin0830w 2015/05/07
List<ProdNameExtendCustom> listDelete = list.FindAll(m => m.Flag == 3 || m.Flag == 1); //查詢過程中,為防止未去掉前後綴,卻到期的商品,進行一次遍歷,去掉前後綴 edit by wwei 0216w 2014/12/22
//獲取 前一天 時間的時間戳 edit by zhuoqin0830w 2015/05/07
long time = CommonFunction.GetPHPTime(Convert.ToString(DateTime.Now)) - 86400;
foreach (ProdNameExtendCustom pec in listDelete)
{
pec.Product_Name = pec.Product_Name.Replace(PriceMaster.L_HKH + pec.Product_Prefix + PriceMaster.R_HKH, "").Replace(PriceMaster.L_HKH + pec.Product_Suffix + PriceMaster.R_HKH, "");
PriceMaster p = new PriceMaster();
p.price_master_id = pec.Price_Master_Id;
p.product_name = pec.Product_Name;
switch (pec.Flag)
{
case 1://審核商品
//判斷結束時間 是否 小於 前一天 時間的時間戳 edit by zhuoqin0830w 2015/05/07
if (pec.Event_End <= time)
{
sqlList.Add(pmMgr.UpdateName(p));
state = 1;//如果審核商品中結束時間小於前一天的時間，則賦值為1;
_mySqlDao.ExcuteSqls(sqlList);
break;
}
break;
case 3://過期商品
//如果在過期的商品名稱中能找到前綴後綴~則調用刪除前後綴的方法
if ((pec.Product_Name.Contains(PriceMaster.L_HKH + pec.Product_Prefix + PriceMaster.R_HKH) || pec.Product_Name.Contains(PriceMaster.L_HKH + pec.Product_Suffix + PriceMaster.R_HKH)))
{
_prodnameExtendMgr.ResetExtendName(new Caller());
state = 1;//如果有過期商品包含前後綴,則賦值為1;
break;
}
break;
}
}
if (state == 1)
{
list = _prodnameExtendMgr.Query(pron, ids);//替換掉之前包含前後綴的商品名稱
}
for (int i = 0; i < list.Count; i++)
{
list[i].Key_Id = i;
}//add by wwei0216w 2014/12/30 為key_id賦值
if (isOverdue)//查詢過期
{
list.RemoveAll(p => p.Flag != 3);
}
else //查詢未過期
{
list.RemoveAll(p => p.Flag == 3);
}
return Json(new { item = list });
}
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);
}
return Json(new List<ProdNameExtendCustom>());
}
