public HttpResponseBase DeletLessThen() { uint producateid = Convert.ToUInt32(Request.Params["producateid"]); //uint key_id = 0; string product_name = string.Empty; int types = 0; if (!string.IsNullOrEmpty(Request.Params["types"]))//變動3 { types = int.Parse(Request.Params["types"]); } string site = "0";//站台改成多個站台的site_id字符串 edit by shuangshuang0420j 20140925 13:40 if (!string.IsNullOrEmpty(Request.Params["websiteid"])) { site = Request.Params["websiteid"]; } ProductCategorySetMgr _categorySetMgr = new ProductCategorySetMgr(mySqlConnectionString); List<ProductCategorySet> categoryList = _categorySetMgr.QueryMsg(new ProductCategorySetQuery { Category_Id = producateid }); ProductMgr _prodMgr = new ProductMgr(mySqlConnectionString); int totalCount = 0; PromotionsMaintainDao pmDao = new PromotionsMaintainDao(mySqlConnectionString); string pricemaster_in = ""; foreach (ProductCategorySet pcs in categoryList) { QueryVerifyCondition query = new QueryVerifyCondition(); query.name_number = pcs.Product_Id.ToString(); query.site_ids = site; if (!string.IsNullOrEmpty(product_name)) { query.product_name = product_name; } List<QueryandVerifyCustom> tempPros = pmDao.QueryByProSite(query, out totalCount, 0); if (1 <= tempPros.Count) { pricemaster_in += tempPros[0].price_master_id + ","; } } pricemaster_in = pricemaster_in.TrimEnd(','); string jsonStr = String.Empty; try { PromoAdditionalPriceQuery model = new PromoAdditionalPriceQuery(); _promoadditionproceMgr = new PromoAdditionalPriceMgr(mySqlConnectionString); model.id = Convert.ToInt32(Request.Params["rowid"].ToString()); model.fixed_price = Convert.ToInt32(Request.Params["fixed_price"].ToString()); model.price_master_in = pricemaster_in; if (string.IsNullOrEmpty(pricemaster_in)) { jsonStr = "{success:true,\"delcount\":\"" + 0 + "\" }"; } else { int result = _promoadditionproceMgr.DeletLessThen(model, types); if (result > 0) { jsonStr = "{success:true,\"delcount\":\"" + 1 + "\" }"; } else if (result == 0) { jsonStr = "{success:true,\"delcount\":\"" + 0 + "\" }"; } else { jsonStr = "{success:false}"; } } } 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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }