public int Update(BannerContent bc) { try { return _bcDao.Update(bc); } catch (Exception ex) { throw new Exception("BannerContentMgr-->Update", ex); } }
public int Add(BannerContent bc) { try { return _bcDao.Add(bc); } catch (Exception ex) { throw new Exception("BannerContentMgr-->Add", ex); } }
public List<BannerContent> GetList(BannerContent bc, out int totalCount) { try { return _bcDao.GetList(bc, out totalCount); } catch (Exception ex) { throw new Exception("BannerContentMgr-->GetList", ex); } }
public List<BannerContent> GetList(BannerContent bc, out int totalCount) { StringBuilder sqlfield = new StringBuilder(); StringBuilder sqlwhere = new StringBuilder(); StringBuilder sqlorderby = new StringBuilder(); StringBuilder sql = new StringBuilder(); sqlfield.AppendLine(@"SELECT banner_content_id,banner_site_id,banner_title,banner_link_url,"); sqlfield.AppendLine(@"banner_link_mode,banner_sort,banner_status,banner_image,FROM_UNIXTIME(banner_start) as banner_start,"); sqlfield.AppendLine(@"FROM_UNIXTIME(banner_end) as banner_end,FROM_UNIXTIME(banner_createdate) as banner_createdate,"); sqlfield.AppendLine(@"FROM_UNIXTIME(banner_updatedate) as banner_updatedate,banner_ipfrom "); sqlfield.AppendLine(@" from banner_content WHERE 1=1 "); sql.Append(sqlfield); if (bc.banner_content_id != 0) { sql.AppendFormat(@" and banner_content_id='{0}' ", bc.banner_content_id); } if (bc.banner_site_id != 0) { sqlwhere.AppendFormat(@" and banner_site_id='{0}' ", bc.banner_site_id); } if (bc.banner_status == 3) { sqlwhere.AppendFormat(@" and banner_status='{0}' ", bc.banner_status); sqlorderby.AppendFormat(@" ORDER BY banner_content_id DESC "); } else { sqlwhere.AppendFormat(@" and banner_status <> 3 "); sqlorderby.AppendFormat(@" ORDER BY banner_sort DESC, banner_content_id DESC "); } sql.Append(sqlwhere); sql.Append(sqlorderby + string.Format("limit {0},{1}", bc.Start, bc.Limit)); //int totalCount; totalCount = 0; try { if (bc.IsPage) { DataTable dt = _access.getDataTable("select count(*) from banner_content where 1=1 " + sqlwhere); totalCount = int.Parse(dt.Rows[0][0].ToString()); } return _access.getDataTableForObj<BannerContent>(sql.ToString()); } catch (Exception ex) { throw new Exception("BannerContentDao-->GetList" + ex.Message + sql.ToString(), ex); } }
public int Add(BannerContent bc) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@"INSERT INTO banner_content (banner_content_id,banner_site_id,banner_title,banner_link_url,"); sql.AppendLine(@"banner_link_mode,banner_sort,banner_status,banner_image,banner_start,"); sql.AppendLine(@"banner_end,banner_createdate,banner_updatedate,banner_ipfrom) values("); sql.AppendFormat(@" '{0}','{1}','{2}','{3}',", bc.banner_content_id, bc.banner_site_id, bc.banner_title, bc.banner_link_url); sql.AppendFormat(@" '{0}','{1}','{2}','{3}','{4}',", bc.banner_link_mode, bc.banner_sort, bc.banner_status, bc.banner_image, CommonFunction.GetPHPTime(bc.banner_start.ToString("yyyy-MM-dd HH:mm:ss"))); sql.AppendFormat(@" '{0}','{1}','{2}','{3}')", CommonFunction.GetPHPTime(bc.banner_end.ToString("yyyy-MM-dd HH:mm:ss")), CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), bc.banner_ipfrom); try { return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("BannerContentDao-->Add" + ex.Message + sql.ToString(), ex); } }
public int Update(BannerContent bc) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@" UPDATE banner_content set "); sql.AppendFormat(@"banner_title='{0}',banner_link_mode='{1}',",bc.banner_title,bc.banner_link_mode); sql.AppendFormat(@" banner_sort='{0}',banner_status='{1}',",bc.banner_sort,bc.banner_status); sql.AppendFormat(@" banner_image='{0}',banner_start='{1}',banner_end='{2}',", bc.banner_image, CommonFunction.GetPHPTime(bc.banner_start.ToString("yyyy-MM-dd HH:mm:ss")), CommonFunction.GetPHPTime(bc.banner_end.ToString("yyyy-MM-dd HH:mm:ss"))); sql.AppendFormat(@"banner_updatedate='{0}',banner_ipfrom='{1}', ", CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), bc.banner_ipfrom); sql.AppendFormat(@"banner_link_url='{0}'",bc.banner_link_url); sql.AppendFormat(@" WHERE 1=1 and banner_content_id='{0}'; ",bc.banner_content_id); try { return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("BannerContentDao-->Update" + ex.Message + sql.ToString(), ex); } }
public HttpResponseBase BannerImageEdit() { string json = string.Empty; BannerContent bc = new BannerContent(); Serial serial = new Serial(); _bcMgr = new BannerContentMgr(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 = imgLocalServerPath + promoPath;//圖片存儲地址 /aimg.gigade100.com/ +/promotion/dev/ string NewName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; FileManagement fileLoad = new FileManagement(); try { string oldImg = string.Empty; serial = _ISerImplMgr.GetSerialById(6); List<BannerContent> store = new List<BannerContent>(); if (!string.IsNullOrEmpty(Request.Params["banner_content_id"])) { int totalCount = 0; bc.IsPage = false; bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]); if (Request.Params["history"] == "1") { bc.banner_status = 3; } store = _bcMgr.GetList(bc, out totalCount); foreach (var item in store) { oldImg = item.banner_image; } } bc = new BannerContent(); bc.banner_title = Request.Params["banner_title"]; bc.banner_link_url = Request.Params["banner_link_url"]; if (!string.IsNullOrEmpty(Request.Params["banner_site_id"])) { bc.banner_site_id = uint.Parse(Request.Params["banner_site_id"]); } if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"])) { bc.banner_link_mode = int.Parse(Request.Params["banner_link_mode"]); } if (!string.IsNullOrEmpty(Request.Params["banner_sort"])) { bc.banner_sort = uint.Parse(Request.Params["banner_sort"]); } if (!string.IsNullOrEmpty(Request.Params["banner_statuses"])) { bc.banner_status = uint.Parse(Request.Params["banner_statuses"]); } if (!string.IsNullOrEmpty(Request.Params["banner_start"])) { bc.banner_start = DateTime.Parse(DateTime.Parse(Request.Params["banner_start"]).ToString("yyyy-MM-dd") + " 00:00:00"); } if (!string.IsNullOrEmpty(Request.Params["banner_end"])) { bc.banner_end = DateTime.Parse(DateTime.Parse(Request.Params["banner_end"]).ToString("yyyy-MM-dd") + " 23:59:59"); } bc.banner_ipfrom = CommonFunction.GetClientIPNew(); if (bc.banner_ipfrom == "::1") { bc.banner_ipfrom = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName())[2].ToString(); } if (!string.IsNullOrEmpty(Request.Params["banner_content_id"]) && Request.Params["banner_image"] == oldImg) { bc.banner_image = oldImg; } if (Request.Files["banner_image"] != null && Request.Files["banner_image"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["banner_image"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; string filename = NewName.Substring(0, NewName.LastIndexOf(".")); //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是哈希字符串 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(filename, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; NewFileName = NewFileName + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; string localPromoDirectory = Server.MapPath(localPromoPath); if (!System.IO.Directory.Exists(localPromoDirectory)) { System.IO.Directory.CreateDirectory(localPromoDirectory); } FTP ftp = new FTP(); string directorys = promoPath + firstFolder + secondFolder; ftp.MakeMultiDirectory(imgLocalPath+"/", directorys.Substring(1, directorys.Length - 2).Split('/'), ftpuser, ftppwd); //NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(localPromoPath + firstFolder + secondFolder); string ErrorMsg = string.Empty; //上傳 result = fileLoad.UpLoadFile(file, ServerPath, imgLocalPath + directorys + NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (!result) { json = "{success:false,msg:'圖片上傳失敗!'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } bc.banner_image = NewName; string oldImgPath = string.Empty; string ftppath = string.Empty; if (oldImg.Length >= 4) { oldImgPath = localPromoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/" + oldImg; } if (System.IO.File.Exists(Server.MapPath(oldImgPath))) { ftppath=imgLocalPath + promoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/"; System.IO.File.Delete(Server.MapPath(oldImgPath)); FTP ftp1 = new FTP(ftppath, ftpuser, ftppwd); List<string> tem = ftp1.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(ftppath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(ftppath + oldImg); } } } else { json = "{success:false,msg:'上傳圖片不能超過" + maxValue + "K'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } #region 新增 if (String.IsNullOrEmpty(Request.Params["banner_content_id"])) { bc.banner_content_id = uint.Parse((serial.Serial_Value + 1).ToString()); if (_bcMgr.Add(bc) > 0) { serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/ _ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/ json = "{success:true,msg:\"" + "新增成功!" + "\"}"; } } #endregion #region 編輯 else { bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]); if (_bcMgr.Update(bc) > 0) { json = "{success:true,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; }
public HttpResponseBase GetBannerImageList() { string json = string.Empty; List<BannerContent> store = new List<BannerContent>(); BannerContent bc = new BannerContent(); try { bc.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 bc.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 if (Request.Params["history"] == "1") { bc.banner_status = 3; } if (!string.IsNullOrEmpty(Request.Params["sid"])) { bc.banner_site_id = uint.Parse(Request.Params["sid"]); } _bcMgr = new BannerContentMgr(mySqlConnectionString); int totalCount = 0; store = _bcMgr.GetList(bc, out totalCount); foreach (var item in store) { if (item.banner_image.Length >= 4) { item.banner_image = imgServerPath + promoPath + item.banner_image.Substring(0, 2) + "/" + item.banner_image.Substring(2, 2) + "/" + item.banner_image; } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss "; 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }