public string UpdateProdCate(ProductCategory model)
{
model.Replace4MySQL();
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" update product_category set");
sb.AppendFormat(" category_name='{0}',category_sort={1},category_display={2},", model.category_name, model.category_sort, model.category_display);
sb.AppendFormat(" category_show_mode={0},category_image_in='{1}',category_image_out='{2}',", model.category_show_mode, model.category_image_in, model.category_image_out);
sb.AppendFormat(" category_link_mode={0},category_link_url='{1}',banner_image='{2}',banner_status={3},banner_link_mode={4},", model.category_link_mode, model.category_link_url, model.banner_image, model.banner_status, model.banner_link_mode);
sb.AppendFormat(" banner_link_url='{0}',banner_show_start={1},banner_show_end={2},", model.banner_link_url, model.banner_show_start, model.banner_show_end);
sb.AppendFormat(" category_updatedate={0},category_ipfrom='{1}',category_father_id='{2}' where category_id={3};", model.category_updatedate, model.category_ipfrom, model.category_father_id, model.category_id);
return sb.ToString();
}
/// <summary>
/// 用於返回事物所用到的sql語句
/// </summary>
/// <param name="model"></param>
/// <returns>PromotiionsAmountFare、Promotionsamountdiscount</returns>
public string SaveCategory(ProductCategory model)
{
model.Replace4MySQL();
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" insert into product_category( category_father_id,category_name,category_sort,category_display,");
sb.AppendFormat(" category_show_mode,category_image_in,category_image_out,category_link_mode,category_link_url,banner_image,banner_status,banner_link_mode,");
sb.AppendFormat(" banner_link_url,banner_show_start,banner_show_end,category_createdate,category_updatedate,category_ipfrom )");
sb.AppendFormat(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}');select @@identity;",
model.category_father_id, model.category_name, model.category_sort,
model.category_display, model.category_show_mode, model.category_image_in
, model.category_image_out, model.category_link_mode, model.category_link_url,
model.banner_image, model.banner_status, model.banner_link_mode,
model.banner_link_url, model.banner_show_start, model.banner_show_end,
model.category_createdate, model.category_updatedate, model.category_ipfrom);
return sb.ToString();
}
