/// <summary> /// 设备号绑定 /// </summary> private void BindEq() { if (cmbWorkPlace.SelectedIndex > -1) { string location_Workplace_Key = cmbWorkPlace.SelectedItem.Value.ToString(); DataTable dtEquipment = new EquipmentAndOEE().GetFactoryWorkPlaceAreas(location_Workplace_Key); cmbEquipmentNo.DataSource = dtEquipment; cmbEquipmentNo.DataBind(); cmbEquipmentNo.Items.Insert(0, new ListEditItem("全部", "")); this.cmbEquipmentNo.SelectedIndex = 0; } }
/// <summary> /// 查询结果,显示在表格中 /// </summary> private void GvBind() { string sdate = string.Empty, edate = string.Empty; if (string.IsNullOrEmpty(cmbWorkPlace.Text.Trim())) { base.ShowMessageBox(this.Page, "车间不能为空"); this.cmbWorkPlace.Focus(); return; } if (string.IsNullOrEmpty(cmbEquipmentNo.Text.Trim())) { base.ShowMessageBox(this.Page, "设备不能为空!"); this.cmbEquipmentNo.Focus(); return; } if (string.IsNullOrEmpty(dateStart.Text.Trim())) { base.ShowMessageBox(this.Page, "开始日期不能为空!"); this.dateStart.Focus(); return; } if (string.IsNullOrEmpty(dateEnd.Text.Trim())) { base.ShowMessageBox(this.Page, "结束日期不能为空!"); this.dateEnd.Focus(); return; } sdate = Convert.ToDateTime(this.dateStart.Text.Trim()).ToString("yyyy-MM-dd") + " 08:00:00"; if (this.dateEnd.Text.Trim().Equals(string.Empty)) { edate = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); } else { edate = Convert.ToDateTime(this.dateEnd.Text.Trim()).AddDays(1).ToString("yyyy-MM-dd"); } edate = edate + " 08:00:00"; try { DataTable dtMain = new EquipmentAndOEE().GetOEE_MainDetail(sdate, edate, cmbEquipmentNo.SelectedItem.Value.ToString(), cmbWorkPlace.SelectedItem.Value.ToString()); ViewState["dt"] = dtMain; grid.DataSource = dtMain; grid.DataBind(); } catch (Exception ex) { base.ShowMessageBox(this.Page, ex.Message); } }