public void GetColdChainDatas(string startTime, string endTime, string pageIndexAndCount) { try { if (coldstoragepda == null) { return; } if (startTime != null && endTime != null) { if (Convert.ToDateTime(startTime) > Convert.ToDateTime(endTime)) { MessageBox.Show("开始时间不能大于结束时间!"); return; } pictureBox1.Show(); //获取显示的标题行 ResultModelOfArrayOfModel_AiInfod4FqxSXX biaoti = cs.GetAiInfoByStorageId(coldstoragepda.StorageIdk__BackingField, true, null); if (biaoti.Code != 0) { MessageBox.Show(biaoti.Message); } else { dataGridView1.Columns.Clear(); dataGridView1.Columns.Add("记录时间", "记录时间"); foreach (Model_AiInfo item in biaoti.Data) { dataGridView1.Columns.Add(item.PpointNamek__BackingField, item.PpointNamek__BackingField); } dataGridView1.Columns.Add("报警状态", "报警状态"); } //线程 调用提示文字框 //waitForm = null; //Thread waitThread = new Thread(new ThreadStart(this._ShowWaitForm)); //waitThread.Start(); //Thread.Sleep(100); //根据冷库id、开始时间、结束时间(下一个开始时间)查询冷链数据 //ResultModelOfArrayOfArrayOfstringuHEDJ7Dj count = cs.GetWaybillNodeHistDataList(coldstoragepda.StorageIdk__BackingField, true, startTime, endTime, null); //winFormPager1.DrawControl(count.Data.Count<String[]>()); ResultModelOfint result = cs.GetWaybillNodeHistDataCount(coldstoragepda.StorageIdk__BackingField, true, startTime, endTime); winFormPager1.DrawControl(result.Data); ResultModelOfArrayOfArrayOfstringuHEDJ7Dj nodedatalist = cs.GetWaybillNodeHistDataList(coldstoragepda.StorageIdk__BackingField, true, startTime, endTime, pageIndexAndCount); if (nodedatalist.Code != 0) { MessageBox.Show(nodedatalist.Message); } else { //Thread.Sleep(100); //if (waitThread != null) //{ // waitForm.Close(); //waitThread.Abort(); //} pictureBox1.Hide(); dataGridView1.Rows.Clear(); foreach (String[] item in nodedatalist.Data) { int rowIndex = dataGridView1.Rows.Add(); for (int i = 0; i < item.Length; i++) { //判断是否为最后一列 if (item[i] != item[item.Length - 1]) { //设置第一列的时间宽度 if (item[i] == item[0]) { dataGridView1.Columns[i].Width = 130; //dataGridView1.Columns[i].Resizable = DataGridViewTriState.False; dataGridView1.Rows[rowIndex].Cells[i].Value = DateTime.Parse(item[i]).ToString("yyyy-MM-dd HH:mm:ss"); } else { //显示一位小数,不为空和非负浮点数 if (item[i] != string.Empty && IsInteger(item[i]) == true) { dataGridView1.Rows[rowIndex].Cells[i].Value = Math.Round(Convert.ToDecimal(item[i]), 1); } else { dataGridView1.Rows[rowIndex].Cells[i].Value = "- -"; } } } else { if (item[item.Length - 1] == "0") { dataGridView1.Rows[rowIndex].Cells[i].Value = "正常"; } else { dataGridView1.Rows[rowIndex].Cells[i].Value = "报警"; } } } } } } else { MessageBox.Show("请选择开始时间和结束时间!"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void GetColdChainData() { try { pictureBox1.Show(); if (lbStartTime.Text.Trim() == null && lbEndTime.Text.Trim() == null) { return; } //获取显示的标题行 ResultModelOfArrayOfModel_AiInfod4FqxSXX biaoti = cs.GetAiInfoByStorageId(node.StorageIdk__BackingField, true, null); if (biaoti.Code != 0) { MessageBox.Show(biaoti.Message); } else { dataGridView2.Columns.Clear(); //dataGridView2.Columns[0].HeaderText = "记录时间"; dataGridView2.Columns.Add("记录时间", "记录时间"); foreach (Model_AiInfo item in biaoti.Data) { dataGridView2.Columns.Add(item.PpointNamek__BackingField, item.PpointNamek__BackingField); } dataGridView2.Columns.Add("报警状态", "报警状态"); } //线程 调用提示文字框 //waitForm = null; //Thread waitThread = new Thread(new ThreadStart(this._ShowWaitForm)); //waitThread.Start(); //Thread.Sleep(100); string pageIndexAndCount = winFormPager1.PageIndex + "." + winFormPager1.PageSize; ResultModelOfint result = cs.GetWaybillNodeHistDataCount(node.StorageIdk__BackingField, true, lbStartTime.Text.Trim(), lbEndTime.Text.Trim()); winFormPager1.DrawControl(result.Data); //根据冷库id、开始时间、结束时间(下一个开始时间)查询冷链数据 ResultModelOfArrayOfArrayOfstringuHEDJ7Dj nodedatalist = cs.GetWaybillNodeHistDataList(node.StorageIdk__BackingField, true, lbStartTime.Text.Trim(), lbEndTime.Text.Trim(), pageIndexAndCount); //ResultModelOfArrayOfArrayOfstringuHEDJ7Dj count = cs.GetWaybillNodeHistDataList(node.StorageIdk__BackingField, true, lbStartTime.Text.Trim(), lbEndTime.Text.Trim(), null); //winFormPager1.DrawControl(count.Data.Count<String[]>()); if (nodedatalist.Code != 0) { MessageBox.Show(nodedatalist.Message); } else { //Thread.Sleep(100); //if (waitThread != null) //{ // waitForm.Close(); //waitThread.Abort(); //} pictureBox1.Hide(); dataGridView2.Rows.Clear(); foreach (String[] item in nodedatalist.Data) { int rowIndex = dataGridView2.Rows.Add(); for (int i = 0; i < item.Length; i++) { if (item[i] != item[item.Length - 1]) { //如果是第一列设置宽度和时间格式 if (item[i] == item[0]) { dataGridView2.Columns[i].Width = 130; dataGridView2.Columns[i].Resizable = DataGridViewTriState.False; dataGridView2.Rows[rowIndex].Cells[i].Value = DateTime.Parse(item[i]).ToString("yyyy-MM-dd HH:mm:ss"); } else { //如果不为空和非负浮点数的值显示一位小数点后的数字 if (item[i].ToString() != string.Empty && IsInteger(item[i].ToString()) == true) { dataGridView2.Rows[rowIndex].Cells[i].Value = Math.Round(Convert.ToDecimal(item[i]), 1); } else { dataGridView2.Rows[rowIndex].Cells[i].Value = "- -"; } } } else { if (item[item.Length - 1] == 0.ToString()) { dataGridView2.Rows[rowIndex].Cells[i].Value = "正常"; } else { dataGridView2.Rows[rowIndex].Cells[i].Value = "报警"; } } dataGridView2.Rows[rowIndex].Tag = item; } dataGridView2.Rows[rowIndex].Tag = item; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void AillLoad() { try { string pageIndexAndCount = winFormPager1.PageIndex + "." + winFormPager1.PageSize; ResultModelOfArrayOfModel_AiInfod4FqxSXX aiin = cs.GetAiInfoByStorageId(mcp.StorageIdk__BackingField, true, pageIndexAndCount); ResultModelOfArrayOfModel_AiInfod4FqxSXX count = cs.GetAiInfoByStorageId(mcp.StorageIdk__BackingField, true, null); winFormPager1.DrawControl(count.Data.Count <Model_AiInfo>()); if (count.Data.Count <Model_AiInfo>() <= 0) { contextMenuStrip1.Enabled = false; } else { contextMenuStrip1.Enabled = true; } if (aiin.Code != 0) { MessageBox.Show(aiin.Message); } else { dataGridView1.Rows.Clear(); dataGridView1.AutoGenerateColumns = false; foreach (Model_AiInfo item in aiin.Data) { int rowIndex = dataGridView1.Rows.Add(); dataGridView1.Rows[rowIndex].Cells[0].Value = item.PointIdk__BackingField; dataGridView1.Rows[rowIndex].Cells[1].Value = item.PpointNamek__BackingField; if (item.PointTypek__BackingField == Enum_PointType.Temp) { dataGridView1.Rows[rowIndex].Cells[2].Value = "温度"; } else if (item.PointTypek__BackingField == Enum_PointType.Hump) { dataGridView1.Rows[rowIndex].Cells[2].Value = "湿度"; } else if (item.PointTypek__BackingField == Enum_PointType.Longitude) { dataGridView1.Rows[rowIndex].Cells[2].Value = "经度"; } else if (item.PointTypek__BackingField == Enum_PointType.Latitude) { dataGridView1.Rows[rowIndex].Cells[2].Value = "纬度"; } if (item.Activedk__BackingField == Enum_Active.Enabled) { dataGridView1.Rows[rowIndex].Cells[3].Value = "激活"; } else { dataGridView1.Rows[rowIndex].Cells[3].Value = "待激活"; } dataGridView1.Rows[rowIndex].Tag = item; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }