private void GetData()
{
DmucNhanvien objStaffList = DmucNhanvien.FetchByID(Utility.Int32Dbnull(txtID.Text, -1));
if (objStaffList != null)
{
txtName.Text = Utility.sDbnull(objStaffList.TenNhanvien);
txtStaffCode.Text = Utility.sDbnull(objStaffList.MaNhanvien);
cboStaffType.SelectedIndex = Utility.GetSelectedIndex(cboStaffType,
objStaffList.MaLoainhanvien.ToString());
txtUID.SetCode(objStaffList.UserName);
cboUserName.SelectedIndex = Utility.GetSelectedIndex(cboUserName, objStaffList.UserName);
cboUpLevel.SelectedIndex = Utility.GetSelectedIndex(cboUpLevel,
objStaffList.IdKhoa.ToString());
cboDepart.SelectedIndex = Utility.GetSelectedIndex(cboDepart,
objStaffList.IdPhong.ToString());
chkHienThi.Checked = Utility.Int32Dbnull(objStaffList.TrangThai, 0) == 1;
LoadQuanHeNhanVienKho();
LoadQuanHeNhanVienQuyen();
LoadQheBS_khoanoitru();
LoadQheBS_khoangoaitru();
LoadQheLoaithuoc();
LoadQheDichvuCLS();
}
}
private DmucNhanvien TaoDoituongNhanvien()
{
DmucNhanvien objDmucNhanvien = null;
if (em_Action == action.Update)
{
objDmucNhanvien = DmucNhanvien.FetchByID(Utility.Int16Dbnull(txtID.Text, -1));
objDmucNhanvien.MarkOld();
objDmucNhanvien.IsNew = false;
objDmucNhanvien.IsLoaded = true;
}
else
{
objDmucNhanvien = new DmucNhanvien();
objDmucNhanvien.IsNew = true;
}
objDmucNhanvien.MaNhanvien = Utility.sDbnull(txtStaffCode.Text);
objDmucNhanvien.TenNhanvien = Utility.sDbnull(txtName.Text);
objDmucNhanvien.IdPhong = Utility.Int16Dbnull(cboDepart.SelectedValue, -1);
objDmucNhanvien.IdKhoa = Utility.Int32Dbnull(cboUpLevel.SelectedValue, -1);
objDmucNhanvien.MaLoainhanvien = Utility.sDbnull(cboStaffType.SelectedValue, "-1");
objDmucNhanvien.UserName = Utility.sDbnull(cboUserName.SelectedValue, "");
objDmucNhanvien.TrangThai = Convert.ToByte(chkHienThi.Checked?1:0);
objDmucNhanvien.MotaThem = Utility.DoTrim(txtmotathem.Text);
objDmucNhanvien.NgayTao = globalVariables.SysDate;
objDmucNhanvien.NguoiTao = globalVariables.UserName;
return(objDmucNhanvien);
}
/// <summary>
/// hàm thực hiện việc thêm phiếu nhập kho thuốc
/// </summary>
private void ThemPhieuXuatKho()
{
TPhieutrathuocKholeVekhochan objPhieuNhap = CreatePhieuNhapKho();
ActionResult actionResult = new PhieuTraLai().ThemPhieuTraLaiKho
(objPhieuNhap, CreateArrPhieuChiTiet());
switch (actionResult)
{
case ActionResult.Success:
txtIDPhieuNhapKho.Text = Utility.sDbnull(objPhieuNhap.IdPhieu);
txtMaPhieu.Text = Utility.sDbnull(objPhieuNhap.MaPhieu);
TPhieutrathuocKholeVekhochan objDPhieuNhap = TPhieutrathuocKholeVekhochan.FetchByID(Utility.Int32Dbnull(txtIDPhieuNhapKho.Text));
DataRow newDr = p_dtPhieuNhapTra.NewRow();
Utility.FromObjectToDatarow(objDPhieuNhap, ref newDr);
TDmucKho objKho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKhoLinh.SelectedValue, -1));
if (objKho != null)
{
newDr["ten_khonhap"] = Utility.sDbnull(objKho.TenKho);
}
objKho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKhoTra.SelectedValue, -1));
if (objKho != null)
{
newDr["ten_khoxuat"] = Utility.sDbnull(objKho.TenKho);
}
DmucNhanvien objStaff = DmucNhanvien.FetchByID(Utility.Int32Dbnull(cboNhanVien.SelectedValue));
if (objStaff != null)
{
newDr["ten_nhanvien"] = Utility.sDbnull(objStaff.TenNhanvien);
}
p_dtPhieuNhapTra.Rows.Add(newDr);
grdList.UpdateData();
//Utility.ShowMsg("Bạn thêm mới phiếu thành công", "Thông báo");
Utility.GonewRowJanus(grdList, TPhieutrathuocKholeVekhochan.Columns.IdPhieu, Utility.sDbnull(txtIDPhieuNhapKho.Text));
em_Action = action.Insert;
b_Cancel = true;
this.Close();
break;
case ActionResult.Error:
Utility.ShowMsg("Lỗi trong quá trình thêm phiếu", "Thông báo lỗi", MessageBoxIcon.Error);
break;
}
}
private void getDataChiDinh()
{
if (objAssignInfo != null)
{
barcode.Data = Utility.sDbnull(objAssignInfo.MaChidinh);
lblAssignCode.Text = Utility.sDbnull(objAssignInfo.MaChidinh);
DmucNhanvien objStaff = DmucNhanvien.FetchByID(objAssignInfo.IdBacsiChidinh);
if (objStaff != null)
{
lblStaffName.Text = Utility.sDbnull(objStaff.TenNhanvien);
}
else
{
lblStaffName.Text = Utility.sDbnull(objAssignInfo.NgayTao);
}
getData();
}
else
{
cmdInPhieuXN.Enabled = false;
}
}
private void getData()
{
TPhieuCapphatNoitru objPhieuCapphat = TPhieuCapphatNoitru.FetchByID(Utility.Int32Dbnull(txtID_CAPPHAT.Text));
if (objPhieuCapphat != null)
{
txtID_CAPPHAT.Text = Utility.sDbnull(objPhieuCapphat.IdCapphat);
dtNgayCapPhat.Value = dtNgayCapPhat.Value;
txtID_KHOA_LINH.Text = Utility.sDbnull(objPhieuCapphat.IdKhoaLinh);
idKhoaLinh = Utility.Int32Dbnull(objPhieuCapphat.IdKhoaLinh);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objPhieuCapphat.IdKhoaLinh);
if (objLDepartment != null)
{
txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.TenKhoaphong);
}
//chkIsBoSung.Checked = Convert.ToBoolean(objPhieuCapphat.LinhBSung);
IsPhieuBoSung = Utility.Byte2Bool(objPhieuCapphat.LoaiPhieu);
radLinhBoSung.Checked = IsPhieuBoSung;
loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu);
radThuoc.Checked = loaiphieu == "THUOC";
radLinhVTYT.Checked = loaiphieu == "VT";
txtID_NVIEN.Text = Utility.sDbnull(objPhieuCapphat.IdNhanviencapphat);
DmucNhanvien objStaff = DmucNhanvien.FetchByID(objPhieuCapphat.IdNhanviencapphat);
if (objStaff != null)
{
txtTen_NVIEN.Text = Utility.sDbnull(objStaff.TenNhanvien);
}
txtId_KhoXuat.Text = Utility.sDbnull(objPhieuCapphat.IdKhoXuat);
id_khoXuat = Utility.Int32Dbnull(objPhieuCapphat.IdKhoXuat);
DKho objKho = DKho.FetchByID(objPhieuCapphat.IdKhoXuat);
if (objKho != null)
{
txtTenKho.Text = Utility.sDbnull(objKho.TenKho);
}
madoituong = Utility.sDbnull(objPhieuCapphat.MaDoiTuong);
txtMaDoiTuong.Text = Utility.sDbnull(madoituong);
SqlQuery sqlQuery = new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong);
LObjectType objectType = sqlQuery.ExecuteSingle <LObjectType>();
if (objectType != null)
{
txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName);
}
txtMOTA_THEM.Text = Utility.sDbnull(objPhieuCapphat.MotaThem);
}
else
{
dtNgayCapPhat.Value = BusinessHelper.GetSysDateTime();
txtID_KHOA_LINH.Text = Utility.sDbnull(idKhoaLinh);
LDepartment objLDepartment = LDepartment.FetchByID(idKhoaLinh);
if (objLDepartment != null)
{
txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.DepartmentName);
}
txtID_NVIEN.Text = Utility.sDbnull(globalVariables.gv_StaffID);
LStaff objStaff = LStaff.FetchByID(globalVariables.gv_StaffID);
if (objStaff != null)
{
txtTen_NVIEN.Text = Utility.sDbnull(objStaff.StaffName);
}
txtId_KhoXuat.Text = Utility.sDbnull(id_khoXuat);
DKho objKho = DKho.FetchByID(id_khoXuat);
if (objKho != null)
{
txtTenKho.Text = Utility.sDbnull(objKho.TenKho);
}
//loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu);
radThuoc.Checked = loaiphieu == "THUOC";
radLinhVTYT.Checked = loaiphieu == "VT";
radLinhBoSung.Checked = IsPhieuBoSung;
// IsPhieuBoSung = Convert.ToBoolean(objPhieuCapphat.LinhBSung);
txtMaDoiTuong.Text = Utility.sDbnull(madoituong);
SqlQuery sqlQuery = new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong);
LObjectType objectType = sqlQuery.ExecuteSingle <LObjectType>();
if (objectType != null)
{
txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName);
}
}
LoadPhieuDonThuoc();
}
private void getData()
{
TPhieuCapphatNoitru objPhieuCapphat = TPhieuCapphatNoitru.FetchByID(Utility.Int32Dbnull(txtID_CAPPHAT.Text));
if (objPhieuCapphat != null)
{
txtID_CAPPHAT.Text = Utility.sDbnull(objPhieuCapphat.IdCapphat);
if (!string.IsNullOrEmpty(Utility.sDbnull(objPhieuCapphat.NgayNhap)))
{
dtNgayCapPhat.Value = Convert.ToDateTime(objPhieuCapphat.NgayNhap);
}
else
{
dtNgayCapPhat.Value = DateTime.Now;
}
txtID_KHOA_LINH.Text = Utility.sDbnull(objPhieuCapphat.IdKhoaLinh);
idKhoaLinh = Utility.Int32Dbnull(objPhieuCapphat.IdKhoaLinh);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objPhieuCapphat.IdKhoaLinh);
if (objLDepartment != null)
{
txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.DepartmentName);
}
//chkIsBoSung.Checked = Convert.ToBoolean(objPhieuCapphat.LinhBSung);
IsPhieuBoSung = Convert.ToBoolean(objPhieuCapphat.loaiPhieu);
radLinhBoSung.Checked = IsPhieuBoSung;
loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu);
radThuoc.Checked = loaiphieu == "THUOC";
radLinhVTYT.Checked = loaiphieu == "VT";
txtID_NVIEN.Text = Utility.sDbnull(objPhieuCapphat.idn);
DmucNhanvien objStaff = DmucNhanvien.FetchByID(objPhieuCapphat.IdNvien);
if (objStaff != null)
{
txtTen_NVIEN.Text = Utility.sDbnull(objStaff.StaffName);
}
txtId_KhoXuat.Text = Utility.sDbnull(objPhieuCapphat.IdKhoXuat);
id_khoXuat = Utility.Int32Dbnull(objPhieuCapphat.IdKhoXuat);
DKho objKho = DKho.FetchByID(objPhieuCapphat.IdKhoXuat);
if (objKho != null)
{
txtTenKho.Text = Utility.sDbnull(objKho.TenKho);
}
madoituong = Utility.sDbnull(objPhieuCapphat.MaDoiTuong);
txtMaDoiTuong.Text = Utility.sDbnull(madoituong);
if (globalVariables.gv_TongHopDonThuocMaDoiTuong)
{
SqlQuery sqlQuery =
new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong);
var objectType = sqlQuery.ExecuteSingle <LObjectType>();
if (objectType != null)
{
txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName);
}
}
else
{
txtObjectType_Name.Text = "Tất cả";
}
txtMOTA_THEM.Text = Utility.sDbnull(objPhieuCapphat.MotaThem);
me_Action = action.Update;
}
else
{
dtNgayCapPhat.Value = globalVariables.SysDate;
txtID_KHOA_LINH.Text = Utility.sDbnull(idKhoaLinh);
LDepartment objLDepartment = LDepartment.FetchByID(idKhoaLinh);
if (objLDepartment != null)
{
txtTen_KHOA_LINH.Text = Utility.sDbnull(objLDepartment.DepartmentName);
}
txtID_NVIEN.Text = Utility.sDbnull(globalVariables.gv_StaffID);
LStaff objStaff = LStaff.FetchByID(globalVariables.gv_StaffID);
if (objStaff != null)
{
txtTen_NVIEN.Text = Utility.sDbnull(objStaff.StaffName);
}
txtId_KhoXuat.Text = Utility.sDbnull(id_khoXuat);
DKho objKho = DKho.FetchByID(id_khoXuat);
if (objKho != null)
{
txtTenKho.Text = Utility.sDbnull(objKho.TenKho);
}
//loaiphieu = Utility.sDbnull(objPhieuCapphat.LoaiPhieu);
radThuoc.Checked = loaiphieu == "THUOC";
radLinhVTYT.Checked = loaiphieu == "VT";
radLinhBoSung.Checked = IsPhieuBoSung;
// IsPhieuBoSung = Convert.ToBoolean(objPhieuCapphat.LinhBSung);
txtMaDoiTuong.Text = Utility.sDbnull(madoituong);
if (globalVariables.gv_TongHopDonThuocMaDoiTuong)
{
SqlQuery sqlQuery =
new Select().From <LObjectType>().Where(LObjectType.Columns.ObjectTypeCode).IsEqualTo(madoituong);
var objectType = sqlQuery.ExecuteSingle <LObjectType>();
if (objectType != null)
{
txtObjectType_Name.Text = Utility.sDbnull(objectType.ObjectTypeName);
}
}
else
{
txtObjectType_Name.Text = "Tất cả";
}
}
LoadDonThuoc();
}
