public bool InsertConditionMaster(ConditionSpecVo vo) { int Checked = 0; using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @"insert into Condition_Spec_Master(Item_Code, Wc_Code, Condition_Code, Condition_Name, Spec_Desc, USL, SL, LSL, Condition_Group, Condition_Unit, Use_YN, Remark, Ins_Emp, Ins_Date, Up_Emp, Up_Date) values (@Item_Code, @Wc_Code, @Condition_Code, @Condition_Name, @Spec_Desc, @USL, @SL, @LSL, @Condition_Group, @Condition_Unit, @Use_YN, @Remark, '김민우', @Ins_Date, '김민우', @Ins_Date)"; cmd.Parameters.AddWithValue("@Item_Code", vo.Item_Code); cmd.Parameters.AddWithValue("@Wc_Code", vo.Wc_Code); cmd.Parameters.AddWithValue("@Condition_Code", vo.Condition_Code); cmd.Parameters.AddWithValue("@Condition_Name", vo.Condition_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("@Condition_Group", vo.Condition_Group); cmd.Parameters.AddWithValue("@Condition_Unit", vo.Condition_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 InsertCondSpecsMaster(ConditionSpecVo vo) { ConditionSpecDAC dac = new ConditionSpecDAC(); return(dac.InsertConditionMaster(vo)); }