private void btSearch_Click(object sender, EventArgs e) { DacHelper dacHelper = new DacHelper(CONNSTR); DataSet ds = null; string soBenhAn = txtSoBenhAn.Text; ds = dacHelper.ExecuteQuery("sp_CUST_DieuChinhSoLe_PhieuDieuTri" , new string[] { "@ACTIONID", "@SoBenhAn" }, new object[] { "Select", soBenhAn }); if (ds != null) { ultraGrid1.DataSource = ds.Tables[0]; } }
private void bFix_Click(object sender, EventArgs e) { if (_ds != null && _ds.Tables[0].Rows.Count != 0) { DacHelper dacHelper = new DacHelper(MainForm.CONNSTR); DataSet ds = null; try { ds = dacHelper.ExecuteQuery("sp_CUST_Sync_BenhAnKhuALenCenter", null, null); bShow_Click(sender, e); MessageBox.Show("Xong"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("Không có dữ liệu"); } }
private void bShow_Click(object sender, EventArgs e) { DacHelper dacHelper = new DacHelper(MainForm.CONNSTR); _ds = dacHelper.ExecuteQuery("sp_CUST_BenhAnKhuAKhongDongBoLenCenter", null, null); if (_ds != null) { if (_ds.Tables[0].Rows.Count != 0) { bFix.Enabled = true; } else { bFix.Enabled = false; } ultraGrid1.DataSource = _ds.Tables[0]; } else { bFix.Enabled = false; } }