/// <summary>
/// 写入历史数据信息
/// </summary>
internal int InsertHistory(NnPolypeptide od)
{
int count = 0;
try
{
using (OleDbCommand cmd = new OleDbCommand($"INSERT INTO history VALUES(@v1,@v2,@v3,@v4,@v5,@v6,@v7,@v8)", mConnection))
{
foreach (var v in od.GetObjects())
{
cmd.Parameters.AddWithValue("", v);
}
count = cmd.ExecuteNonQuery();
}
}
catch { }
return(count);
}
/// <summary>
/// 获取库存信息
/// </summary>
internal NnStockInfo GetStockInfo(NnPolypeptide p)
{
NnStockInfo info = new NnStockInfo(p);
try
{
using (OleDbCommand cmd = new OleDbCommand("SELECT * FROM history,stock_new where history.orderId = stock_new.orderId AND history.sequence=@v1", mConnection))
{
cmd.Parameters.AddWithValue("v1", p.Sequence);
using (OleDbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
NnStock stock = new NnStock();
stock.InitStockByDb(reader);
info.Add(stock);// 这里只添加，由stockInfo判断是否有效，决定是否添加（所以这里添加了，不一定会真添加到库存信息中）
}
}
}
}
catch (Exception e) { Console.WriteLine(e.ToString()); }
return(info);
}
