public string Delete(ProductPictureTemp proPictureTemp, int type)
{
StringBuilder strSql = new StringBuilder("set sql_safe_updates=0; delete from ");
strSql.Append(type == 1 ? " product_picture_temp" : "product_picture_app_temp"); //當type為1時,操作product_picture_temp表,為2時操作product_picture_app_temp表
strSql.AppendFormat(" where writer_id={0} and combo_type={1}", proPictureTemp.writer_Id, proPictureTemp.combo_type);
strSql.AppendFormat(" and product_id='{0}';set sql_safe_updates = 1;", proPictureTemp.product_id);
return strSql.ToString();
}
public string SaveFromProPicture(ProductPictureTemp proPictureTemp,int type)
{
try
{
return _productPicTempDao.SaveFromProPicture(proPictureTemp, type);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->SaveFromProPicture-->" + ex.Message, ex);
}
}
public List<ProductPictureTemp> Query(ProductPictureTemp proPictureTemp, int type)
{
try
{
return _productPicTempDao.Query(proPictureTemp, type);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->Query-->" + ex.Message, ex);
}
}
public string SaveFromProPicture(ProductPictureTemp proPictureTemp, int type)
{
StringBuilder strSql = new StringBuilder("insert into ");
strSql.Append(type == 1 ? "product_picture_temp " : "product_picture_app_temp ");//當type為1時,操作product_picture_temp表,為2時操作product_picture_app_temp表
strSql.AppendFormat("(writer_id,product_id,image_filename,image_sort,image_state,image_createdate,combo_type) ");
strSql.AppendFormat("select {0} as writer_id,product_id,image_filename,image_sort,image_state,image_createdate,{1} as combo_type from ",
proPictureTemp.writer_Id, proPictureTemp.combo_type);
strSql.Append(type == 1 ? "product_picture" : "product_picture_app");//當type為1時,操作product_picture表,為2時操作product_picture_app表
strSql.AppendFormat(" where product_id='{0}'", proPictureTemp.product_id);
return strSql.ToString();
}
public string MoveToProductPicture(ProductPictureTemp proPictureTemp, int type)
{
StringBuilder sql = new StringBuilder("insert into ");
sql.Append(type == 1 ? "product_picture" : "product_picture_app");
sql.Append("(product_id,image_filename,image_sort,image_state,image_createdate)");
sql.Append(" select {0} as product_id,image_filename,image_sort,image_state,image_createdate from ");
sql.Append(type == 1 ? "product_picture_temp" : "product_picture_app_temp");//當type為1時,操作product_picture_temp表,為2時操作product_picture_app_temp表
sql.AppendFormat(" where writer_id={0} and combo_type={1}", proPictureTemp.writer_Id, proPictureTemp.combo_type);
sql.AppendFormat(" and product_id='{0}'", proPictureTemp.product_id);
return sql.ToString();
}
public string Save(ProductPictureTemp Pic, int type)
{
Pic.Replace4MySQL();
StringBuilder stb = new StringBuilder("insert into ");
stb.Append(type == 1 ? "product_picture_temp" : "product_picture_app_temp");//當type為1時,操作product_picture_temp表,為2時操作product_picture_app_temp表
stb.Append("(`writer_id`,`product_id`,`image_filename`,`image_sort`,`image_state`,`image_createdate`,`combo_type`)");
if (!string.IsNullOrEmpty(Pic.product_id))
{
stb.AppendFormat(" values ('{0}','{1}','{2}','{3}','{4}','{5}',{6})", Pic.writer_Id, Pic.product_id, Pic.image_filename, Pic.image_sort, Pic.image_state, Pic.image_createdate, Pic.combo_type);
}
else
{
stb.AppendFormat(" values ('{0}','{1}','{2}','{3}','{4}','{5}',{6})", Pic.writer_Id, Pic.product_id, Pic.image_filename, Pic.image_sort, Pic.image_state, Pic.image_createdate, Pic.combo_type);
}
return stb.ToString();
}
public List<ProductPictureTemp> Query(ProductPictureTemp proPictureTemp, int type)
{
StringBuilder stb = new StringBuilder();
//stb.Append(type == 1 ? "product_picture_temp" : "product_picture_app_temp");//當類型為1時查詢商品說明表,為 2時查詢APP圖檔表
//stb.AppendFormat(" where writer_id={0} and combo_type={1}", proPictureTemp.writer_Id, proPictureTemp.combo_type);
//stb.AppendFormat(" and product_id='{0}'", proPictureTemp.product_id); //edit by xiangwang0413w 2014/10/08 不等於0的商品不再是本次新複製的商品
stb.AppendFormat(@"SELECT image_filename,image_sort,image_state, 1 AS pic_type FROM product_picture_temp
WHERE writer_id={0} and combo_type={1} AND product_id = {2}
UNION ALL
SELECT image_filename,image_sort,image_state, 2 AS pic_type FROM product_picture_app_temp
WHERE writer_id={0} and combo_type={1} AND product_id = {2}", proPictureTemp.writer_Id, proPictureTemp.combo_type, proPictureTemp.product_id);
return _dbAccess.getDataTableForObj<ProductPictureTemp>(stb.ToString());
}
public bool Save(List<ProductPictureTemp> PicList, ProductPictureTemp prPictureTemp,int type)
{
try
{
ArrayList arrList = new ArrayList();
//先刪除商品說明圖記錄
arrList.Add(_productPicTempDao.Delete(prPictureTemp, type));
foreach (var item in PicList)
{
arrList.Add(_productPicTempDao.Save(item, type));
}
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(arrList);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->SingleCompareSave-->" + ex.Message, ex);
}
}
public int TempMove2Pro(int writerId, int combo_type, string product_Id)
{
ArrayList sqls = new ArrayList();
int product_id = 0;
ProductTempMgr proTempMgr = new ProductTempMgr("");
ProductTemp proTemp = new ProductTemp { Writer_Id = writerId, Combo_Type = combo_type, Product_Id = product_Id, Create_Channel = 1 };//1:後台管理者(manage_user) edit by xiagnwang0413w 2014/08/09
string movePro = proTempMgr.MoveProduct(proTemp);
sqls.Add(proTempMgr.Delete(proTemp));
/*********start*********/
//將ProductDeliverySetTemp表數據導入正式表 edit by xiangwang0413w 2014/11/06
IProductDeliverySetTempImplMgr _proDelSetTemp = new ProductDeliverySetTempMgr("");
var proDelSetTemp = new ProductDeliverySetTemp { Writer_Id = writerId, Combo_Type = combo_type, Product_id = int.Parse(product_Id) };
sqls.Add(_proDelSetTemp.MoveProductDeliverySet(proDelSetTemp));
sqls.Add(_proDelSetTemp.Delete(proDelSetTemp));
/*******end***********/
ProductNoticeSetTempMgr proNoticeSetTempMgr = new ProductNoticeSetTempMgr("");
ProductNoticeSetTemp proNoticeSetTemp = new ProductNoticeSetTemp { Writer_Id = writerId, Combo_Type = combo_type, product_id = product_Id };
sqls.Add(proNoticeSetTempMgr.MoveNotice(proNoticeSetTemp));
sqls.Add(proNoticeSetTempMgr.Delete(proNoticeSetTemp));
ProductTagSetTempMgr proTagSetTempMgr = new ProductTagSetTempMgr("");
ProductTagSetTemp proTagSetTemp = new ProductTagSetTemp { Writer_Id = writerId, Combo_Type = combo_type, product_id = product_Id };
sqls.Add(proTagSetTempMgr.MoveTag(proTagSetTemp));
sqls.Add(proTagSetTempMgr.Delete(proTagSetTemp));
ProductPictureTempImplMgr proPicTempMgr = new ProductPictureTempImplMgr("");
ProductPictureTemp proPictureTemp = new ProductPictureTemp { writer_Id = writerId, combo_type = combo_type, product_id = product_Id };
sqls.Add(proPicTempMgr.MoveToProductPicture(proPictureTemp, 1));//更新說明圖表
sqls.Add(proPicTempMgr.MoveToProductPicture(proPictureTemp, 2));//更新APP圖表
sqls.Add(proPicTempMgr.Delete(proPictureTemp, 1));//刪除說明圖臨時表
sqls.Add(proPicTempMgr.Delete(proPictureTemp, 2)); //刪除app臨時表 add by wwei0216w 2014/11/11
ProductCategorySetTempMgr proCateSetTempMgr = new ProductCategorySetTempMgr("");
ProductCategorySetTemp proCategorySetTemp = new ProductCategorySetTemp { Writer_Id = writerId, Combo_Type = combo_type, Product_Id = product_Id.ToString() };
sqls.Add(proCateSetTempMgr.TempMoveCategory(proCategorySetTemp));
sqls.Add(proCateSetTempMgr.TempDelete(proCategorySetTemp));
ProductStatusHistoryMgr proStatusHistoryMgr = new ProductStatusHistoryMgr("");
sqls.Add(proStatusHistoryMgr.SaveNoProductId(new ProductStatusHistory { product_status = 0, user_id = Convert.ToUInt32(writerId), type = 5 }));
ItemPriceTempMgr itemTempPriceMgr = new ItemPriceTempMgr("");
sqls.Add(itemTempPriceMgr.Delete(product_Id, combo_type, writerId));
PriceMasterTempMgr priceMasterTempMgr = new PriceMasterTempMgr("");
PriceMasterTemp priceMasterTemp = new PriceMasterTemp { writer_Id = writerId, product_id = product_Id, combo_type = combo_type };
sqls.Add(priceMasterTempMgr.Delete(priceMasterTemp));
//判斷是單一商品還是組合商品
if (combo_type == 1)
{//單一商品
IProductItemImplDao piDao = new ProductItemDao(connectionStr);
ProductItemTempMgr proItemTempMgr = new ProductItemTempMgr("");
ProductItemTemp proItemTemp = new ProductItemTemp { Writer_Id = writerId, Product_Id = product_Id };
string selItem = proItemTempMgr.QuerySql(proItemTemp);
string moveItem = proItemTempMgr.MoveProductItem(proItemTemp);
sqls.Add(proItemTempMgr.DeleteSql(proItemTemp));
/*************start*課程相關*****************/
//CourseDetailItem
ICourseDetailItemTempImplMgr _cdItemMgr = new CourseDetailItemTempMgr("");
string moveCourDetaItem = _cdItemMgr.MoveCourseDetailItem(writerId);
sqls.Add(_cdItemMgr.DeleteSql(writerId));
//CourseProduct
ICourseProductTempImplMgr _courProdTempMgr = new CourseProductTempMgr("");
var courProdTemp = new CourseProductTemp { Writer_Id = writerId, Product_Id = uint.Parse(product_Id) };
string moveCourProd = _courProdTempMgr.MoveCourseProduct(courProdTemp);
sqls.Add(_courProdTempMgr.DeleteSql(courProdTemp));
/*************end**********************************/
ProductSpecTempMgr proSpecTempMgr = new ProductSpecTempMgr("");
ProductSpecTemp proSpecTemp = new ProductSpecTemp { Writer_Id = writerId, product_id = product_Id };
sqls.Add(proSpecTempMgr.TempMoveSpec(proSpecTemp));
sqls.Add(proSpecTempMgr.TempDelete(proSpecTemp));
string priceMaster = priceMasterTempMgr.Move2PriceMaster(priceMasterTemp);
ItemPriceMgr itemPriceMgr = new ItemPriceMgr("");
string itemPrice = itemPriceMgr.SaveFromItem(writerId, product_Id);
product_id = _productDao.TempMove2Pro(movePro, moveCourProd, moveItem, moveCourDetaItem, selItem, priceMaster, itemPrice, sqls);
//把商品推薦屬性臨時表中的數據moveto商品推薦屬性表中,然後刪除商品推薦臨時表 通過product_id指定商品推薦屬性對應的商品
#region 推薦商品屬性插入recommended_product_attribute表中做記錄
if (_rProductAttribute.ExsitInTemp(writerId, int.Parse(product_Id), combo_type) > 0)//判斷臨時表中是否存在 product_Id為傳入的productId
{
DataTable _dt = _rProductAttribute.GetTempList(writerId, int.Parse(product_Id), combo_type);
RecommendedProductAttribute rPA = new RecommendedProductAttribute();
rPA.product_id = Convert.ToUInt32(product_id);
rPA.time_start = 0;
rPA.time_end = 0;
rPA.expend_day = Convert.ToUInt32(_dt.Rows[0]["expend_day"]);
rPA.months = _dt.Rows[0]["months"].ToString();
rPA.combo_type = 1;
if (_rProductAttribute.GetMsgByProductId(product_id) > 0)//如果大於0,表示推薦表中存在數據
{
if (_rProductAttribute.Update(rPA) > 0)
{
_rProductAttribute.DeleteTemp(writerId, int.Parse(product_Id), combo_type);//刪除臨時表中的數據
}
}
else
{
if (_rProductAttribute.Save(rPA) > 0)
{
_rProductAttribute.DeleteTemp(writerId, int.Parse(product_Id), combo_type);//刪除臨時表中的數據
}
}
}
#endregion
if (product_id > 0)
{
piDao.UpdateErpId(product_id.ToString());
}
return product_id;
}
else
{//組合商品
ProductComboTempMgr pcTempMgr = new ProductComboTempMgr("");
ProductComboTemp proComboTemp = new ProductComboTemp { Writer_Id = writerId, Parent_Id = product_Id };
sqls.Add(pcTempMgr.TempMoveCombo(proComboTemp));
sqls.Add(pcTempMgr.TempDelete(proComboTemp));
string selPrice = priceMasterTempMgr.SelectChild(priceMasterTemp);
string priceMaster = priceMasterTempMgr.Move2PriceMasterByMasterId();
ItemPriceTempMgr itemPriceTempMgr = new ItemPriceTempMgr("");
string itemPrice = itemPriceTempMgr.Move2ItemPrice();
sqls.Add(itemPriceTempMgr.Delete(product_Id, combo_type, writerId));
product_id = _productDao.TempMove2Pro(movePro, "", "", "", selPrice, priceMaster, itemPrice, sqls);
//把商品推薦屬性臨時表中的數據moveto商品推薦屬性表中,然後刪除商品推薦臨時表 通過product_id指定商品推薦屬性對應的商品
#region 推薦商品屬性插入recommended_product_attribute表中做記錄
if (_rProductAttribute.ExsitInTemp(writerId, int.Parse(product_Id), combo_type) > 0)//判斷臨時表中是否存在 product_Id為傳入的productId
{
DataTable _dt = _rProductAttribute.GetTempList(writerId, int.Parse(product_Id), combo_type);
RecommendedProductAttribute rPA = new RecommendedProductAttribute();
rPA.product_id = Convert.ToUInt32(product_id);
rPA.time_start = 0;
rPA.time_end = 0;
rPA.expend_day = Convert.ToUInt32(_dt.Rows[0]["expend_day"]);
rPA.months = _dt.Rows[0]["months"].ToString();
rPA.combo_type = 2;
if (_rProductAttribute.GetMsgByProductId(product_id) > 0)//如果大於0,表示推薦表中存在數據
{
if (_rProductAttribute.Update(rPA) > 0)
{
_rProductAttribute.DeleteTemp(writerId, int.Parse(product_Id), combo_type);//刪除臨時表中的數據
}
}
else
{
if (_rProductAttribute.Save(rPA) > 0)
{
_rProductAttribute.DeleteTemp(writerId, int.Parse(product_Id), combo_type);//刪除臨時表中的數據
}
}
}
return product_id;
#endregion
}
}
/// <summary>
/// 刪除服務器上的圖片
/// </summary>
/// <param name="prod">商品圖是否刪除</param>
/// <param name="spec">規格圖是否是否刪除</param>
/// <param name="desc">說明圖是否刪除</param>
/// <param name="spec_id">規格id</param>
/// <param name="product_id">商品id</param>
public void DeletePicOnServer(bool prod, bool spec, bool desc, uint spec_id, string product_id)
{
try
{
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writerId = (int)vendorModel.vendor_id;
_productTempMgr = new ProductTempMgr(connectionString);
_specTempMgr = new ProductSpecTempMgr(connectionString);
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
ArrayList ImgList = new ArrayList();
//刪除對應的圖片
//商品圖
if (prod)
{
ProductTemp query = new ProductTemp { Writer_Id = writerId, Combo_Type = COMBO_TYPE, Create_Channel = 2, Product_Id = product_id };
string fileName = _productTempMgr.GetProTempByVendor(query).FirstOrDefault().Product_Image;
if (!string.IsNullOrEmpty(fileName))
{
ImgList.Add(imgLocalPath + prodPath + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod50Path + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod150Path + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod280Path + GetDetailFolder(fileName) + fileName);
}
}
//規格圖
if (spec)
{
ProductSpecTemp pSpec = new ProductSpecTemp();
pSpec.Writer_Id = writerId;
pSpec.spec_type = 1;
if (spec_id != 0)
{
pSpec.spec_id = spec_id;
}
if (!string.IsNullOrEmpty(product_id))
{
pSpec.product_id = product_id;
}
List<ProductSpecTemp> pSList = _specTempMgr.VendorQuery(pSpec);
foreach (var item in pSList)
{
if (item.spec_image != "")
{
ImgList.Add(imgLocalPath + specPath + GetDetailFolder(item.spec_image) + item.spec_image);
ImgList.Add(imgLocalPath + spec100Path + GetDetailFolder(item.spec_image) + item.spec_image);
ImgList.Add(imgLocalPath + spec280Path + GetDetailFolder(item.spec_image) + item.spec_image);
}
}
}
//商品說明圖
if (desc)
{
ProductPictureTemp query = new ProductPictureTemp { writer_Id = writerId, combo_type = COMBO_TYPE, product_id = product_id };
List<ProductPictureTemp> pPList = _pPicTempMgr.VendorQuery(query);
foreach (var item in pPList)
{
ImgList.Add(imgLocalPath + descPath + GetDetailFolder(item.image_filename) + item.image_filename);
ImgList.Add(imgLocalPath + desc400Path + GetDetailFolder(item.image_filename) + item.image_filename);
}
}
foreach (string item in ImgList)
{
//刪除服務器上對應的圖片
if (System.IO.File.Exists(item))
{
System.IO.File.Delete(item);
}
}
}
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);
}
}
public HttpResponseBase productPictrueTempSave()
{
string json = "{success:true}";
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writerID = (int)vendorModel.vendor_id;
ProductTemp pTemp = new ProductTemp();
_productTempMgr = new ProductTempMgr(connectionString);
_specTempMgr = new ProductSpecTempMgr(connectionString);
pTemp.Writer_Id = writerID;
pTemp.Combo_Type = COMBO_TYPE;
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
pTemp.Product_Id = Request.Params["product_id"];
}
//if (!string.IsNullOrEmpty(Request.Params["OldProductId"]))
//{
// pTemp.Product_Id = Request.Params["OldProductId"];
//}
if (!string.IsNullOrEmpty(Request.Params["image_InsertValue"])) pTemp.Product_Image = Request.Params["image_InsertValue"];
if (!string.IsNullOrEmpty(Request.Params["productMedia"])) pTemp.product_media = Request.Params["productMedia"];
ProductSpecTemp pSpec = new ProductSpecTemp();
List<ProductSpecTemp> pSpecList = new List<ProductSpecTemp>();
if (!string.IsNullOrEmpty(Request.Params["spec_InsertValue"]))
{
string[] Values = Request.Form["spec_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pSpec = new ProductSpecTemp();
pSpec.Writer_Id = writerID;
pSpec.product_id = pTemp.Product_Id;
string[] perValue = Values[i].Split(',');
if (!string.IsNullOrEmpty(perValue[0])) { pSpec.spec_image = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { pSpec.spec_id = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { pSpec.spec_sort = uint.Parse(perValue[2]); };
if (!string.IsNullOrEmpty(perValue[3])) { pSpec.spec_status = uint.Parse(perValue[3]); };
pSpecList.Add(pSpec);
}
}
List<ProductPictureTemp> picList = new List<ProductPictureTemp>();
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
ProductPictureTemp pPic = new ProductPictureTemp();
if (!string.IsNullOrEmpty(Request.Params["picture_InsertValue"]))
{
string[] Values = Request.Form["picture_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pPic = new ProductPictureTemp();
string[] perValue = Values[i].Split(',');
pPic.combo_type = COMBO_TYPE;
pPic.writer_Id = writerID;
pPic.product_id = pTemp.Product_Id;
pPic.image_createdate = Convert.ToInt32(CommonFunction.GetPHPTime());
if (!string.IsNullOrEmpty(perValue[0])) { pPic.image_filename = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { pPic.image_sort = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { pPic.image_state = uint.Parse(perValue[2]); };
picList.Add(pPic);
}
}
try
{
// int writer_id = writerID; // (Session["caller"] as Caller).user_id;
//保存至productTemp
if (pTemp.Product_Image != "" || pTemp.product_media != "")
{
_productTempMgr.ProductTempUpdateByVendor(pTemp, "pic");
}
//保存規格圖
_specTempMgr.Update(pSpecList, "image");
//保存說明圖
ProductPictureTemp proPictureTemp = new ProductPictureTemp { writer_Id = writerID, combo_type = COMBO_TYPE, product_id = pTemp.Product_Id };
_pPicTempMgr.Save(picList, proPictureTemp);
json = "{success:true,msg:\"" + Resources.VendorProduct.SAVE_SUCCESS + "\"}";
}
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,msg:\"" + Resources.VendorProduct.SAVE_FAIL + "\"}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//[HttpPost]
public string QueryExplainPic()
{
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writerID = (int)vendorModel.vendor_id;
string json = string.Empty;
string serverDescPath = imgServerPath + descPath;
ProductPictureTemp query = new ProductPictureTemp();
query.writer_Id = writerID;
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
query.product_id = Request.Form["product_id"];
}
uint pid = 0;
if (uint.TryParse(Request.Params["product_id"], out pid))
{
#region 正式表
_pPicMgr = new ProductPictureMgr(connectionString);
List<ProductPicture> picProList = _pPicMgr.Query(Convert.ToInt32(Request.Form["product_id"]));
foreach (var item in picProList)
{
if (item.image_filename != "")
{
item.image_filename = serverDescPath + GetDetailFolder(item.image_filename) + item.image_filename;
}
}
json = "{success:true,items:" + JsonConvert.SerializeObject(picProList) + "}";
json = json.Replace("image_filename", "img");
#endregion
}
else
{
#region 供應商 臨時表
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
List<ProductPictureTemp> picList = _pPicTempMgr.VendorQuery(query);
foreach (var item in picList)
{
if (item.image_filename != "")
{
item.image_filename = serverDescPath + GetDetailFolder(item.image_filename) + item.image_filename;
}
}
json = "{success:true,items:" + JsonConvert.SerializeObject(picList) + "}";
json = json.Replace("image_filename", "img");
#endregion
}
return json;
}
/// <summary>
/// 從product_temp product_spec_temp 和product_picture中獲取圖片路徑 刪除服務器上面的圖片
/// </summary>
/// <param name="prod">是否獲取product_temp圖片路徑數據</param>
/// <param name="spec">是否獲取product_spec_temp圖片路徑數據</param>
/// <param name="desc">是否獲取product_picture_temp圖片路徑數據</param>
/// <param name="product_id">商品id</param>
public void DeletePicOnServer(bool prod, bool spec, bool desc, string product_id)
{
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int write_Id = Convert.ToInt32(vendorModel.vendor_id);
_productTempMgr = new ProductTempMgr(connectionString);
_specTempMgr = new ProductSpecTempMgr(connectionString);
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
ArrayList ImgList = new ArrayList();
ProductSpecTemp pSpec = new ProductSpecTemp();
pSpec.Writer_Id = write_Id;
pSpec.product_id = product_id;
pSpec.spec_type = 1;
//刪除對應的圖片
//商品圖
if (prod)
{
ProductTemp query = new ProductTemp { Writer_Id = write_Id, Combo_Type = COMBO_TYPE, Product_Id = product_id, Create_Channel = 2 };
string fileName = _productTempMgr.GetProTempByVendor(query).FirstOrDefault().Product_Image;
if (!string.IsNullOrEmpty(fileName))
{
ImgList.Add(imgLocalPath + prodPath + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod50Path + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod150Path + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod280Path + GetDetailFolder(fileName) + fileName);
}
}
//規格圖
if (spec)
{
List<ProductSpecTemp> pSList = _specTempMgr.Query(pSpec);
foreach (var item in pSList)
{
if (item.spec_image != "")
{
ImgList.Add(imgLocalPath + specPath + GetDetailFolder(item.spec_image) + item.spec_image);
ImgList.Add(imgLocalPath + spec100Path + GetDetailFolder(item.spec_image) + item.spec_image);
ImgList.Add(imgLocalPath + spec280Path + GetDetailFolder(item.spec_image) + item.spec_image);
}
}
}
//商品說明圖
if (desc)
{
ProductPictureTemp query = new ProductPictureTemp { writer_Id = write_Id, combo_type = COMBO_TYPE, product_id = product_id };
List<ProductPictureTemp> pPList = _pPicTempMgr.Query(query);
foreach (var item in pPList)
{
ImgList.Add(imgLocalPath + descPath + GetDetailFolder(item.image_filename) + item.image_filename);
ImgList.Add(imgLocalPath + desc400Path + GetDetailFolder(item.image_filename) + item.image_filename);
}
}
foreach (string item in ImgList)
{
//刪除服務器上對應的圖片
if (System.IO.File.Exists(item))
{
System.IO.File.Delete(item);
}
}
}
public string QueryExplainPic()
{
string json = string.Empty;
//查找臨時表記錄
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writd_Id = Convert.ToInt32(vendorModel.vendor_id);
ProductPictureTemp temp = new ProductPictureTemp { writer_Id = writd_Id, combo_type = COMBO_TYPE };
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
temp.product_id = Request.Params["product_id"].ToString();
}
//if (!string.IsNullOrEmpty(Request.Params["OldProductId"]))
//{
// temp.product_id = Request.Params["OldProductId"].ToString();
//}
if (!string.IsNullOrEmpty(Request.Params["isEdit"]) && Request.Params["isEdit"].ToString() == "true")
{
List<ProductPictureTemp> picList = _pPicTempMgr.Query(temp);
foreach (var item in picList)
{
if (item.image_filename != "")
{
item.image_filename = imgServerPath + descPath + GetDetailFolder(item.image_filename) + item.image_filename;
}
}
json = "{success:true,items:" + JsonConvert.SerializeObject(picList) + "}";
}
else
{
}
json = json.Replace("image_filename", "img");
return json;
}
public string VendorSaveFromProPicture(ProductPictureTemp proPictureTemp, string old_product_Id)
{
StringBuilder strSql = new StringBuilder("insert into product_picture_temp (writer_id,product_id,image_filename,image_sort,image_state,image_createdate,combo_type) ");
strSql.AppendFormat("select {0} as writer_id, '{1}' as product_id,image_filename,image_sort,image_state,image_createdate,{2} as combo_type", proPictureTemp.writer_Id, proPictureTemp.product_id, proPictureTemp.combo_type);
uint productid = 0;
if (uint.TryParse(old_product_Id, out productid))
{
strSql.AppendFormat(" from product_picture where product_id={0};", productid);
}
else
{
strSql.AppendFormat(" from product_picture_temp where product_id='{0}';", old_product_Id);
}
return strSql.ToString();
}
/// <summary>
/// 管理員核可供應商建立的商品時將商品圖檔信息由臨時表移動到正式表
/// </summary>
/// <param name="proPictureTemp">臨時表中的數據對象</param>
/// <returns>此操作的sql語句</returns>
public string Vendor_MoveToProductPicture(ProductPictureTemp proPictureTemp)
{
try
{
return _productPicTempDao.Vendor_MoveToProductPicture(proPictureTemp);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->Vendor_MoveToProductPicture-->" + ex.Message, ex);
}
}
public string QueryExplainPic()
{
int apporexplain = Convert.ToInt32(Request["apporexplain"]);
string json = string.Empty;
SetPath(apporexplain);
if (string.IsNullOrEmpty(Request.Params["product_id"]))
{
//查找臨時表記錄
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
int writer_Id = (Session["caller"] as Caller).user_id;
ProductPictureTemp temp = new ProductPictureTemp { writer_Id = writer_Id, combo_type = COMBO_TYPE };
if (!string.IsNullOrEmpty(Request.Params["OldProductId"]))
{
temp.product_id = Request.Params["OldProductId"];
}
List<ProductPictureTemp> picList = _pPicTempMgr.Query(temp, apporexplain);
foreach (var item in picList)
{
if (item.image_filename != "")
{
if (item.pic_type == 2) ///edti by wwei0216w 當是手機圖片時,將查找的物理路徑改變為手機的路徑
{
descPath = "/product_picture/mobile/";
}
item.image_filename = imgServerPath + descPath + GetDetailFolder(item.image_filename) + item.image_filename;
}
}
json = "{success:true,items:" + JsonConvert.SerializeObject(picList) + "}";
json = json.Replace("image_filename", "img");
}
else
{
//查詢正式表
_productPicMgr = new ProductPictureMgr(connectionString);
int product_id = int.Parse(Request.Params["product_id"]);
List<ProductPicture> pList = _productPicMgr.Query(product_id, apporexplain);
foreach (var item in pList)
{
if (item.image_filename != "")
{
if (item.pic_type == 2) ///edti by wwei0216w 當是手機圖片時,將查找的物理路徑改變為手機的路徑
{
descPath = "/product_picture/mobile/";
}
item.image_filename = imgServerPath + descPath + GetDetailFolder(item.image_filename) + item.image_filename;
}
}
json = "{success:true,items:" + JsonConvert.SerializeObject(pList) + "}";
json = json.Replace("image_filename", "img");
}
return json;
}
public string VendorSaveFromProPicture(ProductPictureTemp proPictureTemp, string old_product_Id)
{
try
{
return _productPicTempDao.VendorSaveFromProPicture(proPictureTemp, old_product_Id);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->VendorSaveFromProPicture-->" + ex.Message, ex);
}
}
public string DeleteByVendor(ProductPictureTemp proPictureTemp)
{
try
{
return _productPicTempDao.DeleteByVendor(proPictureTemp);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->DeleteByVendor-->" + ex.Message, ex);
}
}
/// <summary>
/// 管理員核可供應商建立的商品時將商品圖檔信息由臨時表移動到正式表
/// </summary>
/// <param name="proPictureTemp">臨時表中的數據對象</param>
/// <returns>此操作的sql語句</returns>
public string Vendor_Delete(ProductPictureTemp proPictureTemp)
{
StringBuilder strSql = new StringBuilder("set sql_safe_updates=0; delete from product_picture_temp where ");
//strSql.AppendFormat(" writer_id={0} and combo_type={1}", proPictureTemp.writer_Id, proPictureTemp.combo_type);
strSql.AppendFormat(" product_id='{0}';set sql_safe_updates = 1;", proPictureTemp.product_id);
return strSql.ToString();
}
/// <summary>
/// 管理員核可供應商建立的商品時將商品圖檔信息由臨時表移動到正式表
/// </summary>
/// <param name="proPictureTemp">臨時表中的數據對象</param>
/// <returns>此操作的sql語句</returns>
public string Vendor_MoveToProductPicture(ProductPictureTemp proPictureTemp)
{
StringBuilder sql = new StringBuilder("insert into product_picture(product_id,image_filename,image_sort,image_state,image_createdate)");
sql.Append(" select {0} as product_id,image_filename,image_sort,image_state,image_createdate from product_picture_temp where 1=1");
if (proPictureTemp.writer_Id != 0)
{
sql.AppendFormat(" and writer_id={0}", proPictureTemp.writer_Id);
}
sql.AppendFormat(" and product_id='{0}' and combo_type={1};", proPictureTemp.product_id, proPictureTemp.combo_type);
return sql.ToString();
}
public int Vendor_TempMove2Pro(int writerId, int combo_type, string product_Id, ProductTemp pt)
{
ArrayList sqls = new ArrayList();
int product_id = 0;
ProductTempMgr proTempMgr = new ProductTempMgr("");
ProductTemp proTemp = new ProductTemp { Combo_Type = combo_type, Product_Id = product_Id, Create_Channel = 2 };//1:後台管理者(manage_user) edit by xiagnwang0413w 2014/08/09
string movePro = proTempMgr.Vendor_MoveProduct(proTemp);
sqls.Add(proTempMgr.Vendor_Delete(proTemp));
ProductNoticeSetTempMgr proNoticeSetTempMgr = new ProductNoticeSetTempMgr("");
ProductNoticeSetTemp proNoticeSetTemp = new ProductNoticeSetTemp { Combo_Type = combo_type, product_id = product_Id };
sqls.Add(proNoticeSetTempMgr.Vendor_MoveNotice(proNoticeSetTemp));
sqls.Add(proNoticeSetTempMgr.Vendor_Delete(proNoticeSetTemp));
ProductTagSetTempMgr proTagSetTempMgr = new ProductTagSetTempMgr("");
ProductTagSetTemp proTagSetTemp = new ProductTagSetTemp { Combo_Type = combo_type, product_id = product_Id };
sqls.Add(proTagSetTempMgr.Vendor_MoveTag(proTagSetTemp));
sqls.Add(proTagSetTempMgr.Vendor_Delete(proTagSetTemp));
ProductPictureTempImplMgr proPicTempMgr = new ProductPictureTempImplMgr("");
ProductPictureTemp proPictureTemp = new ProductPictureTemp { combo_type = combo_type, product_id = product_Id };
sqls.Add(proPicTempMgr.Vendor_MoveToProductPicture(proPictureTemp));
sqls.Add(proPicTempMgr.Vendor_Delete(proPictureTemp));
ProductCategorySetTempMgr proCateSetTempMgr = new ProductCategorySetTempMgr("");
ProductCategorySetTemp proCategorySetTemp = new ProductCategorySetTemp { Combo_Type = combo_type, Product_Id = product_Id.ToString() };
sqls.Add(proCateSetTempMgr.Vendor_TempMoveCategory(proCategorySetTemp));
sqls.Add(proCateSetTempMgr.Vendor_TempDelete(proCategorySetTemp));
//product_status_history.type 1,申請審核 2,核可 3,駁回 4,下架 5,新建商品 6,上架 7,系統移轉建立 8,取消送審 parametertype='verify_operate_type'
//product_status_history.product_status 0,新建立商品 1,申請審核 2,審核通過 5,上架 6,下架 20,供應商新建商品 parametertype='product_status'
ProductStatusHistoryMgr proStatusHistoryMgr = new ProductStatusHistoryMgr("");
sqls.Add(proStatusHistoryMgr.SaveNoProductId(new ProductStatusHistory { product_status = 20, user_id = Convert.ToUInt32(pt.Writer_Id), type = 5 }));//供應商新建立商品
sqls.Add(proStatusHistoryMgr.SaveNoProductId(new ProductStatusHistory { product_status = 0, user_id = Convert.ToUInt32(writerId), type = 2 })); //管理員核可
ItemPriceTempMgr itemTempPriceMgr = new ItemPriceTempMgr("");
sqls.Add(itemTempPriceMgr.Vendor_Delete(product_Id, combo_type, 0));
PriceMasterTempMgr priceMasterTempMgr = new PriceMasterTempMgr("");
PriceMasterTemp priceMasterTemp = new PriceMasterTemp { product_id = product_Id, combo_type = combo_type };
sqls.Add(priceMasterTempMgr.Vendor_Delete(priceMasterTemp));
//判斷是單一商品還是組合商品
if (combo_type == 1)
{//單一商品
IProductItemImplDao piDao = new ProductItemDao(connectionStr);
ProductItemTempMgr proItemTempMgr = new ProductItemTempMgr("");
ProductItemTemp proItemTemp = new ProductItemTemp { Product_Id = product_Id };
string selItem = proItemTempMgr.VendorQuerySql(proItemTemp);
string moveItem = proItemTempMgr.VendorMoveProductItem(proItemTemp);//方法修改了writerId
sqls.Add(proItemTempMgr.DeleteVendorSql(proItemTemp));
ProductSpecTempMgr proSpecTempMgr = new ProductSpecTempMgr("");
ProductSpecTemp proSpecTemp = new ProductSpecTemp { product_id = product_Id };
sqls.Add(proSpecTempMgr.VendorTempMoveSpec(proSpecTemp));
sqls.Add(proSpecTempMgr.VendorTempDelete(proSpecTemp));
string priceMaster = priceMasterTempMgr.VendorMove2PriceMaster(priceMasterTemp);
ItemPriceMgr itemPriceMgr = new ItemPriceMgr("");
string itemPrice = itemPriceMgr.SaveFromItem(pt.Writer_Id, pt.Product_Id);
// add 處理price_mater_temp and product_combo_temp
sqls.Add(proTempMgr.VendorEditCM(proTemp));
product_id = _productDao.TempMove2Pro(movePro, "", moveItem, "", selItem, priceMaster, itemPrice, sqls);
if (product_id > 0)
{
piDao.UpdateErpId(product_id.ToString());
}
return product_id;
}
else
{//組合商品
ProductComboTempMgr pcTempMgr = new ProductComboTempMgr("");
ProductComboTemp proComboTemp = new ProductComboTemp { Parent_Id = product_Id };
sqls.Add(pcTempMgr.Vendor_TempMoveCombo(proComboTemp));
sqls.Add(pcTempMgr.TempDeleteByVendor(proComboTemp));
string selPrice = priceMasterTempMgr.SelectChild(priceMasterTemp);
string priceMaster = priceMasterTempMgr.VendorMove2PriceMaster(priceMasterTemp);
ItemPriceTempMgr itemPriceTempMgr = new ItemPriceTempMgr("");
string itemPrice = itemPriceTempMgr.VendorMove2ItemPrice();
sqls.Add(itemPriceTempMgr.Vendor_Delete(product_Id, combo_type, 0));
return _productDao.TempMove2Pro(movePro, "", "", "", selPrice, priceMaster, itemPrice, sqls);
}
//記錄的sql語句
//insert into product(product_id,brand_id,product_vendor_code,product_name,product_price_list,product_spec,spec_title_1,spec_title_2,product_freight_set,product_buy_limit,product_status,product_hide,product_mode,product_sort,product_start,product_end,page_content_1,page_content_2,page_content_3,product_keywords,product_recommend,product_password,product_total_click,expect_time,product_image,product_createdate,product_updatedate,product_ipfrom,goods_area,goods_image1,goods_image2,city,bag_check_money,combination,bonus_percent,default_bonus_percent,bonus_percent_start,bonus_percent_end,tax_type,cate_id,fortune_quota,fortune_freight,product_media,ignore_stock,shortage,stock_alarm,price_type,user_id,show_listprice,expect_msg,create_channel ) select 15164 as product_id,brand_id,product_vendor_code,product_name,product_price_list,product_spec,spec_title_1,spec_title_2,product_freight_set,product_buy_limit,'0' as product_status,product_hide,product_mode,product_sort,product_start,product_end,page_content_1,page_content_2,page_content_3,product_keywords,product_recommend,product_password,product_total_click,expect_time,product_image,1411033321 as product_createdate,product_updatedate,product_ipfrom,goods_area,goods_image1,goods_image2,city,bag_check_money,combination,bonus_percent,default_bonus_percent,bonus_percent_start,bonus_percent_end,tax_type,cate_id,fortune_quota,fortune_freight,product_media,ignore_stock,shortage,stock_alarm,price_type,writer_id,show_listprice,expect_msg,create_channel from product_temp where 1=1 and combo_type=2 and create_channel=2 and product_id='T578';
//select price_master_id,product_id,child_id from price_master_temp where 1=1 and combo_type=2 and product_id='T578';
//insert into price_master(`product_id`,`site_id`,`user_level`,`user_id`,`product_name`,`accumulated_bonus`,`bonus_percent`,`default_bonus_percent`,`same_price`,`event_start`,`event_end`,`price_status`,`price`,`event_price`,`child_id`,`cost`,`event_cost`,`bonus_percent_start`,`bonus_percent_end`,`max_price`,`max_event_price`,`valid_start`,`valid_end`)
//select 15164 as product_id,site_id,user_level,user_id,product_name,accumulated_bonus,bonus_percent,default_bonus_percent,same_price,event_start,event_end,price_status,price,event_price,15164 as child_id,cost,event_cost,bonus_percent_start,bonus_percent_end,max_price,max_event_price,valid_start,valid_end from price_master_temp where 1=1 and combo_type=2 and product_id='T578';select @@identity;
//insert into item_price(`price_master_id`,`item_id`,`item_money`,`item_cost`,`event_money`,`event_cost`) select 5699 as price_master_id,item_id,item_money,item_cost,event_money,event_cost from item_price_temp where price_master_id=1751
//set sql_safe_updates = 0;update price_master set child_id=15164 where price_master_id=5699; set sql_safe_updates = 1;
//set sql_safe_updates = 0;delete from product_temp where product_id='T578';set sql_safe_updates = 1
//insert into product_notice_set(product_id,notice_id) select 15164 as product_id,notice_id from product_notice_set_temp where 1=1 and combo_type = 2 and product_id='T578';
//set sql_safe_updates=0;delete from product_notice_set_temp where product_id='T578';set sql_safe_updates=1;
//insert into product_tag_set(`product_id`,`tag_id`) select 15164 as product_id,tag_id from product_tag_set_temp where 1=1 and combo_type=2 and product_id='T578';
//set sql_safe_updates=0;delete from product_tag_set_temp where product_id='T578';set sql_safe_updates=1;
//insert into product_picture(product_id,image_filename,image_sort,image_state,image_createdate) select 15164 as product_id,image_filename,image_sort,image_state,image_createdate from product_picture_temp where 1=1 and product_id='T578' and combo_type=2;
//set sql_safe_updates=0; delete from product_picture_temp where product_id='T578';set sql_safe_updates = 1;
//insert into product_category_set(product_id,category_id,brand_id) select 15164 as product_id,category_id,brand_id from product_category_set_temp where 1=1 and product_id='T578' and combo_type = 2
//set sql_safe_updates = 0; delete from product_category_set_temp where 1=1 and combo_type = 2 and product_id='T578';set sql_safe_updates = 1;
//set sql_safe_updates = 0; insert into product_status_history (`product_id`,`user_id`,`create_time`,`type`,`product_status`,`remark`) values (15164,0,now(),5,20,'');set sql_safe_updates = 1;
//set sql_safe_updates = 0; insert into product_status_history (`product_id`,`user_id`,`create_time`,`type`,`product_status`,`remark`) values (15164,122,now(),2,0,'');set sql_safe_updates = 1;
//set sql_safe_updates=0;delete item_price_temp from price_master_temp left join item_price_temp on item_price_temp.price_master_id=price_master_temp.price_master_id where 1=1 and price_master_temp.product_id='T578' and price_master_temp.combo_type=2 ;set sql_safe_updates=1;
//set sql_safe_updates = 0;delete from price_master_temp where 1=1 and product_id='T578' and combo_type=2;set sql_safe_updates = 1;
//insert into product_combo(`parent_id`,`child_id`,`s_must_buy`,`g_must_buy`,`pile_id`,`buy_limit`) select 15164 as parent_id,child_id,s_must_buy,g_must_buy,pile_id,buy_limit from product_combo_temp where 1=1 and parent_id='T578';
//set sql_safe_updates = 0; delete from product_combo_temp where writer_id = 0 and parent_id='T578'; set sql_safe_updates= 1;
//set sql_safe_updates=0;delete item_price_temp from price_master_temp left join item_price_temp on item_price_temp.price_master_id=price_master_temp.price_master_id where 1=1 and price_master_temp.product_id='T578' and price_master_temp.combo_type=2 ;set sql_safe_updates=1;
//SELECT * from product where product_id='15164'
}
public string DeleteByVendor(ProductPictureTemp proPictureTemp)
{
StringBuilder strSql = new StringBuilder("set sql_safe_updates=0; delete from product_picture_temp ");
strSql.AppendFormat("where writer_id={0} and combo_type={1}", proPictureTemp.writer_Id, proPictureTemp.combo_type);
strSql.AppendFormat(" and product_id='{0}';set sql_safe_updates = 1;", proPictureTemp.product_id);//edit by xiangwang0413w 2014/10/08 不等於0的商品不再是本次新複製的商品
return strSql.ToString();
}
public void DeletePicOnServer(bool prod, bool spec, bool desc, string product_id, int type = 1)
{
int writerId = (Session["caller"] as Caller).user_id;
_productTempMgr = new ProductTempMgr(connectionString);
_specTempMgr = new ProductSpecTempMgr(connectionString);
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
ArrayList ImgList = new ArrayList();
ProductSpecTemp pSpec = new ProductSpecTemp();
pSpec.Writer_Id = writerId;
pSpec.spec_type = 1;
//刪除對應的圖片
//商品圖
if (prod)
{
ProductTemp query = new ProductTemp { Writer_Id = writerId, Combo_Type = COMBO_TYPE, Product_Id = product_id.ToString() };
string fileName = _productTempMgr.GetProTemp(query).Product_Image;
if (!string.IsNullOrEmpty(fileName))
{
ImgList.Add(imgLocalPath + prodPath + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod50Path + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod150Path + GetDetailFolder(fileName) + fileName);
ImgList.Add(imgLocalPath + prod280Path + GetDetailFolder(fileName) + fileName);
}
}
//規格圖
if (spec)
{
List<ProductSpecTemp> pSList = _specTempMgr.Query(pSpec);
foreach (var item in pSList)
{
if (item.spec_image != "")
{
ImgList.Add(imgLocalPath + specPath + GetDetailFolder(item.spec_image) + item.spec_image);
ImgList.Add(imgLocalPath + spec100Path + GetDetailFolder(item.spec_image) + item.spec_image);
ImgList.Add(imgLocalPath + spec280Path + GetDetailFolder(item.spec_image) + item.spec_image);
}
}
}
//商品說明圖
if (desc)
{
ProductPictureTemp query = new ProductPictureTemp { writer_Id = writerId, combo_type = COMBO_TYPE, product_id = product_id };
List<ProductPictureTemp> pPList = _pPicTempMgr.Query(query);
SetPath(type);
foreach (var item in pPList)
{
ImgList.Add(imgLocalPath + descPath + GetDetailFolder(item.image_filename) + item.image_filename);
ImgList.Add(imgLocalPath + desc400Path + GetDetailFolder(item.image_filename) + item.image_filename);
}
}
foreach (string item in ImgList)
{
//刪除服務器上對應的圖片
if (System.IO.File.Exists(item))
{
System.IO.File.Delete(item);
}
}
}
public List<ProductPictureTemp> VendorQuery(ProductPictureTemp proPictureTemp)
{
StringBuilder stb = new StringBuilder();
try
{
stb.AppendFormat("select image_filename,image_sort,image_state from product_picture_temp where 1=1 ");
if (proPictureTemp.writer_Id != 0)
{
stb.AppendFormat(" and writer_id={0} ", proPictureTemp.writer_Id);
}
if (proPictureTemp.combo_type != 0)
{
stb.AppendFormat(" and combo_type={0} ", proPictureTemp.combo_type);
}
if (!string.IsNullOrEmpty(proPictureTemp.product_id))
{
stb.AppendFormat(" and product_id='{0}' ", proPictureTemp.product_id);
}
return _dbAccess.getDataTableForObj<ProductPictureTemp>(stb.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempDao-->VendorQuery-->" + ex.Message + stb.ToString(), ex);
}
}
public HttpResponseBase productPictrueTempSave()
{
string json = "{success:true}";
ProductTemp pTemp = new ProductTemp();
_productTempMgr = new ProductTempMgr(connectionString);
_specTempMgr = new ProductSpecTempMgr(connectionString);
_productPicMgr = new ProductPictureMgr(connectionString);
_specMgr = new ProductSpecMgr(connectionString);
if (string.IsNullOrEmpty(Request.Params["product_id"]))
{
if (!string.IsNullOrEmpty(Request.Params["image_InsertValue"])) pTemp.Product_Image = Request.Params["image_InsertValue"];
if (!string.IsNullOrEmpty(Request.Params["image_MobileValue"])) pTemp.Mobile_Image = Request.Params["image_MobileValue"];//如果手機說明圖有值,將值賦予Moibile_Image edit by wwei0216w 2015/3/18
if (!string.IsNullOrEmpty(Request.Params["productMedia"])) pTemp.product_media = Request.Params["productMedia"];
if (!string.IsNullOrEmpty(Request.Params["specify_Product_alt"])) pTemp.Product_alt = Request.Params["specify_Product_alt"];//add by wwei0216w 2015/4/9
pTemp.Writer_Id = (Session["caller"] as Caller).user_id;
pTemp.Combo_Type = COMBO_TYPE;
if (!string.IsNullOrEmpty(Request.Form["OldProductId"]))
{
pTemp.Product_Id = Request.Form["OldProductId"];
}
ProductSpecTemp pSpec = new ProductSpecTemp();
List<ProductSpecTemp> pSpecList = new List<ProductSpecTemp>();
if (!string.IsNullOrEmpty(Request.Params["spec_InsertValue"]))
{
string[] Values = Request.Form["spec_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pSpec = new ProductSpecTemp();
pSpec.Writer_Id = (Session["caller"] as Caller).user_id;
pSpec.product_id = pTemp.Product_Id;
string[] perValue = Values[i].Split(',');
if (!string.IsNullOrEmpty(perValue[0])) { pSpec.spec_image = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { pSpec.spec_id = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { pSpec.spec_sort = uint.Parse(perValue[2]); };
if (!string.IsNullOrEmpty(perValue[3])) { pSpec.spec_status = uint.Parse(perValue[3]); };
pSpecList.Add(pSpec);
}
}
List<ProductPictureTemp> picList = new List<ProductPictureTemp>();
_pPicTempMgr = new ProductPictureTempImplMgr(connectionString);
ProductPictureTemp pPic = new ProductPictureTemp();
if (!string.IsNullOrEmpty(Request.Params["picture_InsertValue"]))
{
string[] Values = Request.Form["picture_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pPic = new ProductPictureTemp();
string[] perValue = Values[i].Split(',');
pPic.combo_type = COMBO_TYPE;
pPic.writer_Id = (Session["caller"] as Caller).user_id;
pPic.product_id = pTemp.Product_Id;
if (!string.IsNullOrEmpty(perValue[0])) { pPic.image_filename = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { pPic.image_sort = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { pPic.image_state = uint.Parse(perValue[2]); };
picList.Add(pPic);
}
}
//關於手機APP的代碼部份
List<ProductPictureTemp> picAppList = new List<ProductPictureTemp>();
//IProductPictureTempImplAppMgr ppt = new ProductPictureAppTempImplMgr(connectionString);
ProductPictureTemp pa = new ProductPictureTemp();
if (!string.IsNullOrEmpty(Request.Params["mobilePic_InsertValue"]))
{
string[] Values = Request.Form["mobilePic_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pa = new ProductPictureTemp();
string[] AppValue = Values[i].Split(',');
pa.combo_type = COMBO_TYPE;
pa.writer_Id = (Session["caller"] as Caller).user_id;
pa.product_id = pTemp.Product_Id;
if (!string.IsNullOrEmpty(AppValue[0])) { pa.image_filename = AppValue[0]; };
if (!string.IsNullOrEmpty(AppValue[1])) { pa.image_sort = uint.Parse(AppValue[1]); };
if (!string.IsNullOrEmpty(AppValue[2])) { pa.image_state = uint.Parse(AppValue[2]); };
picAppList.Add(pa);
}
}
try
{
int type = 1;//1：商品說明圖,2：手機App說明圖
int writer_id = (Session["caller"] as Caller).user_id;
//保存至productTemp
if (pTemp.Product_Image != "" || pTemp.product_media != "" || pTemp.Mobile_Image != "" || pTemp.Product_alt != "")
{
_productTempMgr.ProductTempUpdate(pTemp, "pic");
}
//保存規格圖
_specTempMgr.Update(pSpecList, "image");
//保存說明圖
string oldProductId = "0";
if (!string.IsNullOrEmpty(Request.Form["OldProductId"]))
{
oldProductId = Request.Form["OldProductId"];
}
_pPicTempMgr.Save(picList, new ProductPictureTemp() { writer_Id = writer_id, combo_type = COMBO_TYPE, product_id = oldProductId }, type);// edit by wangwei0216w 註釋掉_pPicTempMgr.Save 以解決複製后不能讀取圖片路勁到數據庫
type = 2;
_pPicTempMgr.Save(picAppList, new ProductPictureTemp() { writer_Id = writer_id, combo_type = COMBO_TYPE, product_id = oldProductId }, type);
}
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,msg:\"" + Resources.Product.EDIT_FAIL + "\"}";
}
}
else//更新正式表
{
Product p = new Product();
uint productId = uint.Parse(Request.Params["product_id"]);
if (!string.IsNullOrEmpty(Request.Params["image_InsertValue"])) p.Product_Image = Request.Params["image_InsertValue"];//如果商品說明圖有值,將值賦予Product_Image
if (!string.IsNullOrEmpty(Request.Params["image_MobileValue"])) p.Mobile_Image = Request.Params["image_MobileValue"];//如果手機說明圖有值,將值賦予Moibile_Image edit by wwei0216w 2015/3/18
if (!string.IsNullOrEmpty(Request.Params["productMedia"])) p.product_media = Request.Params["productMedia"];
if (!string.IsNullOrEmpty(Request.Params["specify_Product_alt"])) p.Product_alt = Request.Params["specify_Product_alt"];//add by wwei0216w 2015/4/9
p.Product_Id = productId;
_productMgr = new ProductMgr(connectionString);
ProductSpec pSpec = new ProductSpec();
List<ProductSpec> pSpecList = new List<ProductSpec>();
if (!string.IsNullOrEmpty(Request.Params["spec_InsertValue"]))
{
string[] Values = Request.Form["spec_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pSpec = new ProductSpec();
pSpec.product_id = productId;
string[] perValue = Values[i].Split(',');
if (!string.IsNullOrEmpty(perValue[0])) { pSpec.spec_image = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { pSpec.spec_id = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { pSpec.spec_sort = uint.Parse(perValue[2]); };
if (!string.IsNullOrEmpty(perValue[3])) { pSpec.spec_status = uint.Parse(perValue[3]); };
pSpecList.Add(pSpec);
}
}
List<ProductPicture> picList = new List<ProductPicture>();
_productPicMgr = new ProductPictureMgr(connectionString);
ProductPicture pPic = new ProductPicture();
if (!string.IsNullOrEmpty(Request.Params["picture_InsertValue"]))
{
string[] Values = Request.Form["picture_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
pPic = new ProductPicture();
string[] perValue = Values[i].Split(',');
pPic.product_id = int.Parse(Request.Params["product_id"]);
if (!string.IsNullOrEmpty(perValue[0])) { pPic.image_filename = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { pPic.image_sort = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { pPic.image_state = uint.Parse(perValue[2]); };
picList.Add(pPic);
}
}
//手機app圖檔
List<ProductPicture> appList = new List<ProductPicture>();
_productPicMgr = new ProductPictureMgr(connectionString);
ProductPicture apppPic = new ProductPicture();
if (!string.IsNullOrEmpty(Request.Params["mobilePic_InsertValue"]))
{
string[] Values = Request.Form["mobilePic_InsertValue"].ToString().Split(';');
for (int i = 0; i < Values.Length - 1; i++)
{
apppPic = new ProductPicture();
string[] perValue = Values[i].Split(',');
apppPic.product_id = int.Parse(Request.Params["product_id"]);
if (!string.IsNullOrEmpty(perValue[0])) { apppPic.image_filename = perValue[0]; };
if (!string.IsNullOrEmpty(perValue[1])) { apppPic.image_sort = uint.Parse(perValue[1]); };
if (!string.IsNullOrEmpty(perValue[2])) { apppPic.image_state = uint.Parse(perValue[2]); };
appList.Add(apppPic);
}
}
try
{
_productMgr.Update_Product_Spec_Picture(p, pSpecList, picList, appList);
json = "{success:true,msg:\"" + Resources.Product.SAVE_SUCCESS + "\"}";
}
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:true,msg:\"" + Resources.Product.SAVE_FAIL + "\"}";
}
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<ProductPictureTemp> VendorQuery(ProductPictureTemp proPictureTemp)
{
try
{
return _productPicTempDao.VendorQuery(proPictureTemp);
}
catch (Exception ex)
{
throw new Exception("ProductPictureTempImplMgr-->VendorQuery-->" + ex.Message, ex);
}
}