/// <summary> /// 添加活動時,活動標題不能重複 /// </summary> /// <returns></returns> public HttpResponseBase SelectByEventName() { string json = ""; try { VoteEventQuery query = new VoteEventQuery(); if (!string.IsNullOrEmpty(Request.Params["event_id"])) { query.event_id = Convert.ToInt32(Request.Params["event_id"]); } if (!string.IsNullOrEmpty(Request.Params["event_name"])) { query.event_name = Request.Params["event_name"]; } query.event_name = query.event_name.Trim(); veMgr = new VoteEventMgr(mySqlConnectionString); if (veMgr.SelectByEventName(query) <= 0) { json = "{success:true,msg:'0'}";//返回json數據 } else { json = "{success:true,msg:'1'}";//返回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:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 更改狀態 啟用或者禁用 /// </summary> /// <returns></returns> public JsonResult UpdateEventState() { int id = Convert.ToInt32(Request.Params["id"]); int activeValue = Convert.ToInt32(Request.Params["active"]); veMgr = new VoteEventMgr(mySqlConnectionString); VoteEvent vevent = new VoteEvent(); vevent.event_id = id; vevent.event_status = activeValue; vevent.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; //System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList; //if (addlist.Length > 0) //{ // p.ipfrom = addlist[0].ToString(); //} if (veMgr.UpdateState(vevent) > 0) { return Json(new { success = "true", msg = "" }); } else { return Json(new { success = "false", msg = "" }); } }
/// <summary> /// 活動列表頁 /// </summary> /// <returns></returns> public HttpResponseBase GetVoteEventList() { List<VoteEventQuery> store = new List<VoteEventQuery>(); string json = string.Empty; try { VoteEventQuery query = new VoteEventQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); int totalCount = 0; veMgr = new VoteEventMgr(mySqlConnectionString); _muMgr = new ManageUserMgr(mySqlConnectionString); ManageUserQuery muq = new ManageUserQuery(); muq.IsPage = false; List<ManageUserQuery> mustore = _muMgr.GetNameMail(muq, out totalCount); if (!string.IsNullOrEmpty(Request.Params["search_content"])) { int value = 0; if (int.TryParse(Request.Params["search_content"], out value)) { query.event_id = value; } else { query.event_name = Request.Params["search_content"]; } } store = veMgr.GetVoteEventList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; foreach (var item in store) { if (item.event_banner != "") { item.event_banner = imgServerPath + PaperPath + item.event_banner; } int indexc = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.create_user.ToString())); if (indexc != -1) { item.cuser = mustore[indexc].user_name; } else { item.cuser = string.Empty; } int indexu = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.update_user.ToString())); if (indexu != -1) { item.uuser = mustore[indexu].user_name; } else { item.uuser = string.Empty; } } //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, 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); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 新增或者修改 /// </summary> /// <returns></returns> public HttpResponseBase SaveEvent() { string json = string.Empty; VoteEvent vevent = new VoteEvent(); veMgr = new VoteEventMgr(mySqlConnectionString); 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_Min_Element"); 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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); try { List<VoteEventQuery> store = new List<VoteEventQuery>(); VoteEventQuery veq = new VoteEventQuery(); if (!string.IsNullOrEmpty(Request.Params["event_id"])) { int totalCount = 0; veq.IsPage = false; veq.event_id = int.Parse(Request.Params["event_id"]); store = veMgr.GetVoteEventList(veq, out totalCount); } vevent.event_name = Request.Params["event_name"]; vevent.event_desc = Request.Params["event_desc"]; if (!string.IsNullOrEmpty(Request.Params["event_start"])) { vevent.event_start = DateTime.Parse(Request.Params["event_start"]); } if (!string.IsNullOrEmpty(Request.Params["event_end"])) { vevent.event_end = DateTime.Parse(Request.Params["event_end"]); } if (!string.IsNullOrEmpty(Request.Params["word_length"])) { vevent.word_length = int.Parse(Request.Params["word_length"]); } if (!string.IsNullOrEmpty(Request.Params["vote_everyone_limit"])) { vevent.vote_everyone_limit = int.Parse(Request.Params["vote_everyone_limit"]); } if (!string.IsNullOrEmpty(Request.Params["vote_everyday_limit"])) { vevent.vote_everyday_limit = int.Parse(Request.Params["vote_everyday_limit"]); } if (!string.IsNullOrEmpty(Request.Params["number_limit"])) { vevent.number_limit = int.Parse(Request.Params["number_limit"]); } if (!string.IsNullOrEmpty(Request.Params["is_repeat"])) { vevent.is_repeat = int.Parse(Request.Params["is_repeat"]); } vevent.present_event_id = Request.Params["present_event_id"]; vevent.event_status = 0; vevent.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; vevent.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; #region 上傳圖片 string oldImg = string.Empty; foreach (var item in store) { oldImg = item.event_banner; } if (!string.IsNullOrEmpty(Request.Params["event_id"]) && Request.Params["event_banner"] == oldImg) { vevent.event_banner = oldImg; } else { string ServerPath = string.Empty; try { ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); if (Request.Files["event_banner"] != null && Request.Files["event_banner"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["event_banner"]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = Path.GetFileName(file.FileName); //獲得後綴名 fileExtention = Path.GetExtension(file.FileName); //獲得不帶後綴名的文件名 fileName = Path.GetFileNameWithoutExtension(file.FileName); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { vevent.event_banner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } vevent.event_banner = ""; } } 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}"; } } #endregion if (!string.IsNullOrEmpty(Request.Params["event_id"])) { vevent.event_id = int.Parse(Request.Params["event_id"]); //rgModel.group_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString(); if (veMgr.Update(vevent) > 0) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:true,msg:'修改失敗!'}"; } } else { vevent.create_time = DateTime.Now; vevent.update_time = vevent.create_time; if (veMgr.Save(vevent) > 0) { json = "{success:true,msg:'保存成功!'}"; } else { json = "{success:true,msg:'修改失敗!'}"; } } } 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,msg:'操作失敗!'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetEventId() { List<VoteEventQuery> store = new List<VoteEventQuery>(); string json = string.Empty; try { VoteEventQuery query = new VoteEventQuery(); veMgr = new VoteEventMgr(mySqlConnectionString); //query.event_status = 1; store = veMgr.GetVoteEventDownList(query); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); json = "{success:true,data:" + JsonConvert.SerializeObject(store, 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); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }