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