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);
}
}
