public DataTable GetSsccProducts(string SSCCcode) { SqlDataSource ds = new SqlDataSource(DatabaseConnection); var query = new MySqlQuery().QuerySSCCProducts(SSCCcode); ds.Queries.Add(query); ds.Fill(); ITable source = ds.Result[0]; DataTable dest = new DataTable("Products"); foreach (IColumn column in source.Columns) { dest.Columns.Add(column.Name, column.Type); } foreach (IRow row in source) { DataRow dr = dest.NewRow(); for (int i = 0; i < dest.Columns.Count; i++) { dr[i] = row[i]; } dest.Rows.Add(dr); } return(dest); }
public ITable GetSsccList(string customerCode, string depotDate) { SqlDataSource ds = new SqlDataSource(DatabaseConnection); var query = new MySqlQuery().QuerySSCCList(customerCode, depotDate); ds.Queries.Add(query); ds.Fill(); DisplayMember = "sscc"; ValueMember = "sscc"; return(ds.Result["SSCCList"]); }
public ITable GetDepotList() { SqlDataSource ds = new SqlDataSource(DatabaseConnection); var query = new MySqlQuery().QueryDepotList(); ds.Queries.Add(query); ds.Fill(); DisplayMember = "customername"; ValueMember = "customercode"; return(ds.Result["DepotList"]); }