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."); }