public static BCLinkProperty GetBCLink(SqlConnection conn, string colOID)
{
BCLinkProperty bcLink = new BCLinkProperty();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
StringBuilder sql = new StringBuilder("select ");
sql.Append("AppletName,Caption,BCRunMode,srcFieldName,destFieldName,CondiFieldName,Value,");
sql.Append("QueryFieldName,fQuickQuery,fDropDownMode,DropDownWidth,DropDownHeight ");
sql.Append("from BCLinkDataSet where BusinessColumnOID='" + colOID + "'");
cmd.CommandText = sql.ToString();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
bcLink.AppletName = Util.GetPropString(reader, 0);
bcLink.Caption = Util.GetPropString(reader, 1);
bcLink.RunMode = Util.GetProperInt(reader, 2);
bcLink.srcFieldName = Util.GetPropString(reader, 3);
bcLink.destFieldName = Util.GetPropString(reader, 4);
bcLink.condiFieldName = Util.GetPropString(reader, 5);
bcLink.Value = Util.GetPropString(reader, 6);
bcLink.QueryFieldName = Util.GetPropString(reader, 7);
bcLink.fQuickQuery = Util.GetPropBool(reader, 8);
bcLink.fDropDownMode = Util.GetPropBool(reader, 9);
bcLink.DropDownWidth = Util.GetProperInt(reader, 10);
bcLink.DropDownHeight = Util.GetProperInt(reader, 11);
}
reader.Close();
return(bcLink);
}
public static BCLinkProperty GetBCLink(SqlConnection conn,string colOID)
{
BCLinkProperty bcLink = new BCLinkProperty();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
StringBuilder sql = new StringBuilder("select ");
sql.Append("AppletName,Caption,BCRunMode,srcFieldName,destFieldName,CondiFieldName,Value,");
sql.Append("QueryFieldName,fQuickQuery,fDropDownMode,DropDownWidth,DropDownHeight ");
sql.Append("from BCLinkDataSet where BusinessColumnOID='"+colOID+"'");
cmd.CommandText = sql.ToString();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
bcLink.AppletName = Util.GetPropString(reader, 0);
bcLink.Caption = Util.GetPropString(reader, 1);
bcLink.RunMode = Util.GetProperInt(reader, 2);
bcLink.srcFieldName = Util.GetPropString(reader, 3);
bcLink.destFieldName = Util.GetPropString(reader, 4);
bcLink.condiFieldName = Util.GetPropString(reader, 5);
bcLink.Value = Util.GetPropString(reader, 6);
bcLink.QueryFieldName = Util.GetPropString(reader, 7);
bcLink.fQuickQuery = Util.GetPropBool(reader, 8);
bcLink.fDropDownMode = Util.GetPropBool(reader, 9);
bcLink.DropDownWidth = Util.GetProperInt(reader, 10);
bcLink.DropDownHeight = Util.GetProperInt(reader, 11);
}
reader.Close();
return bcLink;
}
public BusiCompColumn()
{
BCLink = new BCLinkProperty();
}
public BusiCompColumn()
{
BCLink = new BCLinkProperty();
}