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