建立文件 判断文件是否存在
DirectoryInfo m_Directory = new DirectoryInfo(targetPath);
if (m_Directory.Exists == true)
{
foreach (FileSystemInfo m_File in m_Directory.GetFileSystemInfos())
{
if (m_File is FileInfo)
{
FileInfo xFile = (FileInfo)m_File;
var ds = ReadFile(targetPath, xFile.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
PRODUCT = ds.Tables[0].Rows[i]["PRODUCT"].ToString();
PNSTATUS = ds.Tables[0].Rows[i]["PNSTATUS"].ToString();
ATTRIBUTECATEGORY = ds.Tables[0].Rows[i]["ATTRIBUTECATEGORY"].ToString();
ATTRIBUTETYPE = ds.Tables[0].Rows[i]["ATTRIBUTETYPE"].ToString();
PROOFVALUE = ds.Tables[0].Rows[i]["PROOFVALUE"].ToString();
DEVNO = ds.Tables[0].Rows[i]["DEVNO"].ToString();
DEVEXPIRE = ds.Tables[0].Rows[i]["DEVEXPIRE"].ToString();
string sSQL = "select * from SFC.R_EP_DEV_T where PRODUCT='" + PRODUCT + "' and DEV_NO='" + DEVNO + "' and ATTR_TYPE='" + ATTRIBUTETYPE + "'";
exeRes = this.dbtools.ExecuteQueryDS(sSQL);
DataSet DS = new DataSet();
DS = (DataSet)exeRes.Anything;
if (DS.Tables[0].Rows.Count > 0)
{
string sql = "update SFC.R_EP_DEV_T set PRODUCT= '" + PRODUCT + "',PN_STATUS='" + PNSTATUS + "',ATTR_CATEGORY='" + ATTRIBUTECATEGORY + "',ATTR_TYPE='" + ATTRIBUTETYPE + "',PROOF_VALUE='" + PROOFVALUE + "',DEV_NO='" + DEVNO + "',EXPIRED_DATE=to_date('" + DEVEXPIRE + "','yyyyMMdd') where PRODUCT='" + PRODUCT + "' and DEV_NO='" + DEVNO + "' and ATTR_TYPE='" + ATTRIBUTETYPE + "'";
exeRes = this.dbtools.ExecuteUpdate(sql);
}
else
{
string isql = "insert into SFC.R_EP_DEV_T (PRODUCT,PN_STATUS,ATTR_CATEGORY,ATTR_TYPE,PROOF_VALUE,DEV_NO,EXPIRED_DATE) VALUES ('" + PRODUCT + "','" + PNSTATUS + "','" + ATTRIBUTECATEGORY + "','" + ATTRIBUTETYPE + "','" + PROOFVALUE + "','" + DEVNO + "',to_date('" + DEVEXPIRE + "','yyyyMMdd'))";
exeRes = this.dbtools.ExecuteUpdate(isql);
}
}
}
//string File_Fold = xFile.DirectoryName.Replace(Path_Milan_VFT, "");
//string Backup_FullName = Path_Milan_VFT_Backup + "\\" + File_Fold;
//string Backup_FullName1 = backuppath + "\\" + File_Fold;
string FileString = FileHelper.ShareRead(xFile.FullName, Encoding.ASCII);
将文件变为可操作性，正常的
if (File.GetAttributes(xFile.FullName) != FileAttributes.Normal)
{
File.SetAttributes(xFile.FullName, FileAttributes.Normal);
}
xFile.Delete();
}
}
}
}
备份文件
private void Backup_File(FileInfo xFile, string FullPath, string AddString)
{
try
{
DirectoryInfo m_Directory = new DirectoryInfo(FullPath);
if (m_Directory.Exists == false)
{
Directory.CreateDirectory(FullPath);
}
File.Copy(xFile.FullName, FullPath + "\\" + xFile.Name, true);
//FileStream aFile = new FileStream(FullPath + "\\" + xFile.Name, FileMode.OpenOrCreate);
//StreamWriter sw = new StreamWriter(aFile);
//sw.BaseStream.Seek(0, SeekOrigin.End);
//sw.WriteLine(AddString);
//sw.Close();
//sw.Dispose();
//aFile.Close();
//aFile.Dispose();
}
catch (System.Exception ex)
{
LogMgr.WriteLog("Backup_File" + " <<-->> " + ex.ToString());
}
}
对文件删除
public static void DeleteFilefolder(string sourceFilePath)
{
//?方ゅン?い┮Τ獶ヘ?ゅン
string[] files = Directory.GetFiles(sourceFilePath);
string fileName;
//狦ヘ?ゅン?ぃ?穝ヘ?ゅン?
//if (!Directory.Exists(targetFilePath))
//{
// Directory.CreateDirectory(targetFilePath);
//}
//??ゅン???ヘ?ゅン?い
foreach (string file in files)
{
fileName = System.DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetFileName(file);
//destFile = Path.Combine(targetFilePath, fileName);
//File.Copy(s, destFile, true);
File.Delete(file);
}
}
移动文件
public static void MoveFilefolder(string sourceFilePath, string targetFilePath)
{
//?方ゅン?い┮Τ獶ヘ?ゅン
string[] files = Directory.GetFiles(sourceFilePath);
string fileName;
string destFile;
//狦ヘ?ゅン?ぃ?穝ヘ?ゅン?
//if (!Directory.Exists(targetFilePath))
//{
// Directory.CreateDirectory(targetFilePath);
//}
//??ゅン???ヘ?ゅン?い
foreach (string file in files)
{
fileName = System.DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetFileName(file);
destFile = Path.Combine(targetFilePath, fileName);
//File.Copy(s, destFile, true);
File.Move(file, destFile);
}
}
