protected override void InitData()
{
gvLotTx_NG.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gvLotTx_NG_CellValueChanged);
JobNoTextEdit.EditValueChanged += new EventHandler(JobNoTextEdit_EditValueChanged);
var roles = appCacheService.GetItem("roles") as tb_Sys_Roles;
var controlDataList = controlService.GetlistByRolesId(roles.Id).Where(i => i.Windows == "MES_M003_LotTx" && i.Control == "ProcessCode").Select(i => i.CValue).ToList();
var ProcessData = codeService.GetCodeDataByCodeId("PRC");
if (controlDataList.Count > 0)
{
ProcessData = ProcessData.Where(i => controlDataList.Contains(i.Value)).ToList(); //数据权限筛选制程
}
ERPHelper.Instance.SetGridLookUpEdit(ProcessCodeTextEdit, ProcessData, 2, false); //制程
string processCode = Util.AppConfig.Instance.AppConfigGet("ProcessCode");
if (ProcessData.Where(i => i.Value == processCode).ToList().Count > 0)
{
this.lotTxData.ProcessCode = processCode;
}
ERPHelper.Instance.SetGridLookUpEdit(JobNoTextEdit, jobService.GetInputDataList(), 2, false); //工单号
ERPHelper.Instance.SetGridLookUpEdit(ShiftCodeTextEdit, codeService.GetCodeDataByCodeId("BC"), 2); //班次
ERPHelper.Instance.SetGridLookUpEdit(OperatorTextEdit, codeService.GetCodeDataByCodeId("BC"), 2); //操作员
ERPHelper.Instance.SetGridLookUpEdit(MacCodeTextEdit, codeService.GetCodeDataByCodeId("BC"), 2); //机台
repositoryItemProcessCode.DataSource = ProcessData;
repositoryItemProcessCode.DisplayMember = "DisPlayName";
repositoryItemProcessCode.ValueMember = "Value";
ShiftCodeTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(ShiftCodeTextEdit_EditValueChanging);
OperatorTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(ShiftCodeTextEdit_EditValueChanging);
MacCodeTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(ShiftCodeTextEdit_EditValueChanging);
ProcessCodeTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(ShiftCodeTextEdit_EditValueChanging);
this.mESM003LotTxBindingSource.DataSource = lotTxData;
this.gridControl2.DataSource = lotTxService.GetListByJobNo(lotTxData.JobNo);
this.mESM003LotTxNGBindingSource.DataSource = lotTxService.GetLotTxNGListByLotNo(lotTxData.LotNo);
}
public override void InitData()
{
//级别
SetGridLookUpEdit(repositoryItemLevel, codeService.GetCodeDataByCodeId("PLLEVEL"), 1);
//状态
SetGridLookUpEdit(repositoryItemStatus, codeService.GetCodeDataByCodeId("PLSTATUS"), 1);
//班次
var codeData = codeService.GetCodeDataByCodeId("SHIFT");
SetGridLookUpEdit(repositoryItemShift, codeData, 1);
//客户
var customerData = customerService.GetCustomerInputData();
SetGridLookUpEdit(repositoryItemCustomer, customerData, 1);
var tastQuery = TaskService.GetQuery();
if (string.IsNullOrWhiteSpace(txtTxDt1.Text) || string.IsNullOrWhiteSpace(txtTxDt2.Text))
{
throw new AppException("请先输入任务单日期");
}
var taskList = tastQuery.Where(a => a.TaskDt >= txtTxDt1.DateTime && a.TaskDt <= txtTxDt2.DateTime).ToList();
this.mESM202TaskBindingSource.DataSource = taskList;
this.gridTask.BestFitColumns();
//this.gridTaskDetail.BestFitColumns();
}
public override void OnAttachEvent()
{
//base.OnAttachEvent();
dataLayoutControl1.OptionsView.IsReadOnly = DevExpress.Utils.DefaultBoolean.True;
this.mESM501JobTxBindingSource.CurrentChanged += mESM501JobTxBindingSource_CurrentChanged;
SetGridLookUpEdit(ProcessCodeTextEdit, codeService.GetCodeDataByCodeId("PROC"), 0);
SetGridLookUpEdit(txtProcessCode, codeService.GetCodeDataByCodeId("PROC"), 0);
SetGridLookUpEdit(repositoryItemPROCPMS, codeService.GetCodeDataByCodeId("PROCPMS"));
SetGridLookUpEdit(repositoryItemPROCPMSTATUS, codeService.GetCodeDataByCodeId("PROCPMSTATUS"));
if (File.Exists(IniFilePath))
{
INIFile inifile = new INIFile(IniFilePath);
var processCodes = inifile.IniReadValue("JobLot", "ProcessCode").Split(',').ToList();
StringBuilder strSql = new StringBuilder();
for (int i = 0; i < processCodes.Count; i++)
{
if (!string.IsNullOrEmpty(processCodes[i]))
{
if (i == 0)
{
strSql.AppendFormat("[Value]= '{0}'", processCodes[i]);
}
else
{
strSql.AppendFormat(" Or [Value]= '{0}'", processCodes[i]);
}
}
}
ProcessCodeTextEdit.Properties.View.ActiveFilterString = strSql.ToString();
ProcessCodeTextEdit.EditValue = processCodes[0];
ShowLayForm(ProcessCodeTextEdit.Text);
}
}
protected override void InitData()
{
ERPHelper.Instance.SetGridLookUpEdit(MatCategoryTextEdit, codeService.GetCodeDataByCodeId("MTP"), 2); //材质
ERPHelper.Instance.SetGridLookUpEdit(MatTypeTextEdit, codeService.GetCodeDataByCodeId("MCA"), 2); //类别
ERPHelper.Instance.SetGridLookUpEdit(SuppCodeTextEdit, supplier.GetSupplierData(), 2); //类别
MatCategoryTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(MatCategoryTextEdit_EditValueChanging);
MatTypeTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(MatCategoryTextEdit_EditValueChanging);
SuppCodeTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(MatCategoryTextEdit_EditValueChanging);
}
protected override void OnSetLayoutItemStyle()
{
ERPHelper.Instance.ApplyBindingSettings(ItemForCompCode, ItemBindingType.Required);
ERPHelper.Instance.ApplyBindingSettings(ItemForProcessFlowCode, ItemBindingType.Required);
ERPHelper.Instance.ApplyBindingSettings(ItemForProcessFlowName, ItemBindingType.Required);
SetGridLookUpEdit(repositoryItemPROC, codeService.GetCodeDataByCodeId("PROC"));
SetGridLookUpEdit(repositoryItemPROCPMS, codeService.GetCodeDataByCodeId("PROCPMS"));
SetGridLookUpEdit(repositoryItemPROCPMSTATUS, codeService.GetCodeDataByCodeId("PROCPMSTATUS"));
}
protected override void InitData()
{
//级别
SetGridLookUpEdit(TLevelTextEdit, codeService.GetCodeDataByCodeId("PLLEVEL"), 1);
//状态
SetGridLookUpEdit(StatusTextEdit, codeService.GetCodeDataByCodeId("PLSTATUS"), 1);
//班次
var codeData = codeService.GetCodeDataByCodeId("SHIFT");
SetGridLookUpEdit(ShiftCodeTextEdit, codeData, 1);
//机台
codeData = codeService.GetCodeDataByCodeId("MACHINE");
SetGridLookUpEdit(MacCodeTextEdit, codeData, 1);
//产品
var productData = productService.GetProductInputData();
SetGridLookUpEdit(PartNoTextEdit, productData, 1);
//客户
var customerData = customerServer.GetCustomerInputData();
SetGridLookUpEdit(CustCodeTextEdit, customerData, 1);
//计划单
var planData = planDetailService.GetInputList();
SetGridLookUpEdit(txtPlanDetialId, planData, 5);
var processFlowList = processFlowService.GetProcessFlowInputData();
SetGridLookUpEdit(ProcessFlowTextEdit, processFlowList, 1);
//repositoryItemPlan.DisplayMember = "Value";
//repositoryItemPlan.View.Columns[0].Caption = "计划单号";
txtPlanDetialId.Properties.View.Columns[1].Caption = "SO工单";
txtPlanDetialId.Properties.View.Columns[2].Caption = "料号";
txtPlanDetialId.Properties.View.Columns[3].Caption = "品名";
txtPlanDetialId.Properties.View.Columns[4].Caption = "数量";
txtPlanDetialId.Properties.View.Columns[5].Caption = "完成数量";
if (this.Tag.ToStr() == BtnCommandEnum.Add)
{
//保存时自动生成单号
string ls_TaskNo = "";
ls_TaskNo = viewService.GetGenerateOrderCode(4);
tempData.TaskNo = ls_TaskNo;
}
this.mESM202TaskDetailBindingSource.DataSource = tempData;
var taskJobLotList = taskJobLotService.GetQuery().Where(a => a.JobNo == tempData.TaskNo).ToList();
this.mESM202TaskJobLotBindingSource.DataSource = taskJobLotList;
//this.gridProduct.BestFitColumns();
//this.gridMaterial.BestFitColumns();
}
public override void OnAttachEvent()
{
var custData = customerServer.GetCustomerInputData();
SetGridLookUpEdit(repositoryCustCode, custData, 3);
var processFlowList = processFlowService.GetProcessFlowInputData();
SetGridLookUpEdit(repositoryItemProcessFlow, processFlowList, 1);
SetGridLookUpEdit(repositoryItemPROC, codeService.GetCodeDataByCodeId("PROC"));
SetGridLookUpEdit(repositoryItemPROCPMS, codeService.GetCodeDataByCodeId("PROCPMS"));
SetGridLookUpEdit(repositoryItemPROCPMSTATUS, codeService.GetCodeDataByCodeId("PROCPMSTATUS"));
SetGridLookUpEdit(repositoryItemMatCode, materialService.GetInputData());
this.eRPM001ProductProcessFlowBindingSource.CurrentChanged += eRPM001ProductProcessFlowBindingSource_CurrentChanged;
this.eRPM001ProductBindingSource.CurrentChanged += eRPM001ProductBindingSource_CurrentChanged;
}
protected override void InitData()
{
//级别
SetGridLookUpEdit(repositoryItemLevel, codeService.GetCodeDataByCodeId("PLLEVEL"), 1);
//状态
SetGridLookUpEdit(repositoryItemStatus, codeService.GetCodeDataByCodeId("PLSTATUS"), 1);
SetGridLookUpEdit(repositoryItemUnit, codeService.GetCodeDataByCodeId("UNIT"), 1);
this.mESM201PlanDetailBindingSource.CurrentChanged += mESM201PlanDetailBindingSource_CurrentChanged;
var productData = productService.GetProductInputData();
SetGridLookUpEdit(repositoryProduct, productData, 1);
var customerData = customerServer.GetCustomerInputData();
SetGridLookUpEdit(repositoryItemCustomer, customerData, 1);
repositoryProduct.DisplayMember = "Value";
this.mESM201PlanBindingSource.DataSource = tempData;
var productList = planService.GetProductQuery().Where(a => a.PlanId == tempData.Id).ToList();
//var count = productList.Count;
//for (int i = 0; i < 20 - count; i++)
//{
// MES_M201_Plan_Detail bomMat = new MES_M201_Plan_Detail();
// bomMat.PlanId = tempData.Id;
// productList.Add(bomMat);
//}
if (this.Tag.ToStr() == BtnCommandEnum.Add)
{
for (int i = 0; i < 20; i++)
{
MES_M201_Plan_Detail bomMat = new MES_M201_Plan_Detail();
bomMat.PlanId = tempData.Id;
bomMat.Status = "01";
bomMat.PLevel = "01";
productList.Add(bomMat);
}
}
//else
//{
// colQty.OptionsColumn.AllowEdit = false;
//}
this.mESM201PlanDetailBindingSource.DataSource = productList;
this.mESM201PlanMaterialBindingSource.DataSource = planService.GetMaterialQuery().Where(a => a.PLNo == tempData.PLNo).ToList();
this.mESM201PlanDailyBindingSource.DataSource =
planService.GetPlanDailiesQuery().Where(a => a.PLNo == tempData.PLNo).ToList();
//this.gridProduct.BestFitColumns();
//this.gridMaterial.BestFitColumns();
}
protected override void OnSetLayoutItemStyle()
{
ERPHelper.Instance.ApplyBindingSettings(ItemForPartNo, ItemBindingType.Required);
ERPHelper.Instance.ApplyBindingSettings(ItemForPartName, ItemBindingType.Required);
var custData = customerServer.GetCustomerInputData();
SetGridLookUpEdit(repositoryCustCode, custData, 3);
var processFlowList = processFlowService.GetProcessFlowInputData();
SetGridLookUpEdit(ProcessFlowTextEdit, processFlowList, 1);
SetGridLookUpEdit(repositoryItemPROC, codeService.GetCodeDataByCodeId("PROC"));
SetGridLookUpEdit(repositoryItemPROCPMS, codeService.GetCodeDataByCodeId("PROCPMS"));
SetGridLookUpEdit(repositoryItemPROCPMSTATUS, codeService.GetCodeDataByCodeId("PROCPMSTATUS"));
SetGridLookUpEdit(repositoryItemMatCode, materialService.GetInputData());
this.eRPM001ProductProcessFlowBindingSource.CurrentChanged += eRPM001ProductProcessFlowBindingSource_CurrentChanged;
}
protected override void OnSetLayoutItemStyle()
{
ERPHelper.Instance.ApplyBindingSettings(ItemForTechCode, ItemBindingType.Required);
ERPHelper.Instance.ApplyBindingSettings(ItemForTechContent, ItemBindingType.Required);
var ProdInfoList = codeService.GetCodeDataByCodeId("PROCPMS");
SetGridLookUpEdit(TechCodeTextEdit, ProdInfoList, 1);
}
/// <summary>
/// 加载初始化
/// </summary>
public override void OnAttachEvent()
{
dataLayoutControl1.OptionsView.IsReadOnly = DevExpress.Utils.DefaultBoolean.True;
//班次
var codeData = codeService.GetCodeDataByCodeId("SHIFT");
SetGridLookUpEdit(ShiftCodeTextEdit, codeData, 1);
SetGridLookUpEdit(repositoryItemShiftCode, codeData, 1);
var empList = employeeService.GetEmployeeData();
SetGridLookUpEdit(SupervisorTextEdit, empList, 2);
SetGridLookUpEdit(OperatorTextEdit, empList, 2);
SetGridLookUpEdit(QCOperatorTextEdit, empList, 2);
var ngItemList = codeService.GetCodeDataByCodeId("NGPROCESS");
SetGridLookUpEdit(repositoryItemNgItem, ngItemList);
//SetGridLookUpEdit
}
private void MES501PortalForm_Load(object sender, EventArgs e)
{
var machineList = codeService.GetCodeDataByCodeId("MACHINE").Select(a => new { 机台编号 = a.Value, 机台名称 = a.DisPlayName }).ToList();
SetGridLookUpEdit(txtMacCode, machineList, "机台名称", "机台编号");
var shiftList = codeService.GetListByCodeID("SHIFT").Select(a => new { 班次 = a.Description, 代号 = a.Code }).ToList();
SetGridLookUpEdit(txtShiftCode, shiftList, "班次", "代号");
//txtMacCode.Properties.DataSource = machineList;
//txtMacCode.Properties.DisplayMember = "机台名称";
//txtMacCode.Properties.ValueMember = "机台编号";
}
protected override void InitData()
{
ERPHelper.Instance.SetGridLookUpEdit(CustCodeTextEdit, customerService.GetCustomerInputData(), 2); //客户
ERPHelper.Instance.SetGridLookUpEdit(StatusTextEdit, codeService.GetCodeDataByCodeId("ST"), 2); //状态
ERPHelper.Instance.SetGridLookUpEdit(ProcessFlowTextEdit, processFlowService.GetProcessFlowInputData(), 2); //工艺流程
CustCodeTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(CustCodeTextEdit_EditValueChanging);
StatusTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(CustCodeTextEdit_EditValueChanging);
ProcessFlowTextEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(CustCodeTextEdit_EditValueChanging);
this.gridView1.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gridView1_CellValueChanged);
this.gridView1.RowCountChanged += new EventHandler(gridView1_RowCountChanged);
this.gridView1.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(gridView1_FocusedRowChanged);
this.mESM002JobBindingSource.DataSource = jobData;
this.mESM002JobLotBindingSource.DataSource = jobService.GetJobLotListByJobNo(jobData.JobNo);
this.mESM002JobLotProcessBindingSource.DataSource = new List <MES_M002_Job_Lot_Process>();
}
public override void InitData()
{
//级别
SetGridLookUpEdit(repositoryItemLevel, codeService.GetCodeDataByCodeId("PLLEVEL"), 1);
//状态
SetGridLookUpEdit(repositoryItemStatus, codeService.GetCodeDataByCodeId("PLSTATUS"), 1);
//班次
var codeData = codeService.GetCodeDataByCodeId("SHIFT");
SetGridLookUpEdit(repositoryItemShift, codeData, 1);
//机台
codeData = codeService.GetCodeDataByCodeId("MACHINE");
SetGridLookUpEdit(repositoryItemMac, codeData, 1);
//客户
var customerData = customerServer.GetCustomerInputData();
SetGridLookUpEdit(repositoryItemCustomer, customerData, 1);
//计划单
var planData = planDetailService.GetInputList();
SetGridLookUpEdit(repositoryItemPlan, planData, 5);
SetGridLookUpEdit(repositoryItemPROC, codeService.GetCodeDataByCodeId("PROC"));
SetGridLookUpEdit(repositoryItemPROCPMS, codeService.GetCodeDataByCodeId("PROCPMS"));
SetGridLookUpEdit(repositoryItemPROCPMSTATUS, codeService.GetCodeDataByCodeId("PROCPMSTATUS"));
var tastDetailQuery = taskDetailService.GetQuery();
if (string.IsNullOrWhiteSpace(txtTxDt1.Text) || string.IsNullOrWhiteSpace(txtTxDt2.Text))
{
throw new AppException("请先输入任务单日期");
}
var taskDetailList =
tastDetailQuery.Where(
a => a.TaskDt >= txtTxDt1.DateTime && a.TaskDt <= txtTxDt2.DateTime && a.Status != "03").ToList();
mESM202TaskDetailBindingSource.DataSource = taskDetailList;
//this.gridTask.BestFitColumns();
this.gridTaskDetail.BestFitColumns();
}
protected override void InitData()
{
var ngItemList = codeService.GetCodeDataByCodeId("NGPROCESS");
SetGridLookUpEdit(repositoryItemNgItem, ngItemList);
//var processCodes = ykdbContext.Set<MES_M003_JobLotTx>().Where(a => a.JobLotNo == jobLotNo).Select(a => a.ProcessCode).ToList();
var info = codeService.GetListByCodeID("NGPROCESS").Select(a => new MES_M501_JobTx_NG {
CurrProcessCode = "金丝", ProcessCode = "", NGCode = a.Code, NGQty = 0, JobNo = jobLotNo, CreateDt = DateTime.Now
}).ToList().OrderBy(a => a.NGCode).ToList();
//var JobLotTx_NG = jobtxNgService.GetQuery().Where(a => a.JobNo == jobLotNo && a.CurrProcessCode == currProcessCode).ToList();
//JobLotTx_NG.ForEach(a =>
//{
// var joblot = info.Where(b => b.NGCode == a.NGCode).FirstOrDefault();
// if (joblot != null)
// {
// joblot.NGQty = a.NGQty;
// joblot.CurrProcessCode = a.CurrProcessCode;
// }
//});
this.mESM501JobTxNGBindingSource.DataSource = info;//
}
protected override void InitData()
{
//级别
SetGridLookUpEdit(repositoryItemLevel, codeService.GetCodeDataByCodeId("PLLEVEL"), 1);
//状态
SetGridLookUpEdit(repositoryItemStatus, codeService.GetCodeDataByCodeId("PLSTATUS"), 1);
//班次
var codeData = codeService.GetCodeDataByCodeId("SHIFT");
SetGridLookUpEdit(repositoryItemShift, codeData, 1);
//机台
codeData = codeService.GetCodeDataByCodeId("MACHINE");
SetGridLookUpEdit(repositoryItemMac, codeData, 1);
//产品
var productData = productService.GetProductInputData();
SetGridLookUpEdit(repositoryProduct, productData, 1);
//客户
var customerData = customerServer.GetCustomerInputData();
SetGridLookUpEdit(repositoryItemCustomer, customerData, 1);
repositoryItemCustomer.DisplayMember = "Value";
//计划单
var planData = planDetailService.GetInputList();
SetGridLookUpEdit(repositoryItemPlan, planData, 5);
//repositoryItemPlan.DisplayMember = "Value";
//repositoryItemPlan.View.Columns[0].Caption = "计划单号";
repositoryItemPlan.View.Columns[1].Caption = "SO工单";
repositoryItemPlan.View.Columns[2].Caption = "料号";
repositoryItemPlan.View.Columns[3].Caption = "品名";
repositoryItemPlan.View.Columns[4].Caption = "数量";
repositoryItemPlan.View.Columns[5].Caption = "完成数量";
this.mESM202TaskBindingSource.DataSource = tempData;
var TaskDtlList = TaskService.GetProductQuery().Where(a => a.TaskNo == tempData.TaskNo).ToList();
foreach (var taskDtl in TaskDtlList)
{
var planDetail = planDetailService.GetById(taskDtl.PlanDetailId.ToGuid());
if (planDetail != null)
{
taskDtl.PlanSumQty = planDetail.SumQty;
taskDtl.PlanFQty = planDetail.FQty;
}
}
var count = TaskDtlList.Count;
//新增自动添加20空行
for (int i = 0; i < 20 - count; i++)
{
MES_M202_Task_Detail taskdtl = new MES_M202_Task_Detail();
taskdtl.TaskNo = tempData.TaskNo;
taskdtl.FQty = 0;
taskdtl.JobQty = 0;
TaskDtlList.Add(taskdtl);
}
this.mESM202TaskDetailBindingSource.DataSource = TaskDtlList;
//this.gridProduct.BestFitColumns();
//this.gridMaterial.BestFitColumns();
}
public override void OnAttachEvent()
{
SetGridLookUpEdit(repositoryItemPROC, codeService.GetCodeDataByCodeId("PROC"));
SetGridLookUpEdit(repositoryItemPROCPMS, codeService.GetCodeDataByCodeId("PROCPMS"));
SetGridLookUpEdit(repositoryItemPROCPMSTATUS, codeService.GetCodeDataByCodeId("PROCPMSTATUS"));
}
public override void OnAttachEvent()
{
var ProdInfoList = codeService.GetCodeDataByCodeId("PROCPMS");
SetGridLookUpEdit(repositoryItemPROCPMS, ProdInfoList, 1);
}
protected override void InitData()
{
this.mESM001OrderBindingSource.DataSource = orderData;
this.mESM001OrderDetailBindingSource.DataSource = orderService.GetOrderDetailByOrderNo(orderData.OrdNo);
ERPHelper.Instance.SetGridLookUpEdit(StatusTextEdit, codeService.GetCodeDataByCodeId("BC"), 2);//班次
}