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