protected override void Saving()
{
var obj = EquipmentDee.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.Save();
}
protected override void Loading()
{
if (UserStatics.OptrType == "Test")
{
ctProcess.Enabled = false;
label14.Text = "复测产量";
}
ctProcess.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "工序");
ctProcess.DisplayMember = "Name";
ctGrouping.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "班组");
ctGrouping.DisplayMember = "Name";
ctRepairMonitor.DataSource = BllEquipmentDee.GetRepairMonitorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctRepairMonitor.DisplayMember = "Name";
ctGroupMonitor.DataSource = BllEquipmentDee.GetGroupMonitorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctGroupMonitor.DisplayMember = "Name";
ctOperator.DataSource = BllEquipmentDee.GetOperatorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctOperator.DisplayMember = "Name";
if (!IsAdd)
{
var obj = EquipmentDee.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1);
}
}
/// <summary>
/// 取出所有DEE数据
/// </summary>
/// <param name="optrType">操作类型</param>
/// <returns>所有DEE的DataTable</returns>
public static DataTable GetTableByTimeSpan(string beginDate, string endDate, string optrType)
{
var dt = EquipmentDee.Find(CK.K["OptrType"] == optrType && CK.K["DeeDate"] >= beginDate && CK.K["DeeDate"] <= endDate).ToDataTable();
dt.Columns[1].ColumnName = "机台号";
dt.Columns[2].ColumnName = "模具号";
dt.Columns[3].ColumnName = "日期";
dt.Columns[4].ColumnName = "班组";
dt.Columns[5].ColumnName = "组长";
dt.Columns[6].ColumnName = "维修班长";
dt.Columns[7].ColumnName = "操作工";
dt.Columns[8].ColumnName = "工序";
dt.Columns[9].ColumnName = "当前品种";
dt.Columns[10].ColumnName = "实际产量";
dt.Columns[11].ColumnName = "复测产量";
dt.Columns[12].ColumnName = "停产";
dt.Columns[13].ColumnName = "故障次数";
dt.Columns[14].ColumnName = "故障耗时";
dt.Columns[15].ColumnName = "待料";
dt.Columns[16].ColumnName = "试验";
dt.Columns[17].ColumnName = "QA";
dt.Columns[18].ColumnName = "更换次数";
dt.Columns[19].ColumnName = "更换耗时";
dt.Columns[20].ColumnName = "清模";
dt.Columns[21].ColumnName = "PM";
dt.Columns[22].ColumnName = "减产原因";
dt.Columns[23].ColumnName = "适应产品";
dt.Columns[24].ColumnName = "统计分类";
dt.Columns[25].ColumnName = "UPH";
dt.Columns[26].ColumnName = "定额";
dt.Columns[27].ColumnName = "管理分组";
dt.Columns[28].ColumnName = "用户类型";
return(dt);
}
protected override void Saving()
{
if (IsAdd)
{
var obj = EquipmentDee.New;
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.OptrType = UserStatics.OptrType;
obj.Save();
}
else if (IsAdd == false)
{
var obj = EquipmentDee.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.Save();
}
}
protected override void Loading()
{
toolStripStatusLabel1.Text = toolStripStatusLabel1.Text + ",按F7选机台。";
if (UserStatics.OptrType == "Test")
{
ctCurrentProduct.Enabled = false;
ctProcess.Enabled = false;
label14.Text = "复测产量";
}
else
{
ctProcess.Enabled = false;
}
ctProductAdaptation.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "适应产品");
ctProductAdaptation.DisplayMember = "Name";
ctProcess.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "工序");
ctProcess.DisplayMember = "Name";
ctGrouping.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "班组");
ctGrouping.DisplayMember = "Name";
ctRepairMonitor.DataSource = BllEquipmentDee.GetRepairMonitorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctRepairMonitor.DisplayMember = "Name";
ctGroupMonitor.DataSource = BllEquipmentDee.GetGroupMonitorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctGroupMonitor.DisplayMember = "Name";
ctOperator.DataSource = BllEquipmentDee.GetOperatorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctOperator.DisplayMember = "Name";
if (!IsAdd)
{
var obj = EquipmentDee.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1);
}
else
{
ctDeeDate.Value = DateTime.Now.AddDays(-1);
}
}
public static DataTable GetOneWeek(string optrType)
{
DateTime now = DateTime.Now;
DateTime d1 = now.AddDays(-8);
var dt = EquipmentDee.Find(CK.K["OptrType"] == optrType && CK.K["DeeDate"] > d1, "DeeDate desc").ToDataTable();
dt.Columns[1].ColumnName = "机台号";
dt.Columns[2].ColumnName = "模具号";
dt.Columns[3].ColumnName = "日期";
dt.Columns[4].ColumnName = "班组";
dt.Columns[5].ColumnName = "组长";
dt.Columns[6].ColumnName = "维修班长";
dt.Columns[7].ColumnName = "操作工";
dt.Columns[8].ColumnName = "工序";
dt.Columns[9].ColumnName = "当前品种";
dt.Columns[10].ColumnName = "实际产量";
dt.Columns[11].ColumnName = "复测产量";
dt.Columns[12].ColumnName = "停产";
dt.Columns[13].ColumnName = "故障次数";
dt.Columns[14].ColumnName = "故障耗时";
dt.Columns[15].ColumnName = "待料";
dt.Columns[16].ColumnName = "试验";
dt.Columns[17].ColumnName = "QA";
dt.Columns[18].ColumnName = "更换次数";
dt.Columns[19].ColumnName = "更换耗时";
dt.Columns[20].ColumnName = "清模";
dt.Columns[21].ColumnName = "PM";
dt.Columns[22].ColumnName = "减产原因";
dt.Columns[23].ColumnName = "适应产品";
dt.Columns[24].ColumnName = "统计分类";
dt.Columns[25].ColumnName = "UPH";
dt.Columns[26].ColumnName = "定额";
dt.Columns[27].ColumnName = "管理分组";
dt.Columns[28].ColumnName = "用户类型";
return(dt);
}
public static void DelCell(long id)
{
EquipmentDee.DeleteAll(CK.K["Id"] == id);
}
