public bool InsertInspectMaster(InspectVo vo)
{
int Checked = 0;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(ConnectionString);
cmd.CommandText = @"insert into Inspect_Spec_Master(Item_Code, Process_Code, Inspect_Code, Inspect_Name, Spec_Desc, USL, SL, LSL, Inspect_Group, Inspect_Unit, Use_YN, Remark, Ins_Emp, Ins_Date, Up_Emp, Up_Date)
values (@Item_Code, @Process_Code, @Inspect_Code, @Inspect_Name, @Spec_Desc, @USL, @SL, @LSL, @Inspect_Group, @Inspect_Unit, @Use_YN, @Remark, '김민우', @Ins_Date, '김민우', @Ins_Date)";
cmd.Parameters.AddWithValue("@Item_Code", vo.Item_Code);
cmd.Parameters.AddWithValue("@Process_Code", vo.Process_Code);
cmd.Parameters.AddWithValue("@Inspect_Code", vo.Inspect_Code);
cmd.Parameters.AddWithValue("@Inspect_Name", vo.Inspect_Name);
cmd.Parameters.AddWithValue("@Spec_Desc", vo.Spec_Desc);
cmd.Parameters.AddWithValue("@USL", vo.USL);
cmd.Parameters.AddWithValue("@SL", vo.SL);
cmd.Parameters.AddWithValue("@LSL", vo.LSL);
cmd.Parameters.AddWithValue("@Inspect_Group", vo.Inspect_Group);
cmd.Parameters.AddWithValue("@Inspect_Unit", vo.Inspect_Unit);
cmd.Parameters.AddWithValue("@Use_YN", vo.Use_YN);
cmd.Parameters.AddWithValue("@Remark", vo.Remark);
cmd.Parameters.AddWithValue("@Ins_Date", DateTime.Now);
cmd.Connection.Open();
Checked = cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
return(Checked == 1 ? true : false);
}
public bool InsertInspectMaster(InspectVo vo)
{
InspectDAC dac = new InspectDAC();
return(dac.InsertInspectMaster(vo));
}
