/// <summary>
/// 금형정보등록 - 저장버튼클릭
/// </summary>
private void TsbtnSave_Click(object sender, EventArgs e)
{
MoldVO minfo = new MoldVO
{
Mold_Code = txtMoldCode.TextBoxText,
Mold_Name = txtMoldName.TextBoxText,
Mold_Group = txtMoldGroup.TextBoxText,
Mold_Status = "양호",
Cum_Prd_Qty = 0,
Cum_Shot_Cnt = 0,
Cum_Time = 0,
Guar_Shot_Cnt = Convert.ToInt32(numHit.Value),
In_Date = dtpInDate.Value,
Last_Setup_Time = dtpLastEquip.Value,
Purchase_Amt = Convert.ToInt32(txtCost.TextBoxText),
Remark = txtRemark.Text,
Use_YN = "N",
Wc_Code = cboWorkCenter.SelectedValue.ToString()
};
bool result = service.InsertMold(minfo);
if (result)
{
MessageBox.Show("금형정보가 등록되었습니다.", "금형관리");
}
else
{
MessageBox.Show("금형정보등록에 실패하였습니다.", "금형관리", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
RefreshFormShow(null, null);
}
/// <summary>
/// 금형정보등록
/// </summary>
/// <param name="minfo">금형정보가담긴VO</param>
/// <returns>true/false</returns>
public bool InsertMold(MoldVO minfo)
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText = @"insert into Mold_Master( Mold_Code,Mold_Name,Mold_Group,Mold_Status,Cum_Shot_Cnt,Cum_Prd_Qty
,Cum_Time,Guar_Shot_Cnt,Purchase_Amt,In_Date,Last_Setup_Time,Wc_Code,Remark
,Use_YN,Ins_Date,Ins_Emp,Up_Date,Up_Emp) values ( @Mold_Code, @Mold_Name, @Mold_Group, @Mold_Status, @Cum_Shot_Cnt, @Cum_Prd_Qty
, @Cum_Time, @Guar_Shot_Cnt, @Purchase_Amt, @In_Date, @Last_Setup_Time, @Wc_Code,@Remark
, @Use_YN, SYSDATETIME(),'김상영', SYSDATETIME(),'김상영')";
comm.Parameters.AddWithValue("@Mold_Code", minfo.Mold_Code);
comm.Parameters.AddWithValue("@Mold_Name", minfo.Mold_Name);
comm.Parameters.AddWithValue("@Mold_Group", minfo.Mold_Group);
comm.Parameters.AddWithValue("@Mold_Status", minfo.Mold_Status);
comm.Parameters.AddWithValue("@Cum_Shot_Cnt", minfo.Cum_Shot_Cnt);
comm.Parameters.AddWithValue("@Cum_Prd_Qty", minfo.Cum_Prd_Qty);
comm.Parameters.AddWithValue("@Cum_Time", minfo.Cum_Time);
comm.Parameters.AddWithValue("@Guar_Shot_Cnt", minfo.Guar_Shot_Cnt);
comm.Parameters.AddWithValue("@Purchase_Amt", minfo.Purchase_Amt);
comm.Parameters.AddWithValue("@In_Date", minfo.In_Date);
comm.Parameters.AddWithValue("@Last_Setup_Time", minfo.Last_Setup_Time);
comm.Parameters.AddWithValue("@Wc_Code", minfo.Wc_Code);
comm.Parameters.AddWithValue("@Remark", minfo.Remark);
comm.Parameters.AddWithValue("@Use_YN", minfo.Use_YN);
comm.Connection.Open();
int result = comm.ExecuteNonQuery();
comm.Connection.Close();
return(result > 0);
}
}
/// <summary>
/// 금형정보등록
/// </summary>
/// <param name="minfo">금형정보가 담긴 VO</param>
/// <returns>true/false</returns>
public bool InsertMold(MoldVO minfo)
{
MoldDAC dac = new MoldDAC();
return(dac.InsertMold(minfo));
}
private void MachineStart(MachineType machinet)
{
if (!GlobalUsage.WorkOrderNo.Equals("설정안됨"))
{
//기계 설정
setProcess += SetProgress;
machineStop += MachineStop;
machine0 = new Machine
(0, GlobalUsage.WorkOrderNo, GlobalUsage.UserID, GlobalUsage.WcCode,
(value) => btnMachineRun?.Invoke(machineStop, value),
(stackqty, totalqty, prdqty, outqty) => { btnMachineRun?.Invoke(setProcess, stackqty, totalqty); SetGlobalUsage(prdqty, outqty); });
if (!isMachineRun)
{
WorkOrderVO workorder = (dgvMain.DataSource as List <WorkOrderVO>).Find(x => x.Workorderno == GlobalUsage.WorkOrderNo);
InputBox input = new InputBox();
input.StartPosition = FormStartPosition.CenterParent;
input.ShowInTaskbar = false;
if (input.ShowDialog() != DialogResult.OK)
{
return;
}
switch (machinet)
{
case MachineType.Molding: // 성형일경우
// 금형 설정
MoldService service = new MoldService();
List <MoldVO> moldlist = service.GetMoldList(wccode: GlobalUsage.WcCode);
if (moldlist.Count < 1)
{
MessageBox.Show("작업장에 장착된 금형이 없습니다.");
btnMachineRun.BackColor = Color.FromArgb(218, 239, 245);
isMachineRun = false;
return;
}
MoldVO mold = moldlist[0];
// 대차 확인
GV_MasterService gvservice = new GV_MasterService();
List <GVVO> gvlist = gvservice.GetAllByGV("성형그룹", "빈대차");
if (input.Qty.Value > (workorder.Dry_GV_Qty * gvlist.Count))
{
MessageBox.Show("성형대차가 부족합니다.");
return;
}
// 기계 실행
Program.Log.WriteInfo($"{GlobalUsage.UserName}이(가) 작업({GlobalUsage.WorkOrderNo})의 성형기계로 금형({mold.Mold_Code})을 이용해 품목({workorder.Item_Code})을 생산함");
machine0.MachineStart(input.Qty.Value, new Item_MoldPair(workorder.Item_Code, mold.Mold_Code, workorder.Line_Per_Qty));
break;
}
// 공통
btnMachineRun.BackColor = Color.FromArgb(243, 228, 231);
isMachineRun = true;
progressMachine.Visible = true;
}
}
else
{
Program.Log.WriteInfo($"{GlobalUsage.UserName}이(가) 작업지시를 시작하지 않고 기계를 시작하려함");
MessageBox.Show("작업지시를 시작해주세요");
}
}
