private void TsbtnSave_Click(object sender, EventArgs e)
{
WorkOrderAllVO order = new WorkOrderAllVO();
order.Workorderno = txtWorkNum.TextBoxText;
order.Plan_Qty = Convert.ToInt32(numPlanQuantity.Value);
order.Plan_Unit = txtPlanUnit.Text;
order.Plan_Date = dtpPlanDate.Value;
try
{
WorkOrder_Service service = new WorkOrder_Service();
bool result = service.UpdatePPSWorkorder(order);
if (result)
{
MessageBox.Show("작업지시 계획이 변경되었습니다.", "작업지시관리", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("작업지시 계획이 변경되지 않았습니다.", "작업지시관리", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
RefreshFormShow(null, null);
}
}
/// <summary>
/// 작업지시목록에서 선택한 작업의 계획변경
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public bool UpdatePPSWorkorder(WorkOrderAllVO order)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(Connstr);
cmd.CommandText = "update WorkOrder set Plan_Qty=@Plan_Qty, Plan_Date=@Plan_Date, Plan_Unit=@Plan_Unit where Workorderno = @Workorderno";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Workorderno", order.Workorderno);
cmd.Parameters.AddWithValue("@Plan_Qty", order.Plan_Qty);
cmd.Parameters.AddWithValue("@Plan_Date", order.Plan_Date);
cmd.Parameters.AddWithValue("@Plan_Unit", order.Plan_Unit);
cmd.Connection.Open();
int result = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(result > 0);
}
}
private void BtnOK_Click(object sender, EventArgs e)
{
WorkOrderAllVO order = new WorkOrderAllVO();
order.Req_Seq = Convert.ToInt32(txtSeq.Text);
order.Wo_Req_No = txtReqNo.Text;
order.Wo_Status = "생산대기";
order.Wc_Code = cboWorkCenter.SelectedValue.ToString();
order.Remark = txtRemark.Text;
order.Plan_Qty = Convert.ToInt32(txtPlanQty.Text);
order.Out_Qty_Main = 0;
order.In_Qty_Main = 0;
order.Prd_Qty = 0;
order.Plan_Date = dtpDate.Value;
order.Item_Code = txtItemCode.Text;
order.Plan_Unit = txtPlanUnit.Text;
order.Prd_Unit = txtPlanUnit.Text;
try
{
bool result = workservice.InsertPPSWorkorder(order, UserInfo.User_ID);
if (result)
{
MessageBox.Show("작업지시가 생성되었습니다.", "작업지시관리", MessageBoxButtons.OK);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("작업지시가 생성되지 않았습니다.", "작업지시관리", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception err)
{
Program.Log.WriteError(err.Message);
}
}
/// <summary>
/// PPS_SCH_001 생산의뢰에 따른 작업지시생성
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public bool InsertPPSWorkorder(WorkOrderAllVO order, string user)
{
int result = 0;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(Connstr);
cmd.CommandText = "InsertPPSWorkOrder";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Req_Seq", order.Req_Seq);
cmd.Parameters.AddWithValue("@Wo_Req_No", order.Wo_Req_No);
cmd.Parameters.AddWithValue("@Workorderno", "WK" + DateTime.Now.ToString("yyMMddHHmmss"));
cmd.Parameters.AddWithValue("@Wo_Status", order.Wo_Status);
cmd.Parameters.AddWithValue("@Wc_Code", order.Wc_Code);
cmd.Parameters.AddWithValue("@Remark", order.Remark);
cmd.Parameters.AddWithValue("@Plan_Qty", order.Plan_Qty);
cmd.Parameters.AddWithValue("@Out_Qty_Main", order.Out_Qty_Main);
cmd.Parameters.AddWithValue("@In_Qty_Main", order.In_Qty_Main);
cmd.Parameters.AddWithValue("@Prd_Qty", order.Prd_Qty);
cmd.Parameters.AddWithValue("@Plan_Date", order.Plan_Date);
cmd.Parameters.AddWithValue("@Item_Code", order.Item_Code);
cmd.Parameters.AddWithValue("@Plan_Unit", order.Plan_Unit);
cmd.Parameters.AddWithValue("@User", user);
cmd.Parameters.AddWithValue("@Wo_Order", 2);
cmd.Parameters.AddWithValue("@Prd_Unit", order.Prd_Unit);
cmd.Connection.Open();
result = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(result > 0);
//cmd.Connection = new SqlConnection(Connstr);
//for (int i = 2; i < 6; i++)
//{
// cmd.CommandText = "InsertPPSWorkOrder";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Clear();
// cmd.Parameters.AddWithValue("@Req_Seq", order.Req_Seq);
// cmd.Parameters.AddWithValue("@Wo_Req_No", order.Wo_Req_No);
// cmd.Parameters.AddWithValue("@Workorderno", "WK" + DateTime.Now.AddSeconds(i).ToString("yyMMddHHmmss"));
// cmd.Parameters.AddWithValue("@Wo_Status", order.Wo_Status);
// cmd.Parameters.AddWithValue("@Wc_Code", "WC" + i.ToString() + order.Wc_Code.Substring(3, 4));
// cmd.Parameters.AddWithValue("@Remark", order.Remark);
// cmd.Parameters.AddWithValue("@Plan_Qty", order.Plan_Qty);
// cmd.Parameters.AddWithValue("@Out_Qty_Main", order.Out_Qty_Main);
// cmd.Parameters.AddWithValue("@In_Qty_Main", order.In_Qty_Main);
// cmd.Parameters.AddWithValue("@Prd_Qty", order.Prd_Qty);
// cmd.Parameters.AddWithValue("@Plan_Date", order.Plan_Date);
// cmd.Parameters.AddWithValue("@Item_Code", order.Item_Code);
// cmd.Parameters.AddWithValue("@Plan_Unit", order.Plan_Unit);
// cmd.Parameters.AddWithValue("@User", user);
// cmd.Parameters.AddWithValue("@Wo_Order", i);
// cmd.Parameters.AddWithValue("@Prd_Unit", order.Prd_Unit);
// cmd.Connection.Open();
// result = cmd.ExecuteNonQuery();
// cmd.Connection.Close();
//}
//return result > 0;
}
}
/// <summary>
/// PPS_SCH_001 작업지시생성하기
/// </summary>
/// <param name="order">작업지시입력정보VO</param>
/// <returns></returns>
public bool InsertPPSWorkorder(WorkOrderAllVO order, string user)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.InsertPPSWorkorder(order, user));
}
/// <summary>
/// PPS_SCH_002 작업지시계획변경
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public bool UpdatePPSWorkorder(WorkOrderAllVO order)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.UpdatePPSWorkorder(order));
}
