public override StandardValuesCollection GetStandardValues( ITypeDescriptorContext context) { string name = context.PropertyDescriptor.Name; string field = null; if (name == "User") { field = "RUser"; } else if (name == "TypeSize") { field = "TypeSize"; } else if (name == "Client") { field = "Client"; } else if (name == "SG") { field = "SolidGroup"; } else if (name == "Result") { field = "Result"; } List <string> L = new List <string>(); SelectionPars sp = context.Instance as SelectionPars; L.Add(null); Select S = new Select(string.Format("SELECT DISTINCT {0} FROM Tubes where DT >= @DT0 and DT <= @DT1 order by {0}", field)); S.AddParam("@DT0", System.Data.SqlDbType.DateTime, sp.DT0); S.AddParam("@DT1", System.Data.SqlDbType.DateTime, sp.DT1); while (S.Read()) { L.Add(Convert.ToString(S[0])); } S.Dispose(); return(new StandardValuesCollection(L)); }
public ParSet() { LWinPars = new L_WinPars(); Selection = new SelectionPars(); }