/// <summary> /// 将Q01文件记录写入数据库 /// </summary> /// <param name="to"></param> /// <param name="user"></param> /// <returns></returns> private static bool SaveQ01ToDatabase(string to, XbUser user) { String[] lines = File.ReadAllLines(to); Debug.Print("reading {0} lines from {1}", lines.Length, to); Q01File q01File = new Q01File(); q01File.Name = Path.GetFileName(to); q01File.AddDate = DateTime.Now.Date; q01File.RecordCount = lines.Length; q01File.Lower = DateTime.ParseExact(lines[0].Substring(0, 8), "yyyyMMdd", CultureInfo.InvariantCulture).Date; q01File.Upper = DateTime.ParseExact(lines[lines.Length - 1].Substring(0, 8), "yyyyMMdd", CultureInfo.InvariantCulture).Date; q01File.IsImportedToDb = false; q01File.UserName = user.Name; bool isSaved = q01File.Insert(); if (isSaved) { Debug.Print("save Q01File {0} to database success!", to); } return(isSaved); }
public static bool CopyToAppResourceFolder(String q01SrcPathName, XbUser user) { DirectoryInfo directoryInfo = new DirectoryInfo(Q01_PATH); string from = q01SrcPathName; String to = directoryInfo.FullName + "\\" + Path.GetFileName(q01SrcPathName) + ".q01"; var isCopied = false; if (File.Exists(to)) { MessageBox.Show("已存在名为【" + Path.GetFileName(to) + "】的q01文件,请改个名字再加入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); //if (dialogResult == DialogResult.Yes) //{ // File.Delete(to); // Debug.Print("delete file {0}", to); // File.Copy(from, to); // Debug.Print("copy file {0} to {1}", from, to); // isCopied = File.Exists(to); // Debug.Print("has file {0} : {1}", to, isCopied); //} //if (dialogResult == DialogResult.No) //{ // var saveFileDialog = new SaveFileDialog {InitialDirectory = Path.GetDirectoryName(to)}; // if (saveFileDialog.ShowDialog() == DialogResult.OK) // { // to = saveFileDialog.FileName; // File.Copy(from, to); // Debug.Print("copy file {0} to {1}", from, to); // isCopied = File.Exists(to); // Debug.Print("has file {0} : {1}", to, isCopied); // } //} //if (dialogResult == DialogResult.Cancel) //{ // return false; //} } File.Copy(from, to); Debug.Print("copy file {0} to {1}", from, to); isCopied = File.Exists(to); Debug.Print("has file {0} : {1}", to, isCopied); if (isCopied) { String[] lines = File.ReadAllLines(to); Debug.Print("reading {0} lines from {1}", lines.Length, to); Q01File q01File = new Q01File(); q01File.Name = Path.GetFileName(to); q01File.AddDate = DateTime.Now.Date; q01File.RecordCount = lines.Length; q01File.Lower = DateTime.ParseExact(lines[0].Substring(0, 8), "yyyyMMdd", CultureInfo.InvariantCulture).Date; q01File.Upper = DateTime.ParseExact(lines[lines.Length - 1].Substring(0, 8), "yyyyMMdd", CultureInfo.InvariantCulture).Date; q01File.IsImportedToDb = false; q01File.UserName = user.Name; bool isSaved = q01File.Insert(); if (isSaved) { Debug.Print("save Q01File {0} to database success!", to); } else { Debug.Fail("save Q01File {0} to database failed!", to); } } return(isCopied); }