public static ShelfOnInfo GetShelfOnInfo()
{
try
{
myCon.Open();
string sql = "SELECT sp.ProductName,GROUP_CONCAT(tid),COUNT(1) FROM StockProducts sp WHERE sp.ProductState='已入库' GROUP BY sp.ProductName ";
MySqlCommand mySqlCommand = new MySqlCommand(sql, myCon);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
ShelfOnInfo shelfOnInfo = new ShelfOnInfo();
while (mySqlDataReader.Read())
{
if (mySqlDataReader.HasRows)
{
Productinfo productinfo = new Productinfo
{
ProductName = mySqlDataReader[0].ToString(),
tids = mySqlDataReader[1].ToString().Split(new char[1] {
','
}).ToList(),
Count = mySqlDataReader[2].ToString()
};
shelfOnInfo.productinfos.Add(productinfo);
}
}
mySqlDataReader.Close();
string sql2 = "SELECT shelfcode,shelflocation from ShelfCodePositionCorrespondence WHERE ShelfState='无货物'";
MySqlCommand mySqlCommand2 = new MySqlCommand(sql2, myCon);
MySqlDataReader mySqlDataReader2 = mySqlCommand2.ExecuteReader();
while (mySqlDataReader2.Read())
{
if (mySqlDataReader2.HasRows)
{
ShelfCode shelfCode = new ShelfCode
{
shelfcode = mySqlDataReader2[0].ToString(),
shelflocation = mySqlDataReader2[1].ToString(),
};
shelfOnInfo.ShelfCodes.Add(shelfCode);
}
}
mySqlDataReader2.Close();
return(shelfOnInfo);
}
catch (Exception ex)
{
LogHelper.WriteLog("查询失败", ex);
return(null);
}
finally
{
myCon.Close();
}
}
public void GetShelfOnOrder()
{
comboBox1.Items.Clear();
comboBox3.Items.Clear();
shelfOnInfo = DatabaseHelper.GetShelfOnInfo();
foreach (var item in shelfOnInfo.productinfos)
{
comboBox1.Items.Add(item.ProductName);
}
foreach (var item in shelfOnInfo.ShelfCodes)
{
comboBox3.Items.Add(item.shelflocation);
}
}