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
//}
}
