private void MedicineManagerForm_Load(object sender, EventArgs e) { // Load Medicine table gridCMedicineList.DataSource = medicineBusiness.GetAll(); //Load table to show on looktupedit MedicineType MedicineTypeBusiness medicineTypeBusiness = new MedicineTypeBusiness(); LookUpType.DataSource = medicineTypeBusiness.GetAll(); // Set data source LookUpType.ValueMember = "MedicineTypeID"; // Set value to save db LookUpType.DisplayMember = "MedicineTypeName"; //Set value to display //Add column to chose //LookUpType.Columns.Add(new LookUpColumnInfo("MedicineTypeID", "Mã loại thuốc")); LookUpType.Columns.Add(new LookUpColumnInfo("MedicineTypeName", "Tên loại thuốc")); //WaytoUse WayToUseBusiness wayToUse = new WayToUseBusiness(); LookUpWay.DataSource = wayToUse.GetAll(); LookUpWay.ValueMember = "WayToUseID"; LookUpWay.DisplayMember = "WayToUseName"; LookUpWay.Columns.Add(new LookUpColumnInfo("WayToUseName", "Đường dùng")); //Pharamcy PharmacyTypeBusiness medicine = new PharmacyTypeBusiness(); LookUpPharmacy.DataSource = medicine.GetAll(); LookUpPharmacy.ValueMember = "PharmacyTypeID"; LookUpPharmacy.DisplayMember = "PharmacyTypeName"; LookUpPharmacy.Columns.Add(new LookUpColumnInfo("PharmacyTypeName", "Dạng bào chế")); //Unit UnitBusiness unit = new UnitBusiness(); LookUpUnit.DataSource = unit.GetAll(); LookUpUnit.ValueMember = "UnitID"; LookUpUnit.DisplayMember = "UnitName"; LookUpUnit.Columns.Add(new LookUpColumnInfo("UnitName", "Đơn vị")); // Load data for comboboxedit MedicinType // Add default row "Tất cả" DataTable datasource = medicineTypeBusiness.GetAll(); var row = datasource.NewRow(); row["MedicineTypeID"] = 0; row["MedicineTypeName"] = "Tất cả"; datasource.Rows.Add(row); lookUpEditType.Properties.DataSource = datasource; // Set data source lookUpEditType.Properties.ValueMember = "MedicineTypeID"; // Set value to save db lookUpEditType.Properties.DisplayMember = "MedicineTypeName"; //Set value to display //Add column to chose //LookUpType.Columns.Add(new LookUpColumnInfo("MedicineTypeID", "Mã loại thuốc")); lookUpEditType.Properties.Columns.Add(new LookUpColumnInfo("MedicineTypeName", "Chọn")); }
private void MedicineTypeForm_Load(object sender, EventArgs e) { gridControl1.DataSource = medicineTypeBusiness.GetAll(); }