private void Initialize()
{
using (var context = new Model())
{
_cProductProcessing = context.C_ProductProcessing.FirstOrDefault(s => s.ProductBornCode == _productBornCode);
}
}
private void OfflineCntLogicTurn()
{
using (var context = new Model())
{
//在产品加工过程表中根据产品出生证 获取元数据
_cProductProcessing = context.C_ProductProcessing.FirstOrDefault(s => s.ProductBornCode == ProductIDTxt.Text.Trim());
//在控制点过程表中 根据产品出生证 工序编号 控制点id 设备编号(需要修改) 查到相关集合
var cBWuECntlLogicPros = context.C_BWuE_CntlLogicPro.Where(s =>
s.ProductBornCode == ProductIDTxt.Text.Trim() && s.ProcedureCode == _cProductProcessing.ProcedureCode &&
s.ControlPointID == 8 && s.EquipmentCode == _equipmentCode)
.OrderByDescending(s => s.StartTime).ToList();
//判断过程表中有无数据 如果没有(说明已经转档过了) 那就不操作了弟弟
if (cBWuECntlLogicPros.Any())
{
cBWuECntlLogicPros[0].State = "2";
cBWuECntlLogicPros[0].FinishTime = context.GetServerDate();
//遍历 添加后删除过程表中所有选中数据
foreach (var cBWuECntlLogicPro in cBWuECntlLogicPros)
{
var mapperConfiguration = new MapperConfiguration(cfg =>
cfg.CreateMap <C_BWuE_CntlLogicPro, C_BWuE_CntlLogicDoc>());
var mapper = mapperConfiguration.CreateMapper();
var cBWuECntlLogicDoc = mapper.Map <C_BWuE_CntlLogicDoc>(cBWuECntlLogicPro);
context.C_BWuE_CntlLogicDoc.Add(cBWuECntlLogicDoc);
context.C_BWuE_CntlLogicPro.Remove(cBWuECntlLogicPro);
}
context.SaveChanges();
}
}
}
private void AddCntLogicProOffline(string remark = "")
{
using (var context = new Model())
{
//在产品加工过程表中根据产品出生证 获取元数据
_cProductProcessing = context.C_ProductProcessing.FirstOrDefault(s => s.ProductBornCode == ProductIDTxt.Text.Trim());
var cBWuECntlLogicPro = new C_BWuE_CntlLogicPro
{
ProductBornCode = ProductIDTxt.Text.Trim(),
ProcedureCode = _cProductProcessing.ProcedureCode,
ControlPointID = 8,
Sort = "2",
EquipmentCode = _equipmentCode,
State = "1",
StartTime = context.GetServerDate(),
Remarks = remark
};
context.Entry(cBWuECntlLogicPro).State = EntityState.Added;
context.SaveChanges();
}
}
public void DataFill()
{
using (var context = new Model())
{
//在产品加工过程表中根据产品出生证 获取元数据
_cProductProcessing = context.C_ProductProcessing.FirstOrDefault(s => s.ProductBornCode == _productBornCode);
var procedureIdInt16 = Convert.ToInt16(_cProductProcessing.ProcedureID);
//在工序自检项配置表中根据工序主键/是否启用/有效性 获得自检项数据
//类型转换问题 数据库设计有误吗???
_aProcedureSelfCheckingConfigs = context.A_ProcedureSelfCheckingConfig.Where(s =>
s.ProcedureID == procedureIdInt16 &&
s.IsEnable == true && s.IsAvailable == true).OrderByDescending(s => s.IsRequired).ToList();
//动态加载txt和lbl控件
int tabIndex = 1;
int localLblY = 73;
int localTextBoxY = 70;
foreach (var aProcedureSelfCheckingConfig in _aProcedureSelfCheckingConfigs)
{
panel3.Controls.Add(new Label()
{
Location = new Point(110, localLblY),
Size = new Size(86, 26),
Text = aProcedureSelfCheckingConfig.ItemName + ':',
ForeColor = Color.Black,
TabIndex = tabIndex,
BackColor = Color.Transparent,
Font = new Font("微软雅黑", 10.8F, FontStyle.Bold,
GraphicsUnit.Point, ((byte)(134))),
Name = aProcedureSelfCheckingConfig.ItemCode + "lbl"
});
localLblY += 60;
panel3.Controls.Add(new TextBox()
{
Location = new Point(204, localTextBoxY),
Size = new Size(168, 32),
Name = aProcedureSelfCheckingConfig.ItemCode + "txt"
});
localTextBoxY += 60;
_txtNameList.Add(aProcedureSelfCheckingConfig.ItemCode + "txt");
if (aProcedureSelfCheckingConfig.IsRequired != null && (bool)aProcedureSelfCheckingConfig.IsRequired)
{
panel3.Controls[$"{aProcedureSelfCheckingConfig.ItemCode + "lbl"}"].Text =
panel3.Controls[$"{aProcedureSelfCheckingConfig.ItemCode + "lbl"}"].Text
.Insert(panel3.Controls[$"{aProcedureSelfCheckingConfig.ItemCode + "lbl"}"].Text.Length - 1, "*");
panel3.Controls[$"{aProcedureSelfCheckingConfig.ItemCode + "lbl"}"].ForeColor = Color.Red;
panel3.Controls[$"{aProcedureSelfCheckingConfig.ItemCode + "txt"}"].Tag = "*";
_mbNameList.Add(aProcedureSelfCheckingConfig.ItemCode);
}
//在产品质量数据表中根据 订单号项目号计划好产品号出生证工序号检验类型(自检)及检测项编号 获得特定数据(检测实际值)
var cProductQualityData = context.C_ProductQualityData.FirstOrDefault(s =>
s.OrderID == _cProductProcessing.OrderID && s.ProjectID == _cProductProcessing.ProjectID && s.PlanID == _cProductProcessing.PlanID &&
s.ProductID == _cProductProcessing.ProductID && s.ProductBornCode == _cProductProcessing.ProductBornCode &&
s.ProcedureID == _cProductProcessing.ProcedureID && s.CheckType == 1 && s.ItemCode == aProcedureSelfCheckingConfig.ItemCode);
if (cProductQualityData != null && cProductQualityData.CollectValue != null)
{
panel3.Controls[$"{aProcedureSelfCheckingConfig.ItemCode + "txt"}"].Text = cProductQualityData.CollectValue.ToString();
}
}
}
}
private void MainPanel_Load(object sender, EventArgs e)
{
var addXmlFile = new ConfigurationBuilder().SetBasePath("E:\\project\\visual Studio Project\\HotPressing")
.AddXmlFile("config.xml");
var configuration = addXmlFile.Build();
_workshopId = configuration["WorkshopID"];
_workshopCode = configuration["WorkshopCode"];
_workshopName = configuration["WorkshopName"];
_equipmentId = configuration["EquipmentID"];
_equipmentCode = configuration["EquipmentCode"];
_equipmentName = configuration["EquipmentName"];
//使用hzh控件自带的图标库 tuple
//解析tuple 加载顶部菜单栏 绑定事件
var workersGaugeLabel = GenerateLabel();
workersGaugeLabel.Click += lbl_DoubleClick;
var scanGunStateLabel = GenerateLabel();
scanGunStateLabel.DoubleClick += lbl_DoubleClick;
// var onlineLabel = GenerateLabel();
// onlineLabel.Click += OpenScanOnlineForm;
var programFilesLabel = GenerateLabel();
programFilesLabel.Click += OpenProgramFile;
var workInstructionLabel = GenerateLabel();
workInstructionLabel.Click += OpenWorkInstruction;
// var selfCheckItemInputLabel = GenerateLabel();
// selfCheckItemInputLabel.Click += OpenSelfCheckItemForm;
// var offlineLabel = GenerateLabel();
// offlineLabel.Click += OpenScanOfflineForm;
var forceOfflineLabel = GenerateLabel();
forceOfflineLabel.Click += OpenForceOfflineForm;
var forceOfflineLabel1 = GenerateLabel();
forceOfflineLabel1.Click += OpenForceOfflineForm;
var switchAccountLabel = GenerateLabel();
switchAccountLabel.Click += OpenLoginForm;
var exitLabel = GenerateLabel();
exitLabel.Click += CloseForms;
// 加载人员信息图标
var tuple1 = new Tuple <string, string>("人员信息", "A_fa_address_card_o");
var icon1 = (FontIcons)Enum.Parse(typeof(FontIcons), tuple1.Item2);
var pictureBox1 = new PictureBox
{
AutoSize = false,
Size = new Size(240, 160),
ForeColor = Color.FromArgb(255, 77, 59),
Image = FontImages.GetImage(icon1, 32, Color.FromArgb(255, 77, 59)),
Location = new Point(110, 20)
};
PersonnelInfoPanel.Controls.Add(pictureBox1);
// 加载箭头图标
var tuple2 = new Tuple <string, string>("Arrow", "A_fa_arrow_down");
var icon2 = (FontIcons)Enum.Parse(typeof(FontIcons), tuple2.Item2);
int localY = 72;
for (var i = 0; i < 1; i++)
{
ProductionStatusInfoPanel.Controls.Add(new PictureBox()
{
AutoSize = false,
Size = new Size(40, 40),
ForeColor = Color.FromArgb(255, 77, 59),
Image = FontImages.GetImage(icon2, 40, Color.FromArgb(255, 77, 59)),
Location = new Point(270, localY)
});
localY += 98;
}
//修改自定义控件label.text文本
CompletedTask.label1.Text = " 已完成任务";
ProductionTaskQueue.label1.Text = "热压任务队列";
InitialDidTasks();
ucSignalLamp1.LampColor = new Color[] { Color.Green };
ucSignalLamp2.LampColor = new Color[] { Color.Red };
InialToDoTasks();
//初始化生产状态信息面板
using (var context = new Model())
{
//这里需要配置修改xml
var cBBdbRCntlPntBases = context.C_BBdbR_CntlPntBase.Where(s =>
s.CntlPntTyp == "3" && s.Enabled == 1.ToString())
.OrderBy(s => s.CntlPntSort).ToList();
int localLblY = 25;
foreach (var cBBdbRCntlPntBase in cBBdbRCntlPntBases)
{
var label = new Label()
{
Location = new Point(239, localLblY),
Size = new Size(112, 39),
Name = cBBdbRCntlPntBase.CntlPntCd,
BackColor = Color.LightSlateGray,
Font = new Font("微软雅黑", 10.8F, FontStyle.Bold,
GraphicsUnit.Point, ((byte)(134))),
Text = cBBdbRCntlPntBase.CntlPntNm,
TextAlign = ContentAlignment.MiddleCenter,
};
if (label.Name.Equals("control001"))
{
label.Click += ProductOnlineEvent;
}
// else if (label.Name.Equals("control002"))
// {
// label.Click += SelfCheckItemEvent;
// }
else if (label.Name.Equals("control002"))
{
label.Click += ProductOfflineEvent;
}
ProductionStatusInfoPanel.Controls.Add(label);
localLblY += 96;
}
}
//获取当前加工中心的生产任务(已上线)
using (var context = new Model())
{
var cProductProcessing = context.C_ProductProcessing
.FirstOrDefault(s => s.WorkshopCode == _workshopCode && s.OnlineTime != null);
if (cProductProcessing != null)
{
ProductIDTxt.Text = cProductProcessing.ProductBornCode;
ProductIDTxt.ReadOnly = true;
ProductNameTxt.Text = cProductProcessing.ProductName;
ProductNameTxt.ReadOnly = true;
CurrentProcessTxt.Text = cProductProcessing.ProcedureName;
CurrentProcessTxt.ReadOnly = true;
OnlineTimeTxt.Text = cProductProcessing.OnlineTime.ToString();
OnlineTimeTxt.ReadOnly = true;
// ProductOnlineLbl.BackColor = Color.MediumSeaGreen;
ProductionStatusInfoPanel.Controls.Find("control001", false).First().BackColor =
Color.MediumSeaGreen;
}
if (!string.IsNullOrEmpty(ProductIDTxt.Text))
{
//在产品加工过程表中根据产品出生证 获取元数据
_cProductProcessing = context.C_ProductProcessing.FirstOrDefault(s => s.ProductBornCode == ProductIDTxt.Text.Trim());
}
}
timer1.Enabled = true;
}
