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