/// <summary>
/// 添加文件
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool Add(INFO_FILEINFO info)
{
bool isSuccess = true;
StringBuilder pInsertText = new StringBuilder();
pInsertText.Append("INSERT INTO INFO_FILEINFO(FILENAME,FILEURL,UPLOADTIME,FILESIZE,UPLOADUSER) VALUES('");
pInsertText.Append(info.FILENAME + "','" + info.FILEURL + "',TO_DATE('" + info.UPLOADTIME.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss'),'" + info.FILESIZE + "'," + info.UPLOADUSER + ")");
try
{
OracleOperateBLL.ExecuteSql(pInsertText.ToString());
}
catch
{
isSuccess = false;
}
return(isSuccess);
//DbBase<INFO_FILEINFO> db = new DbBase<INFO_FILEINFO>();
//db.Insert(info);
//if (db.SaveChanges() >= 0)
//{
// return true;
//}
//else
//{
// return false;
//}
}
public ActionResult btnUpload_Click(HttpPostedFileBase uploadFile, FormCollection values)
{
if (uploadFile != null)
{
string fileName = uploadFile.FileName;
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
string truthFileName = DateTime.Now.Ticks.ToString() + "_" + fileName;
uploadFile.SaveAs(Server.MapPath("~/upload/" + truthFileName));
//保存文件
INFO_FILEINFO info = new INFO_FILEINFO();
info.FILENAME = fileName;
info.FILEURL = truthFileName;
info.UPLOADTIME = DateTime.Now;
if (Session[WebConstants.UserSession] == null)
{
info.UPLOADUSER = -1;
}
else
{
UserInfo user = Session[WebConstants.UserSession] as UserInfo;
info.UPLOADUSER = user.Id;
}
if (System.IO.File.Exists(Server.MapPath("~/upload/" + truthFileName)))
{
System.IO.FileInfo fileInfo = new System.IO.FileInfo(Server.MapPath("~/upload/" + truthFileName));
info.FILESIZE = System.Math.Ceiling(fileInfo.Length / 1024.0) + "KB";
}
var isSuccess = FileBLL.Add(info);
if (isSuccess)
{
ShowNotify("数据上传成功！");
}
else
{
ShowNotify("数据上传失败！");
}
}
// 调用父页面定义的函数 reload
PageContext.RegisterStartupScript("reload();");
return(UIHelper.Result());
}
/// <summary>
/// 获取文件
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static INFO_FILEINFO Get(int id)
{
INFO_FILEINFO pFileInfo = new INFO_FILEINFO();
OracleConnection pConn = null;
OracleCommand pComm = null;
OracleDataReader pReader = null;
pConn = new OracleConnection(ORACLE_CONNECTION_STRING);
pConn.Open();
string pCmdText = "SELECT ID,FILENAME,FILEURL,TO_CHAR(UPLOADTIME,'yyyy-mm-dd hh24:mi:ss') AS UPLOADTIME,FILESIZE,UPLOADUSER FROM INFO_FILEINFO WHERE ID = " + id + "";
pComm = new OracleCommand(pCmdText, pConn);
pReader = pComm.ExecuteReader();
while (pReader.Read())
{
pFileInfo.ID = Convert.ToInt32(pReader["ID"]);
pFileInfo.FILENAME = Convert.ToString(pReader["FILENAME"]);
pFileInfo.FILEURL = Convert.ToString(pReader["FILEURL"]);
pFileInfo.UPLOADTIME = Convert.ToDateTime(pReader["UPLOADTIME"]);
pFileInfo.FILESIZE = Convert.ToString(pReader["FILESIZE"]);
pFileInfo.UPLOADUSER = Convert.ToInt32(pReader["UPLOADUSER"]);
}
if (pReader != null)
{
pReader.Close();
pReader.Dispose();
}
if (pComm != null)
{
pComm.Dispose();
}
if (pConn != null)
{
pConn.Close();
pConn.Dispose();
}
return(pFileInfo);
//DbBase<INFO_FILEINFO> db = new DbBase<INFO_FILEINFO>();
//return db.FirstOrDefault(p => p.ID == id);
}
