private static void Import()
{
StreamReader reader;
try
{
reader = new StreamReader(ImportPath + ImportFile + ".txt");
}
catch (FileNotFoundException)
{
Console.WriteLine("Couldn't open " + ImportPath + ImportFile + ".txt");
return;
} string textLine;
while (!string.IsNullOrEmpty(textLine = reader.ReadLine()))
{
string[] text = textLine.Split('|');
DbDocumentBoxidPosting boxidPosting = new DbDocumentBoxidPosting();
DbDocumentImagePosting docImagePosting = Factory.DbDocumentImagePostingQuery.GetDocumentImagePostingByImageID(text[0]);
if (docImagePosting != null)
{
boxidPosting.DocumentID = docImagePosting.DocumentID;
boxidPosting.Message = text[3];
boxidPosting.Status = text[2];
try
{
Factory.DbDocumentBoxIDPostingService.Update(boxidPosting);
}
catch (Exception)
{
continue;
}
}
}
}
private static void Export()
{
Console.WriteLine("BoxID export is starting.");
IList <SapInstanceData> sapInstances = Factory.DbSapInstanceQuery.GetSapInstanceList();
foreach (SapInstanceData sapInstance in sapInstances)
{
//bat file set ExportPath = root directory. etc: C:\SAPUpload\eXpense\
string newExportPath = RootPath + sapInstance.AliasName + "\\" + ExportPath + "\\";
Console.WriteLine("BoxID(SAP : " + sapInstance.AliasName + ") export is starting.");
IList <ExportBoxID> exportBoxIDList = Factory.DbDocumentBoxIDPostingQuery.GetExportBoxIDList(sapInstance.Code);
StreamWriter writer;
try
{
writer = new StreamWriter(newExportPath + ExportFile + ".txt");
}
catch (Exception)
{
Console.WriteLine("BoxID export is fail. Becourse of can't create export file.");
return;
}
Console.WriteLine("Writing export file...");
foreach (ExportBoxID item in exportBoxIDList)
{
DbDocumentBoxidPosting boxidPosting;
boxidPosting = Factory.DbDocumentBoxIDPostingService.FindByIdentity(item.DocumentID);
if (boxidPosting == null)
{
boxidPosting = new DbDocumentBoxidPosting();
boxidPosting.DocumentID = item.DocumentID;
boxidPosting.Status = "P";
boxidPosting.Message = "Posting";
writer.WriteLine(item.ImageDocID + "|" + item.BoxID);
writer.Flush();
Factory.DbDocumentBoxIDPostingService.Save(boxidPosting);
}
else
{
boxidPosting.DocumentID = item.DocumentID;
boxidPosting.Status = "P";
boxidPosting.Message = "Re Posting";
writer.WriteLine(item.ImageDocID + "|" + item.BoxID);
writer.Flush();
Factory.DbDocumentBoxIDPostingService.Update(boxidPosting);
}
}
Console.WriteLine("export BoxUpdate(SAP : " + sapInstance.AliasName + ") finish.");
}
Console.WriteLine("export BoxUpdate finish.");
//IList<ExportBoxID> exportBoxIDList = Factory.DbDocumentBoxIDPostingQuery.GetExportBoxIDList();
//StreamWriter writer;
//try
//{
// writer = new StreamWriter(ExportPath + ExportFile + ".txt");
//}
//catch (Exception)
//{
// Console.WriteLine("BoxID export is fail. Becourse of can't create export file.");
// return;
//}
//Console.WriteLine("Writing export file...");
//foreach (ExportBoxID item in exportBoxIDList)
//{
// DbDocumentBoxidPosting boxidPosting;
// boxidPosting = Factory.DbDocumentBoxIDPostingService.FindByIdentity(item.DocumentID);
// if (boxidPosting == null)
// {
// boxidPosting = new DbDocumentBoxidPosting();
// boxidPosting.DocumentID = item.DocumentID;
// boxidPosting.Status = "P";
// boxidPosting.Message = "Posting";
// writer.WriteLine(item.ImageDocID + "|" + item.BoxID);
// writer.Flush();
// Factory.DbDocumentBoxIDPostingService.Save(boxidPosting);
// }
// else
// {
// boxidPosting.DocumentID = item.DocumentID;
// boxidPosting.Status = "P";
// boxidPosting.Message = "Re Posting";
// writer.WriteLine(item.ImageDocID + "|" + item.BoxID);
// writer.Flush();
// Factory.DbDocumentBoxIDPostingService.Update(boxidPosting);
// }
//}
//Console.WriteLine("export BoxUpdate finish.");
}
