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