private void btn_Write_Click(object sender, EventArgs e)
{
if (t == null)
{
MessageBox.Show("측정항목을 선택해주세요.", "알림");
}
else
{
InsertCon_Vo vo = new InsertCon_Vo();
vo.Condition_Val = Convert.ToDecimal(txt_MeasuredValue.Text);
vo.Item_Name = txt_Item.Text;
vo.Wc_Name = txt_WorkPlace.Text;
vo.Workorderno = cb_WorkNum.Text;
vo.Condition_Group = t.ToString();
InsertCon_Service service = new InsertCon_Service();
service.InsertInspect(vo);
txt_MeasuredValue.Text = "";
MessageBox.Show("입력완료", "알림");
SetVal();
}
//Inspect_Service service = new Inspect_Service();
//Inspect_Vo vo = new Inspect_Vo();
//vo.Item_Name = d;
//vo.Inspect_Val = Convert.ToDecimal(txt_MeasuredValue.Text);
//service.InsertInspect(vo);
//MessageBox.Show("입력 완료");
}
private void SetVal()
{
InsertCon_Service service = new InsertCon_Service();
InsertCon_Vo vo = new InsertCon_Vo();
vo.Item_Name = txt_Item.Text;
vo.Wc_Name = txt_WorkPlace.Text;
vo.Condition_Group = t.ToString();
dataGridView2.DataSource = service.GetConditionVal(vo);
}
public List <InsertCon_Vo> GetConditionVal(InsertCon_Vo item)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "GetConditionVal";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Item_Name", item.Item_Name);
cmd.Parameters.AddWithValue("@Wc_Name", item.Wc_Name);
cmd.Parameters.AddWithValue("@Condition_Group", item.Condition_Group);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <InsertCon_Vo> list = Helper.DataReaderMapToList <InsertCon_Vo>(reader);
cmd.Connection.Close();
return(list);
}
}
public List <InsertCon_Vo> GetConditionVal(InsertCon_Vo item)
{
InsertCon_Dac dac = new InsertCon_Dac();
return(dac.GetConditionVal(item));
}
public List <InsertCon_Vo> InsertInspect(InsertCon_Vo item)
{
InsertCon_Dac dac = new InsertCon_Dac();
return(dac.InsertInspect(item));
}
