/// <summary>
/// 입력
/// </summary>
/// <param name="item">itemcode, wccode, conditioncode, conditionval, workorderno</param>
/// <returns></returns>
public bool InsertConditionMeasure(ConditionMeasureVO item, string editor)
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText =
@" INSERT INTO Condition_Measure_History (
Item_code
,Wc_Code
,Condition_Code
,Condition_Date
,Condition_Datetime
,Condition_Val
,Workorderno
,Ins_Date
,Ins_Emp
,Up_Date
,Up_Emp
)
VALUES (
@Item_code
,@Wc_Code
,@Condition_Code
,getdate()
,getdate()
,@Condition_Val
,@Workorderno
,getdate()
,@username
,getdate()
,@username
); " ;
comm.CommandType = CommandType.Text;
comm.Parameters.AddWithValue("@Item_code", item.Item_code);
comm.Parameters.AddWithValue("@Wc_Code", item.Wc_Code);
comm.Parameters.AddWithValue("@Condition_Code", item.Condition_Code);
comm.Parameters.AddWithValue("@Condition_Val", item.Condition_Val);
comm.Parameters.AddWithValue("@Workorderno", item.Workorderno);
comm.Parameters.AddWithValue("@username", editor);
comm.Connection.Open();
int result = comm.ExecuteNonQuery();
comm.Connection.Close();
return(result > 0);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("추가하시겠습니까?", "추가여부", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ConditionMeasureVO item = new ConditionMeasureVO();
item.Item_code = Item_code;
item.Wc_Code = Wc_Code;
item.Condition_Code = Condition_Code;
item.Condition_Val = nudusl.Value;
item.Workorderno = Workorderno;
bool IsSuccess = cmhService.InsertConditionMeasure(item, lblManager.Text); //품질측정 추가 조회
if (IsSuccess)
{
MessageBox.Show("성공적으로 추가하였습니다.", "추가성공", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("추가에 실패하였습니다.", "추가오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnInsertMeasure_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(lblConditionCode.Text))
{
Condition_Measure_HistoryService service = new Condition_Measure_HistoryService();
ConditionMeasureVO item = new ConditionMeasureVO();
item.Item_code = lblItemCode.Text;
item.Wc_Code = lblWcCode.Text;
item.Condition_Code = lblConditionCode.Text;
item.Condition_Val = nudMeasure.Value;
item.Workorderno = GlobalUsage.WorkOrderNo;
if (service.InsertConditionMeasure(item, GlobalUsage.UserID))
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 공정조건({lblConditionCode.Text})에 값({nudMeasure.Value})을 넣는데에 성공하였음");
SearchData();
nudMeasure.Value = 0;
}
else
{
Program.Log.WriteInfo($"{GlobalUsage.UserID}이(가) 공정조건({lblConditionCode.Text})에 값({nudMeasure.Value})을 넣으려 하였으나 실패하였음");
MessageBox.Show("입력할 수 없는 항목입니다.");
}
}
}
/// <summary>
/// 입력
/// </summary>
/// <param name="item">itemcode, wccode, conditioncode, conditionval, workorderno</param>
/// <returns></returns>
public bool InsertConditionMeasure(ConditionMeasureVO item, string editor)
{
Condition_Measure_HistoryDAC dac = new Condition_Measure_HistoryDAC();
return(dac.InsertConditionMeasure(item, editor));
}
