Example #1
0
 public string  SaveComAddress(DeliveryAddress query)
 {
     string json = string.Empty;
     try
     {
         if (query.da_id== 0)
         {
             if (_vipUserGroupDao.SaveComAddress(query) > 0)
             {
                 json = "{success:'true'}";
             }
             else
             {
                 json = "{success:'false'}";
             }
         }
         else
         {
             int n=100;
             if (!int.TryParse(query.da_dist, out n))
             {
                 query.da_dist = _vipUserGroupDao.GetZiPCode(query.da_dist);
             }
             if (_vipUserGroupDao.UPComAddress(query) > 0)
             {
                 json = "{success:'true'}";
             }
             else
             {
                 json = "{success:'false'}";
             }
         }
      
         return json;
     }
     catch (Exception ex)
     {
         throw new Exception("VipUserGroupDao-->SaveComAddress-->" + ex.Message, ex);
     }
 }
Example #2
0
 public string DeleteDeliveryAddress(DeliveryAddress query)
 {
     string json = string.Empty;
     try
     {
         if (_vipUserGroupDao.DeleteDeliveryAddress(query) > 0)
         {
             json = "{success:'true'}";
         }
         else
         {
             json = "{success:'false'}";
         }
         return json;
     }
     catch (Exception ex)
     {
         throw new Exception("VipUserGroupDao-->DeleteDeliveryAddress-->" + ex.Message, ex);
     }
 }
 public HttpResponseBase DeleteDeliveryAddress()
 {
     string json = string.Empty;
     DeliveryAddress query = new DeliveryAddress();
     try
     {
         if (!string.IsNullOrEmpty(Request.Params["da_id"])) 
         {
             query.da_id = Convert.ToInt32(Request.Params["da_id"]);
             _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString);
             json = _vipUserGroup.DeleteDeliveryAddress(query);
         }
     }
     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}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
Example #4
0
 public List<DeliveryAddress> GetComAddress(DeliveryAddress query)
 {
     try
     {
         return _vipUserGroupDao.GetComAddress(query);
     }
     catch (Exception ex)
     {
         throw new Exception("VipUserGroupDao-->GetComAddress-->" + ex.Message, ex);
     }
 }
 public HttpResponseBase GetComAddress()
 {
     List<DeliveryAddress> store = new List<DeliveryAddress>();
     DeliveryAddress query = new DeliveryAddress();
     string  json = "{success:true,data:[]}";
     try
     {
         _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString);
         if (!string.IsNullOrEmpty(Request.Params["user_id"]))
         {
             query.user_id = Convert.ToInt32(Request.Params["user_id"]);
             store = _vipUserGroup.GetComAddress(query);
             json = "{success:true,data:" + JsonConvert.SerializeObject(store) + "}";
         }
      
     }
     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}";
     }
     this.Response.Clear();
     this.Response.Write(json);
     this.Response.End();
     return this.Response;
 }
Example #6
0
 public int DeleteDeliveryAddress(DeliveryAddress query)
 {
     StringBuilder sql = new StringBuilder();
     try
     {
         sql.AppendFormat("delete from delivery_address where da_id='{0}';", query.da_id);
         return _accessMySql.execCommand(sql.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("VipUserGroupDao-->DeleteDeliveryAddress-->" + sql.ToString() + ex.Message, ex);
     }
 }
Example #7
0
 public int UPComAddress(DeliveryAddress query)
 {
     StringBuilder sql = new StringBuilder();
     try
     {
         query.Replace4MySQL();
         sql.AppendFormat("update  delivery_address  set da_address='{0}' ,da_dist='{1}' ,da_title='{2}' where da_id='{3}';", query.da_address, query.da_dist,query.da_title, query.da_id);
         return _accessMySql.execCommand(sql.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("VipUserGroupDao-->SaveComAddress-->" + ex.Message + sql.ToString(), ex);
     }
 }
Example #8
0
        public int SaveComAddress(DeliveryAddress query)
        {
            StringBuilder sql = new StringBuilder();
            try
            {
                query.Replace4MySQL();
                sql.Append("insert into delivery_address(user_id,da_title,da_name,da_gender,da_mobile_no,");
                sql.Append("da_tel_no,da_dist,da_address,da_default,da_created) values(");



                sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',",query.user_id,query.da_title,query.da_name,query.da_gender,query.da_mobile_no);
                sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}');",query.da_tel_no,query.da_dist,query.da_address,query.da_default,CommonFunction.DateTimeToString( query.da_created));
                return _accessMySql.execCommand(sql.ToString());
            }
            catch (Exception ex)
            {
                throw new Exception("VipUserGroupDao-->SaveComAddress-->" + ex.Message + sql.ToString(), ex);
            }
        }
Example #9
0
 public List<DeliveryAddress> GetComAddress(DeliveryAddress query)
 {
     StringBuilder sql = new StringBuilder();
     StringBuilder sqlFrom = new StringBuilder();
     StringBuilder sqlWhere = new StringBuilder();
     try
     {
         sql.Append("select da.da_id,da.user_id,da.da_title,CONCAT(da.da_dist,tzc.middle,'  ',tzc.small) as 'da_dist',da.da_address ");
         sqlFrom.Append(" from delivery_address da left join t_zip_code tzc on da.da_dist=tzc.zipcode ");
         sqlWhere.Append(" where 1= 1 ");
         if (query.user_id != 0)
         {
             sqlWhere.AppendFormat(" and da.user_id='{0}';", query.user_id);
         }
         sql.Append(sqlFrom.ToString()+sqlWhere.ToString());
         return _accessMySql.getDataTableForObj<DeliveryAddress>(sql.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("VipUserGroupDao-->GetComAddress-->" + ex.Message + sql.ToString(), ex);
     }
 }