/// <summary>
/// 保存基本資料
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public int baseInfoSave(ProductTemp p)
{
try
{
p.Replace4MySQL();
StringBuilder strSql = new StringBuilder("insert into product_temp( ");
strSql.Append(" `writer_id`,`product_id`,`brand_id`,`product_vendor_code`,");
strSql.Append(" `product_name`,`product_price_list`,`product_spec`,`spec_title_1`,`spec_title_2`,");
strSql.Append(" `product_freight_set`,`product_buy_limit`,`product_status`,`product_hide`,");
strSql.Append(" `product_mode`,`product_sort`,`product_start`,`product_end`,`page_content_1`,`page_content_2`,");
strSql.Append(" `page_content_3`,`product_keywords`,`product_recommend`,`product_password`,");
strSql.Append(" `product_total_click`,`expect_time`,`product_image`,`product_createdate`,`product_updatedate`,");
strSql.Append(" `product_ipfrom`,`goods_area`,`goods_image1`,`goods_image2`,`city`,");
strSql.Append(" `bag_check_money`,`combination`,`bonus_percent`,`default_bonus_percent`,`bonus_percent_start`,`bonus_percent_end`,`tax_type`,`cate_id`,");
strSql.Append(" `fortune_quota`,`fortune_freight`,`combo_type`,`product_media`,`ignore_stock`,`shortage`,`stock_alarm`,`price_type`,`show_listprice`,`expect_msg`,`create_channel`,");
strSql.Append(" `show_in_deliver`,`prepaid`,`process_type`,`product_type`,`prod_name`,`prod_sz`,`prod_classify`,`deliver_days`,`min_purchase_amount`,`safe_stock_amount`,`extra_days`,`product_alt`,`purchase_in_advance`,`purchase_in_advance_start`,`purchase_in_advance_end`) values ("); //商品新增欄位 add by zhuoqin0830w 2015/03/17
strSql.AppendFormat(" '{0}','{1}','{2}','{3}',", p.Writer_Id, p.Product_Id, p.Brand_Id, p.Product_Vendor_Code);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Product_Name, p.Product_Price_List, p.Product_Spec, p.Spec_Title_1, p.Spec_Title_2);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}',", p.Product_Freight_Set, p.Product_Buy_Limit, p.Product_Status, p.Product_Hide == false ? 0 : 1);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}',", p.Product_Mode, p.Product_Sort, p.Product_Start, p.Product_End, p.Page_Content_1, p.Page_Content_2);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}',", p.Page_Content_3, p.Product_Keywords, p.Product_Recommend, p.Product_Password);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Product_Total_Click, p.Expect_Time, p.Product_Image, p.Product_Createdate, p.Product_Updatedate);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Product_Ipfrom, p.Goods_Area, p.Goods_Image1, p.Goods_Image2, p.City);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Bag_Check_Money, p.Combination, p.Bonus_Percent, p.Default_Bonus_Percent, p.Bonus_Percent_Start);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}',", p.Bonus_Percent_End, p.Tax_Type, p.Cate_Id, p.Fortune_Quota, p.Fortune_Freight, p.Combo_Type);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.product_media, p.Ignore_Stock, p.Shortage, p.stock_alarm, p.Price_type);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9},", p.show_listprice, p.expect_msg, p.Create_Channel, p.Show_In_Deliver, p.Prepaid, p.Process_Type, p.Product_Type, p.Prod_Name, p.Prod_Sz, p.Prod_Classify);
strSql.AppendFormat(" {0},{1},{2},{3},'{4}','{5}','{6}','{7}');", p.Deliver_Days, p.Min_Purchase_Amount, p.Safe_Stock_Amount, p.Extra_Days, p.Product_alt, p.purchase_in_advance, p.purchase_in_advance_start, p.purchase_in_advance_end);
if (p.expend_day>=0&&p.months!="")//新增單一商品或者組合商品商品推薦臨時表
{
strSql.AppendFormat("insert into recommended_product_attribute_temp(`product_id`,`write_id`,`time_start`,`time_end`,`expend_day`,`months`,`combo_type`)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}');", p.Product_Id, p.Writer_Id, 0, 0, p.expend_day, p.months,p.Combo_Type);
}
return _dbAccess.execCommand(strSql.ToString());
///add by wwei0216w 2015/7/30 添加預購3欄位
}
catch (Exception ex)
{
throw new Exception("ProductTempDao.baseInfoSave-->" + ex.Message, ex);
}
}
/// <summary>
/// 複製商品時跟新商品數據+int vendorBaseInfoUpdate(ProductTemp pTemp)
/// </summary>
/// <param name="pTemp"></param>
/// <returns></returns>
public int vendorBaseInfoUpdate(ProductTemp pTemp)
{
StringBuilder stb = new StringBuilder("");
try
{
pTemp.Replace4MySQL();
stb.Append("set sql_safe_updates=0;update product_temp set");
stb.AppendFormat(" brand_id='{0}',product_name='{1}',product_sort='{2}',product_vendor_code='{3}',product_status={4},", pTemp.Brand_Id, pTemp.Product_Name, pTemp.Product_Sort, pTemp.Product_Vendor_Code, pTemp.Product_Status);
stb.AppendFormat(" product_start='{0}',product_end='{1}',expect_time='{2}',product_freight_set='{3}',product_mode='{4}',tax_type='{5}' ", pTemp.Product_Start, pTemp.Product_End, pTemp.Expect_Time, pTemp.Product_Freight_Set, pTemp.Product_Mode, pTemp.Tax_Type);
stb.AppendFormat(",expect_msg='{0}',bag_check_money={1},temp_status='{2}' ", pTemp.expect_msg, pTemp.Bag_Check_Money, pTemp.Temp_Status);
stb.AppendFormat(" ,product_updatedate={0}", pTemp.Product_Updatedate);
if (pTemp.Combination != 1)
{
stb.AppendFormat(" ,combination = {0}", pTemp.Combination);
}
stb.AppendFormat(" where writer_id = {0} and combo_type={1}", pTemp.Writer_Id, pTemp.Combo_Type);
stb.AppendFormat(" and product_id='{0}' and create_channel={1};set sql_safe_updates=1;", pTemp.Product_Id, pTemp.Create_Channel);
return _dbAccess.execCommand(stb.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductTempDao.vendorBaseInfoUpdate-->" + ex.Message + stb.ToString(), ex);
}
}
public string vendorBaseInfoSave(ProductTemp p)
{
StringBuilder strSql = new StringBuilder("");
try
{
p.Replace4MySQL();
strSql.Append("insert into product_temp( ");
strSql.Append(" `writer_id`,`product_id`,`brand_id`,`product_vendor_code`,");
strSql.Append(" `product_name`,`product_price_list`,`product_spec`,`spec_title_1`,`spec_title_2`,");
strSql.Append(" `product_freight_set`,`product_buy_limit`,`product_status`,`product_hide`,");
strSql.Append(" `product_mode`,`product_sort`,`product_start`,`product_end`,`page_content_1`,`page_content_2`,");
strSql.Append(" `page_content_3`,`product_keywords`,`product_recommend`,`product_password`,");
strSql.Append(" `product_total_click`,`expect_time`,`product_image`,`product_createdate`,`product_updatedate`,");
strSql.Append(" `product_ipfrom`,`goods_area`,`goods_image1`,`goods_image2`,`city`,");
strSql.Append(" `bag_check_money`,`combination`,`bonus_percent`,`default_bonus_percent`,`bonus_percent_start`,`bonus_percent_end`,`tax_type`,`cate_id`,");
strSql.Append(" `fortune_quota`,`fortune_freight`,`combo_type`,`product_media`,`ignore_stock`,`shortage`,`stock_alarm`,`price_type`,`show_listprice`,`expect_msg`,`temp_status`,`create_channel`,`prod_classify`) values (");
strSql.AppendFormat(" '{0}','{1}','{2}','{3}',", p.Writer_Id, p.Product_Id, p.Brand_Id, p.Product_Vendor_Code);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Product_Name, p.Product_Price_List, p.Product_Spec, p.Spec_Title_1, p.Spec_Title_2);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}',", p.Product_Freight_Set, p.Product_Buy_Limit, p.Product_Status, p.Product_Hide == false ? 0 : 1);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}',", p.Product_Mode, p.Product_Sort, p.Product_Start, p.Product_End, p.Page_Content_1, p.Page_Content_2);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}',", p.Page_Content_3, p.Product_Keywords, p.Product_Recommend, p.Product_Password);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Product_Total_Click, p.Expect_Time, p.Product_Image, p.Product_Createdate, p.Product_Updatedate);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Product_Ipfrom, p.Goods_Area, p.Goods_Image1, p.Goods_Image2, p.City);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.Bag_Check_Money, p.Combination, p.Bonus_Percent, p.Default_Bonus_Percent, p.Bonus_Percent_Start);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}',", p.Bonus_Percent_End, p.Tax_Type, p.Cate_Id, p.Fortune_Quota, p.Fortune_Freight, p.Combo_Type);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", p.product_media, p.Ignore_Stock, p.Shortage, p.stock_alarm, p.Price_type);
strSql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}');select @@identity;", p.show_listprice, p.expect_msg, p.Temp_Status, p.Create_Channel, p.Prod_Classify);
string rid = _dbAccess.getDataTable(strSql.ToString()).Rows[0][0].ToString();
strSql.Clear();//product_id=“T”+rid
string product_id = "T" + rid;
strSql.AppendFormat(" update product_temp set product_id='{0}' where rid='{1}'", product_id, rid);
if (_dbAccess.execCommand(strSql.ToString()) == 1)
{
return product_id;
}
return null;
}
catch (Exception ex)
{
throw new Exception("ProductTempDao.vendorBaseInfoSave-->" + ex.Message + strSql.ToString(), ex);
}
}
/// <summary>
/// 修改數據
/// </summary>
/// <param name="proTemp"></param>
/// <returns></returns>
public string Update(ProductTemp proTemp)
{
proTemp.Replace4MySQL();
StringBuilder strSql = new StringBuilder("");
try
{
strSql.Append("set sql_safe_updates=0; ");
strSql.Append(" update product_temp set ");
strSql.AppendFormat(" `writer_id`='{0}',`brand_id`='{1}',`product_vendor_code`='{2}',", proTemp.Writer_Id, proTemp.Brand_Id, proTemp.Product_Vendor_Code);
strSql.AppendFormat(" `product_name`='{0}',`product_price_list`='{1}',`product_spec`='{2}',`spec_title_1`='{3}',`spec_title_2`='{4}',", proTemp.Product_Name, proTemp.Product_Price_List, proTemp.Product_Spec, proTemp.Spec_Title_1, proTemp.Spec_Title_2);
strSql.AppendFormat(" `product_freight_set`='{0}',`product_buy_limit`='{1}',`product_status`='{2}',`product_hide`='{3}',", proTemp.Product_Freight_Set, proTemp.Product_Buy_Limit, proTemp.Product_Status, proTemp.Product_Hide == false ? 0 : 1);
strSql.AppendFormat(" `product_mode`='{0}',`product_sort`='{1}',`product_start`='{2}',`product_end`='{3}',`page_content_1`='{4}',`page_content_2`='{5}',", proTemp.Product_Mode, proTemp.Product_Sort, proTemp.Product_Start, proTemp.Product_End, proTemp.Page_Content_1, proTemp.Page_Content_2);
strSql.AppendFormat(" `page_content_3`='{0}',`product_keywords`='{1}',`product_recommend`='{2}',`product_password`='{3}',", proTemp.Page_Content_3, proTemp.Product_Keywords, proTemp.Product_Recommend, proTemp.Product_Password);
strSql.AppendFormat(" `product_total_click`='{0}',`expect_time`='{1}',`product_image`='{2}',`product_createdate`='{3}',`product_updatedate`='{4}',", proTemp.Product_Total_Click, proTemp.Expect_Time, proTemp.Product_Image, proTemp.Product_Createdate, proTemp.Product_Updatedate);
strSql.AppendFormat(" `product_ipfrom`='{0}',`goods_area`='{1}',`goods_image1`='{2}',`goods_image2`='{3}',`city`='{4}',", proTemp.Product_Ipfrom, proTemp.Goods_Area, proTemp.Goods_Image1, proTemp.Goods_Image2, proTemp.City);
strSql.AppendFormat(" `bag_check_money`='{0}',`combination`='{1}',`bonus_percent`='{2}',`default_bonus_percent`='{3}',`bonus_percent_start`='{4}',`bonus_percent_end`='{5}',`tax_type`='{6}',`cate_id`='{7}',", proTemp.Bag_Check_Money, proTemp.Combination, proTemp.Bonus_Percent, proTemp.Default_Bonus_Percent, proTemp.Bonus_Percent_Start, proTemp.Bonus_Percent_End, proTemp.Tax_Type, proTemp.Cate_Id);
strSql.AppendFormat(" `fortune_quota`='{0}',`fortune_freight`='{1}',`combo_type`='{2}',`product_media`='{3}',`ignore_stock`='{4}',`shortage`='{5}',`stock_alarm`='{6}',`price_type`='{7}',`show_listprice`='{8}',`expect_msg`='{9}' ", proTemp.Fortune_Quota, proTemp.Fortune_Freight, proTemp.Combo_Type, proTemp.product_media, proTemp.Ignore_Stock, proTemp.Shortage, proTemp.stock_alarm, proTemp.Price_type, proTemp.show_listprice, proTemp.expect_msg);
strSql.AppendFormat(" where 1=1");
if (proTemp.Create_Channel != 0)
{
strSql.AppendFormat(" and create_channel='{0}'", proTemp.Create_Channel);
}
if (!string.IsNullOrEmpty(proTemp.Product_Id))
{
strSql.AppendFormat(" and product_id='{0}'", proTemp.Product_Id);
}
strSql.Append(";");
}
catch (Exception ex)
{
throw new Exception("ProductTempDao.Update-->" + ex.Message + strSql.ToString(), ex);
}
return strSql.ToString();
}
/// <summary>
/// 更新基本信息
/// </summary>
/// <param name="pTemp"></param>
/// <returns></returns>
public int baseInfoUpdate(ProductTemp pTemp)
{
try
{
pTemp.Replace4MySQL();
StringBuilder stb = new StringBuilder("set sql_safe_updates=0;update product_temp set");
stb.AppendFormat(" brand_id='{0}',product_name='{1}',product_sort='{2}',product_vendor_code='{3}',product_status={4},", pTemp.Brand_Id, pTemp.Product_Name, pTemp.Product_Sort, pTemp.Product_Vendor_Code, pTemp.Product_Status);
stb.AppendFormat(" product_start='{0}',product_end='{1}',expect_time='{2}',product_freight_set='{3}',product_mode='{4}',tax_type='{5}' ", pTemp.Product_Start, pTemp.Product_End, pTemp.Expect_Time, pTemp.Product_Freight_Set, pTemp.Product_Mode, pTemp.Tax_Type);
stb.AppendFormat(",expect_msg='{0}',bag_check_money={1} ", pTemp.expect_msg, pTemp.Bag_Check_Money);
if (pTemp.Combination != 1)
{
stb.AppendFormat(" ,combination = {0}", pTemp.Combination);
}
stb.AppendFormat(",show_in_deliver={0},prepaid={1},process_type={2},product_type={3},prod_name='{4}',prod_sz='{5}',", pTemp.Show_In_Deliver, pTemp.Prepaid, pTemp.Process_Type, pTemp.Product_Type, pTemp.Prod_Name, pTemp.Prod_Sz);
stb.AppendFormat("deliver_days={0},min_purchase_amount={1},safe_stock_amount={2},extra_days={3},purchase_in_advance={4},purchase_in_advance_start = {5},purchase_in_advance_end={6} ", pTemp.Deliver_Days, pTemp.Min_Purchase_Amount, pTemp.Safe_Stock_Amount, pTemp.Extra_Days, pTemp.purchase_in_advance, pTemp.purchase_in_advance_start, pTemp.purchase_in_advance_end); // add by zhuoqin0830w 新增5個修改欄位 2015/03/17
stb.AppendFormat(" where writer_id = {0} and combo_type={1}", pTemp.Writer_Id, pTemp.Combo_Type);
stb.AppendFormat(" and product_id='{0}';", pTemp.Product_Id);
//如果存在更新或者刪除 如果是是否推薦點擊了否,則刪除
if (pTemp.Combo_Type == 1 && pTemp.expend_day >= 0)//如果是單一商品
{
if (reProductDao.ExsitInTemp(Convert.ToInt32(pTemp.Writer_Id), Convert.ToInt32(pTemp.Product_Id), pTemp.Combo_Type) > 0)
{
stb.AppendFormat("update recommended_product_attribute_temp set expend_day='{0}',months='{1}' where product_id='{2}'and write_id='{3}' and combo_type='{4}'; ", pTemp.expend_day, pTemp.months, pTemp.Product_Id, pTemp.Writer_Id, pTemp.Combo_Type);
}
else
{
stb.AppendFormat("insert into recommended_product_attribute_temp(`product_id`,`write_id`,`time_start`,`time_end`,`expend_day`,`months`,`combo_type`)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}');", pTemp.Product_Id, pTemp.Writer_Id, 0, 0, pTemp.expend_day, pTemp.months, pTemp.Combo_Type);
}
}
else if (pTemp.Combo_Type == 1 && pTemp.expend_day == 0 && pTemp.months == "")//如果expend_day==0,並且months等於"",則說明選擇了否
{
stb.AppendFormat("delete from recommended_product_attribute_temp where product_id='{0}'and write_id='{1}' and combo_type='{2}'; ", pTemp.Product_Id, pTemp.Writer_Id, pTemp.Combo_Type);
}
if (pTemp.Combo_Type == 2 && pTemp.expend_day >= 0)//如果是組合商品
{
if (reProductDao.ExsitInTemp(Convert.ToInt32(pTemp.Writer_Id), Convert.ToInt32(pTemp.Product_Id), pTemp.Combo_Type) > 0)
{
stb.AppendFormat("update recommended_product_attribute_temp set expend_day='{0}',months='{1}' where product_id='{2}'and write_id='{3}' and combo_type='{4}'; ", pTemp.expend_day, pTemp.months, pTemp.Product_Id, pTemp.Writer_Id, pTemp.Combo_Type);
}
else
{
stb.AppendFormat("insert into recommended_product_attribute_temp(`product_id`,`write_id`,`time_start`,`time_end`,`expend_day`,`months`,`combo_type`)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}');", pTemp.Product_Id, pTemp.Writer_Id, 0, 0, pTemp.expend_day, pTemp.months, pTemp.Combo_Type);
}
}
else if (pTemp.Combo_Type == 2 && pTemp.expend_day == 0 && pTemp.months == "")//如果expend_day==0,並且months等於"",則說明選擇了否
{
stb.AppendFormat("delete from recommended_product_attribute_temp where product_id='{0}'and write_id='{1}' and combo_type='{2}'; ", pTemp.Product_Id, pTemp.Writer_Id,pTemp.Combo_Type);
}
stb.Append("set sql_safe_updates=1;");
return _dbAccess.execCommand(stb.ToString());
}
catch (Exception ex)
{
throw new Exception("ProductTempDao.baseInfoUpdate-->" + ex.Message, ex);
}
}
/// <summary>
/// 商品取消送審
/// </summary>
/// <param name="productTemp"></param>
/// <returns></returns>
public bool CancelVerify(ProductTemp productTemp)
{
try
{
productTemp.Replace4MySQL();
StringBuilder stb = new StringBuilder("set sql_safe_updates=0;update product_temp set product_status=20 where 1=1");
stb.AppendFormat(" and product_id='{0}'", productTemp.Product_Id);
_dbAccess.execCommand(stb.ToString());
return true;
}
catch (Exception ex)
{
throw new Exception("ProductTempDao.CancelVerify-->" + ex.Message, ex);
}
}
