public List<Model.ProductCategory> GetProductCategoryCSV(CategoryQuery query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.Append("select category_id,category_name,category_father_id from product_category "); return _dbAccess.getDataTableForObj<Model.ProductCategory>(sql.ToString()); } catch (Exception ex) { throw new Exception("CategoryDao-->GetProductCategoryCSV-->" + ex.Message + sql.ToString(), ex); } }
/// <summary> /// 保存類別信息 /// </summary> /// <param name="cq"></param> /// <returns></returns> public int ProductCategorySave(CategoryQuery cq) { cq.Replace4MySQL(); StringBuilder strSql = new StringBuilder(); try { if (cq.category_id == 0) { strSql.AppendFormat("insert into product_category (category_father_id,category_name,category_sort,category_display,category_link_mode,"); strSql.AppendFormat("category_link_url,banner_image,banner_status,banner_link_mode,banner_link_url,banner_show_start,banner_show_end,"); strSql.AppendFormat("category_createdate,category_updatedate,category_ipfrom,short_description,status,category_image_in,category_image_out,category_image_app)"); strSql.AppendFormat(" values('{0}','{1}',", cq.category_father_id, cq.category_name); strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", cq.category_sort, cq.category_display, cq.category_link_mode, cq.category_link_url, cq.banner_image); strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", cq.banner_status, cq.banner_link_mode, cq.banner_link_url, cq.banner_show_start, cq.banner_show_end); strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", cq.category_createdate, cq.category_updatedate, cq.category_ipfrom, cq.short_description, cq.status); strSql.AppendFormat("'{0}','{1}','{2}')", cq.category_image_in, cq.category_image_out, cq.category_image_app); return _dbAccess.execCommand(strSql.ToString()); } else { strSql.AppendFormat("update product_category set category_father_id='{0}',category_name='{1}',", cq.category_father_id, cq.category_name); strSql.AppendFormat("category_sort='{0}',category_display='{1}',category_link_mode='{2}',", cq.category_sort, cq.category_display, cq.category_link_mode); strSql.AppendFormat("category_link_url='{0}',banner_image='{1}',banner_status='{2}',", cq.category_link_url, cq.banner_image, cq.banner_status); strSql.AppendFormat("banner_link_mode='{0}',banner_link_url='{1}',banner_show_start='{2}',", cq.banner_link_mode, cq.banner_link_url, cq.banner_show_start); strSql.AppendFormat("banner_show_end='{0}',category_updatedate='{1}',", cq.banner_show_end, cq.category_updatedate); strSql.AppendFormat("short_description='{0}' , ", cq.short_description); strSql.AppendFormat("category_image_in='{0}' ,category_image_out='{1}', category_image_app='{2}',", cq.category_image_in, cq.category_image_out, cq.category_image_app); strSql.AppendFormat("category_ipfrom='{0}' where category_id='{1}'", cq.category_ipfrom, cq.category_id); return _dbAccess.execCommand(strSql.ToString()); } } catch (Exception ex) { throw new Exception("CategoryDao-->ProductCategorySave-->" + strSql.ToString() + ex.Message, ex); } }