public void InsQuality(InsQualityVO Vo) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @" insert into Inspect_Measure_History(Item_Code,Process_Code,Inspect_Code,Inspect_Date,Inspect_Datetime,Inspect_Val,WorkOrderNo,Ins_Date) values (@Item_Code,@Process_Code,@Inspect_Code,GETDATE(),GETDATE(),@Inspect_Val,@WorkOrderNo,GETDATE()) "; cmd.CommandType = System.Data.CommandType.Text; 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_Val", Vo.Inspect_Val); cmd.Parameters.AddWithValue("@WorkOrderNo", Vo.WorkOrderNo); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public void InsQuality(InsQualityVO insert) { QualityDAC dac = new QualityDAC(); dac.InsQuality(insert); }