public void Save(MES_M202_Task_Detail taskDetail, List <MES_M202_Task_JobLot> taskJobLotList)
{
tb_Sys_User tempUser = appCacheService.GetItem("user") as tb_Sys_User;
var existstemp = this.GetById(taskDetail.Id);
if (existstemp == null)
{
taskDetail.CompCode = tempUser.CompCode;
taskDetail.CreateDt = DateTime.Now;
taskDetail.CreateUser = tempUser.UserName;
taskDetail.Validate();
this.MES_M202_Task_DetailRepository.Add(taskDetail);
}
else
{
taskDetail.ModifyDt = DateTime.Now;
taskDetail.ModifyUser = tempUser.UserName;
taskDetail.Validate();
this.MES_M202_Task_DetailRepository.SetValues(taskDetail, existstemp);
}
if (taskJobLotList != null)
{
string sql = string.Format("Delete MES_M202_Task_JobLot where JobNo = '{0}'", taskDetail.TaskNo);
taskJobLotRepository.GetDbContext().Database.ExecuteSqlCommand(sql);
foreach (var taskJobLot in taskJobLotList)
{
taskJobLot.JobNo = taskDetail.TaskNo;
taskJobLot.CompCode = tempUser.CompCode;
taskJobLot.Validate();
this.taskJobLotRepository.Add(taskJobLot);
}
}
this.runtimeService.Commit();
}
public MES202TaskDetailEditForm(MES_M202_Task_Detail taskDetail, IMES_M202_Task_DetailService TaskDetailService, ICodeService codeService)
{
InitializeComponent();
this.tempData = taskDetail;
this.TaskDetailService = TaskDetailService;
this.codeService = codeService;
}
public void Create(MES_M202_Task_Detail MES_M202_Task_Detail)
{
MES_M202_Task_Detail.CreateDt = DateTime.Now;
tb_Sys_User tempUser = appCacheService.GetItem("user") as tb_Sys_User;
MES_M202_Task_Detail.CreateUser = tempUser.UserName;
MES_M202_Task_Detail.Validate();
this.MES_M202_Task_DetailRepository.Add(MES_M202_Task_Detail);
this.runtimeService.Commit();
}
public void Update(MES_M202_Task_Detail MES_M202_Task_Detail)
{
MES_M202_Task_Detail.ModifyDt = DateTime.Now;
tb_Sys_User tempUser = appCacheService.GetItem("user") as tb_Sys_User;
MES_M202_Task_Detail.ModifyUser = tempUser.UserName;
MES_M202_Task_Detail.Validate();
var existstb_Sys_Menu = this.GetById(MES_M202_Task_Detail.Id);
this.MES_M202_Task_DetailRepository.SetValues(MES_M202_Task_Detail, existstb_Sys_Menu);
this.runtimeService.Commit();
}
public void Save(MES_M501_JobTx MES_M501_JobTx, MES_M202_Task_Detail task, List <MES_M501_JobTx_NG> jobLotNgList)
{
tb_Sys_User tempUser = appCacheService.GetItem("user") as tb_Sys_User;
var existsdevice = this.GetById(MES_M501_JobTx.Id);
if (existsdevice == null)
{
MES_M501_JobTx.CompCode = tempUser.CompCode;
MES_M501_JobTx.CreateDt = DateTime.Now;
MES_M501_JobTx.CreateUser = tempUser.UserName;
MES_M501_JobTx.Validate();
this.MES_M501_JobTxRepository.Add(MES_M501_JobTx);
}
else
{
MES_M501_JobTx.ModifyDt = DateTime.Now;
MES_M501_JobTx.ModifyUser = tempUser.UserName;
MES_M501_JobTx.Validate();
this.MES_M501_JobTxRepository.SetValues(MES_M501_JobTx, existsdevice);
}
var existsmatSupp = this.taskRepository.GetByID(task.Id);
if (existsmatSupp == null)
{
task.CompCode = tempUser.CompCode;
task.CreateDt = DateTime.Now;
task.CreateUser = tempUser.UserName;
task.Validate();
this.taskRepository.Add(task);
}
else
{
task.ModifyDt = DateTime.Now;
task.ModifyUser = tempUser.UserName;
task.Validate();
this.taskRepository.SetValues(task, existsmatSupp);
}
foreach (var jobLotNg in jobLotNgList)
{
jobLotNg.CompCode = tempUser.CompCode;
jobLotNg.CreateDt = DateTime.Now;
jobLotNg.CreateUser = tempUser.UserName;
jobLotNg.Validate();
jobtxNgRepository.Add(jobLotNg);
}
this.runtimeService.Commit();
}
public void ShenHe(MES_M202_Task_Detail mesM202TaskDetail)
{
mesM202TaskDetail.ModifyDt = DateTime.Now;
tb_Sys_User tempUser = appCacheService.GetItem("user") as tb_Sys_User;
mesM202TaskDetail.ModifyUser = tempUser.UserName;
mesM202TaskDetail.Status = "04";
mesM202TaskDetail.Auditor = tempUser.UserName;
mesM202TaskDetail.AuditingDt = DateTime.Now;
mesM202TaskDetail.Validate();
var existstb_Sys_Menu = this.GetById(mesM202TaskDetail.Id);
this.MES_M202_Task_DetailRepository.SetValues(mesM202TaskDetail, existstb_Sys_Menu);
this.runtimeService.Commit();
}
private void EditForm(string formText, string btnCommand)
{
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
MES202TaskDetailEditForm edit = new MES202TaskDetailEditForm(temp, taskDetailService, codeService);
edit.Text = formText;
edit.Tag = btnCommand;
if (edit.ShowDialog() != DialogResult.OK)
{
mESM202TaskDetailBindingSource.CancelEdit();
}
else
{
mESM202TaskDetailBindingSource_CurrentChanged(null, null);
}
}
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 OnBtnCommand(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
// MessageBox.Show(e.Item.Caption);
//新增
if (e.Item.Caption == BtnCommandEnum.Add)
{
mESM202TaskDetailBindingSource.AddNew();
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
temp.TaskDt = DateTime.Now.Date;
temp.TLevel = "01";
temp.Status = "01";
EditForm("跟踪单新增", BtnCommandEnum.Add);
}
else if (e.Item.Caption == BtnCommandEnum.Edit)
{
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
if (temp == null)
{
throw new AppException("请先选择要修改的数据");
}
EditForm("跟踪单修改", BtnCommandEnum.Edit);
}
else if (e.Item.Caption == BtnCommandEnum.Delete)
{
if (ERPHelper.Instance.MessageDel())
{
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
if (temp == null)
{
throw new AppException("请先选择要删除的数据");
}
taskDetailService.Delete(temp.Id);
mESM202TaskDetailBindingSource.RemoveCurrent();
}
}
else if (e.Item.Caption == BtnCommandEnum.Watch)
{
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
if (temp == null)
{
throw new AppException("请先选择要查看的数据");
}
EditForm("跟踪单查看", BtnCommandEnum.Watch);
}
else if (e.Item.Caption == BtnCommandEnum.Refresh)
{
InitData();
}
else if (e.Item.Caption == "打印任务单")
{
var taskDetailList = mESM202TaskDetailBindingSource.DataSource as List <MES_M202_Task_Detail>;
if (taskDetailList == null)
{
return;
}
//MES_M202_Task temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task;
//班次
var codeData = codeService.GetCodeDataByCodeId("SHIFT");
//客户
var customerData = customerServer.GetCustomerInputData();
foreach (var taskdetail in taskDetailList)
{
taskdetail.ShiftName = codeData.Where(a => a.Value == taskdetail.ShiftCode).Select(a => a.DisPlayName).FirstOrDefault();
taskdetail.CustName = customerData.Where(a => a.Value == taskdetail.CustCode).Select(a => a.DisPlayName).FirstOrDefault();
}
MESTaskReport frmreport = new MESTaskReport(taskDetailList);
ReportShowForm frm = new ReportShowForm(frmreport);
frm.Show();
}
else if (e.Item.Caption == "打印前制单")
{
PrintProcess("前制程");
}
else if (e.Item.Caption == "打印后制单")
{
PrintProcess("后制程");
}
else if (e.Item.Caption == "审核")
{
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
if (temp == null)
{
throw new AppException("请先选择要要审核的数据");
}
else if (temp.Status == "04")
{
throw new AppException("已审核");
}
else
{
taskDetailService.ShenHe(temp);
mESM202TaskDetailBindingSource.ResetCurrentItem();
XtraMessageBox.Show("审核成功");
}
}
else if (e.Item.Caption == "反审")
{
MES_M202_Task_Detail temp = mESM202TaskDetailBindingSource.Current as MES_M202_Task_Detail;
if (temp == null)
{
throw new AppException("请先选择要要审核的数据");
}
else if (temp.Status == "04")
{
temp.Auditor = null;
temp.AuditingDt = null;
temp.Status = "01";
taskDetailService.Update(temp);
mESM202TaskDetailBindingSource.ResetCurrentItem();
XtraMessageBox.Show("反审成功");
}
else
{
XtraMessageBox.Show("未审核");
}
}
}
