public DataTable GetProductName()
{
DataSet ds = null;
try
{
ds = DbOperate.ExecuteDataSet(sqlSelectGetProductName, null);
//ds = DbOperate.ExecuteDataSet(
// ConfigManager.GetDBConnectString(ConfigManager.GetCurrentDBType()),
// sqlSelectGetProductName, null);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
}
}
catch (System.Exception ex)
{
MessageBox.Show("获取产品名称时出现错误：" + ex.Message);
}
return(null);
}
public DataTable GetProductInfoTable(string productID)
{
DataSet ds = null;
try
{
ds = DbOperate.ExecuteDataSet(
sqlSelectGetProductInfoByID,
new object[1] {
productID
});
if (ds != null)
{
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
}
}
catch (System.Exception ex)
{
MessageBox.Show("查询数据库时出现错误：" + ex.Message);
}
return(null);
}
public DataTable GetInStorageProductInfoTable()
{
DataSet ds = null;
try
{
ds = DbOperate.ExecuteDataSet(
sqlSelectInStorage, null);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
}
}
catch (System.Exception ex)
{
MessageBox.Show("查询数据库时出现错误：" + ex.Message);
}
return(null);
}
public DataTable GetInStorageProductInventoryByIDs(string productIDs)
{
DataSet ds = null;
string cmd = string.Format(sqlSelectGetProductByIDFormat, productIDs);
try
{
ds = DbOperate.ExecuteDataSet(
cmd, null);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
}
}
catch (System.Exception ex)
{
MessageBox.Show("查询数据库时出现错误：" + ex.Message);
}
return(null);
}
