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