예제 #1
0
        public string GetChildMaxOrder(string oid)
        {
            string strSQL = @" SELECT COUNT(1)+1 FROM TBLFUNCTION WHERE functionparentid=@OID ";
            string[] paramNames = new string[1];
            object[] paramValues = new object[1];

            paramNames[0] = "OID";
            paramValues[0] = oid;
            SqlDBBroker broker = new SqlDBBroker();
            broker.Open();
            return broker.ExecuteScalar(strSQL, CommandType.Text, paramNames, paramValues);
        }