public Valueset(int myvaluesetid) { valitems = new List <Valuesetitem>(); fieldvaluesetid = myvaluesetid; SQL_utils sql = new SQL_utils("data"); DataTable dt = sql.DataTable_from_SQLstring(String.Format("select * from datFieldValueSetItem where fieldvaluesetid = {0}", fieldvaluesetid)); foreach (DataRow row in dt.Rows) { int val = Convert.ToInt32(row["FieldValue"]); string label = row["FieldValueLabel"].ToString(); Valuesetitem itm = new Valuesetitem(val, label); valitems.Add(itm); } sql.Close(); }
public Valueset(string raw_vallabels) { string[] delimiter = new string[] { " | " }; List <string> raw_vallabel = raw_vallabels.Split(delimiter, StringSplitOptions.RemoveEmptyEntries).ToList(); if (raw_vallabel.Count > 0) { valitems = new List <Valuesetitem>(); foreach (string raw_vl in raw_vallabel) { List <string> val_and_label = raw_vl.Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries).ToList(); Valuesetitem vi = new Valuesetitem(Convert.ToInt32(val_and_label[0]), val_and_label[1]); if (vi != null) { valitems.Add(vi); } } } }
public Valueset(string tblname, string fldname) { valitems = new List <Valuesetitem>(); SQL_utils sql = new SQL_utils("data"); DataTable dt = sql.DataTable_from_SQLstring(String.Format("select * from datFieldValueSetItem where fieldvaluesetid = " + " (select fieldvaluesetid from def.fld where tblpk={0} and fldname='{1}')", tblname, fldname)); fieldvaluesetid = dt.AsEnumerable().Select(f => f.Field <int>("fieldvaluesetid")).Min(); foreach (DataRow row in dt.Rows) { int val = Convert.ToInt32(row["FieldValue"]); string label = row["FieldValueLabel"].ToString(); Valuesetitem itm = new Valuesetitem(val, label); valitems.Add(itm); } sql.Close(); }
public Variable(SpssLib.SpssDataset.Variable spssvar) { varname = spssvar.Name; varlabel = spssvar.Label; //if (spssvar.IsDate()) datatype = "date"; //else if (spssvar.Type == SpssLib.SpssDataset.DataType.Numeric) datatype = "float"; //else if (spssvar.Type == SpssLib.SpssDataset.DataType.Text) datatype = "varchar"; if (spssvar.IsDate()) { datatype = new Datatype(SqlDatatype.Date); } else if (spssvar.Type == SpssLib.SpssDataset.DataType.Numeric) { datatype = new Datatype(SqlDatatype.Float); } else if (spssvar.Type == SpssLib.SpssDataset.DataType.Text) { datatype = new Datatype(SqlDatatype.Varchar); } if (spssvar.ValueLabels != null) { if (spssvar.ValueLabels.Count > 0) { Valueset valset = new Valueset(); foreach (KeyValuePair <double, string> label in spssvar.ValueLabels) { Valuesetitem itm = new Valuesetitem(label); valset.valitems.Add(itm); } valueset = valset; } } }