public static List <UcmlVcColumn> PrepareVcColumn(SqlConnection conn, int vcOid) { List <UcmlVcColumn> columns = new List <UcmlVcColumn>(); StringBuilder sql = new StringBuilder("select "); sql.Append("FieldName,ChineseName,AllowEdit,Visible,Width,fFixColumn,FixColumnValue,fCustomerControl,CustomerControlHTC,ControlID,EditContrl "); sql.Append("from AppletColumnDataSet "); sql.Append("where AppletOID=" + vcOid); SqlCommand cmd = new SqlCommand(sql.ToString(), conn); SqlDataReader reader = cmd.ExecuteReader(); int i = 0; while (reader.Read()) { UcmlVcColumn column = new UcmlVcColumn(); column.FieldName = Util.GetPropString(reader, 0); column.Caption = Util.GetPropString(reader, 1); column.fCanModify = Util.GetPropBool(reader, 2); column.fDisplay = Util.GetPropBool(reader, 3); column.Width = Util.GetProperInt(reader, 4); column.fFixColumn = Util.GetPropBool(reader, 5); column.FixColumnValue = Util.GetPropString(reader, 6); column.fCustomerControl = Util.GetPropBool(reader, 7); column.CustomerControlHTC = Util.GetPropString(reader, 8); column.ControlID = Util.GetPropString(reader, 9); column.EditContrl = Util.GetPropString(reader, 10); column.CurrentPos = i; i++; columns.Add(column); } reader.Close(); return(columns); }
public static List <UcmlVcColumn> GetVcColumn(SqlConnection conn, string vcOid) { List <UcmlVcColumn> columns = new List <UcmlVcColumn>(); StringBuilder sql = new StringBuilder("select "); sql.Append("FieldName,ChineseName,AllowEdit,Visible,Width,fFixColumn,FixColumnValue,fCustomerControl,CustomerControlHTC,ControlID,"); sql.Append("EditContrl,LeftBracket,RightBracket,LogicConnect,CondiFieldValue,fIsFunctionValue,OperationIndent,InnerLinkComp "); sql.Append("from AppletColumnDataSet "); sql.Append("where AppletOID='" + vcOid + "'"); SqlCommand cmd = new SqlCommand(sql.ToString(), conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UcmlVcColumn column = new UcmlVcColumn(); column.FieldName = Util.GetPropString(reader, 0); column.Caption = Util.GetPropString(reader, 1); column.fCanModify = Util.GetPropBool(reader, 2); column.fDisplay = Util.GetPropBool(reader, 3); column.Width = Util.GetProperInt(reader, 4); column.fFixColumn = Util.GetPropBool(reader, 5); column.FixColumnValue = Util.GetPropString(reader, 6); column.fCustomerControl = Util.GetPropBool(reader, 7); column.CustomerControlHTC = Util.GetPropString(reader, 8); column.ControlID = Util.GetPropString(reader, 9); column.EditContrl = Util.GetProperInt(reader, 10).ToString(); column.LeftBracket = Util.GetPropString(reader, 11); column.RightBracket = Util.GetPropString(reader, 12); column.Logic = Util.GetProperInt(reader, 13); column.CondiFieldValue = Util.GetPropString(reader, 14); column.fIsFunctionValue = Util.GetPropBool(reader, 15); column.Operation = Util.GetProperInt(reader, 16); column.InnerLinkComp = Util.GetPropBool(reader, 17); columns.Add(column); } reader.Close(); return(columns); }
public static List<UcmlVcColumn> GetVcColumn(SqlConnection conn, string vcOid) { List<UcmlVcColumn> columns = new List<UcmlVcColumn>(); StringBuilder sql = new StringBuilder("select "); sql.Append("FieldName,ChineseName,AllowEdit,Visible,Width,fFixColumn,FixColumnValue,fCustomerControl,CustomerControlHTC,ControlID,"); sql.Append("EditContrl,LeftBracket,RightBracket,LogicConnect,CondiFieldValue,fIsFunctionValue,OperationIndent,InnerLinkComp "); sql.Append("from AppletColumnDataSet "); sql.Append("where AppletOID='" + vcOid+"'"); SqlCommand cmd = new SqlCommand(sql.ToString(), conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UcmlVcColumn column = new UcmlVcColumn(); column.FieldName = Util.GetPropString(reader, 0); column.Caption = Util.GetPropString(reader, 1); column.fCanModify = Util.GetPropBool(reader, 2); column.fDisplay = Util.GetPropBool(reader, 3); column.Width = Util.GetProperInt(reader, 4); column.fFixColumn = Util.GetPropBool(reader, 5); column.FixColumnValue = Util.GetPropString(reader, 6); column.fCustomerControl = Util.GetPropBool(reader, 7); column.CustomerControlHTC = Util.GetPropString(reader, 8); column.ControlID = Util.GetPropString(reader, 9); column.EditContrl = Util.GetProperInt(reader, 10).ToString(); column.LeftBracket = Util.GetPropString(reader, 11); column.RightBracket = Util.GetPropString(reader, 12); column.Logic = Util.GetProperInt(reader, 13); column.CondiFieldValue = Util.GetPropString(reader, 14); column.fIsFunctionValue = Util.GetPropBool(reader, 15); column.Operation = Util.GetProperInt(reader, 16); column.InnerLinkComp = Util.GetPropBool(reader, 17); columns.Add(column); } reader.Close(); return columns; }
public static List<UcmlVcColumn> PrepareVcColumn(SqlConnection conn, int vcOid) { List<UcmlVcColumn> columns = new List<UcmlVcColumn>(); StringBuilder sql = new StringBuilder("select "); sql.Append("FieldName,ChineseName,AllowEdit,Visible,Width,fFixColumn,FixColumnValue,fCustomerControl,CustomerControlHTC,ControlID,EditContrl "); sql.Append("from AppletColumnDataSet "); sql.Append("where AppletOID="+vcOid); SqlCommand cmd = new SqlCommand(sql.ToString(), conn); SqlDataReader reader = cmd.ExecuteReader(); int i = 0; while (reader.Read()) { UcmlVcColumn column = new UcmlVcColumn(); column.FieldName = Util.GetPropString(reader, 0); column.Caption = Util.GetPropString(reader, 1); column.fCanModify = Util.GetPropBool(reader, 2); column.fDisplay = Util.GetPropBool(reader, 3); column.Width = Util.GetProperInt(reader, 4); column.fFixColumn = Util.GetPropBool(reader, 5); column.FixColumnValue = Util.GetPropString(reader, 6); column.fCustomerControl = Util.GetPropBool(reader, 7); column.CustomerControlHTC = Util.GetPropString(reader, 8); column.ControlID = Util.GetPropString(reader, 9); column.EditContrl = Util.GetPropString(reader, 10); column.CurrentPos = i; i++; columns.Add(column); } reader.Close(); return columns; }