[MES]制造执行系统（四）

最新推荐文章于 2022-12-07 16:53:38 发布

Jasson

最新推荐文章于 2022-12-07 16:53:38 发布

阅读量714

点赞数

分类专栏： ZcoderLife 文章标签：制造 object null string memcached exception

本文链接：https://blog.csdn.net/jiali765/article/details/5902799

版权

ZcoderLife 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

這樣下去也不對啊，現場不能夠老是出問題啊，要不還怎麼運行啊！想辦法改了，試了之前的辦法都是行不通，这可叫我怎么办啊？不能老卡在这里，寻找资料，先确定应该是看板的程式要查询数据，消耗了很多资源，如果从它那里开始改善应该会是个很好的办法。那看板的程式又需要怎么改呢？想...想...想

有了，Memcached!它可是个好东西帮了我的大忙了。Memcached在我之前的博文中也有简单的介绍。大家可以查看。继续我们的思路。有了这点苗头，我就可以这样做了，在做一个C/S程式，用来从数据库收集数据，并存储在Memcached中，再在看板的web页面中读取Memcched数据。这样就断开了页面直接与数据库的直接交互。减低数据库服务器的负荷！这样不管开多少个看板也不会有影响了。

思路出来了，马上实施。编写代码，改写页面。

收集器代码：

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Threading; using System.Collections; using System.Collections.Specialized; using MemcachedProviders.Cache; namespace MemcachedMESKB { public partial class Form1 : Form { Thread thSapRead; string DateFrom, DateTo; string curShift = ""; #region Form Events public Form1() { InitializeComponent(); } private void Scheduler_Load(object sender, EventArgs e) { this.DateFrom = ""; this.DateTo = ""; this.SetTimer(); } #endregion #region Delegate private delegate void UpdateMessageDelegate(string msg); private delegate void UpdateLine1MessageDelegate(string msg); private delegate void UpdateLine2MessageDelegate(string msg); private delegate void UpdateLine3MessageDelegate(string msg); private delegate void UpdateLine4MessageDelegate(string msg); private delegate void UpdateLine5MessageDelegate(string msg); private delegate void UpdateLine6MessageDelegate(string msg); private delegate void UpdateLine7MessageDelegate(string msg); private delegate void UpdateLine8MessageDelegate(string msg); private delegate void UpdateSummaryMessageDelegate(string msg); private void UpdateMessage(string msg) { this.labelMessage.Text = msg; } private void UpdateLine1Message(string msg) { this.labelLine1Msg.Text = msg; } private void UpdateLine2Message(string msg) { this.labelLine2Msg.Text = msg; } private void UpdateLine3Message(string msg) { this.labelLine3Msg.Text = msg; } private void UpdateLine4Message(string msg) { this.labelLine4Msg.Text = msg; } private void UpdateLine5Message(string msg) { this.labelLine5Msg.Text = msg; } private void UpdateLine6Message(string msg) { this.labelLine6Msg.Text = msg; } private void UpdateLine7Message(string msg) { this.labelLine7Msg.Text = msg; } private void UpdateLine8Message(string msg) { this.labelLine8Msg.Text = msg; } private void UpdateSummaryMessage(string msg) { this.labelSummaryMsg.Text = msg; } #endregion #region Ticker Events private void timerSchedule_Tick(object sender, EventArgs e) { bool CanWork = false; ThreadStart threadDelegate = new ThreadStart(this.ScheduleProcess); if (this.thSapRead == null) { CanWork = true; } else { if (this.thSapRead.ThreadState == ThreadState.Running) { this.labelMessage.Text = "目前已有程序執行中，請稍後執行！"; CanWork = false; } else { CanWork = true; } } if (CanWork) { this.labelMessage.Text = "資料讀取中...請稍候"; this.thSapRead = new Thread(threadDelegate); this.thSapRead.Start(); this.labelLastTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); this.SetTimer(); this.labelShift.Text = this.curShift; } } private void SetTimer() { this.timerSchedule.Stop(); int Interval = 0; int Unit = 0; if (this.comboBoxUnit.Text == "秒") { Unit = 1000; } else if (this.comboBoxUnit.Text == "分") { Unit = 1000 * 60; } else { Unit = 0; } Interval = Convert.ToInt32(this.textBoxPeriod.Text) * Unit; this.timerSchedule.Interval = Interval; this.labelScheduleTime.Text = DateTime.Now.AddMilliseconds(Interval).ToString("yyyy-MM-dd HH:mm:ss"); this.timerSchedule.Start(); } #endregion #region Button Events private void buttonSchedule_Click(object sender, EventArgs e) { this.SetTimer(); } #endregion #region Update Process private void ScheduleProcess() { this.Invoke(new UpdateMessageDelegate(this.UpdateMessage), new object[] { "排程啟動！" }); if (this.checkBoxLine1.Checked) { this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine1Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("1"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine1Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("1"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine1Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("1"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine1Message), new object[] { "更新完成！" }); } if (this.checkBoxLine2.Checked) { this.Invoke(new UpdateLine2MessageDelegate(this.UpdateLine2Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("2"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine2Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("2"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine2Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("2"); this.Invoke(new UpdateLine2MessageDelegate(this.UpdateLine2Message), new object[] { "更新完成！" }); } if (this.checkBoxLine3.Checked) { this.Invoke(new UpdateLine3MessageDelegate(this.UpdateLine3Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("3"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine3Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("3"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine3Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("3"); this.Invoke(new UpdateLine3MessageDelegate(this.UpdateLine3Message), new object[] { "更新完成！" }); } if (this.checkBoxLine4.Checked) { this.Invoke(new UpdateLine4MessageDelegate(this.UpdateLine4Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("4"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine4Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("4"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine4Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("4"); this.Invoke(new UpdateLine4MessageDelegate(this.UpdateLine4Message), new object[] { "更新完成！" }); } if (this.checkBoxLine5.Checked) { this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine5Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("5"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine5Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("5"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine5Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("5"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine5Message), new object[] { "更新完成！" }); } if (this.checkBoxLine6.Checked) { this.Invoke(new UpdateLine2MessageDelegate(this.UpdateLine6Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("6"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine6Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("6"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine6Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("6"); this.Invoke(new UpdateLine2MessageDelegate(this.UpdateLine6Message), new object[] { "更新完成！" }); } if (this.checkBoxLine7.Checked) { this.Invoke(new UpdateLine3MessageDelegate(this.UpdateLine7Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("7"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine7Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("7"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine7Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("7"); this.Invoke(new UpdateLine3MessageDelegate(this.UpdateLine7Message), new object[] { "更新完成！" }); } if (this.checkBoxLine8.Checked) { this.Invoke(new UpdateLine4MessageDelegate(this.UpdateLine8Message), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("8"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine8Message), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("8"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateLine8Message), new object[] { "更新 TOP 5 不良項目..." }); this.BindNGList("8"); this.Invoke(new UpdateLine4MessageDelegate(this.UpdateLine8Message), new object[] { "更新完成！" }); } if (this.checkBoxSummary.Checked) { this.Invoke(new UpdateSummaryMessageDelegate(this.UpdateSummaryMessage), new object[] { "更新班別資料及前班產量..." }); this.CheckShift("0"); this.Invoke(new UpdateLine1MessageDelegate(this.UpdateSummaryMessage), new object[] { "更新各機台投入量及良品..." }); this.BindCarverQty("0"); //this.Invoke(new UpdateLine1MessageDelegate(this.UpdateSummaryMessage), new object[] { "更新 TOP 5 不良項目..." }); //this.BindNGList("0"); this.Invoke(new UpdateSummaryMessageDelegate(this.UpdateSummaryMessage), new object[] { "更新完成！" }); } this.Invoke(new UpdateMessageDelegate(this.UpdateMessage), new object[] { "更新日產量..." }); //this.BindDayQty(); this.Invoke(new UpdateMessageDelegate(this.UpdateMessage), new object[] { "排程結束！" }); } #endregion private void CheckShift(string LineNo) { DateTime curTime = DateTime.Now; string preDateFrom, preDateTo; if (curTime > DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 08:00:00")) && curTime <= DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:00:00"))) { if (this.curShift != "白") { preDateFrom = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00:00"); preDateTo = DateTime.Now.ToString("yyyy-MM-dd 08:00:00"); this.BindPreShiftQty(preDateFrom, preDateTo); this.curShift = "白"; } this.DateFrom = DateTime.Now.ToString("yyyy-MM-dd 08:00:00"); this.DateTo = DateTime.Now.ToString("yyyy-MM-dd 20:00:00"); } else { if (curTime < DateTime.Parse(curTime.ToString("yyyy-MM-dd 08:00:00"))) { this.DateFrom = curTime.AddDays(-1).ToString("yyyy-MM-dd 20:00:00"); this.DateTo = curTime.ToString("yyyy-MM-dd 08:00:00"); preDateFrom = curTime.AddDays(-1).ToString("yyyy-MM-dd 08:00:00"); preDateTo = curTime.AddDays(-1).ToString("yyyy-MM-dd 20:00:00"); } else { this.DateFrom = curTime.ToString("yyyy-MM-dd 20:00:00"); this.DateTo = curTime.AddDays(1).ToString("yyyy-MM-dd 08:00:00"); preDateFrom = curTime.ToString("yyyy-MM-dd 08:00:00"); preDateTo = curTime.ToString("yyyy-MM-dd 20:00:00"); } if (this.curShift != "晚") { this.BindPreShiftQty(preDateFrom, preDateTo); this.curShift = "晚"; } } } private void BindPreShiftQty(string preDateFrom, string preDateTo) { try { System.Text.StringBuilder sbSqlCommand = new System.Text.StringBuilder(512); System.Data.DataTable dt; sbSqlCommand.Append("SELECT qdn.inspstationid,SUBSTRING(qn.carverid,1,1)carverid, SUM(Convert(tinyint,qdn.ok))gdQty "); sbSqlCommand.Append("FROM QCAVN qn INNER JOIN QCAVDN qdn "); sbSqlCommand.Append("ON qn.workid=qdn.workid AND qn.jobid=qdn.jobid AND qn.lotno=qdn.lotno AND qn.seq=qdn.seq AND qn.cavityseq=qdn.cavityseq "); sbSqlCommand.Append("where "); sbSqlCommand.Append("qdn.reportdate BETWEEN '" + preDateFrom + "' AND '" + preDateTo + "' "); sbSqlCommand.Append("group by qdn.inspstationid,SUBSTRING(qn.carverid,1,1)"); dt = DBUtility.GetDataTableBySql(sbSqlCommand.ToString()); if (dt.Rows.Count > 0) { for (int cnt = 0; cnt < dt.Rows.Count; cnt++) { if (dt.Rows[cnt]["carverid"].ToString() == "1") { //this.labelLine1PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB11-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB01-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "2") { //this.labelLine2PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB12-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB02-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "3") { //this.labelLine3PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB13-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB03-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "4") { //this.labelLine4PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB14-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB04-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "5") { //this.labelLine5PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB15-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB05-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "6") { //this.labelLine6PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB16-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB06-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "7") { //this.labelLine7PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB17-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB07-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } else if (dt.Rows[cnt]["carverid"].ToString() == "8") { //this.labelLine8PreMsg.Text = dt.Rows[cnt]["gdQty"].ToString(); if (dt.Rows[cnt]["inspstationid"].ToString() == "1") DistCache.Add("KB18-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); else if (dt.Rows[cnt]["inspstationid"].ToString() == "2") DistCache.Add("KB08-PreShiftQty", string.IsNullOrEmpty(dt.Rows[cnt]["gdQty"].ToString()) ? "0" : dt.Rows[cnt]["gdQty"].ToString(), 32400000); } } // labelLine00PreMsg.Text = dt.Compute("SUM(gdQty)", "").ToString(); DistCache.Add("KB00-PreShiftQty", dt.Compute("SUM(gdQty)", "inspstationid='1'").ToString(), 32400000); DistCache.Add("KB10-PreShiftQty", dt.Compute("SUM(gdQty)", "inspstationid='2'").ToString(), 32400000); } else { DistCache.Add("KB11-PreShiftQty", "0", 32400000); DistCache.Add("KB12-PreShiftQty", "0", 32400000); DistCache.Add("KB13-PreShiftQty", "0", 32400000); DistCache.Add("KB14-PreShiftQty", "0", 32400000); DistCache.Add("KB15-PreShiftQty", "0", 32400000); DistCache.Add("KB16-PreShiftQty", "0", 32400000); DistCache.Add("KB17-PreShiftQty", "0", 32400000); DistCache.Add("KB18-PreShiftQty", "0", 32400000); DistCache.Add("KB10-PreShiftQty", "0", 32400000); DistCache.Add("KB00-PreShiftQty", "0", 32400000); } } catch (Exception ex) { LogUtility.GetInstance().HandleExceptionLog("KB-PreShiftQty：", ex); } } private void BindCarverQty(string LineNo) { try { System.Text.StringBuilder sbSqlCommand = new System.Text.StringBuilder(512); System.Data.DataTable dt, dtTemp; NameValueCollection nvcCarver = new NameValueCollection(); System.Data.DataView dv; System.Data.DataRow _row; int ShiftQty = 0; sbSqlCommand.Append("SELECT qdn.inspstationid,"); if (LineNo == "0") { sbSqlCommand.Append("SUBSTRING(qn.carverid,1,1) carverid,"); } else { sbSqlCommand.Append("qn.carverid,"); } sbSqlCommand.Append("SUM(Convert(tinyint,qdn.ok))gdqty,"); sbSqlCommand.Append("COUNT(*)manqty "); if (LineNo != "0")//包裝站不用計算百分比 { sbSqlCommand.Append(",CAST(SUM(Convert(tinyint,qdn.ok))*100.0/COUNT(*) as numeric(18,2))pcent "); } sbSqlCommand.Append("FROM QCAVN qn "); sbSqlCommand.Append("INNER JOIN QCAVDN qdn ON qn.workid=qdn.workid AND qn.jobid=qdn.jobid AND qn.lotno=qdn.lotno AND qn.seq=qdn.seq AND qn.cavityseq=qdn.cavityseq "); sbSqlCommand.Append("WHERE "); sbSqlCommand.Append("qdn.reportdate BETWEEN '" + this.DateFrom + "' AND '" + this.DateTo + "' "); if (LineNo == "0") { sbSqlCommand.Append("AND qdn.inspstationid='2' "); } else { sbSqlCommand.Append("AND qdn.inspstationid='1' "); sbSqlCommand.Append("AND qn.carverid LIKE '" + LineNo + "-%' "); } sbSqlCommand.Append("AND qdn.isreport=1 "); sbSqlCommand.Append("GROUP BY qdn.inspstationid, "); if (LineNo == "0") { sbSqlCommand.Append("SUBSTRING(qn.carverid,1,1) "); } else { sbSqlCommand.Append("qn.carverid "); } dt = DBUtility.GetDataTableBySql(sbSqlCommand.ToString()); dv = dt.DefaultView; if (dt.Rows.Count > 0) { if (LineNo == "0") { dv.RowFilter = "carverid='1'"; } else { dv.RowFilter = "carverid='" + LineNo + "-1'"; } dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty11", _row["manqty"].ToString()); nvcCarver.Add("GdQty11", _row["gdqty"].ToString()); if (LineNo != "0") { nvcCarver.Add("PCent11", _row["pcent"].ToString() + "%"); } ShiftQty += Convert.ToInt32(_row["gdqty"]); } if (LineNo == "0") { dv.RowFilter = "carverid='2'"; } else { dv.RowFilter = "carverid='" + LineNo + "-2'"; } dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty12", _row["manqty"].ToString()); nvcCarver.Add("GdQty12", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); if (LineNo != "0") { nvcCarver.Add("PCent12", _row["pcent"].ToString() + "%"); } } if (LineNo == "0") { dv.RowFilter = "carverid='3'"; } else { dv.RowFilter = "carverid='" + LineNo + "-3'"; } dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty13", _row["manqty"].ToString()); nvcCarver.Add("GdQty13", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); if (LineNo != "0") { nvcCarver.Add("PCent13", _row["pcent"].ToString() + "%"); } } if (LineNo == "0") { dv.RowFilter = "carverid='4'"; } else { dv.RowFilter = "carverid='" + LineNo + "-4'"; } dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty14", _row["manqty"].ToString()); nvcCarver.Add("GdQty14", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); if (LineNo != "0") { nvcCarver.Add("PCent14", _row["pcent"].ToString() + "%"); } } if (LineNo == "4" || LineNo == "8")//4線 8線多了兩臺熱壓機 { dv.RowFilter = "carverid='" + LineNo + "-5'"; dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty15", _row["manqty"].ToString()); nvcCarver.Add("GdQty15", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); nvcCarver.Add("PCent15", _row["pcent"].ToString() + "%"); } dv.RowFilter = "carverid='" + LineNo + "-6'"; dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty16", _row["manqty"].ToString()); nvcCarver.Add("GdQty16", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); nvcCarver.Add("PCent16", _row["pcent"].ToString() + "%"); } } if (LineNo == "0")//包裝站多出的5，6，7，8線 { dv.RowFilter = "carverid='5'"; dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty15", _row["manqty"].ToString()); nvcCarver.Add("GdQty15", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); } dv.RowFilter = "carverid='6'"; dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty16", _row["manqty"].ToString()); nvcCarver.Add("GdQty16", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); } dv.RowFilter = "carverid='7'"; dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty17", _row["manqty"].ToString()); nvcCarver.Add("GdQty17", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); } dv.RowFilter = "carverid='8'"; dtTemp = dv.ToTable(); for (int cnt = 0; cnt < dtTemp.Rows.Count; cnt++) { _row = dtTemp.Rows[cnt]; nvcCarver.Add("ManQty18", _row["manqty"].ToString()); nvcCarver.Add("GdQty18", _row["gdqty"].ToString()); ShiftQty += Convert.ToInt32(_row["gdqty"]); } } nvcCarver.Add("ShiftQty", ShiftQty.ToString()); } else { nvcCarver.Add("ManQty11", "0"); nvcCarver.Add("ManQty12", "0"); nvcCarver.Add("ManQty13", "0"); nvcCarver.Add("ManQty14", "0"); nvcCarver.Add("ManQty15", "0"); nvcCarver.Add("ManQty16", "0"); nvcCarver.Add("ManQty17", "0"); nvcCarver.Add("ManQty18", "0"); nvcCarver.Add("GdQty11", "0"); nvcCarver.Add("GdQty12", "0"); nvcCarver.Add("GdQty13", "0"); nvcCarver.Add("GdQty14", "0"); nvcCarver.Add("GdQty15", "0"); nvcCarver.Add("GdQty16", "0"); nvcCarver.Add("GdQty17", "0"); nvcCarver.Add("GdQty18", "0"); nvcCarver.Add("PCent11", "0%"); nvcCarver.Add("PCent12", "0%"); nvcCarver.Add("PCent13", "0%"); nvcCarver.Add("PCent14", "0%"); nvcCarver.Add("PCent15", "0%"); nvcCarver.Add("PCent16", "0%"); nvcCarver.Add("ShiftQty", "0"); } DistCache.Add("KB1" + LineNo + "-CarverQty", nvcCarver, 32400000); } catch (Exception ex) { DistCache.Remove("KB1" + LineNo + "-CarverQty"); LogUtility.GetInstance().HandleExceptionLog("KB1" + LineNo + "-CarverQty：", ex); } } private void BindNGList(string LineNo) { try { if (LineNo == "0") { return; //包裝站不需要不良項目 } System.Text.StringBuilder sbSqlCommand = new System.Text.StringBuilder(512); System.Text.StringBuilder sbColName = new System.Text.StringBuilder(64); System.Data.DataTable dt, dtInspItem; NameValueCollection nvcNG = new NameValueCollection(); sbSqlCommand.Append("SELECT SUM(CONVERT(tinyint,inspitem01)) II01, SUM(CONVERT(tinyint,inspitem02)) II02, SUM(CONVERT(tinyint,inspitem03)) II03,"); sbSqlCommand.Append("SUM(CONVERT(tinyint,inspitem04)) II04, SUM(CONVERT(tinyint,inspitem05)) II05, SUM(CONVERT(tinyint,inspitem06)) II06,"); sbSqlCommand.Append("SUM(CONVERT(tinyint,inspitem07)) II07, SUM(CONVERT(tinyint,inspitem08)) II08, SUM(CONVERT(tinyint,inspitem09)) II09,"); sbSqlCommand.Append("SUM(CONVERT(tinyint,inspitem10)) II10, SUM(CONVERT(tinyint,inspitem11)) II11, SUM(CONVERT(tinyint,inspitem12)) II12,"); sbSqlCommand.Append("SUM(CONVERT(tinyint,inspitem13)) II13, SUM(CONVERT(tinyint,inspitem14)) II14, SUM(CONVERT(tinyint,inspitem15)) II15,"); sbSqlCommand.Append("SUM(CONVERT(tinyint,inspitem16)) II16, SUM(CONVERT(tinyint,inspitem17)) II17, SUM(CONVERT(tinyint,inspitem18)) II18,"); sbSqlCommand.Append("SUM(CONVERT(tinyint,inspitem19)) II19, SUM(CONVERT(tinyint,inspitem20)) II20 "); sbSqlCommand.Append("FROM QCAVN qn "); sbSqlCommand.Append("INNER JOIN QCAVDN qdn ON qn.workid=qdn.workid AND qn.jobid=qdn.jobid AND qn.lotno=qdn.lotno AND qn.seq=qdn.seq AND qn.cavityseq=qdn.cavityseq "); sbSqlCommand.Append("WHERE "); sbSqlCommand.Append(" qn.carverid LIKE '" + LineNo + "-%' "); sbSqlCommand.Append("AND qdn.inspstationid='1' "); sbSqlCommand.Append("AND qdn.reportdate BETWEEN '" + this.DateFrom + "' AND '" + this.DateTo + "' "); dt = DBUtility.GetDataTableBySql(sbSqlCommand.ToString()); if (DistCache.Get("CNKBInspItem") == null) { dtInspItem = dtInspItem = DBUtility.GetDataTableBySql("SELECT InspItem, ColName FROM InspItem WHERE workid='2011' AND materialno='16EN00070FC00' AND inspstationid='1' ORDER BY colname "); DistCache.Add("CNKBInspItem", dtInspItem); } else { dtInspItem = (System.Data.DataTable)DistCache.Get("CNKBInspItem"); } if (dt.Rows.Count > 0) { object[] ar = dt.Rows[0].ItemArray; System.Data.DataRow[] dr; string colName = ""; int idx = -1; Array.Sort(ar, 0, 20); if (ar[19].ToString() != "" && ar[19].ToString() != "0") { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[19]); colName = "InspItem" + (idx + 1).ToString("00"); dr = dtInspItem.Select("colname='" + colName + "'"); if (dr.Length > 0) { nvcNG.Add("NG1Text", dr[0]["InspItem"].ToString()); nvcNG.Add("NG1Qty", ar[19].ToString()); } sbColName.Append("SUM(CONVERT(tinyint," + colName + ")) " + colName); sbColName.Append(","); } else { nvcNG.Add("NG1Text", ""); nvcNG.Add("NG1Qty", ""); sbColName.Append("0 " + colName); sbColName.Append(","); } if (ar[18].ToString() != "" && ar[18].ToString() != "0") { if (string.Equals(ar[19], ar[18])) { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[18], idx + 1); } else { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[18]); } colName = "InspItem" + (idx + 1).ToString("00"); dr = dtInspItem.Select("colname='" + colName + "'"); if (dr.Length > 0) { nvcNG.Add("NG2Text", dr[0]["InspItem"].ToString()); nvcNG.Add("NG2Qty", ar[18].ToString()); } sbColName.Append("SUM(CONVERT(tinyint," + colName + ")) " + colName); sbColName.Append(","); } else { nvcNG.Add("NG2Text", ""); nvcNG.Add("NG2Qty", ""); sbColName.Append("0 " + colName); sbColName.Append(","); } if (ar[17].ToString() != "" && ar[17].ToString() != "0") { if (string.Equals(ar[18], ar[17])) { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[17], idx + 1); } else { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[17]); } colName = "InspItem" + (idx + 1).ToString("00"); dr = dtInspItem.Select("colname='" + colName + "'"); if (dr.Length > 0) { nvcNG.Add("NG3Text", dr[0]["InspItem"].ToString()); nvcNG.Add("NG3Qty", ar[17].ToString()); } sbColName.Append("SUM(CONVERT(tinyint," + colName + ")) " + colName); sbColName.Append(","); } else { nvcNG.Add("NG3Text", ""); nvcNG.Add("NG3Qty", ""); sbColName.Append("0 " + colName); sbColName.Append(","); } if (ar[16].ToString() != "" && ar[16].ToString() != "0") { if (string.Equals(ar[17], ar[16])) { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[16], idx + 1); } else { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[16]); } colName = "InspItem" + (idx + 1).ToString("00"); dr = dtInspItem.Select("colname='" + colName + "'"); if (dr.Length > 0) { nvcNG.Add("NG4Text", dr[0]["InspItem"].ToString()); nvcNG.Add("NG4Qty", ar[16].ToString()); } sbColName.Append("SUM(CONVERT(tinyint," + colName + ")) " + colName); sbColName.Append(","); } else { nvcNG.Add("NG4Text", ""); nvcNG.Add("NG4Qty", ""); sbColName.Append("0 " + colName); sbColName.Append(","); } if (ar[15].ToString() != "" && ar[15].ToString() != "0") { if (string.Equals(ar[16], ar[15])) { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[15], idx + 1); } else { idx = Array.IndexOf(dt.Rows[0].ItemArray, ar[15]); } colName = "InspItem" + (idx + 1).ToString("00"); dr = dtInspItem.Select("colname='" + colName + "'"); if (dr.Length > 0) { nvcNG.Add("NG5Text", dr[0]["InspItem"].ToString()); nvcNG.Add("NG5Qty", ar[15].ToString()); } sbColName.Append("SUM(CONVERT(tinyint," + colName + ")) " + colName); sbColName.Append(","); } else { nvcNG.Add("NG5Text", ""); nvcNG.Add("NG5Qty", ""); sbColName.Append("0 " + colName); sbColName.Append(","); } if (sbColName.Length > 0) { sbColName.Remove(sbColName.Length - 1, 1); System.Data.DataTable dtTemp; System.Data.DataView dv; sbSqlCommand.Length = 0; if (LineNo == "0") { sbSqlCommand.Append("SELECT SUBSTRING(carverid,1,1) carverid,"); } else { sbSqlCommand.Append("SELECT carverid,"); } sbSqlCommand.Append(sbColName.ToString() + " "); sbSqlCommand.Append("FROM QCAVN qn "); sbSqlCommand.Append("INNER JOIN QCAVDN qdn ON qn.workid=qdn.workid AND qn.jobid=qdn.jobid AND qn.lotno=qdn.lotno AND qn.seq=qdn.seq AND qn.cavityseq=qdn.cavityseq "); sbSqlCommand.Append("WHERE "); sbSqlCommand.Append(" qdn.inspstationid='1' "); if (LineNo != "0") { sbSqlCommand.Append("AND qn.carverid LIKE '" + LineNo + "-%' "); } sbSqlCommand.Append("AND qdn.reportdate BETWEEN '" + this.DateFrom + "' AND '" + this.DateTo + "' "); sbSqlCommand.Append("GROUP BY "); if (LineNo == "0") { sbSqlCommand.Append("SUBSTRING(qn.carverid,1,1)"); } else { sbSqlCommand.Append("qn.carverid"); } dt = DBUtility.GetDataTableBySql(sbSqlCommand.ToString()); dv = dt.DefaultView; if (LineNo == "0") { dv.RowFilter = "carverid='1'"; } else { dv.RowFilter = "carverid='" + LineNo + "-1'"; } dtTemp = dv.ToTable(); if (dtTemp.Rows.Count > 0) { nvcNG.Add("NG11Qty", dtTemp.Rows[0][1].ToString() == "0" ? "" : dtTemp.Rows[0][1].ToString()); nvcNG.Add("NG12Qty", dtTemp.Rows[0][2].ToString() == "0" ? "" : dtTemp.Rows[0][2].ToString()); nvcNG.Add("NG13Qty", dtTemp.Rows[0][3].ToString() == "0" ? "" : dtTemp.Rows[0][3].ToString()); nvcNG.Add("NG14Qty", dtTemp.Rows[0][4].ToString() == "0" ? "" : dtTemp.Rows[0][4].ToString()); nvcNG.Add("NG15Qty", dtTemp.Rows[0][5].ToString() == "0" ? "" : dtTemp.Rows[0][5].ToString()); } else { nvcNG.Add("NG11Qty", ""); nvcNG.Add("NG12Qty", ""); nvcNG.Add("NG13Qty", ""); nvcNG.Add("NG14Qty", ""); nvcNG.Add("NG15Qty", ""); } if (LineNo == "0") { dv.RowFilter = "carverid='2'"; } else { dv.RowFilter = "carverid='" + LineNo + "-2'"; } dtTemp = dv.ToTable(); if (dtTemp.Rows.Count > 0) { nvcNG.Add("NG21Qty", dtTemp.Rows[0][1].ToString() == "0" ? "" : dtTemp.Rows[0][1].ToString()); nvcNG.Add("NG22Qty", dtTemp.Rows[0][2].ToString() == "0" ? "" : dtTemp.Rows[0][2].ToString()); nvcNG.Add("NG23Qty", dtTemp.Rows[0][3].ToString() == "0" ? "" : dtTemp.Rows[0][3].ToString()); nvcNG.Add("NG24Qty", dtTemp.Rows[0][4].ToString() == "0" ? "" : dtTemp.Rows[0][4].ToString()); nvcNG.Add("NG25Qty", dtTemp.Rows[0][5].ToString() == "0" ? "" : dtTemp.Rows[0][5].ToString()); } else { nvcNG.Add("NG21Qty", ""); nvcNG.Add("NG22Qty", ""); nvcNG.Add("NG23Qty", ""); nvcNG.Add("NG24Qty", ""); nvcNG.Add("NG25Qty", ""); } if (LineNo == "0") { dv.RowFilter = "carverid='3'"; } else { dv.RowFilter = "carverid='" + LineNo + "-3'"; } dtTemp = dv.ToTable(); if (dtTemp.Rows.Count > 0) { nvcNG.Add("NG31Qty", dtTemp.Rows[0][1].ToString() == "0" ? "" : dtTemp.Rows[0][1].ToString()); nvcNG.Add("NG32Qty", dtTemp.Rows[0][2].ToString() == "0" ? "" : dtTemp.Rows[0][2].ToString()); nvcNG.Add("NG33Qty", dtTemp.Rows[0][3].ToString() == "0" ? "" : dtTemp.Rows[0][3].ToString()); nvcNG.Add("NG34Qty", dtTemp.Rows[0][4].ToString() == "0" ? "" : dtTemp.Rows[0][4].ToString()); nvcNG.Add("NG35Qty", dtTemp.Rows[0][5].ToString() == "0" ? "" : dtTemp.Rows[0][5].ToString()); } else { nvcNG.Add("NG31Qty", ""); nvcNG.Add("NG32Qty", ""); nvcNG.Add("NG33Qty", ""); nvcNG.Add("NG34Qty", ""); nvcNG.Add("NG35Qty", ""); } if (LineNo == "0") { dv.RowFilter = "carverid='4'"; } else { dv.RowFilter = "carverid='" + LineNo + "-4'"; } dtTemp = dv.ToTable(); if (dtTemp.Rows.Count > 0) { nvcNG.Add("NG41Qty", dtTemp.Rows[0][1].ToString() == "0" ? "" : dtTemp.Rows[0][1].ToString()); nvcNG.Add("NG42Qty", dtTemp.Rows[0][2].ToString() == "0" ? "" : dtTemp.Rows[0][2].ToString()); nvcNG.Add("NG43Qty", dtTemp.Rows[0][3].ToString() == "0" ? "" : dtTemp.Rows[0][3].ToString()); nvcNG.Add("NG44Qty", dtTemp.Rows[0][4].ToString() == "0" ? "" : dtTemp.Rows[0][4].ToString()); nvcNG.Add("NG45Qty", dtTemp.Rows[0][5].ToString() == "0" ? "" : dtTemp.Rows[0][5].ToString()); } else { nvcNG.Add("NG41Qty", ""); nvcNG.Add("NG42Qty", ""); nvcNG.Add("NG43Qty", ""); nvcNG.Add("NG44Qty", ""); nvcNG.Add("NG45Qty", ""); } if (LineNo == "4" || LineNo == "8")//4線 8線多了兩臺熱壓機 { dv.RowFilter = "carverid='" + LineNo + "-5'"; dtTemp = dv.ToTable(); if (dtTemp.Rows.Count > 0) { nvcNG.Add("NG51Qty", dtTemp.Rows[0][1].ToString() == "0" ? "" : dtTemp.Rows[0][1].ToString()); nvcNG.Add("NG52Qty", dtTemp.Rows[0][2].ToString() == "0" ? "" : dtTemp.Rows[0][2].ToString()); nvcNG.Add("NG53Qty", dtTemp.Rows[0][3].ToString() == "0" ? "" : dtTemp.Rows[0][3].ToString()); nvcNG.Add("NG54Qty", dtTemp.Rows[0][4].ToString() == "0" ? "" : dtTemp.Rows[0][4].ToString()); nvcNG.Add("NG55Qty", dtTemp.Rows[0][5].ToString() == "0" ? "" : dtTemp.Rows[0][5].ToString()); } else { nvcNG.Add("NG51Qty", ""); nvcNG.Add("NG52Qty", ""); nvcNG.Add("NG53Qty", ""); nvcNG.Add("NG54Qty", ""); nvcNG.Add("NG55Qty", ""); } dv.RowFilter = "carverid='" + LineNo + "-6'"; dtTemp = dv.ToTable(); if (dtTemp.Rows.Count > 0) { nvcNG.Add("NG61Qty", dtTemp.Rows[0][1].ToString() == "0" ? "" : dtTemp.Rows[0][1].ToString()); nvcNG.Add("NG62Qty", dtTemp.Rows[0][2].ToString() == "0" ? "" : dtTemp.Rows[0][2].ToString()); nvcNG.Add("NG63Qty", dtTemp.Rows[0][3].ToString() == "0" ? "" : dtTemp.Rows[0][3].ToString()); nvcNG.Add("NG64Qty", dtTemp.Rows[0][4].ToString() == "0" ? "" : dtTemp.Rows[0][4].ToString()); nvcNG.Add("NG65Qty", dtTemp.Rows[0][5].ToString() == "0" ? "" : dtTemp.Rows[0][5].ToString()); } else { nvcNG.Add("NG61Qty", ""); nvcNG.Add("NG62Qty", ""); nvcNG.Add("NG63Qty", ""); nvcNG.Add("NG64Qty", ""); nvcNG.Add("NG65Qty", ""); } } DistCache.Add("KB1" + LineNo + "-NGList", nvcNG, 32400000); } } } catch (Exception ex) { LogUtility.GetInstance().HandleExceptionLog("KB1" + LineNo + "-NGList：", ex); } } } }

页面代码（看板一线）：

using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Collections.Specialized; using AdGroup.CNKB.Utility; using MemcachedProviders.Cache; namespace AdGroup.CNKB.Form.KB { public partial class KB11 : System.Web.UI.Page { #region Page Events protected void Page_Load(object sender, EventArgs e) { this.CheckShift(); this.BindCarverQty(); this.BindNGList(); this.DrawingCurve(); } protected void Page_PreRender(object sender, EventArgs e) { this.LabelSysTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } #endregion private void CheckShift() { try { DateTime curTime = DateTime.Now; if (curTime > DateTime.Parse(curTime.ToString("yyyy-MM-dd 08:00:00")) && curTime <= DateTime.Parse(curTime.ToString("yyyy-MM-dd 20:00:00"))) //日班 { this.LabelWorkDay.Text = curTime.ToString("yyyy/MM/dd"); this.LabelShift.Text = "日"; if (DistCache.Get("checkshift11") == null) { DistCache.Add("checkshift11", "日"); this.RemoveTable(); this.CreatTable(); } else { if (DistCache.Get("checkshift11").ToString() != "日") { DistCache.Add("checkshift11", "日"); this.RemoveTable(); this.CreatTable(); } } } else { if (curTime <= DateTime.Parse(curTime.ToString("yyyy-MM-dd 08:00:00"))) //8點前表前一天的夜班 { this.LabelWorkDay.Text = curTime.AddDays(-1).ToString("yyyy/MM/dd"); } else { this.LabelWorkDay.Text = curTime.ToString("yyyy/MM/dd"); } if (DistCache.Get("checkshift11").ToString() != "晚") { DistCache.Add("checkshift11", "晚"); this.RemoveTable(); this.CreatTable(); } this.LabelShift.Text = "晚"; } if (DistCache.Get("KB11-PreShiftQty") != null) { this.LabelPreShiftTotal.Text = DistCache.Get("KB11-PreShiftQty").ToString(); } else { this.LabelPreShiftTotal.Text = ""; } } catch (Exception ex) { LogUtility.GetInstance().HandleExceptionLog("KB11-CheckShift：", ex); } } private void BindCarverQty() { try { NameValueCollection nvcCarver = new NameValueCollection(); if (DistCache.Get("KB11-CarverQty") != null) { nvcCarver = (NameValueCollection)DistCache.Get("KB11-CarverQty"); if (nvcCarver.Get("ManQty11") == null) { this.tdManQty311.InnerText = "0"; } else { this.tdManQty311.InnerText = string.IsNullOrEmpty(nvcCarver.Get("ManQty11").ToString()) ? "0" : nvcCarver.Get("ManQty11").ToString(); } if (nvcCarver.Get("ManQty12") == null) { this.tdManQty312.InnerText = "0"; } else { this.tdManQty312.InnerText = string.IsNullOrEmpty(nvcCarver.Get("ManQty12").ToString()) ? "0" : nvcCarver.Get("ManQty12").ToString(); } if (nvcCarver.Get("ManQty13") == null) { this.tdManQty313.InnerText = "0"; } else { this.tdManQty313.InnerText = string.IsNullOrEmpty(nvcCarver.Get("ManQty13").ToString()) ? "0" : nvcCarver.Get("ManQty13").ToString(); } if (nvcCarver.Get("ManQty14") == null) { this.tdManQty314.InnerText = "0"; } else { this.tdManQty314.InnerText = string.IsNullOrEmpty(nvcCarver.Get("ManQty14").ToString()) ? "0" : nvcCarver.Get("ManQty14").ToString(); } if (nvcCarver.Get("GdQty11") == null) { this.tdGdQty311.InnerText = "0"; } else { this.tdGdQty311.InnerText = string.IsNullOrEmpty(nvcCarver.Get("GdQty11").ToString()) ? "0" : nvcCarver.Get("GdQty11").ToString(); } if (nvcCarver.Get("GdQty12") == null) { this.tdGdQty312.InnerText = "0"; } else { this.tdGdQty312.InnerText = string.IsNullOrEmpty(nvcCarver.Get("GdQty12").ToString()) ? "0" : nvcCarver.Get("GdQty12").ToString(); } if (nvcCarver.Get("GdQty13") == null) { this.tdGdQty313.InnerText = "0"; } else { this.tdGdQty313.InnerText = string.IsNullOrEmpty(nvcCarver.Get("GdQty13").ToString()) ? "0" : nvcCarver.Get("GdQty13").ToString(); } if (nvcCarver.Get("GdQty14") == null) { this.tdGdQty314.InnerText = "0"; } else { this.tdGdQty314.InnerText = string.IsNullOrEmpty(nvcCarver.Get("GdQty14").ToString()) ? "0" : nvcCarver.Get("GdQty14").ToString(); } if (nvcCarver.Get("PCent11") == null) { this.tdPercent311.InnerText = "0%"; } else { this.tdPercent311.InnerText = string.IsNullOrEmpty(nvcCarver.Get("PCent11").ToString()) ? "0%" : nvcCarver.Get("PCent11").ToString(); } if (nvcCarver.Get("PCent12") == null) { this.tdPercent312.InnerText = "0%"; } else { this.tdPercent312.InnerText = string.IsNullOrEmpty(nvcCarver.Get("PCent12").ToString()) ? "0%" : nvcCarver.Get("PCent12").ToString(); } if (nvcCarver.Get("PCent13") == null) { this.tdPercent313.InnerText = "0%"; } else { this.tdPercent313.InnerText = string.IsNullOrEmpty(nvcCarver.Get("PCent13").ToString()) ? "0%" : nvcCarver.Get("PCent13").ToString(); } if (nvcCarver.Get("PCent14") == null) { this.tdPercent314.InnerText = "0%"; } else { this.tdPercent314.InnerText = string.IsNullOrEmpty(nvcCarver.Get("PCent14").ToString()) ? "0%" : nvcCarver.Get("PCent14").ToString(); } //this.LabelShiftTotal.Text = nvcCarver.Get("ShiftQty"); } else { this.tdManQty311.InnerText = "0"; this.tdManQty312.InnerText = "0"; this.tdManQty313.InnerText = "0"; this.tdManQty314.InnerText = "0"; this.tdGdQty311.InnerText = "0"; this.tdGdQty312.InnerText = "0"; this.tdGdQty313.InnerText = "0"; this.tdGdQty314.InnerText = "0"; this.tdPercent311.InnerText = "0%"; this.tdPercent312.InnerText = "0%"; this.tdPercent313.InnerText = "0%"; this.tdPercent314.InnerText = "0%"; //this.LabelShiftTotal.Text = ""; } int GdQty311 = this.tdGdQty311.InnerText.Trim() == "" ? 0 : Convert.ToInt32(this.tdGdQty311.InnerText.Trim()); int GdQty312 = this.tdGdQty312.InnerText.Trim() == "" ? 0 : Convert.ToInt32(this.tdGdQty312.InnerText.Trim()); int GdQty313 = this.tdGdQty313.InnerText.Trim() == "" ? 0 : Convert.ToInt32(this.tdGdQty313.InnerText.Trim()); int GdQty314 = this.tdGdQty314.InnerText.Trim() == "" ? 0 : Convert.ToInt32(this.tdGdQty314.InnerText.Trim()); this.LabelShiftTotal.Text = (GdQty311 + GdQty312 + GdQty313 + GdQty314).ToString(); } catch(Exception ex) { LogUtility.GetInstance().HandleExceptionLog("KB11-CarverQty：", ex); } } private void BindNGList() { try { if (DistCache.Get("KB11-NGList") != null) { int manQty, manQty1, manQty2, manQty3, manQty4 = 0; NameValueCollection nvcNG = new NameValueCollection(); nvcNG = (NameValueCollection)DistCache.Get("KB11-NGList"); if (nvcNG.Get("NG1Text") == null) { this.tdNg1.InnerText = ""; } else { this.tdNg1.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG1Text").ToString()) ? "0" : nvcNG.Get("NG1Text").ToString(); } if (nvcNG.Get("NG2Text") == null) { this.tdNg2.InnerText = ""; } else { this.tdNg2.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG2Text").ToString()) ? "0" : nvcNG.Get("NG2Text").ToString(); } if (nvcNG.Get("NG3Text") == null) { this.tdNg3.InnerText = ""; } else { this.tdNg3.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG3Text").ToString()) ? "0" : nvcNG.Get("NG3Text").ToString(); } if (nvcNG.Get("NG4Text") == null) { this.tdNg4.InnerText = ""; } else { this.tdNg4.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG4Text").ToString()) ? "0" : nvcNG.Get("NG4Text").ToString(); } if (nvcNG.Get("NG5Text") == null) { this.tdNg5.InnerText = ""; } else { this.tdNg5.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG5Text").ToString()) ? "0" : nvcNG.Get("NG5Text").ToString(); } if (nvcNG.Get("NG1Qty") == null) { this.tdNgQty1.InnerText = ""; } else { this.tdNgQty1.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG1Qty").ToString()) ? "0" : nvcNG.Get("NG1Qty").ToString(); } if (nvcNG.Get("NG2Qty") == null) { this.tdNgQty2.InnerText = ""; } else { this.tdNgQty2.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG2Qty").ToString()) ? "0" : nvcNG.Get("NG2Qty").ToString(); } if (nvcNG.Get("NG3Qty") == null) { this.tdNgQty3.InnerText = ""; } else { this.tdNgQty3.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG3Qty").ToString()) ? "0" : nvcNG.Get("NG3Qty").ToString(); } if (nvcNG.Get("NG4Qty") == null) { this.tdNgQty4.InnerText = ""; } else { this.tdNgQty4.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG4Qty").ToString()) ? "0" : nvcNG.Get("NG4Qty").ToString(); } if (nvcNG.Get("NG5Qty") == null) { this.tdNgQty5.InnerText = ""; } else { this.tdNgQty5.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG5Qty").ToString()) ? "0" : nvcNG.Get("NG5Qty").ToString(); } if (nvcNG.Get("NG11Qty") == null) { this.tdNgQty111.InnerText = ""; } else { this.tdNgQty111.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG11Qty").ToString()) ? "0" : nvcNG.Get("NG11Qty").ToString(); } if (nvcNG.Get("NG12Qty") == null) { this.tdNgQty211.InnerText = ""; } else { this.tdNgQty211.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG12Qty").ToString()) ? "0" : nvcNG.Get("NG12Qty").ToString(); } if (nvcNG.Get("NG13Qty") == null) { this.tdNgQty311.InnerText = ""; } else { this.tdNgQty311.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG13Qty").ToString()) ? "0" : nvcNG.Get("NG13Qty").ToString(); } if (nvcNG.Get("NG14Qty") == null) { this.tdNgQty411.InnerText = ""; } else { this.tdNgQty411.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG14Qty").ToString()) ? "0" : nvcNG.Get("NG14Qty").ToString(); } if (nvcNG.Get("NG15Qty") == null) { this.tdNgQty511.InnerText = ""; } else { this.tdNgQty511.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG15Qty").ToString()) ? "0" : nvcNG.Get("NG15Qty").ToString(); } if (nvcNG.Get("NG21Qty") == null) { this.tdNgQty112.InnerText = ""; } else { this.tdNgQty112.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG21Qty").ToString()) ? "0" : nvcNG.Get("NG21Qty").ToString(); } if (nvcNG.Get("NG22Qty") == null) { this.tdNgQty212.InnerText = ""; } else { this.tdNgQty212.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG22Qty").ToString()) ? "0" : nvcNG.Get("NG22Qty").ToString(); } if (nvcNG.Get("NG23Qty") == null) { this.tdNgQty312.InnerText = ""; } else { this.tdNgQty312.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG23Qty").ToString()) ? "0" : nvcNG.Get("NG23Qty").ToString(); } if (nvcNG.Get("NG24Qty") == null) { this.tdNgQty412.InnerText = ""; } else { this.tdNgQty412.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG24Qty").ToString()) ? "0" : nvcNG.Get("NG24Qty").ToString(); } if (nvcNG.Get("NG25Qty") == null) { this.tdNgQty512.InnerText = ""; } else { this.tdNgQty512.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG25Qty").ToString()) ? "0" : nvcNG.Get("NG25Qty").ToString(); } if (nvcNG.Get("NG31Qty") == null) { this.tdNgQty113.InnerText = ""; } else { this.tdNgQty113.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG31Qty").ToString()) ? "0" : nvcNG.Get("NG31Qty").ToString(); } if (nvcNG.Get("NG32Qty") == null) { this.tdNgQty213.InnerText = ""; } else { this.tdNgQty213.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG32Qty").ToString()) ? "0" : nvcNG.Get("NG32Qty").ToString(); } if (nvcNG.Get("NG33Qty") == null) { this.tdNgQty313.InnerText = ""; } else { this.tdNgQty313.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG33Qty").ToString()) ? "0" : nvcNG.Get("NG33Qty").ToString(); } if (nvcNG.Get("NG34Qty") == null) { this.tdNgQty413.InnerText = ""; } else { this.tdNgQty413.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG34Qty").ToString()) ? "0" : nvcNG.Get("NG34Qty").ToString(); } if (nvcNG.Get("NG35Qty") == null) { this.tdNgQty513.InnerText = ""; } else { this.tdNgQty513.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG35Qty").ToString()) ? "0" : nvcNG.Get("NG35Qty").ToString(); } if (nvcNG.Get("NG41Qty") == null) { this.tdNgQty114.InnerText = ""; } else { this.tdNgQty114.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG41Qty").ToString()) ? "0" : nvcNG.Get("NG41Qty").ToString(); } if (nvcNG.Get("NG42Qty") == null) { this.tdNgQty214.InnerText = ""; } else { this.tdNgQty214.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG42Qty").ToString()) ? "0" : nvcNG.Get("NG42Qty").ToString(); } if (nvcNG.Get("NG43Qty") == null) { this.tdNgQty314.InnerText = ""; } else { this.tdNgQty314.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG43Qty").ToString()) ? "0" : nvcNG.Get("NG43Qty").ToString(); } if (nvcNG.Get("NG44Qty") == null) { this.tdNgQty414.InnerText = ""; } else { this.tdNgQty414.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG44Qty").ToString()) ? "0" : nvcNG.Get("NG44Qty").ToString(); } if (nvcNG.Get("NG45Qty") == null) { this.tdNgQty514.InnerText = ""; } else { this.tdNgQty514.InnerText = string.IsNullOrEmpty(nvcNG.Get("NG45Qty").ToString()) ? "0" : nvcNG.Get("NG45Qty").ToString(); } if (int.TryParse(this.tdManQty311.InnerText, out manQty1)) { this.tdNgPercent111.InnerText = this.tdNgQty111.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty111.InnerText) * 100.0 / manQty1).ToString("0.0") + "%"; this.tdNgPercent211.InnerText = this.tdNgQty211.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty211.InnerText) * 100.0 / manQty1).ToString("0.0") + "%"; this.tdNgPercent311.InnerText = this.tdNgQty311.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty311.InnerText) * 100.0 / manQty1).ToString("0.0") + "%"; this.tdNgPercent411.InnerText = this.tdNgQty411.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty411.InnerText) * 100.0 / manQty1).ToString("0.0") + "%"; this.tdNgPercent511.InnerText = this.tdNgQty511.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty511.InnerText) * 100.0 / manQty1).ToString("0.0") + "%"; } else { this.tdNgPercent111.InnerText = "0%"; this.tdNgPercent211.InnerText = "0%"; this.tdNgPercent311.InnerText = "0%"; this.tdNgPercent411.InnerText = "0%"; this.tdNgPercent511.InnerText = "0%"; } if (int.TryParse(this.tdManQty312.InnerText, out manQty2)) { this.tdNgPercent112.InnerText = this.tdNgQty112.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty112.InnerText) * 100.0 / manQty2).ToString("0.0") + "%"; this.tdNgPercent212.InnerText = this.tdNgQty212.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty212.InnerText) * 100.0 / manQty2).ToString("0.0") + "%"; this.tdNgPercent312.InnerText = this.tdNgQty312.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty312.InnerText) * 100.0 / manQty2).ToString("0.0") + "%"; this.tdNgPercent412.InnerText = this.tdNgQty412.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty412.InnerText) * 100.0 / manQty2).ToString("0.0") + "%"; this.tdNgPercent512.InnerText = this.tdNgQty512.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty512.InnerText) * 100.0 / manQty2).ToString("0.0") + "%"; } else { this.tdNgPercent112.InnerText = "0%"; this.tdNgPercent212.InnerText = "0%"; this.tdNgPercent312.InnerText = "0%"; this.tdNgPercent412.InnerText = "0%"; this.tdNgPercent512.InnerText = "0%"; } if (int.TryParse(this.tdManQty313.InnerText, out manQty3)) { this.tdNgPercent113.InnerText = this.tdNgQty113.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty113.InnerText) * 100.0 / manQty3).ToString("0.0") + "%"; this.tdNgPercent213.InnerText = this.tdNgQty213.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty213.InnerText) * 100.0 / manQty3).ToString("0.0") + "%"; this.tdNgPercent313.InnerText = this.tdNgQty313.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty313.InnerText) * 100.0 / manQty3).ToString("0.0") + "%"; this.tdNgPercent413.InnerText = this.tdNgQty413.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty413.InnerText) * 100.0 / manQty3).ToString("0.0") + "%"; this.tdNgPercent513.InnerText = this.tdNgQty513.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty513.InnerText) * 100.0 / manQty3).ToString("0.0") + "%"; } else { this.tdNgPercent113.InnerText = "0%"; this.tdNgPercent213.InnerText = "0%"; this.tdNgPercent313.InnerText = "0%"; this.tdNgPercent413.InnerText = "0%"; this.tdNgPercent513.InnerText = "0%"; } if (int.TryParse(this.tdManQty314.InnerText, out manQty4)) { this.tdNgPercent114.InnerText = this.tdNgQty114.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty114.InnerText) * 100.0 / manQty4).ToString("0.0") + "%"; this.tdNgPercent214.InnerText = this.tdNgQty214.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty214.InnerText) * 100.0 / manQty4).ToString("0.0") + "%"; this.tdNgPercent314.InnerText = this.tdNgQty314.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty314.InnerText) * 100.0 / manQty4).ToString("0.0") + "%"; this.tdNgPercent414.InnerText = this.tdNgQty414.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty414.InnerText) * 100.0 / manQty4).ToString("0.0") + "%"; this.tdNgPercent514.InnerText = this.tdNgQty514.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty514.InnerText) * 100.0 / manQty4).ToString("0.0") + "%"; } else { this.tdNgPercent114.InnerText = "0%"; this.tdNgPercent214.InnerText = "0%"; this.tdNgPercent314.InnerText = "0%"; this.tdNgPercent414.InnerText = "0%"; this.tdNgPercent514.InnerText = "0%"; } manQty = manQty1 + manQty2 + manQty3 + manQty4; if (manQty > 0) { this.tdNgPercent1.InnerText = this.tdNgQty1.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty1.InnerText) * 100.0 / manQty).ToString("0.0") + "%"; this.tdNgPercent2.InnerText = this.tdNgQty2.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty2.InnerText) * 100.0 / manQty).ToString("0.0") + "%"; this.tdNgPercent3.InnerText = this.tdNgQty3.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty3.InnerText) * 100.0 / manQty).ToString("0.0") + "%"; this.tdNgPercent4.InnerText = this.tdNgQty4.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty4.InnerText) * 100.0 / manQty).ToString("0.0") + "%"; this.tdNgPercent5.InnerText = this.tdNgQty5.InnerText.Trim() == "0" ? "0%" : (Convert.ToInt32(this.tdNgQty5.InnerText) * 100.0 / manQty).ToString("0.0") + "%"; } else { this.tdNgPercent1.InnerText = "0%"; this.tdNgPercent2.InnerText = "0%"; this.tdNgPercent3.InnerText = "0%"; this.tdNgPercent4.InnerText = "0%"; this.tdNgPercent5.InnerText = "0%"; } } else { this.tdNg1.InnerText = "0"; this.tdNg2.InnerText = "0"; this.tdNg3.InnerText = "0"; this.tdNg4.InnerText = "0"; this.tdNg5.InnerText = "0"; this.tdNgQty1.InnerText = "0"; this.tdNgQty2.InnerText = "0"; this.tdNgQty3.InnerText = "0"; this.tdNgQty4.InnerText = "0"; this.tdNgQty5.InnerText = "0"; this.tdNgQty111.InnerText = "0"; this.tdNgQty211.InnerText = "0"; this.tdNgQty311.InnerText = "0"; this.tdNgQty411.InnerText = "0"; this.tdNgQty511.InnerText = "0"; this.tdNgQty112.InnerText = "0"; this.tdNgQty212.InnerText = "0"; this.tdNgQty312.InnerText = "0"; this.tdNgQty412.InnerText = "0"; this.tdNgQty512.InnerText = "0"; this.tdNgQty113.InnerText = "0"; this.tdNgQty213.InnerText = "0"; this.tdNgQty313.InnerText = "0"; this.tdNgQty413.InnerText = "0"; this.tdNgQty513.InnerText = "0"; this.tdNgQty114.InnerText = "0"; this.tdNgQty214.InnerText = "0"; this.tdNgQty314.InnerText = "0"; this.tdNgQty414.InnerText = "0"; this.tdNgQty514.InnerText = "0"; } } catch (Exception ex) { LogUtility.GetInstance().HandleExceptionLog("KB11-NGList：", ex); } } private void DrawingCurve() { bool retBool = IsSave(); if (retBool) { this.SavePercent(); } } private bool IsSave() { bool retBool = false; DateTime d; if (DistCache.Get("IsSave11") != null) { d = (DateTime)DistCache.Get("IsSave11"); if (DateTime.Now > d) { retBool = true; d = d.AddMinutes(25); DistCache.Add("IsSave11", d); } else { retBool = false; } } else { DistCache.Add("IsSave11", DateTime.Now); } return retBool; } private void SavePercent() { System.Data.DataTable dt = new System.Data.DataTable(); string time = DateTime.Now.ToLongTimeString().ToString(); if (DistCache.Get("percent1111") != null) { dt = (System.Data.DataTable)DistCache.Get("percent1111"); dt.Rows.Add(); dt.Rows[dt.Rows.Count - 1]["Point"] = dt.Rows.Count; dt.Rows[dt.Rows.Count - 1]["Percent"] = tdPercent311.InnerText.Trim().Substring(0, tdPercent311.InnerText.Trim().IndexOf('%')); dt.Rows[dt.Rows.Count - 1]["Time"] = time; DistCache.Add("percent1111", dt); } if (DistCache.Get("percent1112") != null) { dt = (System.Data.DataTable)DistCache.Get("percent1112"); dt.Rows.Add(); dt.Rows[dt.Rows.Count - 1]["Point"] = dt.Rows.Count; dt.Rows[dt.Rows.Count - 1]["Percent"] = tdPercent312.InnerText.Trim().Substring(0, tdPercent312.InnerText.Trim().IndexOf('%')); dt.Rows[dt.Rows.Count - 1]["Time"] = time; DistCache.Add("percent1112", dt); } if (DistCache.Get("percent1113") != null) { dt = (System.Data.DataTable)DistCache.Get("percent1113"); dt.Rows.Add(); dt.Rows[dt.Rows.Count - 1]["Point"] = dt.Rows.Count; dt.Rows[dt.Rows.Count - 1]["Percent"] = tdPercent313.InnerText.Trim().Substring(0, tdPercent313.InnerText.Trim().IndexOf('%')); dt.Rows[dt.Rows.Count - 1]["Time"] = time; DistCache.Add("percent1113", dt); } if (DistCache.Get("percent1114") != null) { dt = (System.Data.DataTable)DistCache.Get("percent1114"); dt.Rows.Add(); dt.Rows[dt.Rows.Count - 1]["Point"] = dt.Rows.Count; dt.Rows[dt.Rows.Count - 1]["Percent"] = tdPercent314.InnerText.Trim().Substring(0, tdPercent314.InnerText.Trim().IndexOf('%')); dt.Rows[dt.Rows.Count - 1]["Time"] = time; DistCache.Add("percent1114", dt); } } private void CreatTable() { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("Point"); dt.Columns.Add("Percent"); dt.Columns.Add("Time"); DistCache.Add("percent1111", dt); DistCache.Add("percent1112", dt); DistCache.Add("percent1113", dt); DistCache.Add("percent1114", dt); DistCache.Add("IsSave11", DateTime.Now.AddMinutes(25)); } private void RemoveTable() { DistCache.Remove("percent1111"); DistCache.Remove("percent1112"); DistCache.Remove("percent1113"); DistCache.Remove("percent1114"); DistCache.Remove("IsSave11"); } } }

下面为我开发后的说明文件：

此次CN看板程式變動較大，主要目的是消除看板的多查詢數據庫訪問，以便減小數據庫服務器的負荷，
從而縮短現場的回報時間，提高大家的訪問速度。

本次修改採取了分佈緩存技術，運用了Memcached緩存服務，從而使看板頁面不用直接訪問數據庫服務器，
只要訪問Memcached即可，由Memcached與數據庫直接交互，從而達到簡訊數據庫負荷的目的。

此次看板程式包括兩部分 1：winform(排程程式用來刷新Memcached中的數據)
2:webform(讀取Memcached數據，顯示給用戶)

2010/08/18

Jasson

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
[MES]制造执行系统（四）

<br /> 這樣下去也不對啊，現場不能夠老是出問題啊，要不還怎麼運行啊！想辦法改了，試了之前的辦法都是行不通，这可叫我怎么办啊？不能老卡在这里，寻找资料，先确定应该是看板的程式要查询数据，消耗了很多资源，如果从它那里开始改善应该会是个很好的办法。那看板的程式又需要怎么改呢？想...想...想<br /> 有了，Memcached!它可是个好东西帮了我的大忙了。Memcached在我之前的博文中也有简单的介绍。大家可以查看。继续我们的思路。有了这点苗头，我就可以这样做了，在做一个C/S程
复制链接

扫一扫

专栏目录