/// <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)); }