C# (CSharp) DAO Provider.ExecSelectCommand_Output Examples

Example #1

        public static DataTable TimTheoLoai(int mode, string maLoai, string MaNH, ref int sl)
        {
            Provider provider = new Provider();
            string   store    = "sp_TimTheoLoai";

            if (mode == 3)
            {
                store = "sp_TimTheoLoai_Fix";
            }

            SqlCommand cm = provider.CreateCommandStoreName(store);

            cm.Parameters.Add("@maLoai", SqlDbType.VarChar, 5);
            cm.Parameters.Add("@maNH", SqlDbType.VarChar, 5);
            cm.Parameters.Add("@dem", SqlDbType.Int);

            cm.Parameters["@maLoai"].Value = maLoai;
            cm.Parameters["@maNH"].Value   = MaNH;

            cm.Parameters["@dem"].Direction = ParameterDirection.Output;
            string name = "@dem";

            return(provider.ExecSelectCommand_Output(cm, name, ref sl));
        }

Example #2

File: MonAn_DAO.cs Project: chutinhha/dbmsrestaurant

        public static DataTable TimTheoLoai(int mode,string maLoai, string MaNH,ref int sl)
        {
            Provider provider = new Provider();
            string store="sp_TimTheoLoai";
            if(mode==3)
                store = "sp_TimTheoLoai_Fix";

            SqlCommand cm = provider.CreateCommandStoreName(store);
            cm.Parameters.Add("@maLoai", SqlDbType.VarChar, 5);
            cm.Parameters.Add("@maNH", SqlDbType.VarChar, 5);
            cm.Parameters.Add("@dem", SqlDbType.Int);

            cm.Parameters["@maLoai"].Value = maLoai;
            cm.Parameters["@maNH"].Value = MaNH;

            cm.Parameters["@dem"].Direction = ParameterDirection.Output;
            string name="@dem";
            return provider.ExecSelectCommand_Output(cm, name,ref sl);
        }