public int Insert_Condition_CurStationInfo_Table(Trace_StationStatus_Modle trace_StationStatus_Modle, bool historyFlag) { using (var con = GetOpenConnection()) { return(con.Execute(trace_StationStatus_Dal.Insert_Condition_CurStationInfo_Table(trace_StationStatus_Modle, historyFlag))); } }
public string Insert_Condition_CurStationInfo_Table(Trace_StationStatus_Modle trace_StationStatus_Modle, bool histroyFlag) { if (histroyFlag) { string _insert_sql = "INSERT INTO [AMS].[dbo].[Trace_StationStatus_transfer] ([SN]" + ",[Station],[TrayCode],[StationStatue],[RecordTime],[WorkOrder],[StationBeat]) VALUES('" + trace_StationStatus_Modle.SN + "','" + trace_StationStatus_Modle.Station + "','" + trace_StationStatus_Modle.TrayCode + "'," + trace_StationStatus_Modle.StationStatue + ",'" + trace_StationStatus_Modle.RecordTime + "','" + trace_StationStatus_Modle.WorkOrder + "','" + trace_StationStatus_Modle.StationBeat + "')"; return(_insert_sql); } else { string _insert_sql = "INSERT INTO [AMS].[dbo].[Trace_StationStatus] ([SN]" + ",[Station],[TrayCode],[StationStatue],[RecordTime],[WorkOrder],[StationBeat]) VALUES('" + trace_StationStatus_Modle.SN + "','" + trace_StationStatus_Modle.Station + "','" + trace_StationStatus_Modle.TrayCode + "'," + trace_StationStatus_Modle.StationStatue + ",'" + trace_StationStatus_Modle.RecordTime + "','" + trace_StationStatus_Modle.WorkOrder + "','" + trace_StationStatus_Modle.StationBeat + "')"; return(_insert_sql); } }