protected void Button1_Click(object sender, EventArgs e) { string RootPath = "J:/RD"; string strTempPath = "FileTemp"; string filePath = RootPath + "/" + strTempPath; string fileName = MyPath.Substring(MyPath.LastIndexOf("/") + 1); string CopyFilePath = ""; string folderName = MyPath.Substring(0, MyPath.LastIndexOf("/")); DocFileInfo _docFileInfo = DbHelper.GetInstance().GetFileInfoEntityByFileName(fileName, folderName); if (!File.Exists(filePath)) { Directory.CreateDirectory(filePath); } CopyFilePath = filePath + "/" + fileName.Substring(0,fileName.LastIndexOf(".")); DataTable dtEdition = DbHelper.GetInstance().GetFileEditionInfoByID(_docFileInfo.FileSerialID); if (fileEdtion == "EDITIONTEXTISNULL") { fileEdtion = (dtEdition.Rows.Count + 1).ToString() + ".0"; } else { fileEdtion = fileEdtion +"_" + (dtEdition.Rows.Count + 1).ToString() + ".0"; } CopyFilePath = CopyFilePath + "_" + fileEdtion + fileName.Substring(fileName.LastIndexOf(".") ); try { File.Copy(MyPath, CopyFilePath); }catch(Exception ex) { } DocFileEdition _docFileEdition = new DocFileEdition(); _docFileEdition.FileID = _docFileInfo.FileSerialID; _docFileEdition.FileEdition = fileEdtion; _docFileEdition.FileUrl = CopyFilePath; _docFileEdition.ModifyDate = DateTime.Now; _docFileEdition.ModifyUserName = userEntity.UserName; _docFileEdition.FileNote = ""; _docFileEdition.FileName = fileName; DbHelper.GetInstance().AddFileEditionInfo(_docFileEdition); }
public string AddFileEditionInfo(DocFileEdition _DocFileEdition) { DbParameter[] pramsInsert = { MakeInParam("@FileID",(DbType)SqlDbType.Int,4,_DocFileEdition.FileID), MakeInParam("@FileEdition",(DbType)SqlDbType.VarChar,50,_DocFileEdition.FileEdition), MakeInParam("@ModifyDate",(DbType)SqlDbType.DateTime,10,_DocFileEdition.ModifyDate), MakeInParam("@ModifyUser",(DbType)SqlDbType.VarChar,50,_DocFileEdition.ModifyUserName), MakeInParam("@FileNote",(DbType)SqlDbType.VarChar,50,_DocFileEdition.FileNote), MakeInParam("@FileUrl",(DbType)SqlDbType.VarChar,50,_DocFileEdition.FileUrl), MakeInParam("@FileName",(DbType)SqlDbType.VarChar,50,_DocFileEdition.FileName), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Doc_FileEdition]"); sb.Append("([FileID]"); sb.Append(",[FileEdition]"); sb.Append(",[ModifyUser]"); sb.Append(",[ModifyDate]"); sb.Append(",[FileNote]"); sb.Append(",[FileUrl]"); sb.Append(",[FileName]"); sb.Append(")"); sb.Append("VALUES"); sb.Append("(@FileID"); sb.Append(",@FileEdition"); sb.Append(",@ModifyUser"); sb.Append(",@ModifyDate"); sb.Append(",@FileNote"); sb.Append(",@FileUrl"); sb.Append(",@FileName"); sb.Append(")"); sb.Append(" select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }