internal void Delete(DMNhanVienInfo dmNhanVienInfor)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spNhanVienDelete, dmNhanVienInfor.IdNhanVien);
//CreateCommonCommand(Declare.StoreProcedureNamespace.spNhanVienDelete);
//Parameters.AddWithValue("@IdNhanVien", dmNhanVienInfor.IdNhanVien);
//ExecuteNoneQuery();
}
//fill dữ liệu vào control
private void LoadOldChungTuInfor(ChungTuBanHangInfor lstHD)
{
grbChungTuMua.Text = "Thông tin phiếu mua hàng: " +
(String.IsNullOrEmpty(lstHD.TenTrungTam)
? ""
: (lstHD.TenTrungTam + (String.IsNullOrEmpty(lstHD.TenKho) ? "" : "(" + lstHD.TenKho + ")")));
_IdTrungTam = lstHD.IdTrungTam;
txtSoGiaoDich.Text = lstHD.SoChungTu;
txtSoPhieuXuat.Text = lstHD.SoPhieuXuat;
dteNgayLap.EditValue = lstHD.NgayLap;
dteNgayXuat.EditValue = lstHD.NgayXuatHang;
txtKiHieu.Text = lstHD.KyHieu;
txtSoHoaDon.Text = lstHD.SoSeri;
txtTenDoiTuong.Text = lstHD.HoTen;
txtCongTy.Text = lstHD.CongTy;
cboGioiTinh.SelectedIndex = lstHD.GioiTinh;
txtCMND.Text = lstHD.SoCMND;
txtSoDienThoai.Text = lstHD.MaSoThue;
txtEmail.Text = lstHD.Email;
txtDiaChiHD.Text = lstHD.DiaChiHoaDon;
txtDiaChiGH.Text = lstHD.DiaChiGiaoHang;
txtSoDienThoai.Text = lstHD.DienThoai;
if (lstHD.IdNhanVien != 0)
{
DMNhanVienInfo thuongvien = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(lstHD.IdNhanVien);
if (thuongvien != null)
{
bteThuongVien.Tag = thuongvien;
bteThuongVien.Text = thuongvien.HoTen;
}
}
if (lstHD.IdDoiTuong != 0)
{
DMDoiTuongInfo doituong = DmDoiTuongProvider.GetDmDoiTuongInfoFromOid(lstHD.IdDoiTuong);
if (doituong != null)
{
txtKhachHang.Tag = doituong;
txtKhachHang.Text = doituong.TenDoiTuong;
}
}
if (lstHD.IdKhachLe != 0)
{
DMDoiTuongInfo khachle = DmDoiTuongProvider.GetDmDoiTuongInfoFromOid(lstHD.IdKhachLe);
if (khachle != null)
{
bteKhachLe.Tag = khachle;
bteKhachLe.Text = khachle.TenDoiTuong;
}
}
txtTongTienTT.Text = Common.Double2Str(lstHD.TongTienThanhToan);
txtTienThucTra.Text = Common.Double2Str(lstHD.TienThanhToanThuc);
txtTienConNo.Text = Common.Double2Str(lstHD.TienConNo);
txtTienTraKhach.Text = "0";
txtTienNoKhach.Text = txtTienThucTra.Text;
}
private void LoadThuNgan()
{
ThuNganSelected = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(Declare.IdThuNgan);
if (ThuNganSelected != null)
{
bteThuNgan.Text = ThuNganSelected.HoTen;
bteThuNgan.Tag = ThuNganSelected;
}
}
private void LoadTruongCa()
{
TruongCaSelected = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(Declare.IdTruongCa);
if (TruongCaSelected != null)
{
bteTruongCa.Text = TruongCaSelected.HoTen;
bteTruongCa.Tag = TruongCaSelected;
}
}
private void LoadQLTrucTiep(int idQLTrucTiep)
{
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(idQLTrucTiep);
if (nv != null)
{
bteQLTrucTiep.Text = nv.HoTen;
bteQLTrucTiep.Tag = nv;
}
}
private void btnFilter_Click(object sender, EventArgs e)
{
DMNhanVienInfo dm = new DMNhanVienInfo();
dm.HoTen = txtFilterTen.Text.Trim();
dm.MaNhanVien = txtFilterMa.Text.Trim();
dm.IdChucVu = Convert.ToInt32(cboChucDanhS.SelectedValue.ToString());
dm.IdPhongBan = Convert.ToInt32(cboPhongBanS.SelectedValue.ToString());
grcBase.DataSource = DmNhanVienDataProvider.Search(dm);
}
private void LoadNhanVienGiaoNhan()
{
//load nhan vien
int idNhanVien = ChiTietGiaoNhan.IdNhanVien > 0 ? ChiTietGiaoNhan.IdNhanVien : nguoiDung.IdNhanVien;
DMNhanVienInfo nhanVien = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(idNhanVien);
if (nhanVien != null)
{
bteThuongVien.Tag = nhanVien;
bteThuongVien.Text = nhanVien.HoTen;
txtMaNhanVien.Text = nhanVien.MaNhanVien;
}
if (ChiTietGiaoNhan.IdNhanVien2 > 0)
{
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(ChiTietGiaoNhan.IdNhanVien2);
if (nv != null)
{
bteThuongVien2.Tag = nv;
bteThuongVien2.Text = nv.HoTen;
txtMaNhanVien2.Text = nv.MaNhanVien;
}
}
if (ChiTietGiaoNhan.IdNhanVien3 > 0)
{
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(ChiTietGiaoNhan.IdNhanVien3);
if (nv != null)
{
bteThuongVien3.Tag = nv;
bteThuongVien3.Text = nv.HoTen;
txtMaNhanVien3.Text = nv.MaNhanVien;
}
}
//load lai xe
if (ChiTietGiaoNhan.IdLaiXe > 0)
{
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(ChiTietGiaoNhan.IdLaiXe);
if (nv != null)
{
bteLaiXe.Tag = nv;
bteLaiXe.Text = nv.HoTen;
}
}
//load doi tac
if (ChiTietGiaoNhan.IdDoiTac > 0)
{
DMNhanVienInfo dt = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(ChiTietGiaoNhan.IdDoiTac);
if (dt != null)
{
bteDoiTac.Tag = dt;
bteDoiTac.Text = dt.HoTen;
}
}
txtNhanVienDoiTac.Text = ChiTietGiaoNhan.NhanVienDoiTac;
}
internal bool Exist(DMNhanVienInfo dmNhanVienInfor)
{
return(GetObjectCommand <int>(Declare.StoreProcedureNamespace.spNhanVienExist,
dmNhanVienInfor.IdNhanVien,
dmNhanVienInfor.MaNhanVien) > 0);
//CreateCommonCommand(Declare.StoreProcedureNamespace.spNhanVienExist);
//Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output;
//Parameters.AddWithValue("@IdNhanVien", dmNhanVienInfor.IdNhanVien);
//Parameters.AddWithValue("@MaNhanVien", dmNhanVienInfor.MaNhanVien);
//ExecuteNoneQuery();
//return Convert.ToInt32(Parameters["@Count"].Value.ToString()) == 1;
}
internal void Update(DMNhanVienInfo dmNhanVienInfor)
{
//ExecuteCommand(Declare.StoreProcedureNamespace.spNhanVienUpdate, ParseToParams(dmNhanVienInfor));
ExecuteCommand(Declare.StoreProcedureNamespace.sp_NhanVien_Update,
dmNhanVienInfor.IdNhanVien, dmNhanVienInfor.MaNhanVien,
dmNhanVienInfor.HoTen, dmNhanVienInfor.NgaySinh,
dmNhanVienInfor.GioiTinh, dmNhanVienInfor.IdPhongBan,
dmNhanVienInfor.IdChucVu, dmNhanVienInfor.DiaChi,
dmNhanVienInfor.DienThoai, dmNhanVienInfor.SuDung,
dmNhanVienInfor.Email, dmNhanVienInfor.GhiChu,
dmNhanVienInfor.IdTrungTamHachToan,
dmNhanVienInfor.IdQuanLyTrucTiep,
dmNhanVienInfor.PhuTrachCSKH, dmNhanVienInfor.MaVach);
}
internal List <DMNhanVienInfo> Search(DMNhanVienInfo dmNhanVienInfor)
{
return(GetListCommand <DMNhanVienInfo>(Declare.StoreProcedureNamespace.spNhanVienSearch,
dmNhanVienInfor.HoTen,
dmNhanVienInfor.MaNhanVien,
dmNhanVienInfor.IdPhongBan,
dmNhanVienInfor.IdChucVu));
//CreateGetListCommand(Declare.StoreProcedureNamespace.spNhanVienSearch);
//Parameters.AddWithValue("@TenNhanVien", dmNhanVienInfor.HoTen);
//Parameters.AddWithValue("@MaNhanVien", dmNhanVienInfor.MaNhanVien);
//Parameters.AddWithValue("@IdPhongBan", dmNhanVienInfor.IdPhongBan);
//Parameters.AddWithValue("@IdChucVu", dmNhanVienInfor.IdChucVu);
//return FillToList<DMNhanVienInfo>();
}
internal int Insert(DMNhanVienInfo dmNhanVienInfor)
{
//CreateCommonCommand(Declare.StoreProcedureNamespace.spNhanVienInsert);
//SetParams(dmNhanVienInfor);
//Parameters["@IdNhanVien"].Direction = ParameterDirection.Output;
//ExecuteNoneQuery();
//return Convert.ToInt32(Parameters["@IdNhanVien"].Value.ToString());
return(GetObjectCommand <int>(Declare.StoreProcedureNamespace.sp_DM_NhanVien_Insert,
dmNhanVienInfor.MaNhanVien,
dmNhanVienInfor.HoTen, dmNhanVienInfor.NgaySinh, dmNhanVienInfor.GioiTinh,
dmNhanVienInfor.IdPhongBan, dmNhanVienInfor.IdChucVu,
dmNhanVienInfor.DiaChi, dmNhanVienInfor.DienThoai, dmNhanVienInfor.Email, dmNhanVienInfor.GhiChu, dmNhanVienInfor.SuDung,
dmNhanVienInfor.IdTrungTamHachToan, dmNhanVienInfor.IdQuanLyTrucTiep, dmNhanVienInfor.PhuTrachCSKH, dmNhanVienInfor.MaVach));
}
private void txtMaNhanVien3_Leave(object sender, EventArgs e)
{
DMNhanVienInfo nhanvien = DmNhanVienDataProvider.GetNhanVienByText(txtMaNhanVien3.Text);
if (nhanvien != null)
{
txtMaNhanVien3.Text = nhanvien.MaNhanVien;
bteThuongVien3.Tag = nhanvien;
bteThuongVien3.Text = nhanvien.HoTen;
}
else
{
txtMaNhanVien3.Text = "";
bteThuongVien3.Tag = null;
bteThuongVien3.Text = "";
//bteThuongVien_KeyDown(null, null);
}
}
private void UpdateNhanVien()
{
cboNhanVien.DataSource = null;
List <DMNhanVienInfo> liNhanVien = new List <DMNhanVienInfo>();
foreach (ChungTuGiaoNhanChiTietInfor ct in (BindingList <ChungTuGiaoNhanChiTietInfor>)gPhanCongGiaoNhan.DataSource)
{
DMNhanVienInfo nv = new DMNhanVienInfo();
nv.IdNhanVien = ct.IdNhanVien;
nv.MaNhanVien = ct.MaNhanVien;
nv.HoTen = ct.HoTen;
liNhanVien.Add(nv);
}
cboNhanVien.DataSource = liNhanVien;
cboNhanVien.DisplayMember = "HoTen";
cboNhanVien.ValueMember = "IdNhanVien";
cboNhanVien.SelectedIndex = -1;
}
private void LoadThuNgan()
{
try
{
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(nguoiDung.IdNhanVien);
if (nv != null)
{
bteThuNgan.Text = nv.HoTen;
bteThuNgan.Tag = nv;
}
}
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
}
}
private void frmHT_AddNguoiDung_Load(object sender, EventArgs e)
{
LoadNhomNguoiDung();
if (objNguoiDung != null)
{
txtUserName.ReadOnly = true;
txtPassword.ReadOnly = true;
txtRetypePassword.ReadOnly = true;
txtFullName.Text = objNguoiDung.TenDayDu;
txtUserName.Text = objNguoiDung.TenDangNhap;
txtPassword.Text = objNguoiDung.MatKhau;
txtRetypePassword.Text = objNguoiDung.MatKhau;
chkSuDung.Checked = objNguoiDung.SuDung;// (objNguoiDung.SuDung == 1 ? true : false);
chkSuperUser.Checked = Common.Int2Bool(objNguoiDung.SupperUser);
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(objNguoiDung.IdNhanVien);
bteThuongVien.Text = nv.HoTen;
bteThuongVien.Tag = nv;
cboGroup.SelectedValue = objNguoiDung.IdNhomNguoiDung;
if (objNguoiDung.ThoiGianApDung == -1)
{
chkNeverExpired.Checked = true;
chkForceChangeOnExpired.Checked = false;
chkForceChangeOnExpired.Enabled = false;
txtExpiredIn.Enabled = false;
txtExpiredIn.Text = "30";
}
else
{
chkNeverExpired.Checked = false;
chkNeverExpired.Enabled = false;
chkForceChangeOnExpired.Checked = true;
txtExpiredIn.Enabled = true;
txtExpiredIn.Text = objNguoiDung.ThoiGianApDung == -1 ? "30" :
objNguoiDung.ThoiGianApDung.ToString();
}
chkForceChangeAtFirst.Checked = objNguoiDung.ChangeOnNext;
}
}
public void Insert()
{
if (objNhanVien == null)
{
objNhanVien = new DMNhanVienInfo();
objNhanVien.MaNhanVien = View.MaNhanVien;
objNhanVien.HoTen = View.HoTen;
objNhanVien.NgaySinh = View.NgaySinh;
objNhanVien.GioiTinh = View.GioiTinh;
objNhanVien.IdPhongBan = View.IdPhongBan;
objNhanVien.IdChucVu = View.IdChucVu;
objNhanVien.DiaChi = View.DiaChi;
objNhanVien.DienThoai = View.DienThoai;
objNhanVien.SuDung = View.SuDung;
objNhanVien.Email = View.Email;
objNhanVien.GhiChu = View.GhiChu;
objNhanVien.IdTrungTamHachToan = View.IdTrungTamHachToan;
objNhanVien.IdNhanVien = DMNhanVienDAO.Instance.Insert(objNhanVien);
((List <DMNhanVienInfo>)(DSNhanVienView.Instance.DataSource)).Add(objNhanVien);
DSNhanVienView.Instance.RefreshDataSource();
}
}
private DMNhanVienInfo SetNhanVien()
{
DMNhanVienInfo dm = new DMNhanVienInfo();
dm.HoTen = txtHoTen.Text.Trim();
dm.MaNhanVien = txtMaNhanVien.Text.Trim();
dm.NgaySinh = mstNgaySinh.Value;
dm.DiaChi = txtDiaChi.Text.Trim();
dm.DienThoai = txtDienThoai.Text.Trim();
dm.Email = txtEmail.Text.Trim();
dm.SuDung = Convert.ToInt32(chkSuDung.Checked);
dm.GhiChu = txtGhiChu.Text.Trim();
dm.GioiTinh = Convert.ToInt32(optNam.Checked);
dm.IdChucVu = Convert.ToInt32(cboChucVu.SelectedValue);
dm.IdPhongBan = Convert.ToInt32(cboPhongBan.SelectedValue);
dm.IdNhanVien = Convert.ToInt32(frmNV.Oid);
dm.IdTrungTamHachToan = ((DMTrungTamInfor)bteTrungTam.Tag).IdTrungTam;
dm.IdQuanLyTrucTiep = bteQLTrucTiep.Tag != null ? ((DMNhanVienInfo)bteQLTrucTiep.Tag).IdNhanVien : 0;
dm.PhuTrachCSKH = Common.Bool2Int(chkPhuTrach.Checked);
dm.MaVach = txtMaVach.Text;
return(dm);
}
public void TestNhanVien07_DeleteSuccess()
{
TestNhanVien05_InsertSuccess();
List <DMNhanVienInfo> list = DmNhanVienDataProvider.GetListDmNhanVienInfor();
DMNhanVienInfo infor = list.Find(delegate(DMNhanVienInfo match)
{
return(match.MaNhanVien == "TA111");
});
frmDM_NhanVien frm = new frmDM_NhanVien();
frm.isAdd = false;
frm.Oid = infor.IdNhanVien;
frmChiTiet_NhanVien frmChiTietNhanVien = new frmChiTiet_NhanVien(frm);
frmChiTietNhanVien.TestDelete();
list = DmNhanVienDataProvider.GetListDmNhanVienInfor();
infor = list.Find(delegate(DMNhanVienInfo match)
{
return(match.MaNhanVien == "TA111");
});
Assert.AreEqual(infor, null);
}
public void TestNhanVien03_MaNhanVienHasExistedOnUpdate()
{
try
{
TestNhanVien05_InsertSuccess();
List <DMNhanVienInfo> list = DmNhanVienDataProvider.GetListDmNhanVienInfor();
DMNhanVienInfo infor = list.Find(delegate(DMNhanVienInfo match)
{
return(match.MaNhanVien == "TA111");
});
frmDM_NhanVien frm = new frmDM_NhanVien();
frm.isAdd = false;
frm.Oid = infor.IdNhanVien;
frmChiTiet_NhanVien frmChiTietNhanVien = new frmChiTiet_NhanVien(frm);
frmChiTietNhanVien.SetInput("Bùi Đức Hạnh", "TA004", "04/02/1988", "abcdef", "12345678", "*****@*****.**", "UnitsTest Nhan Vien", 1, 42, 1);
frmChiTietNhanVien.TestSave();
list = DmNhanVienDataProvider.GetListDmNhanVienInfor();
List <DMNhanVienInfo> listDuplicate = list.FindAll(delegate(DMNhanVienInfo match)
{
return(match.MaNhanVien == "TA004");
});
frmChiTietNhanVien.TestDelete();
Assert.AreEqual(1, listDuplicate.Count);
}
catch (Exception ex)
{
if (ex.GetType() != typeof(AssertFailedException))
{
Assert.AreEqual(ex.Message, "Mã nhân viên đã tồn tại trong hệ thống !");
}
else
{
throw;
}
}
}
private void LoadChungTuHeader()
{
Draft = Business.ChungTu.Draft;
TrangThai = Business.ChungTu.TrangThai;
LoaiChungTu = Business.ChungTu.LoaiChungTu;
_IdTrungTam = Business.ChungTu.IdTrungTam;
bteKhoXuat.Tag = DMKhoDataProvider.GetKhoByIdInfo(Business.ChungTu.IdKho);
bteKhoXuat.Text = bteKhoXuat.Tag != null ? ((DMKhoInfo)bteKhoXuat.Tag).TenKho : "";
txtSoPhieuNhap.Text = Business.ChungTu.SoChungTu;
txtGhiChu.Text = Business.ChungTu.GhiChu;
try
{
dteNgayNhap.EditValue = Business.ChungTu.NgayLap;
}
catch (Exception)
{
dteNgayNhap.EditValue = CommonProvider.Instance.GetSysDate();
}
try
{
dteNgayXacNhan.EditValue = Business.ChungTu.NgayXuatHang;
}
catch (Exception)
{
dteNgayXacNhan.EditValue = CommonProvider.Instance.GetSysDate();
}
lueLyDo.EditValue = Business.ChungTu.IdLyDoGiaoDich;
grbChungTuMua.Text = "Thông tin phiếu mua hàng: " +
(String.IsNullOrEmpty(Business.ChungTu.TenTrungTam)
? ""
: (Business.ChungTu.TenTrungTam + (String.IsNullOrEmpty(Business.ChungTu.TenKho) ? "" : "(" + Business.ChungTu.TenKho + ")")));
txtSoGiaoDich.Text = Business.ChungTu.SoChungTuGoc;
txtSoPhieuXuat.Text = Business.ChungTu.SoPhieuXuat;
try
{
dteNgayLap.EditValue = Business.ChungTu.NgayHenGiaoHang;
}
catch (Exception)
{
dteNgayLap.EditValue = CommonProvider.Instance.GetSysDate();
}
try
{
dteNgayXuat.EditValue = Business.ChungTu.NgayGiaoHang;
}
catch (Exception)
{
dteNgayXuat.EditValue = CommonProvider.Instance.GetSysDate();
}
//cboCaBanHang.SelectedIndex = Business.ChungTu.CaBanHang;
txtKiHieu.Text = Business.ChungTu.KyHieu;
txtSoHoaDon.Text = Business.ChungTu.SoSeri;
txtTenDoiTuong.Text = Business.ChungTu.HoTen;
txtCongTy.Text = Business.ChungTu.CongTy;
cboGioiTinh.SelectedIndex = Business.ChungTu.GioiTinh;
txtCMND.Text = Business.ChungTu.SoCMND;
txtSoDienThoai.Text = Business.ChungTu.DienThoai;
txtEmail.Text = Business.ChungTu.Email;
txtDiaChiHD.Text = Business.ChungTu.DiaChiHoaDon;
txtDiaChiGH.Text = Business.ChungTu.DiaChiGiaoHang;
if (Business.ChungTu.IdNhanVien != 0)
{
DMNhanVienInfo nhanvien = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(Business.ChungTu.IdNhanVien);
if (nhanvien != null)
{
bteThuongVien.Tag = nhanvien;
bteThuongVien.Text = nhanvien.HoTen;
}
}
if (Business.ChungTu.IdDoiTuong != 0)
{
DMDoiTuongInfo doituong = DmDoiTuongProvider.GetDmDoiTuongInfoFromOid(Business.ChungTu.IdDoiTuong);
if (doituong != null)
{
txtKhachHang.Tag = doituong;
txtKhachHang.Text = doituong.TenDoiTuong;
}
}
if (Business.ChungTu.IdKhachLe != 0)
{
DMDoiTuongInfo khachle = DmDoiTuongProvider.GetDmDoiTuongInfoFromOid(Business.ChungTu.IdKhachLe);
if (khachle != null)
{
bteKhachLe.Tag = khachle;
bteKhachLe.Text = khachle.TenDoiTuong;
}
}
txtTongTienTT.Text = Common.Double2Str(Business.ChungTu.TongTienHang);
txtTienThucTra.Text = Common.Double2Str(Business.ChungTu.TongTienThanhToan);
txtTienConNo.Text = Common.Double2Str(Business.ChungTu.TongTienHang - Business.ChungTu.TongTienThanhToan);
txtTienTraKhach.Text = Common.Double2Str(Business.ChungTu.TienThanhToanThuc);
txtTienNoKhach.Text = Common.Double2Str(Business.ChungTu.TienConNo);
}
private void btnFilter_Click(object sender, EventArgs e)
{
#region old
// try {
// string dk = "1=1";
// if (!String.IsNullOrEmpty(txtFilterMa.Text)) {
// dk += String.Format(" and tbl_DM_NhanVien.MaNhanVien like '%{0}%'", txtFilterMa.Text);
// }
// if (!String.IsNullOrEmpty(txtFilterTen.Text)) {
// dk += String.Format(" and tbl_DM_NhanVien.HoTen like N'%{0}%'", txtFilterTen.Text);
// }
// if (cboPhongBanS.SelectedValue != null)
// {
// dk += String.Format(" and tbl_DM_NhanVien.IdPhongBan = {0}", cboPhongBanS.SelectedValue);
// }
// if (cboChucDanhS.SelectedValue != null)
// {
// dk += String.Format(" and tbl_DM_NhanVien.IdChucVu = {0}", cboChucDanhS.SelectedValue);
// }
// string sql = "SELECT tbl_DM_NhanVien.IdNhanVien, tbl_DM_NhanVien.MaNhanVien, tbl_DM_NhanVien.HoTen, tbl_DM_NhanVien.NgaySinh, " +
// "tbl_DM_NhanVien.GioiTinh, tbl_DM_PhongBan.TenPhongBan, tbl_DM_ChucVu.TenChucVu, tbl_DM_NhanVien.DiaChi, tbl_DM_NhanVien.DienThoai, tbl_DM_NhanVien.SuDung, tbl_DM_NhanVien.Email, tbl_DM_NhanVien.GhiChu " +
// "FROM tbl_DM_NhanVien LEFT OUTER JOIN " +
// "tbl_DM_PhongBan ON tbl_DM_NhanVien.IdPhongBan = tbl_DM_PhongBan.IdPhongBan LEFT OUTER JOIN " +
// "tbl_DM_ChucVu ON tbl_DM_NhanVien.IdChucVu = tbl_DM_ChucVu.IdChucVu where " + dk;
// DBTools.GridView_LoadData(dgvList, sql, true);
// int index;
// if (GridIndex == -1 || GridIndex >= dgvList.Rows.Count)
// index = 0;
// else
// index = GridIndex;
// if (dgvList.Rows.Count > 0) {
// dgvList.Rows[index].Selected = true;
// txtIdNhanVien.Text = dgvList[1, index].Value.ToString();
// txtMaNhanVien.Text = dgvList[2, index].Value.ToString();
// txtHoTen.Text = dgvList[3, index].Value.ToString();
// txtNgaySinh.Text = dgvList[4, index].Value.ToString();
// if (dgvList[5, index].Value.ToString() == "True") {
// optNam.Checked = true;
// optNu.Checked = false;
// }
// else {
// optNam.Checked = false;
// optNu.Checked = true;
// }
// cboPhongBan.Text = (dgvList[6, index].Value.ToString() == "") ? dgvList[6, index].Value.ToString() : "";
// cboChucVu.Text = (dgvList[7, index].Value.ToString() == "") ? dgvList[7, index].Value.ToString() : "";
// txtDiaChi.Text = dgvList[8, index].Value.ToString();
// txtDienThoai.Text = dgvList[9, index].Value.ToString();
// chkSuDung.Checked = Common.BoolValue(dgvList[10, index].Value.ToString());
// txtEmail.Text = dgvList[11, index].Value.ToString();
// txtGhiChu.Text = dgvList[12, index].Value.ToString();
// SetCheckListKho();
// }
// else {
// txtIdNhanVien.Text = "";
// txtMaNhanVien.Text = "";
// txtHoTen.Text = "";
// txtNgaySinh.Text = "";
// txtDiaChi.Text = "";
// txtDienThoai.Text = "";
// chkSuDung.Checked = false;
// }
// }
// catch (System.Exception ex) {
//#if DEBUG
// MessageBox.Show(ex.ToString());
//#else
// MessageBox.Show(ex.Message);
//#endif
// }
#endregion
DMNhanVienInfo dm = new DMNhanVienInfo();
dm.HoTen = txtFilterTen.Text.Trim();
dm.MaNhanVien = txtFilterMa.Text.Trim();
dm.IdChucVu = Convert.ToInt32(cboChucDanhS.SelectedValue.ToString());
dm.IdPhongBan = Convert.ToInt32(cboPhongBanS.SelectedValue.ToString());
dgvList.DataSource = DmNhanVienDataProvider.Search(dm);
}
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;
}
}
private void GetData()
{
objNhanVien = View.NhanVienInfo;
}
private void InPhieuGiaoNhan()
{
if (LstPhieuPCGN.Count == 0)
{
return;
}
HoaDonPCGNInfo hd = new HoaDonPCGNInfo();
double tongtien = 0, thuctra = 0, tienno = 0;
string sochungtu = "";
string sohoadon = "";
string ghichu = "";
foreach (ChungTuBanHangInfor ct in LstPhieuPCGN)
{
sochungtu = sochungtu + ct.SoChungTu + ",";
sohoadon = sohoadon + ct.SoSeri + ",";
ghichu = ghichu + ct.GhiChu + ",";
tongtien += ct.TongTienThanhToan;
thuctra += ct.TienThanhToanThuc;
tienno += ct.TienConNo;
}
if (LstPhieuPCGN.Count > 0)
{
DMNhanVienInfo nv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(LstPhieuPCGN[0].IdNhanVien);
hd.ThuongVien = (nv != null ? nv.HoTen : "");
}
hd.SoChungTu = sochungtu;
hd.SoHoaDon = sohoadon;
hd.NgayLap = LstPhieuPCGN[0].NgayLap;
hd.KhachHang = LstPhieuPCGN[0].TenDoiTuong;
hd.CongTy = LstPhieuPCGN[0].CongTy;
hd.HoTen = LstPhieuPCGN[0].HoTen;
hd.DiaChiHoaDon = LstPhieuPCGN[0].DiaChiHoaDon;
hd.DiaChiGiaoHang = LstPhieuPCGN[0].DiaChiGiaoHang;
hd.DienThoai = LstPhieuPCGN[0].DienThoai;
DMKhoInfo dmKho = DMKhoDataProvider.GetKhoByIdInfo(LstPhieuPCGN[0].IdKho);
if (dmKho != null)
{
hd.KhoXuat = dmKho.MaKho;
}
//hd.HinhThucThanhToan = LstPhieuPCGN[0];
hd.CachGiaoHang = LstPhieuPCGN[0].GiaoNhan != 0 ? "Giao tại nhà khách" : "Giao tại công ty";
hd.TongTienHang = tongtien;
hd.TienThanhToanThuc = thuctra;
hd.TienConNo = tienno;
//if (ListIdChungTu.Length > 0)
// ListIdChungTu = ListIdChungTu.Substring(0, ListIdChungTu.Length - 1);
hd.NhanVienKinhDoanh = "";
foreach (ChungTuGiaoNhanChiTietInfor ct in (BindingList <ChungTuGiaoNhanChiTietInfor>)gPhanCongGiaoNhan.DataSource)
{
hd.NhanVienKinhDoanh += String.Format("{0}(Phương tiện: {1})", ct.HoTen, ct.TenPhuongTien) +
(String.IsNullOrEmpty(ct.BienSoXe) ? "" : "/" + ct.BienSoXe) + ";";
}
hd.GhiChu = ghichu;
CommonFuns.Instance.InPhieuGiaoNhan(hd, liHangGiaoNhan, -1);
}
public static List <DMNhanVienInfo> Search(DMNhanVienInfo match)
{
return(DMNhanVienDAO.Instance.Search(match));
}
public static void Delete(DMNhanVienInfo dmNhanVienInfo)
{
DMNhanVienDAO.Instance.Delete(dmNhanVienInfo);
}
internal static void Update(DMNhanVienInfo dmNhanVienInfo)
{
DMNhanVienDAO.Instance.Update(dmNhanVienInfo);
}
internal static int Insert(DMNhanVienInfo dmNhanVienInfo)
{
return(DMNhanVienDAO.Instance.Insert(dmNhanVienInfo));
}
public static bool KiemTra(DMNhanVienInfo match)
{
return(DMNhanVienDAO.Instance.Exist(match));
}
protected override void LoadDataInstance()
{
//bteKhodi.Enabled = false;
if (chungTuInfo.IdKhoDieuChuyen != 0)
{
DMKhoInfo dmKho = DMKhoDataProvider.GetKhoByIdInfo(chungTuInfo.IdKhoDieuChuyen);
bteKhoDen.Tag = dmKho;
bteKhoDen.Text = dmKho.TenKho;
bteKhoDen.Enabled = false;
}
else if (chungTuInfo.TenKho != null && chungTuInfo.LoaiChungTu == Convert.ToInt32(TransactionType.DE_NGHI_NHAN_DIEU_CHUYEN) ||
chungTuInfo.TenKho != null && chungTuInfo.LoaiChungTu == Convert.ToInt32(TransactionType.NHAN_DIEU_CHUYEN))
{
bteKhoDen.Text = chungTuInfo.TenKho;
bteKhoDen.Enabled = false;
}
if (chungTuInfo.IdKhoNhanCuoi != 0)
{
DMKhoInfo dmKho = DMKhoDataProvider.GetKhoByIdInfo(chungTuInfo.IdKhoNhanCuoi);
bteKhoNhanCuoi.Tag = dmKho;
bteKhoNhanCuoi.Text = dmKho.TenKho;
bteKhoNhanCuoi.Enabled = false;
}
if (SoCTG != null)
{
ChungTuXuatDieuChuyenInfo chungTuXuatDieuChuyenInfor =
DeNghiNhapDieuChuyenDataProvider.Instance.GetListDNNDCBySoCT(SoCTG);
if (chungTuXuatDieuChuyenInfor.IdKho != 0)
{
DMKhoInfo dmKho = DMKhoDataProvider.GetKhoByIdInfo(chungTuXuatDieuChuyenInfor.IdKho);
bteKhoDi.Text = dmKho.TenKho;
bteKhoDi.Enabled = false;
}
}
else if (chungTuInfo.TenKho != null && chungTuInfo.LoaiChungTu == Convert.ToInt32(TransactionType.DE_NGHI_XUAT_DIEU_CHUYEN) ||
chungTuInfo.TenKho != null && chungTuInfo.LoaiChungTu == Convert.ToInt32(TransactionType.XUAT_DIEU_CHUYEN))
{
bteKhoDi.Text = chungTuInfo.TenKho;
bteKhoDi.Enabled = false;
}
else if (chungTuInfo.IdChungTu == 0)
{
bteKhoDi.Text = "";
}
if (chungTuInfo.GhiChu != null)
{
txtGhiChu.Text = chungTuInfo.GhiChu;
}
else
{
txtGhiChu.Text = "";
}
if (chungTuInfo.NguoiLap != null)
{
txtNguoiLap.Text = chungTuInfo.NguoiLap;
}
else
{
txtNguoiLap.Text = Declare.UserName;
}
txtHoaDonDC.Text = chungTuInfo.HoaDonDC;
txtPhuongtien.Text = chungTuInfo.PhuongTien;
if (chungTuInfo.IdNguoiVC != 0)
{
DMNhanVienInfo dmNv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(chungTuInfo.IdNguoiVC);
bteNguoiVanChuyen.Tag = dmNv;
bteNguoiVanChuyen.Text = dmNv.HoTen;
}
if (chungTuInfo.IdNguoiUyNhiem != 0)
{
DMNhanVienInfo dmNv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(chungTuInfo.IdNguoiUyNhiem);
bteNguoiUyNhiem.Tag = dmNv;
bteNguoiUyNhiem.Text = dmNv.HoTen;
}
if (chungTuInfo.IdNguoiKyDuyet != 0)
{
DMNhanVienInfo dmNv = DmNhanVienDataProvider.GetListDmNhanVienInfoFromOid(chungTuInfo.IdNguoiKyDuyet);
bteNguoiKyDuyet.Tag = dmNv;
bteNguoiKyDuyet.Text = dmNv.HoTen;
}
btnXoaSP.Enabled = chungTuInfo.IdChungTu == 0;
btnThemSP.Enabled = chungTuInfo.IdChungTu == 0;
}
