/// <summary>
/// 操作商品細項
/// </summary>
/// <param name="pe">需要操作的商品條件</param>
/// <returns>操作是否成功</returns>
public bool UpdateProductExt(List<ProductExtCustom> lists , Caller _caller,string controlId)
{
bool flag = true;
IFunctionImplMgr _functionMgr = new FunctionMgr(conStr); //用於找到控件的function信息
ITableHistoryImplMgr _tableHistoryMgr; //用於歷史記錄保存的類
IProductExtImplMgr _productExtMgr = new ProductExtMgr(conStr);
try
{
Function fun = _functionMgr.QueryFunction(controlId, "/ProductParticulars/Index");
ArrayList aList = new ArrayList();
_tableHistoryMgr = new TableHistoryMgr(conStr);//實例化歷史記錄的類
HistoryBatch batch = new HistoryBatch { functionid = fun.RowId };
Int64 n_Time = CommonFunction.GetPHPTime();
batch.kuser = _caller.user_email;
foreach (ProductExtCustom item in lists)
{
aList.Add(pei.UpdateProductExt(item));
batch.batchno = n_Time + "_" + "2" + "_" + item.Product_id;//add by wwei0216w 2015/7/6 註:將item_id改為product_id 統一使用product_id查詢
flag = _tableHistoryMgr.SaveHistory<ProductExtCustom>(item, batch, aList);
if(flag == false)
{
throw new Exception("ProductExtMgr-->UpdateProductExt Exception!" );
}
}
return flag;
}
catch (Exception ex)
{
throw new Exception("ProductExtMgr-->UpdateProductExt-->" + ex.Message, ex);
}
}
/// <summary>
/// 匯出功能
/// </summary>
public ActionResult OutToExcel(int rowId = 0, string functionName = "")
{
try
{
IFunctionImplMgr _funMgr = new FunctionMgr(connectionString);
Function fun = new Function { RowId = rowId };
MemoryStream ms = _funMgr.ExcelOut(fun, functionName);
if (ms == null)
{
return new EmptyResult();
}
return File(ms.ToArray(), "application/-excel", "權限人員名單_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
}
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 = false });
}
}
