public static List <BCCondiColumn> GetCondiColumn(SqlConnection conn, string bcOid)
{
List <BCCondiColumn> columns = new List <BCCondiColumn>();
StringBuilder sql = new StringBuilder("select ");
sql.Append("FieldName,LeftBracket,RightBracket,OperationIndent,CondiFieldValue,");
sql.Append("fIsFunctionValue,valueFunction,logicConnect,fFreeWhere,SQL");
sql.Append(" from BsuiCompCondiDataSet ");
sql.Append("where BusinessTableOID='" + bcOid + "'");
SqlCommand cmd = new SqlCommand(sql.ToString(), conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BCCondiColumn column = new BCCondiColumn();
column.FieldName = Util.GetPropString(reader, 0);
column.LeftBracket = Util.GetPropString(reader, 1);
column.RightBracket = Util.GetPropString(reader, 2);
column.Operation = Util.GetProperInt(reader, 3);
column.CondiFieldValue = Util.GetPropString(reader, 4);
column.fCondiField = true;
column.fIsFunctionValue = Util.GetPropBool(reader, 5);
column.valueFunction = Util.GetPropString(reader, 6);
column.Logic = Util.GetProperInt(reader, 7);
column.fFreeWhere = Util.GetPropBool(reader, 8);
column.SQL = Util.GetPropString(reader, 9);
columns.Add(column);
}
reader.Close();
return(columns);
}
public static List<BCCondiColumn> GetCondiColumn(SqlConnection conn, string bcOid)
{
List<BCCondiColumn> columns = new List<BCCondiColumn>();
StringBuilder sql = new StringBuilder("select ");
sql.Append("FieldName,LeftBracket,RightBracket,OperationIndent,CondiFieldValue,");
sql.Append("fIsFunctionValue,valueFunction,logicConnect,fFreeWhere,SQL");
sql.Append(" from BsuiCompCondiDataSet ");
sql.Append("where BusinessTableOID='" + bcOid + "'");
SqlCommand cmd = new SqlCommand(sql.ToString(), conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BCCondiColumn column = new BCCondiColumn();
column.FieldName = Util.GetPropString(reader, 0);
column.LeftBracket = Util.GetPropString(reader, 1);
column.RightBracket = Util.GetPropString(reader, 2);
column.Operation = Util.GetProperInt(reader, 3);
column.CondiFieldValue = Util.GetPropString(reader, 4);
column.fCondiField = true;
column.fIsFunctionValue = Util.GetPropBool(reader, 5);
column.valueFunction = Util.GetPropString(reader, 6);
column.Logic = Util.GetProperInt(reader, 7);
column.fFreeWhere = Util.GetPropBool(reader, 8);
column.SQL = Util.GetPropString(reader, 9);
columns.Add(column);
}
reader.Close();
return columns;
}