public override void Load()
{
//将当天的数据写入到表格
using (DataTable dt = frmMain.mMain.AllDataBase.WriteData.Read(string.Format("select * from TestCount where TestYear={0:yyyy} and TestMonth={0:MM}", frmMain.mMain.AllDataXml.LocalSet.TodayStart)))
{
if (dt == null || dt.Rows.Count <= 0)
{
string title = "";
string data = "";
for (int i = 0; i < 31; i++)
{
title = string.Format("{0},Count{1},Time{1}", title, i + 1);
data = string.Format("{0},0,0", data);
}
frmMain.mMain.AllDataBase.WriteData.Write(string.Format("insert into TestCount (TestYear,TestMonth{0}) Values ({1:yyyy},{1:MM}{2})", title, frmMain.mMain.AllDataXml.LocalSet.TodayStart, data));
}
else
{
Count = All.Class.Num.ToInt(dt.Rows[0][string.Format("Count{0}", frmMain.mMain.AllDataXml.LocalSet.TodayStart.Day)]);
}
}
OEETimes = OEETime.GetAllOEETime();
OEEShow.Clear();
for (int i = 0; i < OEETimes.Count; i++)
{
OEEShow.Add(OEETimes[i].ToString());
}
CheckTime();
}
/// <summary>
/// 获取所有时间段
/// </summary>
/// <returns></returns>
public static List <OEETime> GetAllOEETime()
{
List <OEETime> result = new List <OEETime>();
OEETime tmp;
using (DataTable dt = frmMain.mMain.AllDataBase.ReadData.Read("select HourStart,MinStart,HourEnd,MinEnd,UseTime from SetTime order by HourStart,MinStart"))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmp = new OEETime();
tmp.HourStart = All.Class.Num.ToInt(dt.Rows[i]["HourStart"]);
tmp.MinStart = All.Class.Num.ToInt(dt.Rows[i]["MinStart"]);
tmp.HourEnd = All.Class.Num.ToInt(dt.Rows[i]["HourEnd"]);
tmp.MinEnd = All.Class.Num.ToInt(dt.Rows[i]["MinEnd"]);
tmp.UseTime = All.Class.Num.ToBool(dt.Rows[i]["UseTime"]);
result.Add(tmp);
}
}
}
return(result);
}
