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