public HttpResponseBase GetVipLevel() { DataTable _dt = new DataTable(); string json = string.Empty; try { _memberMgr = new MemberLevelMgr(mySqlConnectionString); _dt = _memberMgr.GetLevel(); VipUserGroup Dmodel = new VipUserGroup(); json = "{success:true,data:" + JsonConvert.SerializeObject(_dt) + "}";//返回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); json = "{success:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public List<VipUserGroup> QueryAll(VipUserGroup query) { List<VipUserGroup> list = new List<VipUserGroup>(); StringBuilder sb = new StringBuilder(); sb.Append(@"select group_id,group_name,domain,tax_id,image_name,gift_bonus,createdate,group_category,bonus_rate,bonus_expire_day,eng_name,check_iden from vip_user_group"); return _accessMySql.getDataTableForObj<VipUserGroup>(sb.ToString()); }
/// <summary> /// vip_user_group數據增加 /// </summary> /// <param name="userGroup"></param> /// <returns></returns> public int Insert(VipUserGroup userGroup) { try { return _vipUserGroup.Insert(userGroup); } catch (Exception ex) { throw new Exception("VipUserGroupMgr.Insert-->" + ex.Message, ex); } }
public string GetVuserCount(VipUserGroup query) { try { return _vipUserGroup.GetVuserCount(query); } catch (Exception ex) { throw new Exception("VipUserGroupMgr.GetVuserCount-->" + ex.Message, ex); } }
/// <summary> /// 獲取會員分組 /// </summary> /// <returns></returns> public HttpResponseBase GetVipGroup() { List<VipUserGroup> stores = new List<VipUserGroup>(); string json = string.Empty; try { int totalCount = 0; stores = _vipGroupMgr.GetAllUserGroup(); VipUserGroup Dmodel = new VipUserGroup(); Dmodel.group_id = 0; Dmodel.group_name = "不分"; stores.Insert(0, Dmodel);//使會員群組的第一行為不分 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores) + "}";//返回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); json = "{success:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetVipUserGroup() { string json = string.Empty; List<VipUserGroup> store = new List<VipUserGroup>(); VipUserGroup vu = new VipUserGroup(); try { _IOrderUserMgr = new OrderUserReduceMgr(mySqlConnectionString); store = _IOrderUserMgr.GetVipUserGroupStore(); vu.group_id = 0; vu.group_name = "所有群組會員"; store.Insert(0, vu); json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}"; } 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// vip_user_group數據的編輯更新 /// </summary> /// <param name="userGroup"></param> /// <returns></returns> public int Update(VipUserGroup userGroup) { try { return _vipUserGroup.Update(userGroup); } catch (Exception ex) { throw new Exception("VipUserGroupMgr.Update-->" + ex.Message, ex); } }
// [HttpPost] public HttpResponseBase SaveVipUserGroup() { NameValueCollection param = Request.Params; VipUserGroup userGroup = new VipUserGroup(); string json = string.Empty; bool size = true; Serial serial = new Serial(); _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); _ISerImplMgr = new SerialMgr(mySqlConnectionString); serial = _ISerImplMgr.GetSerialById(72); string path = Server.MapPath(xmlPath); SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format"); SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue"); SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME"); SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD"); //擴展名、最小值、最大值 string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value; string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value; string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value; string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址 Random rand = new Random(); int newRand = rand.Next(1000, 9999); string NewName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; FileManagement fileLoad = new FileManagement(); try { #region 新增 if (String.IsNullOrEmpty(param["group_id"])) { if (!string.IsNullOrEmpty(Request.Form["group_name"])) { userGroup.group_name = Request.Form["group_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["tax_id"])) { userGroup.tax_id = Request.Form["tax_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["eng_name"])) { userGroup.eng_name = Request.Form["eng_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["gift_bonus"])) { userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]); } if (!string.IsNullOrEmpty(Request.Form["group_category"])) { userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]); } siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath)); try { if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["image_name"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是隨機數字 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath); NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); string ErrorMsg = string.Empty; //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { userGroup.image_name = NewName; } } else { size = false; } } } catch (Exception) { userGroup.image_name = string.Empty; } if (!string.IsNullOrEmpty(Request.Params["check_iden"])) { userGroup.check_iden = int.Parse(Request.Params["check_iden"]); } userGroup.createdate = (uint)CommonFunction.GetPHPTime(DateTime.Now.ToString()); userGroup.group_id = uint.Parse((serial.Serial_Value + 1).ToString()); if (_userGroupMgr.Insert(userGroup) > 0) { serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/ _ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/ if (size) { json = "{success:true,msg:\"" + "" + "\"}"; } else { json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB!" + "\"}"; } } else { json = "{success:false,msg:\"" + "新增失敗!" + "\"}"; } } #endregion #region 編輯 else { _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); userGroup.group_id = Convert.ToUInt32(param["group_id"]); VipUserGroup oldUserGroup = _userGroupMgr.GetModelById(userGroup.group_id); if (!string.IsNullOrEmpty(Request.Form["group_name"])) { userGroup.group_name = Request.Form["group_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["tax_id"])) { userGroup.tax_id = Request.Form["tax_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["eng_name"])) { userGroup.eng_name = Request.Form["eng_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["gift_bonus"])) { userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]); } if (!string.IsNullOrEmpty(Request.Form["group_category"])) { userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]); } try { //如果圖片沒有改變 if (Request.Form["image_name"] == oldUserGroup.image_name) { userGroup.image_name = Request.Form["image_name"]; } else { //圖片改變了 if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["image_name"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是隨機數字 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath); // returnName += promoPath + NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 string oldFileName = oldUserGroup.image_name; //FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); //List<string> tem = ftp.GetFileList(); //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { userGroup.image_name = NewName; if (System.IO.File.Exists(ServerPath + oldFileName)) { FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd); if (System.IO.File.Exists(localPromoPath + oldFileName)) { ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片 } DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 } } else { userGroup.image_name = oldUserGroup.image_name; } } else { size = false; userGroup.image_name = oldUserGroup.image_name; } } } } catch (Exception) { userGroup.image_name = oldUserGroup.image_name; } try { userGroup.check_iden = int.Parse(Request.Params["check_iden"]); } catch (Exception) { userGroup.check_iden = 0; } if (_userGroupMgr.Update(userGroup) > 0) { if (size) { json = "{success:true,msg:\"" + "" + "\"}"; } else { json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB!" + "\"}"; } } else { json = "{success:false,msg:\"" + "修改失敗!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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(json); this.Response.End(); return this.Response; }
/// <summary> /// 名單數 /// </summary> /// <param name="query">根據group_id查詢</param> /// <returns></returns> public string GetVuserCount(VipUserGroup query) { string sql = string.Format("select count(v_id) as search_total from vip_user where 1=1 and group_id={0}", query.group_id); try { DataTable vuser = _accessMySql.getDataTable(sql); if (vuser.Rows.Count > 0) { return vuser.Rows[0]["search_total"].ToString(); } else { return ""; } } catch (Exception ex) { throw new Exception("VipUserGroupDao.GetVuserCount-->" + ex.Message + sql, ex); } }
/// <summary> /// 更新vip_user_group表中的數據 /// </summary> /// <param name="userGroup"></param> /// <returns></returns> public int Update(VipUserGroup userGroup) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"update vip_user_group set group_name='{0}',tax_id='{1}',image_name='{2}',", userGroup.group_name, userGroup.tax_id, userGroup.image_name); sql.AppendFormat(@"gift_bonus={0},group_category={1},eng_name='{2}',", userGroup.gift_bonus, userGroup.group_category, userGroup.eng_name); sql.AppendFormat(@"check_iden={0} where 1=1 and group_id={1}", userGroup.check_iden, userGroup.group_id); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("VipUserGroupDao.Update-->" + ex.Message + sql.ToString(), ex); } }
/// <summary> /// 向vip_user_group表中插入數據 /// </summary> /// <param name="userGroup"></param> /// <returns></returns> public int Insert(VipUserGroup userGroup) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"insert into vip_user_group(group_id,group_name,tax_id,image_name,gift_bonus,group_category,eng_name,check_iden,createdate) "); sql.AppendFormat(@"values({0},'{1}','{2}',", userGroup.group_id, userGroup.group_name, userGroup.tax_id); sql.AppendFormat(@"'{0}',{1},{2},", userGroup.image_name, userGroup.gift_bonus, userGroup.group_category); sql.AppendFormat(@"'{0}',{1},{2} )", userGroup.eng_name, userGroup.check_iden, userGroup.createdate); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("VipUserGroupDao.Insert-->" + ex.Message + sql.ToString(), ex); } }