public static void Add()
{
List <TVD> TVDs = new List <TVD>();
for (int i = 0; i < Current.ovens.Count; i++)
{
if (Current.ovens[i].IsAlive)
{
for (int j = 0; j < Current.ovens[i].Floors.Count; j++)
{
if (Current.ovens[i].Floors[j].IsBaking)
{
for (int k = 0; k < Current.ovens[i].Floors[j].Stations.Count; k++)
{
TVD tvd = new TVD();
tvd.StationId = Current.ovens[i].Floors[j].Stations[k].Id;
tvd.UserId = TengDa.WF.Current.user.Id;
tvd.RunMinutes = Current.ovens[i].Floors[j].RunMinutes;
tvd.T = Current.ovens[i].Floors[j].Stations[k].Temperatures;
tvd.V1 = Current.ovens[i].Floors[j].Vacuum;
TVDs.Add(tvd);
}
}
}
}
}
string msg = string.Empty;
if (!TVD.Add(TVDs, out msg))
{
Error.Alert(msg);
}
}
public static int Add(TVD addTVD, out string msg)
{
StringBuilder sb = new StringBuilder();
sb.Append(string.Format("INSERT INTO [dbo].[{0}] ", TableName));
sb.Append("([StationId], [T1], [T2], [T3], [T4], [T5], [T6], [T7], [T8], [V1], [RunMinutes], [Time], [UserId]) ");
sb.Append(string.Format("VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, '{11}', {12})",
addTVD.StationId,
addTVD.T[0], addTVD.T[1], addTVD.T[2], addTVD.T[3], addTVD.T[4], addTVD.T[5], addTVD.T[6], addTVD.T[7],
addTVD.V1, addTVD.RunMinutes, DateTime.Now, addTVD.UserId));
return(Database.Insert(sb.ToString(), out msg));
}
