static void CheckInOrOut(object arg) { Index win = arg as Index; while (true) { try { DasherStation.storage.StockStatLogic oStockModel = new DasherStation.storage.StockStatLogic(); DataTable dttIn = oStockModel.InStat(); DataTable dttOut = oStockModel.OutStat(); bool bAlertIn = (from DataRow row in dttIn.Rows where row["最低库存量"].ToString() != "" && Convert.ToDecimal(row["库存"].ToString()) < Convert.ToDecimal(row["最低库存量"].ToString()) select row[0]).Count() > 0; bool bAlertOut = (from DataRow row in dttOut.Rows where row["最低库存量"].ToString() != "" && Convert.ToDecimal(row["库存"].ToString()) < Convert.ToDecimal(row["最低库存量"].ToString()) select row[0]).Count() > 0; SetState(win, bAlertIn, bAlertOut); } catch (System.Exception ex) { new Logging().LogWrite(new LogEntry() { ID = (int)DateTime.Now.Minute, LogEx = ex, LogMessage = ex.Message }); } //配置文件中设置多少分钟检查一次. double minute = Convert.ToDouble(System.Configuration.ConfigurationManager.AppSettings["StockAlertReFresh"]); System.Threading.Thread.Sleep(TimeSpan.FromMinutes(minute)); } }
/* * 方法名称:SetPSockStat() * 方法功能描述:产品入库统计查询方法 * * 创建人:冯雪 * 创建时间:2009-03-16 * * 修改人: * 修改时间: * 修改内容: * */ private void SetPSockStat() { dgvStockStat.DataSource = stockStatLogic.OutStat(); dgvStockStat.Columns["id"].Visible = false; }