public List<ProductCategoryBannerQuery> QueryAll(ProductCategoryBannerQuery query) { try { return _prodCategoryBannerDao.QueryAll(query); } catch (Exception ex) { throw new Exception("ProductCategoryBannerMgr-->QueryAll-->" + ex.Message, ex); } }
//public List<ProductCategoryBannerQuery> GetProCateBanList(ProductCategoryBannerQuery query, out int totalCount) //{ // try // { // List<ProductCategoryBannerQuery> store = _prodCategoryBannerDao.GetProCateBanList(query, out totalCount); // foreach (var item in store) // { // item.banner_catename = _prodCateDao.GetModelById(item.category_father_id).category_name; // item.category_father_name = _paremDao.Query(new Parametersrc { ParameterType = "banner_cate", ParameterCode = item.banner_cateid.ToString() }).FirstOrDefault().parameterName; // } // return store; // } // catch (Exception ex) // { // throw new Exception("ProductCategoryBannerMgr-->GetProCateBanList-->" + ex.Message, ex); // } //} public List<ProductCategoryBannerQuery> GetProCateBanList(ProductCategoryBannerQuery query, out int totalCount) { try { return _prodCategoryBannerDao.GetProCateBanList(query, out totalCount); } catch (Exception ex) { throw new Exception("ProductCategoryBannerMgr-->GetProCateBanList-->" + ex.Message, ex); } }
public List<ProductCategoryBannerQuery> QueryAll(ProductCategoryBannerQuery query) { StringBuilder sql = new StringBuilder(); StringBuilder sqlcount = new StringBuilder(); StringBuilder sqlfrom = new StringBuilder(); try { sql.AppendFormat("select category_id,category_name,category_father_id "); sqlfrom.AppendFormat(" from product_category_banner "); return _access.getDataTableForObj<ProductCategoryBannerQuery>(sql.ToString() + sqlfrom.ToString()); } catch (Exception ex) { throw new Exception("ProductCategoryBannerDao-->QueryAll-->" + ex.Message + sql.ToString() + sqlfrom.ToString(), ex); } }
public List<ProductCategoryBannerQuery> GetProCateBanList(ProductCategoryBannerQuery query, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlcount = new StringBuilder(); StringBuilder sqlfrom = new StringBuilder(); StringBuilder sqlWhere = new StringBuilder(); try { sqlcount.Append("select count( pcb.row_id) as totalCount "); sql.Append("select pcb.row_id,pcb.banner_cateid, et.parameterName 'banner_catename', pcb.category_id,pcb.category_father_id,pcb.category_name,pcb.category_sort,"); sql.Append("pcb.category_display,pcb.category_link_mode,pcb.createdate,pcb.updatedate,pcb.create_ipfrom,pcb.`status`,pc.category_name as category_father_name , pce.category_name as banner_catename "); sqlfrom.Append(" from product_category_banner pcb "); sqlfrom.Append(" left join product_category pc on pcb.category_father_id=pc.category_id "); sqlfrom.Append(" left join product_category pce on pcb.banner_cateid=pce.category_id"); sqlfrom.Append(" LEFT JOIN (select parameterCode,parameterName,parameterType,parameterProperty from t_parametersrc where parameterType='banner_cate' ) et on et.parameterCode=pcb.banner_cateid"); if (query.banner_cateid != 0) { sqlWhere.AppendFormat(" where pcb.banner_cateid={0} ", query.banner_cateid); } sqlWhere.Append(" order by pcb.row_id desc "); totalCount = 0; if (query.IsPage) { DataTable _dt = _access.getDataTable(sqlcount.ToString() + sqlfrom.ToString() + sqlWhere.ToString()); if (_dt != null && _dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]); } sqlWhere.AppendFormat(" limit {0},{1}", query.Start, query.Limit); } return _access.getDataTableForObj<ProductCategoryBannerQuery>(sql.ToString() + sqlfrom.ToString() + sqlWhere.ToString()); } catch (Exception ex) { throw new Exception("ProductCategoryBannerDao-->GetProCateBanList-->" + ex.Message + sql.ToString() + sqlfrom.ToString(), ex); } }
public bool DeleteByCateId(ProductCategoryBannerQuery query) { try { MySqlDao mySqlDao = new MySqlDao(connectionStr); ArrayList insertList = new ArrayList(); insertList.Add(_prodCategoryBannerDao.DeleteByBanCateId(query)); return mySqlDao.ExcuteSqls(insertList); } catch (Exception ex) { throw new Exception("ProductCategoryBannerMgr-->DeleteByCateId-->" + ex.Message, ex); } }
public int UpdateState(ProductCategoryBannerQuery query) { try { return _prodCategoryBannerDao.UpdateState(query); } catch (Exception ex) { throw new Exception("ProductCategoryBannerMgr-->UpdateState-->" + ex.Message, ex); } }
/// <summary> /// 新增數據 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Save(string[] values, ProductCategoryBannerQuery query) { try { ArrayList insertList = new ArrayList(); insertList.Add(_prodCategoryBannerDao.DeleteByBanCateId(query)); for (int i = 0; i < values.Length; i++) { insertList.Add(_prodCategoryBannerDao.Save(values[i].Split(','), query)); } MySqlDao mySqlDao = new MySqlDao(connectionStr); return mySqlDao.ExcuteSqls(insertList); } catch (Exception ex) { throw new Exception("ProductCategoryBannerMgr-->Save-->" + ex.Message, ex); } }
public HttpResponseBase GetProCateBanList() { string json = string.Empty; List<ProductCategoryBannerQuery> store = new List<ProductCategoryBannerQuery>(); ProductCategoryBannerQuery query = new ProductCategoryBannerQuery(); try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20"); if (!string.IsNullOrEmpty(Request.Params["banner_id"])) { query.banner_cateid = Convert.ToUInt32(Request.Params["banner_id"]); } int totalCount = 0; _IProductCategoryBannerMgr = new ProductCategoryBannerMgr(mySqlConnectionString); store = _IProductCategoryBannerMgr.GetProCateBanList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } 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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetProductCategoryBanner(string id = "true") { List<ProductCategoryBannerQuery> categoryList = new List<ProductCategoryBannerQuery>(); List<ProductCategoryBannerCustom> cateList = new List<ProductCategoryBannerCustom>(); string resultStr = ""; try { _productCategoryBannerImplMgr = new ProductCategoryBannerMgr(mySqlConnectionString); ProductCategoryBannerQuery model = new ProductCategoryBannerQuery(); categoryList = _productCategoryBannerImplMgr.QueryAll(model); cateList = ProductCategoryBannerCate(categoryList, 2); List<ProductCategorySet> resultList = new List<ProductCategorySet>(); GetCategoryList(categoryList, ref cateList, resultList); resultStr = JsonConvert.SerializeObject(cateList); } 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); } this.Response.Clear(); this.Response.Write(resultStr); this.Response.End(); return this.Response; }
public JsonResult UpdateState() { string json = string.Empty; ProductCategoryBannerQuery query = new ProductCategoryBannerQuery(); try { if (!string.IsNullOrEmpty(Request.Params["id"])) { query.row_id = Convert.ToInt32(Request.Params["id"]); } if (!string.IsNullOrEmpty(Request.Params["active"])) { query.status = Convert.ToInt32(Request.Params["active"]); } _IProductCategoryBannerMgr = new ProductCategoryBannerMgr(mySqlConnectionString); if (_IProductCategoryBannerMgr.UpdateState(query) > 0) { return Json(new { success = "true", msg = "" }); } else { return Json(new { success = "false", msg = "" }); } } 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", msg = "" }); } }
/// <summary> /// 新增編輯類別設定信息 /// </summary> /// <returns></returns> public HttpResponseBase CategoryBannerSetSave() { ProductCategoryBannerQuery query = new ProductCategoryBannerQuery(); _IProductCategoryBannerMgr = new ProductCategoryBannerMgr(mySqlConnectionString); string json = string.Empty; string insertValues = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["banner_cateid"])) { query.banner_cateid = Convert.ToUInt32(Request.Params["banner_cateid"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["insertValues"])) { insertValues = Request.Params["insertValues"].ToString(); insertValues = Server.HtmlDecode(insertValues); string[] values = insertValues.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); query.createdate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString())); query.updatedate = query.createdate; query.create_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString(); if (_IProductCategoryBannerMgr.Save(values, query)) { json = "{success:true}"; } else { json = "{success:false}"; } } else { bool b = _IProductCategoryBannerMgr.DeleteByCateId(query); if (b) { json = "{success:true}"; } } } 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetProductCatagory() { //吉甲地美安 string resultStr = ""; try { List<Parametersrc> Market = new List<Parametersrc>(); _ptersrc = new ParameterMgr(mySqlConnectionString); Market = _ptersrc.GetAllKindType("market_category");//物流業者 if (Market.Count > 0) { ProductCategory category = new ProductCategory(); category.category_name = "新館"; List<ProductCategory> categoryStore = new List<ProductCategory>();//-------取新館的id用來獲取product_category_banner的子節點 // List<ProductCategory> categoryList = new List<ProductCategory>(); List<ProductCategoryCustom> cateList = new List<ProductCategoryCustom>(); _procateMgr = new ProductCategoryMgr(mySqlConnectionString); categoryStore = _procateMgr.QueryAll(category);// if (categoryStore.Count > 0)//取father_id;//在product_category表查詢新館的編號 { category = categoryStore[0]; } else { category.category_id = 754; } ProductCategoryBannerQuery bannerquery = new ProductCategoryBannerQuery();//查詢裡面屬於新錧裡面美安的父元素和子元素 bannerquery.banner_cateid = uint.Parse(Market[0].ParameterCode); bannerquery.IsPage = false; _bannerMgr = new ProductCategoryBannerMgr(mySqlConnectionString); List<ProductCategoryBannerQuery> bannerList = new List<ProductCategoryBannerQuery>(); int total = 0; bannerList = _bannerMgr.GetProCateBanList(bannerquery, out total); // categoryList = _procateMgr.GetProductCate(new ProductCategory { }); //cateList = getCate(categoryList, "2", Market[0].ParameterCode.ToString()); cateList = getCate(bannerList,category.category_id.ToString()); GetCategoryList(bannerList, ref cateList); // GetCategoryList(categoryList, ref cateList); resultStr = JsonConvert.SerializeObject(cateList); } } 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); } this.Response.Clear(); this.Response.Write(resultStr); this.Response.End(); return this.Response; }
public string DeleteByBanCateId(ProductCategoryBannerQuery query) { StringBuilder sql = new StringBuilder(); string str = string.Empty; sql.AppendFormat("set sql_safe_updates=0;delete from product_category_banner where banner_cateid={0};set sql_safe_updates=1; ", query.banner_cateid); return sql.ToString(); }
public string Save(string[] values, ProductCategoryBannerQuery query) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(" insert into product_category_banner(category_id,category_name, category_father_id,category_sort,category_display,"); sql.AppendFormat(" category_link_mode,createdate,updatedate,create_ipfrom,status,banner_cateid)"); sql.AppendFormat(" values ('{0}','{1}','{2}','{3}','{4}',", Convert.ToUInt32(values[0]), values[1], Convert.ToUInt32(values[2]), Convert.ToUInt32(values[3]), Convert.ToUInt32(values[4])); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}');", Convert.ToUInt32(values[5]), query.createdate, query.updatedate, query.create_ipfrom, Convert.ToInt32(values[6]), query.banner_cateid); return sql.ToString(); }
public int UpdateState(ProductCategoryBannerQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("set sql_safe_updates=0;update product_category_banner set status={0},updatedate={1} where row_id={2};set sql_safe_updates=1; ", query.status, CommonFunction.GetPHPTime(), query.row_id); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ProductCategoryBannerDao-->UpdateState-->" + ex.Message + sql.ToString(), ex); } }