public int UpdateModel(EventPromoAdditionalPriceGroup model) { try { return dao.UpdateModel(model); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupMgr-->UpdateModel-->" + ex.Message, ex); } }
public List<EventPromoAdditionalPriceGroup> GetPromoProductGroup(EventPromoAdditionalPriceGroup model) { try { return dao.GetPromoProductGroup(model); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceProductMgr-->GetPromoProductGroup-->" + ex.Message, ex); } }
public List<EventPromoAdditionalPriceGroupQuery> GetList(EventPromoAdditionalPriceGroup model) { try { return dao.GetList(model); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupMgr-->GetList-->" + ex.Message, ex); } }
public List<EventPromoAdditionalPriceGroup> GetPromoProductGroup(EventPromoAdditionalPriceGroup model) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("select * from event_promo_additional_price_product "); sql.AppendFormat(" where group_id={0}", model.group_id); return access.getDataTableForObj<Model.EventPromoAdditionalPriceGroup>(sql.ToString()); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceProductDao-->GetPromoProductGroup-->" + ex.Message + sql.ToString(), ex); } }
public int UpdateModel(EventPromoAdditionalPriceGroup model) { StringBuilder sbAll = new StringBuilder(); try { sbAll.AppendFormat("update event_promo_additional_price_group set group_name='{0}',group_status={1},modify_user={2},modify_time='{3}' where group_id={4}",model.group_name,model.group_status,model.modify_user,Common.CommonFunction.DateTimeToString(model.modify_time),model.group_id); return access.execCommand(sbAll.ToString()); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupDao-->UpdateModel-->" + ex.Message + sbAll.ToString(), ex); } }
public int InsertModel(EventPromoAdditionalPriceGroup model) { StringBuilder sbAll = new StringBuilder(); try { sbAll.Append("insert into event_promo_additional_price_group(group_name,create_user,create_date,modify_user,modify_time,group_status)"); sbAll.AppendFormat("values('{0}',{1},'{2}',{3},'{4}',{5})",model.group_name,model.create_user,Common.CommonFunction.DateTimeToString(model.create_date),model.modify_user,Common.CommonFunction.DateTimeToString(model.modify_time),model.group_status); return access.execCommand(sbAll.ToString()); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupDao-->InsertModel-->" + ex.Message + sbAll.ToString(), ex); } }
public List<EventPromoAdditionalPriceGroupQuery> GetList(EventPromoAdditionalPriceGroup model) { StringBuilder sbAll = new StringBuilder(); try { sbAll.Append("SELECT eg.group_id,mu.user_username,eg.group_name,eg.group_status,eg.create_user,eg.create_date,eg.modify_user,eg.modify_time FROM event_promo_additional_price_group AS eg "); sbAll.Append("left join manage_user mu on eg.create_user=mu.user_id "); if(model.group_name!=string.Empty) { sbAll.AppendFormat(" where eg.group_name='{0}'",model.group_name); } return access.getDataTableForObj<EventPromoAdditionalPriceGroupQuery>(sbAll.ToString()); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupDao-->GetList-->" + ex.Message+sbAll.ToString(), ex); } }
public HttpResponseBase GetProductGroupCbo() { string jsonStr = "{success:false,data:[]}"; try { EventPromoAdditionalPriceGroup model = new EventPromoAdditionalPriceGroup(); epapgMgr = new EventPromoAdditionalPriceGroupMgr(mySqlConnectionString); List<EventPromoAdditionalPriceGroupQuery> _list = epapgMgr.GetList(model); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; jsonStr = "{success:true,data:" + JsonConvert.SerializeObject(_list, 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); } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase GetGroupName() { string jsonStr = "{success:false}"; try { EventPromoAdditionalPriceGroup model = new EventPromoAdditionalPriceGroup(); if (!string.IsNullOrEmpty(Request.Params["group_name"])) { model.group_name = Request.Params["group_name"]; } epapgMgr = new EventPromoAdditionalPriceGroupMgr(mySqlConnectionString); if (epapgMgr.GetList(model).Count > 0) { jsonStr = "{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); } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase SaveEventPromoAdditionalPriceGroup() { string jsonStr = "{success:false}"; try { EventPromoAdditionalPriceGroup model = new EventPromoAdditionalPriceGroup(); if (!string.IsNullOrEmpty(Request.Params["group_name"])) { model.group_name = Request.Params["group_name"]; } if (!string.IsNullOrEmpty(Request.Params["group_id"])) { model.group_id = int.Parse(Request.Params["group_id"]); } model.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; model.create_date = DateTime.Now; model.modify_user = model.create_user; model.modify_time = model.create_date; model.group_status = 1; epapgMgr = new EventPromoAdditionalPriceGroupMgr(mySqlConnectionString); if (model.group_id == 0) { if (epapgMgr.InsertModel(model) > 0) { jsonStr = "{success:true}"; } } else { if (epapgMgr.UpdateModel(model) > 0) { jsonStr = "{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); } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }