/// <summary> /// 得到运行情况 /// </summary> /// <param name="youxi"></param> public List <YunXingQK> getYunXingQk() { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后显示在前台"); SqlHelp sqh = SqlHelp.GetInstance(); List <YunXingQK> rs = new List <YunXingQK>(); try { string selsql = "select top 10 a.* from yunxingqk a order by a.xh desc"; DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { YunXingQK jqqk = new YunXingQK(); jqqk.Xh = (int)dt.Rows[i][0]; Dictionary <string, JiQiYunXing> dict = new Dictionary <string, JiQiYunXing>(); JiQiYunXing jq1 = new JiQiYunXing(); jqqk.Zongxiugai = (int)dt.Rows[i][1]; jq1.Chuchan = (int)dt.Rows[i][2]; dict.Add("hao1", jq1); JiQiYunXing jq2 = new JiQiYunXing(); jq2.Xiugai = (int)dt.Rows[i][3]; jq2.Chuchan = (int)dt.Rows[i][4]; dict.Add("hao2", jq2); JiQiYunXing jq3 = new JiQiYunXing(); jq3.Xiugai = (int)dt.Rows[i][5]; jq3.Chuchan = (int)dt.Rows[i][6]; dict.Add("hao3", jq3); JiQiYunXing zk = new JiQiYunXing(); zk.Xiugai = (int)dt.Rows[i][7]; zk.Chuchan = (int)dt.Rows[i][8]; dict.Add("zk", zk); jqqk.Jqyx = dict; jqqk.Xgsj = (DateTime)dt.Rows[i][13]; rs.Add(jqqk); } } } catch (Exception ex) { WriteLog.WriteLogFile("", "得到运行情况失败"); throw ex; } return(rs); }
/// <summary> /// 更新运行情况表 /// </summary> /// <param name="youxi"></param> public void gxYunXingQk() { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后存入表"); SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { YunXingQK jqqk = new YunXingQK(); string selsql = "select " + "sum(case when z.pcname='1hao' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao1chanshu," + "sum(case when z.pcname='2hao' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao2xiugai," + "sum(case when z.pcname='2hao' and z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao2chanshu," + "sum(case when z.pcname='3hao' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao3xiugai," + "sum(case when z.pcname='3hao' and z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao2chanshu," + "sum(case when z.pcname='wlzhongkong' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zkxiugai," + "sum(case when z.pcname='wlzhongkong' and z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zkchanshu," + "sum(case when z.zuanshi>0 then 1 else 0 end) zuanshidayu0," + "sum(case when z.zuanshi>1000 then 1 else 0 end) zuanshidayu1000," + "sum(case when z.zuanshi>3000 then 1 else 0 end) zuanshidayu3000," + "sum(case when z.qiangzhequan>0 then 1 else 0 end) qiangzhedayu0," + "sum(case when z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zxiugai" + " from zhanghao z where yxbz='Y' and yimai='N'"; DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; if (dt.Rows.Count > 0) { Dictionary <string, JiQiYunXing> dict = new Dictionary <string, JiQiYunXing>(); JiQiYunXing jq1 = new JiQiYunXing(); jq1.Chuchan = (int)dt.Rows[0][0]; dict.Add("hao1", jq1); JiQiYunXing jq2 = new JiQiYunXing(); jq2.Xiugai = (int)dt.Rows[0][1]; jq2.Chuchan = (int)dt.Rows[0][2]; dict.Add("hao2", jq2); JiQiYunXing jq3 = new JiQiYunXing(); jq3.Xiugai = (int)dt.Rows[0][3]; jq3.Chuchan = (int)dt.Rows[0][4]; dict.Add("hao3", jq3); JiQiYunXing zk = new JiQiYunXing(); zk.Xiugai = (int)dt.Rows[0][5]; zk.Chuchan = (int)dt.Rows[0][6]; dict.Add("zk", zk); jqqk.Jqyx = dict; jqqk.Zuanshidayu0 = (int)dt.Rows[0][7]; jqqk.Zuanshidayu1000 = (int)dt.Rows[0][8]; jqqk.Zuanshidayu3000 = (int)dt.Rows[0][9]; jqqk.Qiangzhedayu0 = (int)dt.Rows[0][10]; jqqk.Xgsj = DateTime.Now; jqqk.Zongxiugai = (int)dt.Rows[0][11]; WriteLog.WriteLogFile("", "当前运行机器的出产情况" + jqqk.Zongxiugai + "单独:" + jqqk.Jqyx["hao1"].Chuchan + " " + jqqk.Jqyx["hao2"].Chuchan + " " + jqqk.Jqyx["hao3"].Chuchan + " " + jqqk.Jqyx["zk"].Chuchan); } string inssql = "insert into yunxingqk (hao1chanchu,hao2xiugai,hao2chanchu,hao3xiugai,hao3chanchu,zkxiugai,zkchanchu,zuanshidayu0,zuanshidayu1000,zuanshidayu3000,qiangzhedayu0,gxsj,zxiugai) values(" + jqqk.Jqyx["hao1"].Chuchan + "," + jqqk.Jqyx["hao2"].Xiugai + "," + jqqk.Jqyx["hao2"].Chuchan + "," + jqqk.Jqyx["hao3"].Xiugai + "," + jqqk.Jqyx["hao3"].Chuchan + "," + jqqk.Jqyx["zk"].Xiugai + "," + jqqk.Jqyx["zk"].Chuchan + "," + jqqk.Zuanshidayu0 + "," + jqqk.Zuanshidayu1000 + "," + jqqk.Zuanshidayu3000 + "," + jqqk.Qiangzhedayu0 + ",'" + jqqk.Xgsj + "'," + jqqk.Zongxiugai + ")"; sqh.update(inssql); } catch (Exception ex) { WriteLog.WriteLogFile("", "更新运行情况失败"); throw ex; } } }