Exemplos de WSSDT.WSSDT em C# (CSharp)

Exemplo n.º 1

Arquivo: UC_SoSanhDienThoai.ascx.cs Projeto: hongtien510/shopdienthoai

        protected void ddl_hsxss_SelectedIndexChanged(object sender, EventArgs e)
        {
            WSSDT.WSSDT dthoai = new WSSDT.WSSDT();
            DataSet     ds     = new DataSet();
            string      idHSX  = ddl_hsxss.SelectedValue.ToString();
            string      sql    = "SELECT idDT, TenDT FROM DIENTHOAI WHERE ANHIEN=1 AND idHSX=" + idHSX;

            //string sql = "SELECT idDT, TenDT FROM DIENTHOAI";
            ds = dthoai.SelectQuery(sql);

            DataTable dt = new DataTable();

            dt = ds.Tables[0];

            ListItem item;

            ddl_dtss.Items.Clear();
            item       = new ListItem();
            item.Value = "0";
            item.Text  = "-----Chọn Model-----";
            ddl_dtss.Items.Add(item);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                item       = new ListItem();
                item.Value = dt.Rows[i]["idDT"].ToString();
                item.Text  = dt.Rows[i]["TenDT"].ToString();
                ddl_dtss.Items.Add(item);
            }
        }

Exemplo n.º 2

Arquivo: UC_SoSanhDienThoai.ascx.cs Projeto: hongtien510/shopdienthoai

        protected void ddl_hsxss_SelectedIndexChanged(object sender, EventArgs e)
        {
            WSSDT.WSSDT dthoai = new WSSDT.WSSDT();
            DataSet ds = new DataSet();
            string idHSX = ddl_hsxss.SelectedValue.ToString();
            string sql = "SELECT idDT, TenDT FROM DIENTHOAI WHERE ANHIEN=1 AND idHSX=" + idHSX;
            //string sql = "SELECT idDT, TenDT FROM DIENTHOAI";
            ds = dthoai.SelectQuery(sql);

            DataTable dt = new DataTable();
            dt = ds.Tables[0];

            ListItem item;
            ddl_dtss.Items.Clear();
            item = new ListItem();
            item.Value = "0";
            item.Text = "-----Chọn Model-----";
            ddl_dtss.Items.Add(item);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                item = new ListItem();
                item.Value = dt.Rows[i]["idDT"].ToString();
                item.Text = dt.Rows[i]["TenDT"].ToString();
                ddl_dtss.Items.Add(item);
            }
        }

Exemplo n.º 3

Arquivo: UC_CacHangDienThoai.ascx.cs Projeto: hongtien510/shopdienthoai

        public void showCacHangDT()
        {
            WSSDT.WSSDT hangdt = new WSSDT.WSSDT();
            DataSet     ds     = new DataSet();

            ds = hangdt.SelectQuery("SELECT idHSX, TenHSX FROM HANGSANXUAT WHERE AnHien = 1");

            //DataTable dt = new DataTable();
            //dt = ds.Tables[0];

            CachangDienThoai.DataSource = ds;
            CachangDienThoai.DataBind();
        }

Exemplo n.º 4

Arquivo: UC_SoSanhDienThoai.ascx.cs Projeto: hongtien510/shopdienthoai

        public void ShowHSXSoSanh()
        {
            WSSDT.WSSDT hsxss = new WSSDT.WSSDT();

            DataSet ds = new DataSet();
            ds = hsxss.SelectQuery("SELECT idHSX, TenHSX FROM HANGSANXUAT WHERE ANHIEN=1");

            DataTable dt = new DataTable();
            dt = ds.Tables[0];

            ListItem item;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                item = new ListItem();
                item.Value = dt.Rows[i]["idHSX"].ToString();
                item.Text = dt.Rows[i]["TenHSX"].ToString();
                ddl_hsxss.Items.Add(item);
            }
        }

Exemplo n.º 5

Arquivo: UC_TimKiemDienThoai.ascx.cs Projeto: hongtien510/shopdienthoai

        public void showHSX()
        {
            WSSDT.WSSDT hsx = new WSSDT.WSSDT();
            DataSet     ds  = new DataSet();

            ds = hsx.SelectQuery("SELECT idHSX, TenHSX FROM HANGSANXUAT WHERE ANHIEN=1");

            DataTable dt = new DataTable();

            dt = ds.Tables[0];

            ListItem item;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                item       = new ListItem();
                item.Value = dt.Rows[i]["idHSX"].ToString();
                item.Text  = dt.Rows[i]["TenHSX"].ToString();
                ddl_hsx.Items.Add(item);
            }
        }