public object DownFileData(int Restype, long SeqID, string ColumnName) { if (userLoginManager.LoginUser == null || userLoginManager.LoginUser.UserID < 1) return new { Rcode = -2, Rdata = "未登录" }; string userIP = null; string tablename, serviceno, orderno; int costtype; decimal m_price, m_discount; int status = BaseBLL.GetFullPathResourceCheckCost(Restype, SeqID, userLoginManager.LoginUser.UserID, userLoginManager.LoginUser.Customerid, userIP, out tablename, out costtype, out m_price, out m_discount, out serviceno, out orderno, out errmsg); if (status == -1) return new { Rcode = -1, Rmsg = errmsg }; if (status == 0) return new { Rcode = -3, Rmsg = "此资源需要付费才能下载,现在去付费", Rdata = orderno }; BookInfo bookinfo = ResourcesBLL.GetFilePath(tablename, SeqID, 0, ColumnName, out errmsg); if (!string.IsNullOrEmpty(errmsg) || bookinfo == null) return new { Rcode = -1, Rmsg = "获取资源数据错误" + errmsg }; if (string.IsNullOrEmpty(bookinfo.BookPath)) { return new { Rcode = -1, Rmsg = "资源文件路径不存在" }; } string pdffile = string.Format("{0}{1}", GlobalParameters.RootFilePath, bookinfo.BookPath).Replace("//", "/").Replace("/", "\\"); if (!File.Exists(pdffile)) { return new { Rcode = -1, Rmsg = "资源文件不存在" }; } string filecode = StrFormatClass.Encrypt(bookinfo.BookPath + DateTime.Now.ToString("yyyyMMddHHmmss"), ref errmsg); return new { Rcode = 1, Rdata = filecode }; }
private void showOldResInfo(int resid) { try { ResourcesBLL resource = new ResourcesBLL(); ResourceModel res = resource.GetResourcesById(resid); ViewState["ResID"] = resid; this.txtResName.Text = res.ResName; this.txtjianjie.Text = res.ResDescription; } catch (Exception) { } }
protected void btnDownExcel_Click(object sender, EventArgs e) { Response.AppendHeader("Content-Disposition", "attachment;filename=registerStore.xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); ResourcesBLL resource = new ResourcesBLL(); DataTable dt = resource.GetTableForExcel(ViewState["pagewhere"].ToString()); StringBuilder sb = Excel.GetExcelTable(dt, GetTran("000653", "资料下载表"), new string[] { "ResName=" + GetTran("000204", "资料名称"), "FileName=" + GetTran("000278", "对应文件名"), "ResDescription=" + GetTran("000280", "资料简介"), "ResSize=" + GetTran("000282", "文件大小"), "ResTimes=" + GetTran("000287", "下载次数") }); Response.Write(sb.ToString()); Response.Flush(); Response.End(); }
/// <summary> /// 检查文件名字 /// </summary> /// <returns></returns> /// private bool CheckFileNames() { if (this.txtResName.Text.Trim() == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + GetTran("001510", "资料名不能为空") + "!')", true); return(false); } ResourcesBLL resoucres = new ResourcesBLL(); if (resoucres.CheckReourceResname(DisposeString.DisString(this.txtResName.Text.Trim().Trim()))) { ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + GetTran("001512", "存在同名资料") + "!')", true); return(false); } return(true); }
private void UpdateResInfo(string resname, string filename, string resdes, string ressize) { ResourceModel res = new ResourceModel(); res.ResID = Convert.ToInt32(ViewState["ResID"].ToString()); res.ResDateTime = DateTime.Now.ToUniversalTime(); res.ResDescription = resdes; res.ResName = resname; res.ResSize = ressize; res.FileName = filename; res.DownTarget = Convert.ToInt32(this.DropDownList2.SelectedValue); res.DownMenberLev = Convert.ToInt32(this.DropDownList3.SelectedValue); ResourcesBLL resource = new ResourcesBLL(); resource.UpdateResource(res); }
/// <summary> /// 上传文件方法 /// </summary> /// <param name="resname"></param> /// <param name="filename"></param> /// <param name="resdes"></param> /// <param name="ressize"></param> /// <param name="datetime"></param> private void RecordResInfo(string resname, string filename, string resdes, string ressize, string datetime) { ResourceModel res = new ResourceModel(); res.ResDateTime = DateTime.Now.ToUniversalTime(); res.ResDescription = resdes; res.ResName = resname; res.ResSize = ressize; res.FileName = filename; res.CPPCode = Convert.ToInt32(this.DropDownList1.SelectedValue); res.DownMenberLev = Convert.ToInt32(this.DropDownList3.SelectedValue); res.DownTarget = Convert.ToInt32(this.DropDownList2.SelectedValue); ResourcesBLL resource = new ResourcesBLL(); if (resource.InsertResource(res)) { labUpInfo.Text = GetTran("001506", "上传成功") + "!!!"; } else { labUpInfo.Text = GetTran("001508", "上传失败") + "!!!"; } }
public object GetItemQsEchart(int year, int wordnum = 0) { int total; string errmsg; List <base_itemcontents> list = BLL.BaseBLL.GetItemContents("wx_yjqspicdata", false, 0, 10000, out total, out errmsg); if (year > 0) { list = list.FindAll(o => o.aboutdate == year.ToString()); } Dictionary <string, int> wordlist = new Dictionary <string, int>(); Dictionary <string, int> nexuslist = new Dictionary <string, int>(); List <EchartNode> nodes = new List <EchartNode>(); // category,name,value,label List <EchartLink> links = new List <EchartLink>(); // source,target,weight,name Random rand = new Random(); foreach (base_itemcontents itemcontents in list) { if (!wordlist.ContainsKey(itemcontents.title)) { wordlist.Add(itemcontents.title, 1); nodes.Add(new EchartNode() { category = itemcontents.author, name = itemcontents.title, // value = 1, symbolSize = 1 }); } } base_itemcontents tcon; foreach (EchartNode node in nodes) { tcon = list.Find(o => o.title == node.name); if (tcon != null && !string.IsNullOrEmpty(tcon.abstracts)) { foreach (string word in tcon.abstracts.Split('|')) { if (word.Length > 0 && wordlist.ContainsKey(word)) { links.Add(new EchartLink() { weight = 1, name = "", source = tcon.title, target = word }); } } } } foreach (EchartNode node in nodes) { node.value = node.symbolSize = links.FindAll(o => o.source == node.name).Count; } if (wordnum > 0 && wordnum < nodes.Count) { nodes.Sort(delegate(EchartNode x, EchartNode y) { return(y.value.CompareTo(x.value)); }); nodes = nodes.Take(wordnum).ToList <EchartNode>(); } EchartLink tlink; EchartNode tsnode; EchartNode ttnode; for (int i = 0; i < links.Count; i++) { tlink = links[i]; tsnode = nodes.Find(o => o.name == tlink.source); ttnode = nodes.Find(o => o.name == tlink.target); if (tsnode == null || ttnode == null) { links.Remove(tlink); continue; } int count = links.FindAll(o => o.source == ttnode.name && o.target == tsnode.name).Count; if (count > 0) { tlink.weight = tlink.weight * count + 2; } if (tsnode.category == ttnode.category) { tlink.weight = tlink.weight * 8; } } DataTable restable = ResourcesBLL.GetResTypeList(out errmsg); List <object> reslist = new List <object>(); foreach (DataRow dr in restable.Rows) { reslist.Add(new { name = dr["databasecname"].ToString(), value = dr["databaseid"].ToString() }); } return(new { nodes = nodes, links = links, categoryes = reslist }); }
protected void givshowFile_RowCommand(object sender, GridViewCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument.ToString()); ResourcesBLL resource = new ResourcesBLL(); ResourceModel resuouces = resource.GetResourcesById(id); if (resuouces == null) { ScriptHelper.SetAlert(givshowFile, GetTran("001332", "该资料可能已经不存在") + "!!!"); return; } if (e.CommandName.ToLower().Trim() == "del") { try { //从文件夹中删除指定的文件 string path = Server.MapPath(@"..\company\upLoadRes\") + resuouces.FileName; System.IO.FileInfo file = new System.IO.FileInfo(path); if (file.Exists) { file.Delete(); } //删除数据库中文件的信息 resource.DelResurces(Convert.ToInt32(id)); ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("000008", "删除成功") + "!');</script>"); PageBind(); } catch { } } else if (e.CommandName.ToLower().Trim() == "download") { try { string dlDir = "upLoadRes/"; string path = Server.MapPath(dlDir + resuouces.FileName); System.IO.FileInfo file = new System.IO.FileInfo(path); if (file.Exists) { //修改最后下载时间 // ResourcesBLL resource = new ResourcesBLL(); resource.UpdateResutcesResTime(Convert.ToInt32(id)); PageBind(); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(file.Name).Replace('+', ' ')); Response.AddHeader("Content-Length", file.Length.ToString()); Response.AddHeader("Content-Transfer-Encoding", "binary"); Response.ContentType = "application/octet-stream"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); Response.WriteFile(file.FullName); Response.Flush(); Response.End(); string wheret = ViewState["pagewhere"].ToString(); Pager pager = Page.FindControl("Pager1") as Pager; pager.PageBind(0, 10, "Resources", "ResID, ResName, FileName, ResDescription, ResSize, ResDateTime, ResTimes", wheret, "ResID", "givshowFile"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('" + GetTran("000666", "您下载的文件不在文件夹中") + "!');</script>"); } } catch (Exception ex) { } finally { PageBind(); } } }
public object GetBookInfo(BookParm book) { string errmsg = null; if (book == null || book.did < 1 || book.sid < 1 || book.pid < 0) { return(new { Rcode = -1, Rmsg = "参数错误" }); } if (userLoginManager.LoginUser == null || userLoginManager.LoginUser.UserID < 1) { return new { Rcode = -2, Rmsg = "未登录" } } ; string userIP = null; string tablename, serviceno, orderno; int costtype; decimal m_price, m_discount; int status = BaseBLL.GetFullPathResourceCheckCost(book.did, book.sid, userLoginManager.LoginUser.UserID, userLoginManager.LoginUser.Customerid, userIP, out tablename, out costtype, out m_price, out m_discount, out serviceno, out orderno, out errmsg); if (status == -1) { return new { Rcode = -1, Rmsg = errmsg } } ; if (status == 0) { return new { Rcode = -3, Rmsg = "此资源需要付费才能在线阅读,现在去付费", Rdata = orderno } } ; BookInfo bookinfo = ResourcesBLL.GetFilePath(tablename, book.sid, book.pid, "fullpath", out errmsg); if (!string.IsNullOrEmpty(errmsg) || bookinfo == null) { return new { Rcode = -1, Rmsg = "获取资源数据错误" + errmsg } } ; if (string.IsNullOrEmpty(bookinfo.BookPath)) { return(new { Rcode = -1, Rmsg = "资源文件路径不存在" }); } string pdffile = string.Format("{0}{1}", GlobalParameters.RootFilePath, bookinfo.BookPath).Replace("//", "/").Replace("/", "\\"); if (!File.Exists(pdffile)) { return(new { Rcode = -1, Rmsg = "资源文件不存在" }); } if (!Path.GetExtension(pdffile).Equals(".pdf", StringComparison.CurrentCultureIgnoreCase)) { return(new { Rcode = -1, Rmsg = "此资源非在线阅读资源,请直接下载" }); } BookInfo info = new BookInfo(); info.IsCopy = false; info.IsDown = false; info.IsFind = false; string swfpath = Path.GetDirectoryName(pdffile) + "\\swf"; if (!Directory.Exists(swfpath)) { return(new { Rcode = -1, Rmsg = "资源文件未转换" }); } string[] files = Directory.GetFiles(swfpath, "*.swf"); if (files.Length == 0) { return(new { Rcode = -1, Rmsg = "资源文件未转换或转换失败" }); } info.LimitPage = bookinfo.LimitPage; info.PageCount = files.Length; info.Domain = string.Format("http://{0}", HttpContext.Current.Request.Url.Authority); info.BookPath = Path.GetDirectoryName(bookinfo.BookPath) + "/swf"; string[] fiarr = Directory.GetFiles(Path.GetDirectoryName(pdffile), "*.xml"); if (fiarr.Length > 0) { try { //解析xml目录文件 //string xmlstr = File.ReadAllText(fiarr[0]); //XmlDocument xmldoc = new XmlDocument(); //xmldoc.LoadXml(xmlstr); //XmlElement rootnode = (XmlElement)xmldoc.SelectSingleNode("Bookmark"); //RIPS.BaseModels.Options options = new RIPS.BaseModels.Options() { id = "0", text = "", children = new List<RIPS.BaseModels.Options>() }; //int idnum = 0; //getChildren(rootnode, options, idnum); //info.ThemeStr = options.children; } catch (Exception ex) { info.ThemeStr = null; } } return(new { Rcode = 1, Rdata = info }); } //private static void getChildren(XmlElement element, RIPS.BaseModels.Options option, int idnum) //{ // option.children = new List<RIPS.BaseModels.Options>(); // RIPS.BaseModels.Options op; // string text; // foreach (object obja in element.ChildNodes) // { // if (obja.GetType() == typeof(XmlElement)) // { // XmlElement el = (XmlElement)obja; // if (el.FirstChild != null) // text = el.FirstChild.Value; // else // text = el.InnerText; // text = text.Replace("\r\n", ""); // op = new RIPS.BaseModels.Options() { id = idnum.ToString() + "_" + el.GetAttribute("Page"), text = text, children = new List<RIPS.BaseModels.Options>() }; // idnum++; // option.children.Add(op); // if (el.ChildNodes.Count > 0) // { // getChildren(el, op, idnum); // } // } // } //} } }
protected void btnUpLoad_Click(object sender, EventArgs e) { ResourcesBLL resources = new ResourcesBLL(); string mfileName = ""; if (this.txtjianjie.Text.Trim().Length > 50) { ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + GetTran("001502", "输入的简介超过50个字符") + "')"); return; } if (this.txtResName.Text.Trim() == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006938", "资料名称和资料简介不能为空!") + "')</script>"); return; } if (!System.IO.Directory.Exists(Server.MapPath("~/Company/upLoadRes/"))) { System.IO.Directory.CreateDirectory(Server.MapPath("~/Company/upLoadRes/") + "\\"); } if (Request.QueryString["action"] != "edit") { string filepath = upFile.PostedFile.FileName;//获取要上传的文件的说有字符,包括文件的路径,文件的名称文件的扩展名称 //验证上传文件后缀名 string s = filepath.Substring(filepath.LastIndexOf(".") + 1); s = s.ToLower(); if (s != "rar" && s != "zip") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('您上传的文件格式不正确,请重新上传!')</script>"); return; } try { string mPath = Server.MapPath("~/Company/upLoadRes/"); mfileName = filepath.Substring(filepath.LastIndexOf("\\") + 1); if (mfileName.Length > 30) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('资料文件名不得大于30个字符!')</script>"); } else { int sizeLength = upFile.PostedFile.ContentLength; if (sizeLength > 4 * 1024 * 1024) { ClientScript.RegisterStartupScript(this.GetType(), "", "alert('上传文件不能超过4MB')", true); return; } string ressize;//文件大小 if (sizeLength <= 1203) { ressize = upFile.PostedFile.ContentLength.ToString() + "B"; } else { ressize = Convert.ToString(upFile.PostedFile.ContentLength / 1204) + "K"; } string resname = this.txtResName.Text.Trim(); string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1); string resdes = this.txtjianjie.Text.Trim(); string realName = DateTime.Now.Millisecond.ToString() + mfileName; upFile.PostedFile.SaveAs(mPath + "\\" + realName); if (CheckFileForm(mPath + "\\" + realName) <= 0) { File.Delete(mPath + "\\" + realName); ClientScript.RegisterStartupScript(this.GetType(), "", "alert('" + GetTran("000823", "上传文件格式不正确!") + "');", true); return; }//图片文件上传后进行压缩再删除原有图片 else if (CheckFileForm(mPath + "\\" + realName) == 2) { ZipClass zc = new ZipClass(); string err = ""; string zipPath1 = mPath + realName; string zipPath = zipPath1.Replace(zipPath1.Substring(zipPath1.LastIndexOf(".") + 1), "rar"); realName = realName.Replace(realName.Substring(realName.LastIndexOf(".") + 1), "rar"); bool res = zc.ZipFile(zipPath1, zipPath, out err); if (res) { File.Delete(zipPath1); } else { labUpInfo.Text = err; return; } } RecordResInfo(resname, realName, resdes, ressize, DateTime.UtcNow.ToLongDateString()); this.txtjianjie.Text = ""; this.txtResName.Text = ""; } } catch (Exception) { //throw; labUpInfo.Text = "上传失败!该资料的操作权限不够,请设置权限再进行上传!"; } } else { string resname = this.txtResName.Text.Trim(); string resdes = this.txtjianjie.Text.Trim(); UpdateResInfo(resname, "", resdes, ""); this.labUpInfo.Text = GetTran("001505", "资料修改成功") + "!"; } }