public byte[] Get_File(ViewPDF request) { byte[] Result = null; string strPath = ""; string eDocumentPath = ""; try { using (var db = DbConnectionFactory.OpenDbConnection()) { string strSQL = "Select Top 1 eDocumentPath From Saco1"; List <Saco1> saco1 = db.Select <Saco1>(strSQL); eDocumentPath = saco1[0].eDocumentPath; strPath = eDocumentPath + "\\" + request.FolderName + "\\eDoc\\" + request.Key + "\\" + request.FileName; using (FileStream fsRead = new FileStream(strPath, FileMode.Open)) { int fsLen = (int)fsRead.Length; byte[] heByte = new byte[fsLen]; int r = fsRead.Read(heByte, 0, heByte.Length); Result = heByte; } } } catch { throw; } return(Result); }
public object Get_List(ViewPDF request) { object Result = null; tnPDF = new List <TrxNoPDFName>(); string strPath = ""; string eDocumentPath = ""; try { using (var db = DbConnectionFactory.OpenDbConnection()) { string strSQL = "Select Top 1 eDocumentPath From Saco1"; List <Saco1> saco1 = db.Select <Saco1>(strSQL); if (saco1.Count > 0) { eDocumentPath = saco1[0].eDocumentPath; } } if (!string.IsNullOrEmpty(request.FolderName)) { strPath = eDocumentPath + "\\" + request.FolderName + "\\eDoc"; GetAllDirList(strPath); } if (tnPDF.Count > 0) { string strKeys = ""; for (int i = 0; i <= tnPDF.Count - 1; i++) { strKeys = strKeys + "'" + tnPDF[i].Key + "',"; } if (strKeys.LastIndexOf(",").Equals(strKeys.Length - 1)) { strKeys = strKeys.Substring(0, strKeys.Length - 1); } using (var db = DbConnectionFactory.OpenDbConnection()) { string strSQL = ""; switch (request.FolderName.ToLower()) { case "ivcr1": strSQL = "Select TrxNo,InvoiceNo,InvoiceDate,CustomerName,InvoiceAmt From Ivcr1 Where TrxNo in (" + strKeys + ")"; List <ViewPDF_Ivcr> rIvcr = db.Select <ViewPDF_Ivcr>(strSQL); foreach (ViewPDF_Ivcr vi in rIvcr) { for (int i = 0; i <= tnPDF.Count - 1; i++) { if (tnPDF[i].Key.Equals(vi.TrxNo.ToString())) { vi.FileName = tnPDF[i].FileName; break; } } } Result = rIvcr; break; case "jmjm1": strSQL = "Select JobNo,JobDate,CustomerName,InvoiceLocalAmt From Jmjm1 Where JobNo in (" + strKeys + ")"; List <ViewPDF_Jmjm> rJmjm = db.Select <ViewPDF_Jmjm>(strSQL); foreach (ViewPDF_Jmjm vi in rJmjm) { for (int i = 0; i <= tnPDF.Count - 1; i++) { if (tnPDF[i].Key.Equals(vi.JobNo.ToString())) { vi.FileName = tnPDF[i].FileName; break; } } } Result = rJmjm; break; case "slcu1": strSQL = "Select TrxNo,InvoiceNo,InvoiceDate,CustomerName,InvoiceAmt From Ivcr1 Where TrxNo in (" + strKeys + ")"; List <ViewPDF_Jmjm> rSlcu = db.Select <ViewPDF_Jmjm>(strSQL); foreach (ViewPDF_Jmjm vi in rSlcu) { for (int i = 0; i <= tnPDF.Count - 1; i++) { if (tnPDF[i].Key.Equals(vi.JobNo.ToString())) { vi.FileName = tnPDF[i].FileName; break; } } } Result = rSlcu; break; } } } } catch { throw; } return(Result); }