C# (CSharp) HY_BLL HY_SupplierBLL.f_SupplierLiset Exemples

Exemple #1

Fichier : HY_SupplierListSO.cs Projet : elanyang/ll-furniture

 private void requistionDate(string sql)
 {
     HY_BLL.HY_SupplierBLL hysuplist = new HY_SupplierBLL();
     this.listView1.View = View.Details;
     this.listView1.FullRowSelect = true;
     SqlDataReader sdr = hysuplist.f_SupplierLiset(sql);
     while (sdr.Read())
     {
         ListViewItem lv = new ListViewItem(sdr[0].ToString());
         lv.SubItems.Add(sdr[1].ToString());
         lv.SubItems.Add(sdr[2].ToString());
         this.listView1.Items.Add(lv);
     }
 }

Exemple #2

Fichier : HY_SupplierList.cs Projet : elanyang/ll-furniture

 private void HY_SupplierList_Load(object sender, EventArgs e)
 {
     HY_BLL.HY_SupplierBLL hysuplist = new HY_SupplierBLL();
     this.listView1.View = View.Details;
     this.listView1.FullRowSelect = true;
     string sql = "select s_gyName,s_jName,s_Area,s_Name,s_Tel,s_cpName from HY_Supplier";
     SqlDataReader sdr = hysuplist.f_SupplierLiset(sql);
     while (sdr.Read())
     {
         ListViewItem lv = new ListViewItem(sdr[0].ToString());
         lv.SubItems.Add(sdr[1].ToString());
         lv.SubItems.Add(sdr[2].ToString());
         lv.SubItems.Add(sdr[3].ToString());
         lv.SubItems.Add(sdr[4].ToString());
         lv.SubItems.Add(sdr[5].ToString());
         lv.ImageIndex = 1;
         this.listView1.Items.Add(lv);
     }
 }