public static List <string> GetPrintEinvoiceNumbersByPrintNo(string printNo) { List <string> invoiceList = new List <string>(); Repositoies.SaveMesagesToTextFile("取號開始:" + printNo); var data = PrintEinvoiceSqlHandler(printNo); Repositoies.SaveMesagesToTextFile("取號結束:" + printNo); return(data); }
public static List <string> PrintEinvoiceSqlHandler(string printNo) { List <string> result = new List <string>(); try { string connectionString = @"Data Source=192.168.1.4;Initial Catalog=NavisionNew;User ID=sa;Password=sasasasa"; string queryString = @" select * from [Rinnai$VAT Print Number] where [Print No] =@printNo order by [VAT No] "; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter() { ParameterName = "@printNo", Value = printNo }); Repositoies.SaveMesagesToTextFile("取號資料庫連線開始:" + printNo); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); command.Parameters.AddRange(sqlParameters.ToArray()); connection.Open(); SqlDataReader reader = command.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); if (dt.Rows.Count == 0) { Repositoies.SaveMesagesToTextFile("取得筆數0筆:"); throw new Exception(string.Format("列印序號:{0} 查無發票號碼!", printNo)); } for (int i = 0; i < dt.Rows.Count; i++) { result.Add(dt.Rows[i]["VAT No"].ToString()); } } Repositoies.SaveMesagesToTextFile("取號資料庫連線結束:" + printNo); } catch (Exception ex) { throw ex; } result = result.Distinct().ToList(); return(result); }