public DataTable GetInfomation(string code)
{
using (StoreAccess accesss = new StoreAccess())
{
string strSQL = string.Format("SELECT [MaterialNumber],[MaterialName], [Result],[Iquantity],[Batch],[SupplierName] FROM [Table_InvoiceVerify] WHERE [InvoiceNumber] = '{0}'", code);
return(accesss.ExcuteTable(strSQL));
}
}
/// <summary>
/// 查询仓库结构
/// </summary>
/// <returns></returns>
public DataTable GetStoreStructure()
{
using (StoreAccess access = new StoreAccess())
{
string strSQL = "SELECT [Row],[Column],[Layer],[StoreStaus],[MaxCount],[Status],[Type] FROM [WMS_Manager].[dbo].[Table_Warehouse]";
return(access.ExcuteTable(strSQL));
}
}