public void TestLoaiThuChi07_DeleteSuccess() { TestLoaiThuChi05_InsertSuccess(); List <DMLoaiThuChiInfor> list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor(); DMLoaiThuChiInfor infor = list.Find(delegate(DMLoaiThuChiInfor match) { return(match.KyHieu == "1111D"); }); frmDM_LoaiThuChi frm = new frmDM_LoaiThuChi(); frm.isAdd = false; frm.Oid = infor.IdThuChi; frmChiTiet_LoaiThuChi frmChiTietLoaiThuChi = new frmChiTiet_LoaiThuChi(frm); frmChiTietLoaiThuChi.TestDelete(); list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor(); infor = list.Find(delegate(DMLoaiThuChiInfor match) { return(match.KyHieu == "1111D"); }); Assert.AreEqual(infor, null); }
private void Loaddata() { if (frmDMLoaiThuChi.isAdd) { Reset(); btnDelete.Enabled = false; } else { txtKyHieu.Enabled = false; dm = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(frmDMLoaiThuChi.Oid); txtTen.Text = dm.Ten; txtKyHieu.Text = dm.KyHieu; txtGhiChu.Text = dm.GhiChu; txtType.Text = Convert.ToString(dm.Type); chkSuDung.Checked = dm.SuDung == 1; } if (frmDMLoaiThuChi.IsSync) { //không cho phép người dùng sửa, xóa các thông tin trên form. txtKyHieu.Enabled = false; txtTen.Enabled = false; btnDelete.Enabled = false; } }
internal List <DMLoaiThuChiInfor> Search(DMLoaiThuChiInfor dmLoaiThuChiInfor) { CreateGetListCommand(Declare.StoreProcedureNamespace.spLoaiThuChiSearch); Parameters.AddWithValue("@KyHieu", dmLoaiThuChiInfor.KyHieu); Parameters.AddWithValue("@Ten", dmLoaiThuChiInfor.Ten); return(FillToList <DMLoaiThuChiInfor>()); }
internal void Update(DMLoaiThuChiInfor dmLoaiThuChiInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiUpdate); SetParams(dmLoaiThuChiInfor); //Parameters["IdThuChi"].Direction = ParameterDirection.Output; ExecuteNoneQuery(); //return Convert.ToInt32(Parameters["@IdThuChi"].Value.ToString()); }
private void LoadThoiHanThanhToan() { ThoiHanTTSelected = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(Declare.IdThoiHanThanhToan); if (ThoiHanTTSelected != null) { bteThoiHanThanhToan.Text = ThoiHanTTSelected.Ten; bteThoiHanThanhToan.Tag = ThoiHanTTSelected; } }
internal bool Exist(DMLoaiThuChiInfor dmLoaiThuChiInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiExist); Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output; Parameters.AddWithValue("@IdThuChi", dmLoaiThuChiInfor.IdThuChi); Parameters.AddWithValue("@KyHieu", dmLoaiThuChiInfor.KyHieu); ExecuteNoneQuery(); return(Convert.ToInt32(Parameters["@Count"].Value) == 1); }
private DMLoaiThuChiInfor SetDanhMuc() { DMLoaiThuChiInfor dm = new DMLoaiThuChiInfor(); dm.IdThuChi = Convert.ToInt32(frmDMLoaiThuChi.Oid); dm.Ten = txtTen.Text.Trim(); dm.KyHieu = txtKyHieu.Text.Trim(); dm.GhiChu = txtGhiChu.Text.Trim(); dm.Type = Convert.ToInt32(txtType.Text.Trim()); dm.SuDung = Convert.ToInt32(chkSuDung.Checked); return(dm); }
private DMLoaiThuChiInfor getinfor() { DMLoaiThuChiInfor dmLoaiThuChiInfor = new DMLoaiThuChiInfor(); dmLoaiThuChiInfor.Ten = txtTen.Text; dmLoaiThuChiInfor.KyHieu = txtMa.Text; dmLoaiThuChiInfor.GhiChu = txtMoTa.Text; dmLoaiThuChiInfor.Type = cboType.SelectedIndex; dmLoaiThuChiInfor.SuDung = Convert.ToInt32(chkSuDung.Checked); dmLoaiThuChiInfor.IdThuChi = Convert.ToInt32(getValue("clIdThuChi")); return(dmLoaiThuChiInfor); }
//private void LoadNganHang() //{ // liNganHangTT = DMNganHangDataProvider.Instance.GetListNganHangInfors(); // cboNganHangTT.DataSource = liNganHangTT; // cboNganHangTT.DisplayMember = "TenNganHang"; // cboNganHangTT.ValueMember = "IdNganHang"; // DMNganHangInfor[] t = new DMNganHangInfor[liNganHangTT.Count]; // liNganHangTT.CopyTo(t); // liNganHangPH = new List<DMNganHangInfor>(t); // //liNganHangPH = DMNganHangDataProvider.Instance.GetListNganHangInfors(); // cboNganHangPH.DataSource = liNganHangPH; // cboNganHangPH.DisplayMember = "TenNganHang"; // cboNganHangPH.ValueMember = "IdNganHang"; //} //private void LoadTaiKhoanQuy() //{ // liTaiKhoanQuy = DMTaiKhoanQuyDataProvider.Instance.GetListTaiKhoanQuyByTrungTam(-1); // cboTaiKhoanQuy.DataSource = liTaiKhoanQuy; // cboTaiKhoanQuy.DisplayMember = "TaiKhoanQuy"; // cboTaiKhoanQuy.ValueMember = "TaiKhoanQuy"; //} private void LoadThoiHanThanhToan() { int idThoiHanTT = ThanhToan.IdThoiHanThanhToan == 0 ? Declare.IdThoiHanThanhToan : ThanhToan.IdThoiHanThanhToan; DMLoaiThuChiInfor dmLoaiThuChi = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(idThoiHanTT); if (dmLoaiThuChi != null) { bteThoiHanThanhToan.Text = dmLoaiThuChi.Ten; bteThoiHanThanhToan.Tag = dmLoaiThuChi; } }
internal int Insert(DMLoaiThuChiInfor dmLoaiThuChiInfor) { //ExecuteCommand(Declare.StoreProcedureNamespace.spLoaiThuChiInsert, dmLoaiThuChiInfor.KyHieu, // dmLoaiThuChiInfor.Ten, dmLoaiThuChiInfor.GhiChu, dmLoaiThuChiInfor.Type, // dmLoaiThuChiInfor.SuDung); // Common.IntValue(Parameters["p_IdThuChi"].Value.ToString()); CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiInsert); SetParams(dmLoaiThuChiInfor); Parameters["@IdThuChi"].Direction = ParameterDirection.Output; //Parameters["@IDORDERTYPE"].Direction = ParameterDirection.Output; ExecuteNoneQuery(); return(Convert.ToInt32(Parameters["@IdThuChi"].Value)); }
private void Insert() { if (_thuchiinfor == null) { _thuchiinfor = new DMLoaiThuChiInfor(); _thuchiinfor.KyHieu = View.KyHieu; _thuchiinfor.Ten = View.Ten; _thuchiinfor.GhiChu = View.GhiChu; _thuchiinfor.Type = View.Type; _thuchiinfor.SuDung = View.SuDung; _thuchiinfor.IdThuChi = DmLoaiThuChiDAO.Instance.Insert(_thuchiinfor); ((List <DMLoaiThuChiInfor>)DSThoiHanThanhToanView.Instance.DataSource).Add(_thuchiinfor); DSThoiHanThanhToanView.Instance.RefreshDataSource(); } }
private void LoadLoaiThuChi() { try { DMLoaiThuChiInfor dmLoaiThuChi = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(IdThoiHanTTSelected); if (dmLoaiThuChi != null) { bteThoiHanThanhToan.Text = dmLoaiThuChi.Ten; bteThoiHanThanhToan.Tag = dmLoaiThuChi; } } catch (System.Exception ex) { #if DEBUG MessageBox.Show("Lỗi ngoại lệ: " + ex.ToString(), Declare.titleError, MessageBoxButtons.OK, MessageBoxIcon.Error); #else MessageBox.Show("Lỗi ngoại lệ: " + ex.Message, Declare.titleError, MessageBoxButtons.OK, MessageBoxIcon.Error); #endif } }
public void TestLoaiThuChi03_MaLoaiThuChiHasExistedOnUpdate() { try { TestLoaiThuChi05_InsertSuccess(); List <DMLoaiThuChiInfor> list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor(); DMLoaiThuChiInfor infor = list.Find(delegate(DMLoaiThuChiInfor match) { return(match.KyHieu == "1111D"); }); frmDM_LoaiThuChi frm = new frmDM_LoaiThuChi(); frm.isAdd = false; frm.Oid = infor.IdThuChi; frmChiTiet_LoaiThuChi frmChiTietLoaiThuChi = new frmChiTiet_LoaiThuChi(frm); frmChiTietLoaiThuChi.SetInput("Trả Chậm 1111 ngày", "111D", "Unit test LoaiThuChi", 0, 1); frmChiTietLoaiThuChi.TestSave(); list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor(); List <DMLoaiThuChiInfor> listDuplicate = list.FindAll(delegate(DMLoaiThuChiInfor match) { return(match.KyHieu == "111D"); }); frmChiTietLoaiThuChi.TestDelete(); Assert.AreEqual(1, listDuplicate.Count); } catch (Exception ex) { if (ex.GetType() != typeof(AssertFailedException)) { Assert.AreEqual(ex.Message, "Ký hiệu đã tồn tại trong hệ thống!"); } else { throw; } } }
private bool Exist(DMLoaiThuChiInfor dmLoaiThuChiInfor) { return(dmLoaiThuChiInfor.IdThuChi != idThuChi && dmLoaiThuChiInfor.Ten != null && dmLoaiThuChiInfor.Ten.ToLower() == txtTen.Text.Trim().ToLower()); }
public static List <DMLoaiThuChiInfor> Search(DMLoaiThuChiInfor match) { return(DmLoaiThuChiDAO.Instance.Search(match)); }
public static void Delete(DMLoaiThuChiInfor dmLoaiThuChiInfo) { DmLoaiThuChiDAO.Instance.Delete(dmLoaiThuChiInfo); }
internal static void Update(DMLoaiThuChiInfor dmLoaiThuChiInfo) { DmLoaiThuChiDAO.Instance.Update(dmLoaiThuChiInfo); }
internal static void Insert(DMLoaiThuChiInfor dmLoaiThuChiInfo) { DmLoaiThuChiDAO.Instance.Insert(dmLoaiThuChiInfo); }
internal static bool KiemTra(DMLoaiThuChiInfor dmLoaiThuChiInfo) { return(DmLoaiThuChiDAO.Instance.Exist(dmLoaiThuChiInfo)); }
private void GetData() { _thuchiinfor = View.thuchiinfor; }
private void btnUpdate_Click(object sender, EventArgs e) { if (ValidData()) { if (bteTrungTam.Tag != null) { TTamSelected = (DMTrungTamInfor)bteTrungTam.Tag; } if (bteKhoXuat.Tag != null) { KhoSelected = (DMKhoInfo)bteKhoXuat.Tag; } if (cboCurrentLoaiDT.SelectedIndex != -1) { LoaiDTSelected = liLoaiDT[cboCurrentLoaiDT.SelectedIndex]; } if (bteKhachHang.Tag != null) { KHangSelected = (DMDoiTuongInfo)bteKhachHang.Tag; } if (bteTruongCa.Tag != null) { TruongCaSelected = (DMNhanVienInfo)bteTruongCa.Tag; } if (bteThuNgan.Tag != null) { ThuNganSelected = (DMNhanVienInfo)bteThuNgan.Tag; } if (bteThoiHanThanhToan.Tag != null) { ThoiHanTTSelected = (DMLoaiThuChiInfor)bteThoiHanThanhToan.Tag; } if (TypeReset == 1 || TypeReset == 2) { if (TTamSelected != null) { Declare.IdTrungTam = TTamSelected.IdTrungTam; Declare.TenTrungTam = TTamSelected.TenTrungTam; } if (KhoSelected != null) { Declare.IdKho = KhoSelected.IdKho; Declare.TenKho = KhoSelected.TenKho; } if (LoaiDTSelected != null) { Declare.IdLoaiKhachHang = LoaiDTSelected.IdLoaiDT; } if (KHangSelected != null) { Declare.IdKHMacDinh = KHangSelected.IdDoiTuong; Declare.TenKhachHang = KHangSelected.TenDoiTuong; } Declare.IdThuNgan = ThuNganSelected != null ? ThuNganSelected.IdNhanVien : 0; Declare.IdTruongCa = TruongCaSelected != null ? TruongCaSelected.IdNhanVien : 0; Declare.IdThoiHanThanhToan = ThoiHanTTSelected != null ? ThoiHanTTSelected.IdThuChi : 0; Declare.NgayLamViec = dtNgayLamViec.Value; DateTime now = CommonProvider.Instance.GetSysDate(); if (KhoSelected.NgayDuDau.CompareTo(now) > 0) { Declare.NgayDuDau = KhoSelected.NgayDuDau; } else { Declare.NgayDuDau = now; } } if (TypeReset == 2) { string formMacDinh = ""; if (choseForm && lueFormMacDinh.EditValue != null) { formMacDinh = lueFormMacDinh.EditValue.ToString(); } NguoiDungDataProvider.SetKhoMacDinh(Declare.IdTrungTam, Declare.IdKho, Declare.IdLoaiKhachHang, Declare.IdKHMacDinh, Declare.IdTruongCa, Declare.IdThuNgan, Declare.IdThoiHanThanhToan, nguoiDung.IdNguoiDung, formMacDinh); } if (this.frmParent != null) { foreach (Form frm in frmParent.MdiChildren) { frm.Close(); } } this.DialogResult = DialogResult.OK; } }
internal void Delete(DMLoaiThuChiInfor dmLoaiThuChiInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiDelete); Parameters.AddWithValue("@IdThuChi", dmLoaiThuChiInfor.IdThuChi); ExecuteNoneQuery(); }