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