Example #1
0
 public int Insert_Condition_Material_Table(Trace_Keypart_Modle trace_Keypart_Modle)
 {
     using (var con = GetOpenConnection())
     {
         return(con.Execute(trace_Keypart_Dal.Insert_Condition_Material_Table(trace_Keypart_Modle)));
     }
 }
Example #2
0
        public string Insert_Condition_Material_Table(Trace_Keypart_Modle trace_Keypart_Modle)
        {
            string _insert_sql = "INSERT INTO [AMS].[dbo].[Trace_Keypart] ([ComponentName]"
                                 + ",[ComponentBarcode],[SN],[Station],[RecordTime]) VALUES('"
                                 + trace_Keypart_Modle.ComponentName + "','" + trace_Keypart_Modle.ComponentBarcode
                                 + "','" + trace_Keypart_Modle.SN + "','" + trace_Keypart_Modle.Station
                                 + "','" + trace_Keypart_Modle.RecordTime + "')";

            return(_insert_sql);
        }