コード例 #1
0
        public static float GetDecimal(string procName, string ID)
        {
            SqlDataReader reader;
            Database      database = new Database();

            SqlParameter[] prams = { database.MakeInParam("@ID", SqlDbType.VarChar, 100, ID) };
            database.RunProc(procName, prams, out reader);
            ArrayList list = new ArrayList();

            while (reader.Read())
            {
                if (!reader.IsDBNull(0))
                {
                    return(reader.GetFloat(0));
                }
            }
            return(0);
        }
コード例 #2
0
        public int Delete_User(UserPublic p)
        {
            Database cn = new Database();

            SqlParameter[] prams =
            {
                cn.MakeInParam("@Id", SqlDbType.Int, 4, p.Id)
            };
            cn.RunProc("User_Delete", prams);
            cn.Dispose();
            try
            {
                return((int)prams[0].Value);
            }
            catch (Exception)
            {
                return(1);
            }
            finally
            {
                cn.Close();
                cn.Dispose();
            }
        }
コード例 #3
0
        public static ArrayList GetIntANDString(string procName, int ID, string Name)
        {
            SqlDataReader reader;

            SqlParameter[] parameterArray;
            ArrayList      list;

            object[] objArray;
            Database database = new Database();

            if (ID != -1)
            {
                parameterArray = new SqlParameter[] { database.MakeInParam("@ID", SqlDbType.Int, 4, ID) };
                database.RunProc(procName, parameterArray, out reader);
                list = new ArrayList();
                while (reader.Read())
                {
                    objArray = new object[2];
                    if (!reader.IsDBNull(0))
                    {
                        objArray[0] = reader.GetString(0);
                    }
                    if (!reader.IsDBNull(1))
                    {
                        objArray[1] = reader.GetString(1);
                    }
                    list.Add(objArray);
                }
                return(list);
            }
            if (!Name.Equals(""))
            {
                parameterArray = new SqlParameter[] { database.MakeInParam("@Name", SqlDbType.VarChar, 10, Name) };
                database.RunProc(procName, parameterArray, out reader);
                list = new ArrayList();
                while (reader.Read())
                {
                    objArray = new object[2];
                    if (!reader.IsDBNull(0))
                    {
                        objArray[0] = reader.GetString(0);
                    }
                    if (!reader.IsDBNull(1))
                    {
                        objArray[1] = reader.GetString(1);
                    }
                    list.Add(objArray);
                }
                return(list);
            }
            database.RunProc(procName, out reader);
            list = new ArrayList();
            while (reader.Read())
            {
                objArray = new object[2];
                if (!reader.IsDBNull(0))
                {
                    objArray[0] = reader.GetInt32(0);
                }
                if (!reader.IsDBNull(1))
                {
                    objArray[1] = reader.GetString(1);
                }
                list.Add(objArray);
            }
            return(list);
        }