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