public string UpdateNewPromoPresent(NewPromoPresentQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"update new_promo_present set event_id='{0}',gift_type='{1}',group_id='{2}',start='{3}',end='{4}' ", store.event_id, store.gift_type, store.group_id, CommonFunction.DateTimeToString(store.start), CommonFunction.DateTimeToString(store.end)); sql.AppendFormat(@",ticket_name='{0}',ticket_serial='{1}',gift_id='{2}',deduct_welfare='{3}',welfare_mulriple='{4}',event_type='{5}'", store.ticket_name, store.ticket_serial, store.gift_id, store.deduct_welfare, store.welfare_mulriple,store.event_type); sql.AppendFormat(@",gift_amount='{0}',gift_amount_over='{1}',freight_price='{2}',bonus_expire_day='{6}',muser={4},modified='{5}',use_span_day='{7}' where row_id='{3}'", store.gift_amount, store.gift_amount_over, store.freight_price, store.row_id, store.muser, CommonFunction.DateTimeToString(store.modified), store.bonus_expire_day,store.use_span_day); return sql.ToString(); } catch (Exception ex) { throw new Exception("NewPromoPresentDao.UpdateNewPromoPresent-->" + ex.Message + sql.ToString(), ex); } }
public string InsertNewPromoPresent(NewPromoPresentQuery store) { StringBuilder sql = new StringBuilder(); try { sql.Append(@"insert into new_promo_present (event_id,gift_type,group_id,start,end,ticket_name,ticket_serial,gift_id,deduct_welfare,row_id,gift_amount ,gift_amount_over,status,freight_price,bonus_expire_day,welfare_mulriple,created,modified,kuser,muser,use_span_day,event_type)"); sql.AppendFormat(@" values('{0}','{1}','{2}','{3}','{4}' ", store.event_id, store.gift_type, store.group_id, CommonFunction.DateTimeToString(store.start), CommonFunction.DateTimeToString(store.end)); sql.AppendFormat(@",'{0}','{1}','{2}','{3}','{4}'", store.ticket_name, store.ticket_serial, store.gift_id, store.deduct_welfare, store.row_id); sql.AppendFormat(@",'{0}','{1}','{2}','{3}','{4}','{5}'", store.gift_amount, store.gift_amount_over, 1, store.freight_price, store.bonus_expire_day, store.welfare_mulriple); sql.AppendFormat(@",'{0}','{1}',{2},{3},{4},'{5}');",CommonFunction.DateTimeToString( store.created),CommonFunction.DateTimeToString(store.modified),store.kuser,store.muser,store.use_span_day,store.event_type); return sql.ToString(); } catch (Exception ex) { throw new Exception("NewPromoPresentDao.InsertNewPromoPresent-->" + ex.Message + sql.ToString(), ex); } }
public DataTable GetNewPromoPresentList(NewPromoPresentQuery query, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlCount = new StringBuilder(); StringBuilder sqlCondition = new StringBuilder(); try {//from new_promo_present npp LEFT JOIN product pt on pt.product_id=npp.gift_id LEFT JOIN vip_user_group vug on npp.group_id=vug.group_id sql.Append(@" select temp.parameterName as event_type, npp.row_id as trow_id,npp.event_id,npp.welfare_mulriple,npp.gift_type,npp.ticket_name,npp.ticket_serial,npp.gift_id,npp.deduct_welfare,npp.gift_amount ,npp.gift_amount_over,npp.`status`,npp.freight_price,pt.product_name,npp.start as tstart,npp.end as tend,npp.group_id as tgroup_id ,npp.bonus_expire_day,npp.use_span_day,vug.group_name,npp.muser,mu.user_username "); sqlCondition.Append(" from new_promo_present npp "); sqlCondition.Append(" LEFT JOIN (SELECT parameterCode, parameterName FROM t_parametersrc WHERE parameterType='new_promo_present_event_type') AS temp on temp.parameterCode=npp.event_type "); sqlCondition.Append(" LEFT JOIN product pt on pt.product_id=npp.gift_id "); sqlCondition.Append(" LEFT JOIN vip_user_group vug on npp.group_id=vug.group_id "); sqlCondition.Append(" LEFT JOIN manage_user mu ON npp.muser=mu.user_id "); sqlCount.Append(@" select count(row_id) as totalcount "); sqlCondition.Append(" where 1=1 "); if (!string.IsNullOrEmpty(query.event_id)) { sqlCondition.AppendFormat(" and npp.event_id LIKE N'%{0}%'", query.event_id); } totalCount = 0; if (query.IsPage) { sqlCount.Append(sqlCondition.ToString()); DataTable _dt = _access.getDataTable(sqlCount.ToString() ); if (_dt.Rows.Count > 0) { totalCount = int.Parse(_dt.Rows[0]["totalCount"].ToString()); } sqlCondition.Append(" order by npp.row_id desc "); sqlCondition.AppendFormat(" limit {0},{1} ", query.Start, query.Limit); } else { sqlCondition.Append(" order by npp.row_id desc "); } sql.Append(sqlCondition.ToString()); return _access.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("NewPromoPresentDao.GetNewPromoPresentList-->" + ex.Message + sql.ToString() + sqlCount.ToString(), ex); } }
public HttpResponseBase InestNewPromoPresent() { string jsonStr = String.Empty; try { if (string.IsNullOrEmpty(Request.Params["row_id"])) { NewPromoPresentQuery newPresentQuery = new NewPromoPresentQuery(); newPresentQuery.event_type = Request.Params["event_type"]; if(newPresentQuery.event_type=="0") { newPresentQuery.event_type = ""; } newPresentQuery.created = DateTime.Now; newPresentQuery.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; newPresentQuery.modified = newPresentQuery.created; newPresentQuery.muser = newPresentQuery.kuser; _INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString); newPresentQuery.start = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_start"])).ToString("yyyy-MM-dd HH:mm:ss")); newPresentQuery.end = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_end"])).ToString("yyyy-MM-dd HH:mm:ss")); newPresentQuery.bonus_expire_day = Convert.ToInt32(Request.Params["bonus_expire_day"]); if (!string.IsNullOrEmpty(Request.Params["use_span_day"])) { newPresentQuery.use_span_day = Convert.ToInt32(Request.Params["use_span_day"]); } if (!string.IsNullOrEmpty(Request.Params["group_id"])) { newPresentQuery.group_id = int.Parse(Request.Params["group_id"]); } //newPresentQuery.event_id = Request.Params["this_event_id"]; if (Convert.ToBoolean(Request.Params["state1"]) == true) { newPresentQuery.bonus_expire_day = 0; newPresentQuery.gift_type = 1; newPresentQuery.gift_id = Convert.ToInt32(Request.Params["gift_id"]); newPresentQuery.freight_price = Convert.ToInt32(Request.Params["freight_price"]); newPresentQuery.gift_amount = Convert.ToInt32(Request.Params["gift_amount"]); } else if (Convert.ToBoolean(Request.Params["state2"]) == true) { newPresentQuery.welfare_mulriple = Convert.ToDouble(Request.Params["welfare_mulriple"]); newPresentQuery.gift_type = 2; newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]); newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString(); } else if (Convert.ToBoolean(Request.Params["state3"]) == true) { newPresentQuery.gift_type = 3; newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]); newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString(); } newPresentQuery.row_id = _INewPromoPresentMgr.GetNewPromoPresentMaxId(); newPresentQuery.event_id = BLL.gigade.Common.CommonFunction.GetEventId("PB", newPresentQuery.row_id.ToString()); if (_INewPromoPresentMgr.InsertNewPromoPresent(newPresentQuery) > 0) { jsonStr = "{success:true,event_id:\"" + newPresentQuery.event_id + "\"}";//返回json數據 } else { jsonStr = "{success:false}";//返回json數據 } } else { NewPromoPresentQuery newPresentQuery = new NewPromoPresentQuery(); newPresentQuery.event_type = Request.Params["event_type"]; if (newPresentQuery.event_type == "0") { newPresentQuery.event_type = ""; } _INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString); newPresentQuery.row_id = Convert.ToInt32(Request.Params["row_id"]); newPresentQuery.start = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_start"])).ToString("yyyy-MM-dd HH:mm:ss")); newPresentQuery.end = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_end"])).ToString("yyyy-MM-dd HH:mm:ss")); newPresentQuery.bonus_expire_day = Convert.ToInt32(Request.Params["bonus_expire_day"]); newPresentQuery.event_id = Request.Params["this_event_id"]; newPresentQuery.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; newPresentQuery.modified = DateTime.Now; if (!string.IsNullOrEmpty(Request.Params["use_span_day"])) { newPresentQuery.use_span_day = Convert.ToInt32(Request.Params["use_span_day"]); } if (!string.IsNullOrEmpty(Request.Params["group_id"])) { newPresentQuery.group_id = int.Parse(Request.Params["group_id"]); } if (Convert.ToBoolean(Request.Params["state1"]) == true) { newPresentQuery.gift_type = 1; newPresentQuery.gift_id = Convert.ToInt32(Request.Params["gift_id"]); newPresentQuery.freight_price = Convert.ToInt32(Request.Params["freight_price"]); newPresentQuery.gift_amount = Convert.ToInt32(Request.Params["gift_amount"]); } else if (Convert.ToBoolean(Request.Params["state2"]) == true) { newPresentQuery.welfare_mulriple = Convert.ToDouble(Request.Params["welfare_mulriple"]); newPresentQuery.gift_type = 2; newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]); newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString(); } else if (Convert.ToBoolean(Request.Params["state3"]) == true) { newPresentQuery.gift_type = 3; newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]); newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString(); } if (_INewPromoPresentMgr.UpdateNewPromoPresent(newPresentQuery) > 0) { jsonStr = "{success:true,event_id:0}"; } else { jsonStr = "{success:false}";//返回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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase GetNewPromoPresentList() { string json = string.Empty; DataTable _dt = new DataTable(); NewPromoPresentQuery query = new NewPromoPresentQuery(); int totalCount = 0; try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); if (!string.IsNullOrEmpty(Request.Params["entId"])) { query.event_id = Request.Params["entId"].ToString(); } //query.event_id = Request.Params["entId"]; _INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString); _dt = _INewPromoPresentMgr.NewPromoPresentList(query, out totalCount); for (int i = 0; i < _dt.Rows.Count; i++) { if(_dt.Rows[i]["event_type"].ToString()=="") { _dt.Rows[i]["event_type"] = "0"; } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, Formatting.Indented, timeConverter) + "}"; } 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); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase DeleteNewPromoPresent() { string jsonStr = String.Empty; _INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString); NewPromoPresentQuery query = new NewPromoPresentQuery(); if (!String.IsNullOrEmpty(Request.Params["rowID"])) { try { foreach (string rid in Request.Params["rowID"].ToString().Split('|')) { if (!string.IsNullOrEmpty(rid)) { query.row_id = Convert.ToInt32(rid); _INewPromoPresentMgr.DeleteNewPromoPresent(query); } } 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); jsonStr = "{success:false}"; } } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
public JsonResult UpdateNewPromoPresentActive() { try { int currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; int muser =0; int activeValue = Convert.ToInt32(Request.Params["active"]); if (!string.IsNullOrEmpty(Request.Params["muser"])) { muser = int.Parse(Request.Params["muser"].ToString()); } if (currentUser == muser && activeValue == 1) { return Json(new { success = "stop" }); } _INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString); NewPromoPresentQuery modelPresent = new NewPromoPresentQuery(); modelPresent.status = Convert.ToInt32(Request.Params["active"]); modelPresent.row_id = Convert.ToInt32(Request.Params["id"]); modelPresent.muser = currentUser; modelPresent.modified = DateTime.Now; if (_INewPromoPresentMgr.UpdateActive(modelPresent) > 0) { return Json(new { success = "true" }); } else { return Json(new { success = "false" }); } } 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); return Json(new { success = "false" }); } }
public string DeleteNewPromoPresent(NewPromoPresentQuery newPresent) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"delete from new_promo_present where row_id='{0}'", newPresent.row_id); return sql.ToString(); } catch (Exception ex) { throw new Exception("NewPromoPresentDao.DeleteNewPromoPresent-->" + ex.Message + sql.ToString(), ex); } }
public string UpdateActive(NewPromoPresentQuery newPresent) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"update new_promo_present set status='{0}',muser={2},modified='{3}' where row_id='{1}'", newPresent.status, newPresent.row_id,newPresent.muser,CommonFunction.DateTimeToString(newPresent.modified)); return sql.ToString(); } catch (Exception ex) { throw new Exception("NewPromoPresentDao.UpdateActive-->" + ex.Message + sql.ToString(), ex); } }