Exemplo n.º 1
0
 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);
     }
 }
Exemplo n.º 2
0
 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);
     }
 }
Exemplo n.º 3
0
        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);
            }

        }
Exemplo n.º 4
0
        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;

        }
Exemplo n.º 5
0
 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;
 }
Exemplo n.º 6
0
        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;
        }
Exemplo n.º 7
0
        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" });
            }

        }
Exemplo n.º 8
0
 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);
     }
 }
Exemplo n.º 9
0
        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);
            }
        }