예제 #1
0
        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();
            }
        }
예제 #2
0
        public void InsQuality(InsQualityVO insert)
        {
            QualityDAC dac = new QualityDAC();

            dac.InsQuality(insert);
        }