private void btnThem_Click(object sender, EventArgs e) { //bắt đk if (usePhieugui.MaSTKLaNULL(txtMaSTK.Text)) { MessageBox.Show("Mã Sổ tiết kiệm không được trống!", "Cảnh báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (usePhieugui.MaKHLaNULL(txtMaKH.Text)) { MessageBox.Show("Mã khách hàng không được trống!", "Cảnh báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (usePhieugui.SoTienGuiLaNULL(txtSoTienGui.Text)) { MessageBox.Show("số tiền gửi không được trống!", "Cảnh báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { try { PhieuGui pg = new PhieuGui(txtMaPhieuGui.Text, txtMaSTK.Text, txtMaKH.Text, dateTimePicker1.Text, txtSoTienGui.Text); usePhieugui.ThemPhieuGui(pg); init(); gridPhieuGui.DataSource = usePhieugui.loadPhieuGui(); } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } } }
public List <PhieuGui> LoadPhieuGuiByTime(string start, string end) { List <PhieuGui> list = new List <PhieuGui>(); string query = "SET DATEFORMAT DMY SELECT [MAPHIEU],[CMND],[MADV],[NGAYGUI],[LAISUAT],[KYHAN],[SOTIEN_GUI],[NGAYDENHAN],[MAGDV_LPG]FROM [QL_TAIKHOAN].[dbo].[PHIEUGUI] WHERE [NGAYGUI]>='" + start + "' AND [NGAYGUI]<='" + end + "'"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { PhieuGui phieu = new PhieuGui(item); list.Add(phieu); } return(list); }
public List <PhieuGui> LoadAllPhieuGuiByCMND(string cmnd) { List <PhieuGui> list = new List <PhieuGui>(); string query = "SELECT [MAPHIEU],[CMND],[MADV],[NGAYGUI],[LAISUAT],[KYHAN],[SOTIEN_GUI],[NGAYDENHAN],[MAGDV_LPG] FROM PHIEUGUI WHERE MAPHIEU NOT IN(SELECT MAPHIEU FROM PHIEURUT) AND CMND ='" + cmnd + "'"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { PhieuGui phieu = new PhieuGui(item); list.Add(phieu); } return(list); }
public List <PhieuGui> LoadAllPhieuGui() { List <PhieuGui> list = new List <PhieuGui>(); string query = "SELECT [MAPHIEU],[CMND],[MADV],[NGAYGUI],[LAISUAT], [KYHAN] ,[SOTIEN_GUI],[NGAYDENHAN],[MAGDV_LPG] FROM [QL_TAIKHOAN].[dbo].[PHIEUGUI] ORDER BY MAPHIEU DESC"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { PhieuGui phieu = new PhieuGui(item); list.Add(phieu); } return(list); }
private void btnXoa_Click(object sender, EventArgs e) { try { PhieuGui pg = new PhieuGui(txtMaPhieuGui.Text, txtMaSTK.Text, txtMaKH.Text, dateTimePicker1.Text, txtSoTienGui.Text); usePhieugui.XoaPhieuGui(pg); init(); gridPhieuGui.DataSource = usePhieugui.loadPhieuGui(); } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } }
//sửa public void XoaPhieuGui(PhieuGui pg) { string sql = "delete from PhieuGoiTien where MaPhieuGoi = N'" + pg.MaPhieuGui + "'"; try { cnn = new SqlConnection(str); cnn.Open(); SqlCommand cmd = new SqlCommand(sql, cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); cnn.Close(); cnn.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); // throw; } }
//thêm public void ThemPhieuGui(PhieuGui pg) { string sql = "insert into PhieuGoiTien values (N'" + pg.MaPhieuGui + "', N'" + pg.MaSTK + "', N'" + pg.MaKH + "', '" + pg.ThoiGianGui.ToString("yyyy-MM-dd HH:mm:ss") + "', N'" + pg.SoTienGui + "') "; try { cnn = new SqlConnection(str); cnn.Open(); SqlCommand cmd = new SqlCommand(sql, cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); cnn.Close(); cnn.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); // throw; } }
private void cbxMaPhieu_SelectedValueChanged(object sender, EventArgs e) { ComboBox cb = sender as ComboBox; if (cbxMaPhieu.SelectedItem == null) { return; } PhieuGui phieu = cbxMaPhieu.SelectedItem as PhieuGui; try { if (phieu != null) { txtMaDV.Text = phieu.MaDV; txtMoney.Text = Math.Round(phieu.SoTienGui, 0).ToString(); txtLaiSuat.Text = phieu.LaiSuat.ToString(); dateNgayGui.Value = Convert.ToDateTime(phieu.NgayGui); dateNgayDenHan.Value = Convert.ToDateTime(phieu.NgayDenHan); txtKyHan.Text = phieu.KyHan.ToString(); string maDV = phieu.MaDV; try { DichvuLaisuat dvls = DichvuLaisuatDAO.Instance.LoadDVLSByMaDV(maDV); txtTenDV.Text = dvls.TenDV; } catch { } } } catch { } txtTienLai.Text = ""; }