public string AddNewsFileInfo(DocFileInfo _DocFileInfo) { DbParameter[] pramsInsert = { MakeInParam("@FileName",(DbType)SqlDbType.VarChar,50,_DocFileInfo.FileName), MakeInParam("@FileFoldName",(DbType)SqlDbType.VarChar,50,_DocFileInfo.FileFolderName), MakeInParam("@FileES",(DbType)SqlDbType.Int,4,_DocFileInfo.FileES), MakeInParam("@FileEdition",(DbType)SqlDbType.Int,4,_DocFileInfo.FileEdition), MakeInParam("@FileModifyDate",(DbType)SqlDbType.DateTime,10,_DocFileInfo.FileModifyDate), MakeInParam("@FileModifyUserID",(DbType)SqlDbType.Int,4,_DocFileInfo.FileModifyUserId), MakeInParam("@FileSize",(DbType)SqlDbType.Int,4,_DocFileInfo.FileSize), MakeInParam("@FileNote",(DbType)SqlDbType.VarChar,50,_DocFileInfo.FileNote), MakeInParam("@FileValidPeriod",(DbType)SqlDbType.DateTime,10,_DocFileInfo.FileValidPeriod), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Doc_FileInfo]"); sb.Append("([FileName]"); sb.Append(",[FileFoldName]"); sb.Append(",[FileES]"); sb.Append(",[FileEdition]"); sb.Append(",[FileModifyDate]"); sb.Append(",[FileModifyUserID]"); sb.Append(",[FileSize]"); sb.Append(",[FileNote]"); sb.Append(",[FileValidPeriod]"); sb.Append(")"); sb.Append("VALUES"); sb.Append("(@FileName"); sb.Append(",@FileFoldName"); sb.Append(",@FileES"); sb.Append(",@FileEdition"); sb.Append(",@FileModifyDate"); sb.Append(",@FileModifyUserID"); sb.Append(",@FileSize"); sb.Append(",@FileNote"); sb.Append(",@FileValidPeriod"); sb.Append(")"); sb.Append(" select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }
private DocFileInfo GetFileInfoFromIDataReader(DbDataReader dr) { DocFileInfo dt = new DocFileInfo(); if (dr.FieldCount > 0) { dt.FileSerialID = Int32.Parse(dr["FileSerial"].ToString()); dt.FileEdition =Int32.Parse(dr["FileEdition"].ToString()); dt.FileES = Int32.Parse(dr["FileES"].ToString()); dt.FileFolderName = dr["FileFoldName"].ToString(); dt.FileModifyDate =DateTime.Parse(dr["FileModifyDate"].ToString()); dt.FileModifyUserId =Int32.Parse(dr["FileModifyUserID"].ToString()); dt.FileName = dr["FileName"].ToString(); dt.FileNote = dr["FileNote"].ToString(); dt.FileSize =Int32.Parse(dr["FileSize"].ToString()); dt.FileValidPeriod =DateTime.Parse(dr["FileValidPeriod"].ToString()); dr.Close(); return dt; } dr.Close(); return null; }
private void GetFileList(string MyPath) { DirectoryInfo dirInfo = new DirectoryInfo(MyPath); string imgStr = ""; Random rd = new Random(1); foreach (FileInfo file in dirInfo.GetFiles("*.*")) { string MyStr=""; int index; string tailname; string IdName ; int FileES=0; DateTime dtTime = new DateTime(); index = file.Name.LastIndexOf("."); tailname = file.Name.Substring(index + 1); IdName = rd.Next().ToString(); DataTable dt =DbHelper.GetInstance().GetFileInfoByName(file.Name,MyPath); if(dt.Rows.Count==0) { DocFileInfo _DocFileInfo = new DocFileInfo(); _DocFileInfo.FileEdition = 0; _DocFileInfo.FileES=0; _DocFileInfo.FileFolderName=MyPath; _DocFileInfo.FileModifyDate=DateTime.Now; _DocFileInfo.FileModifyUserId=userEntity.UserSerialID; _DocFileInfo.FileName=file.Name; _DocFileInfo.FileNote=""; _DocFileInfo.FileSize=0; _DocFileInfo.FileValidPeriod = DateTime.Now.AddMonths(1); FileES = 0; DbHelper.GetInstance().AddNewsFileInfo(_DocFileInfo); }else { FileES = Int32.Parse(dt.Rows[0]["FileES"].ToString()); dtTime = DateTime.Parse(dt.Rows[0]["FileValidPeriod"].ToString()); //DocFileInfo _docFileInfo = DbHelper.GetInstance().GetFileInfoEntityByFileName(file.Name, MyPath); //_docFileInfo.FileEdition = 0; //DbHelper.GetInstance().UpDateFileInfoByFileName(_docFileInfo); } if (dtTime > DateTime.Now) //是否过期 { MyStr = "<a href=\"javascript:void()\" onmousedown=\"Get('" + file.FullName.Replace("\\", "/") + "','" + tailname + "','" + IdName + "','" + FileES + "')\">"; if (tailname == "doc" || tailname == "docx") MyStr = MyStr + "<img src=\"../images/ico_file_word.PNG\" id='" + IdName + "'/>" + file.Name + "</a>"; else if (tailname == "xls" || tailname == "xlsx") MyStr = MyStr + "<img src=\"../images/ico_file_excel.PNG\" id='" + IdName + "'/>" + file.Name + "</a>"; else if (tailname == "ppt") MyStr = MyStr + "<img src=\"../images/ico_file_ppt.PNG\" id='" + IdName + "'/>" + file.Name + "</a>"; else if (tailname == "pdf") MyStr = MyStr + "<img src=\"../images/ico_file_pdf.PNG\" id='" + IdName + "'/>" + file.Name + "</a>"; else MyStr = MyStr + "<img src=\"../images/ico_file_content.PNG\" id='" + IdName + "'/>" + file.Name + "</a>"; imgStr = imgStr + MyStr; } } showfiles.InnerHtml = imgStr; }
public string UpDateFileInfoByFileName(DocFileInfo _DocFileInfo) { DbParameter[] pramsUpDate = { MakeInParam("@FileName",(DbType)SqlDbType.VarChar,50,_DocFileInfo.FileName), MakeInParam("@FileFoldName",(DbType)SqlDbType.VarChar,50,_DocFileInfo.FileFolderName), MakeInParam("@FileES",(DbType)SqlDbType.Int,4,_DocFileInfo.FileES), MakeInParam("@FileEdition",(DbType)SqlDbType.Int,4,_DocFileInfo.FileEdition), MakeInParam("@FileModifyDate",(DbType)SqlDbType.DateTime,10,_DocFileInfo.FileModifyDate), MakeInParam("@FileModifyUserID",(DbType)SqlDbType.Int,4,_DocFileInfo.FileModifyUserId), MakeInParam("@FileSize",(DbType)SqlDbType.Int,4,_DocFileInfo.FileSize), MakeInParam("@FileNote",(DbType)SqlDbType.VarChar,50,_DocFileInfo.FileNote), MakeInParam("@FileValidPeriod",(DbType)SqlDbType.DateTime,10,_DocFileInfo.FileValidPeriod), }; StringBuilder sb = new StringBuilder(); sb.Append("UpDate [dbo].[Doc_FileInfo]"); sb.Append(" set "); sb.Append(" [FileName]=@FileName,"); sb.Append(" [FileFoldName]=@FileFoldName,"); sb.Append(" [FileES]=@FileES,"); sb.Append(" [FileEdition]=@FileEdition,"); sb.Append(" [FileModifyDate]=@FileModifyDate,"); sb.Append(" [FileModifyUserID]=@FileModifyUserID,"); sb.Append(" [FileSize]=@FileSize,"); sb.Append(" [FileNote]=@FileNote,"); sb.Append(" [FileValidPeriod]=@FileValidPeriod"); sb.Append(" where [FileName]=@FileName and [FileFoldName]=@FileFoldName"); sb.Append(" select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpDate).ToString(); }
protected void btnFileUpload_Click(object sender, EventArgs e) { if (EndTime.Value == "") { lblMessage.Text = "请设置上传文件的有效期"; } else { if (FileUpLoad1.HasFile) { //判断文件是否小于10Mb if (FileUpLoad1.PostedFile.ContentLength < 10485760) { try { //上传文件并指定上传目录的路径 FileUpLoad1.PostedFile.SaveAs(MyPath + "/" + FileUpLoad1.FileName); lblMessage.Text = "上传成功!"; string foldTName = MyPath.Substring(0, MyPath.LastIndexOf("\\")); string foldName = foldTName.Substring(foldTName.LastIndexOf("\\") + 1); DataTable dt = DbHelper.GetInstance().GetFileInfoByName(FileUpLoad1.FileName, MyPath); if (dt.Rows.Count == 0) { DocFileInfo _DocFileInfo = new DocFileInfo(); _DocFileInfo.FileEdition = 0; _DocFileInfo.FileES = 0; _DocFileInfo.FileFolderName = MyPath; _DocFileInfo.FileModifyDate = DateTime.Now; _DocFileInfo.FileModifyUserId = userEntity.UserSerialID; _DocFileInfo.FileName = FileUpLoad1.FileName; _DocFileInfo.FileNote = ""; _DocFileInfo.FileSize = 0; _DocFileInfo.FileValidPeriod = DateTime.Parse(EndTime.Value); DbHelper.GetInstance().AddNewsFileInfo(_DocFileInfo); } } catch (Exception ex) { lblMessage.Text = "出现异常,无法上传!"; } } else { lblMessage.Text = "上传文件不能大于10MB!"; } } else { lblMessage.Text = "尚未选择文件!"; } } //if (AttachFile.HasFile) //{ // string FileName = this.AttachFile.FileName;//获取上传文件的文件名,包括后缀 // string ExtenName = System.IO.Path.GetExtension(FileName);//获取扩展名 // string SaveFileName = MyPath + "/" + FileName; //System.IO.Path.Combine(System.Web.HttpContext.Current.Request.MapPath("UpLoads/"), DateTime.Now.ToString("yyyyMMddhhmm") + ExtenName);//合并两个路径为上传到服务器上的全路径 // AttachFile.MoveTo(SaveFileName, Brettle.Web.NeatUpload.MoveToOptions.Overwrite); // // string url = "UpLoads/" + DateTime.Now.ToString("yyyyMMddhhmmss") + ExtenName; //文件保存的路径 // float FileSize = (float)System.Math.Round((float)AttachFile.ContentLength / 1024000, 1); //获取文件大小并保留小数点后一位,单位是M //} }