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); }