Beispiel #1
0
        public M_PageReg GetSelectByUserID(int UserID)
        {
            string strSQL = "SELECT TOP 1 * FROM [ZL_PageReg] WHERE [UserID]=" + UserID;

            using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, strSQL))
            {
                if (reader.Read())
                {
                    return(initMod.GetModelFromReader(reader));
                }
                else
                {
                    return(null);
                }
            }
        }
Beispiel #2
0
 public M_PageReg SelReturnModel(int ID)
 {
     if (ID == -1)
     {
         return(SelSysModel());
     }
     using (DbDataReader reader = Sql.SelReturnReader(TbName, PK, ID))
     {
         if (reader.Read())
         {
             return(initMod.GetModelFromReader(reader));
         }
         else
         {
             return(null);
         }
     }
 }