/// <summary>
/// hàm thực hiện việc thêm phiếu nhập kho thuốc
/// </summary>
private void ThemPhieuthanhly()
{
TPhieuNhapxuatthuoc objPhieuNhap = CreatePhieuNhapKho();
ActionResult actionResult = new XuatThuoc().ThemPhieuXuatKho(objPhieuNhap, CreateArrPhieuChiTiet());
switch (actionResult)
{
case ActionResult.Success:
txtIDPhieuNhapKho.Text = Utility.sDbnull(objPhieuNhap.IdPhieu);
txtMaPhieu.Text = Utility.sDbnull(objPhieuNhap.MaPhieu);
TPhieuNhapxuatthuoc objPhieu = TPhieuNhapxuatthuoc.FetchByID(Utility.Int32Dbnull(txtIDPhieuNhapKho.Text));
DataRow newDr = p_mDataPhieuNhapKho.NewRow();
Utility.FromObjectToDatarow(objPhieu, ref newDr);
TDmucKho objKho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKhohuy.SelectedValue, -1));
if (objKho != null)
{
newDr["ten_khoxuat"] = Utility.sDbnull(objKho.TenKho);
}
p_mDataPhieuNhapKho.Rows.Add(newDr);
Utility.GonewRowJanus(grdList, TPhieuNhapxuatthuoc.Columns.IdPhieu, Utility.sDbnull(txtIDPhieuNhapKho.Text));
//Utility.ShowMsg("Bạn thêm mới phiếu chuyển kho thành công", "Thông báo");
m_enAction = 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 FrmThongTinDonThuoc_Load(object sender, EventArgs e)
{
//
objDKho =
new Select().From(TDmucKho.Schema)
.Where(TDmucKho.Columns.IdKho)
.IsEqualTo(idkhosaochep)
.ExecuteSingle <TDmucKho>();
objLuotkham =
new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham)
.IsEqualTo(txtPatientCode.Text.Trim())
.ExecuteSingle <KcbLuotkham>();
m_dtqheCamchidinhChungphieu = globalVariables.gv_dtDmucQheCamCLSChungPhieu;
_bhytPtramTraituyennoitru =
Utility.DecimaltoDbnull(
THU_VIEN_CHUNG.Laygiatrithamsohethong("BHYT_PTRAM_TRAITUYENNOITRU", "0", false), 0m);
if (!string.IsNullOrEmpty(txtMaBenhChinh.Text.Trim()))
{
LoadThongTinChanDoan(txtMaBenhChinh.Text);
}
m_dtDonthuocChitiet = _kedonthuoc.LaythongtinchitietdonthuocDeSaoChep(Utility.Int64Dbnull(txtPres_ID.Text));
if (m_dtDonthuocChitiet.Rows.Count > 0)
{
Utility.SetDataSourceForDataGridEx(grdPresDetail, m_dtDonthuocChitiet, false, true, "", "");
grdPresDetail.CheckAllRecords();
m_dtDonthuocChitiet_View = m_dtDonthuocChitiet.Clone();
}
}
/// <summary>
/// hàm thực hiện việc thêm mới thông tin
/// </summary>
private void InsertData()
{
try
{
TDmucKho objDmuckho = CreateKhoThuoc();
objDmuckho.IsNew = true;
objDmuckho.Save();
txtIDKHO.Text = Utility.sDbnull(objDmuckho.IdKho);
objDmuckho = TDmucKho.FetchByID(Utility.Int32Dbnull(txtIDKHO.Text, -1));
if (objDmuckho != null)
{
DataRow dataRow = p_dtDataChung.NewRow();
Utility.FromObjectToDatarow(objDmuckho, ref dataRow);
p_dtDataChung.Rows.Add(dataRow);
Utility.GonewRowJanus(grdList, TDmucKho.Columns.IdKho, Utility.sDbnull(txtIDKHO.Text));
}
foreach (QheDoituongKho objdoituongkho in CreateDoiTuongKhoThem())
{
QuanHeDoiTuongKho.THEM_DOITUONG_KHO(objdoituongkho);
}
// Utility.ShowMsg("Bạn thực hiện thêm mới thành công", "Thông báo", MessageBoxIcon.Information);
if (chkTrangThaiForm.Checked)
{
this.Close();
}
else
{
NhapLienTuc();
}
}
catch (Exception)
{
throw;
}
}
private void LoadThuocTrongKho()
{
TDmucKho _kho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKho.SelectedValue, -1));
if (_kho != null)
{
kieu_thuocvattu = _kho.KhoThuocVt;
if (kieu_thuocvattu != "THUOC" || kieu_thuocvattu != "VT")
{
kieu_thuocvattu = "ALL";
}
DataSet ds = SPs.ThuocLaythongtinthuoctontrongkhoTheokho(Utility.Int32Dbnull(cboKho.SelectedValue, -1)).GetDataSet();
m_dtKhothuoc = ds.Tables[0];
m_dataFull = ds.Tables[1];
Utility.SetDataSourceForDataGridEx(grdList, m_dtKhothuoc, true, true, "1=1", "TEN_THUOC");
string Orderby = TThuockho.Columns.SttBan;
Utility.SetDataSourceForDataGridEx(grdDieuchinh, m_dataFull, true, true, "1=2", getOrderOut());
if (grdList.GetDataRows().Length > 0)
{
grdList.MoveFirst();
grdList_CurrentCellChanged(grdList, new EventArgs());
}
}
else
{
m_dtKhothuoc.Rows.Clear();
m_dataFull.Rows.Clear();
m_dtkho.Rows.Clear();
}
}
private void Getdata()
{
TDmucKho objDmucKho = TDmucKho.FetchByID(Utility.sDbnull(txtIDKHO.Text, -1));
if (objDmucKho != null)
{
txt_STT_HTHI.Text = Utility.sDbnull(objDmucKho.SttHthi, 1);
txtMa.Text = Utility.sDbnull(objDmucKho.MaKho, "");
txtTEN.Text = Utility.sDbnull(objDmucKho.TenKho, "");
radKhoChan.Checked = objDmucKho.KieuKho == "CHAN";
radKhoLe.Checked = objDmucKho.KieuKho == "LE";
optChanle.Checked = objDmucKho.KieuKho == "CHANLE";
chkChongiakhikedon.Checked = Utility.Byte2Bool(objDmucKho.ChophepChongia);
txtKieubiendong.SetCode(objDmucKho.KieuBiendong);
if (Utility.sDbnull(objDmucKho.KhoThuocVt) == "VT")
{
optVT.Checked = true;
}
else if (Utility.sDbnull(objDmucKho.KhoThuocVt) == "THUOC")
{
optThuoc.Checked = true;
}
else
{
optThuocVT.Checked = true;
}
optKhothuong.Checked = Utility.ByteDbnull(objDmucKho.LoaiKho, 0) == 0;
optKhoAo.Checked = Utility.ByteDbnull(objDmucKho.LoaiKho, 0) == 1;
txtKhoanoitru.SetId(Utility.sDbnull(objDmucKho.IdKhoaphong, "-1"));
chkSoLuongTon.Checked = Utility.Int32Dbnull(objDmucKho.KtraTon) == 1;
chkTuThuoc.Checked = Utility.Int32Dbnull(objDmucKho.LaTuthuoc) == 1;
chkHienThi.Checked = Utility.Int32Dbnull(objDmucKho.TrangThai) == 1;
int loaiBN = 0;
if (Utility.sDbnull(objDmucKho.LoaiBnhan, "") == "TATCA")
{
loaiBN = 0;
}
else if (Utility.sDbnull(objDmucKho.LoaiBnhan, "") == "NGOAITRU")
{
loaiBN = 1;
}
else if (Utility.sDbnull(objDmucKho.LoaiBnhan, "") == "NOITRU")
{
loaiBN = 2;
}
radTatCa.Checked = loaiBN == 0;
radNgoaiTru.Checked = loaiBN == 1;
radNoiTru.Checked = loaiBN == 2;
txtGhiChu.Text = Utility.sDbnull(objDmucKho.MotaThem);
chkKhoBan.Checked = Utility.Int32Dbnull(objDmucKho.LaQuaythuoc) == 1;
}
}
void SelectStock()
{
if (Utility.Int32Dbnull(cboKho.SelectedValue, -1) < 0)
{
_item = null;
}
else
{
_item = new Select().From(TDmucKho.Schema).Where(TDmucKho.IdKhoColumn).IsEqualTo(Utility.Int32Dbnull(cboKho.SelectedValue)).ExecuteSingle <TDmucKho>();
GetKieuThuocVT();
BindThuocVT();
}
}
private void chkThekhochitiet_CheckedChanged(object sender, EventArgs e)
{
if (!allowChanged)
{
return;
}
if (_item == null)
{
_item =
new Select().From(TDmucKho.Schema).Where(TDmucKho.IdKhoColumn).IsEqualTo(
Utility.Int32Dbnull(cboKho.SelectedValue)).ExecuteSingle <TDmucKho>();
}
GetKieuThuocVT();
}
private void UpdatePhieuXuatKho()
{
TPhieuNhapxuatthuoc objPhieuNhap = CreatePhieuNhapKho();
ActionResult actionResult = new XuatThuoc().UpdatePhieuXuatKho(objPhieuNhap, CreateArrPhieuChiTiet());
switch (actionResult)
{
case ActionResult.Success:
TPhieuNhapxuatthuoc objTPhieuNhapxuatthuoc = TPhieuNhapxuatthuoc.FetchByID(Utility.Int32Dbnull(txtIDPhieuNhapKho.Text));
DataRow[] arrDr =
p_mDataPhieuNhapKho.Select(string.Format("{0}={1}", TPhieuNhapxuatthuoc.Columns.IdPhieu,
Utility.Int32Dbnull(txtIDPhieuNhapKho.Text)));
if (arrDr.GetLength(0) > 0)
{
arrDr[0].Delete();
}
DataRow newDr = p_mDataPhieuNhapKho.NewRow();
Utility.FromObjectToDatarow(objTPhieuNhapxuatthuoc, ref newDr);
TDmucKho objKho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKhoNhap.SelectedValue, -1));
if (objKho != null)
{
newDr["TEN_KHO_NHAP"] = Utility.sDbnull(objKho.TenKho);
}
objKho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKhoXuat.SelectedValue, -1));
if (objKho != null)
{
newDr["TEN_KHO_XUAT"] = Utility.sDbnull(objKho.TenKho);
}
newDr["ID_KHOA_LINH"] = Utility.Int16Dbnull(cboKhoaTra.SelectedValue, 0);
newDr["TEN_KHOA"] = cboKhoaTra.Text;
p_mDataPhieuNhapKho.Rows.Add(newDr);
Utility.GonewRowJanus(grdList, TPhieuNhapxuatthuoc.Columns.IdPhieu, Utility.sDbnull(txtIDPhieuNhapKho.Text));
Utility.ShowMsg("Bạn sửa phiếu trả thành công", "Thông báo");
m_enAction = action.Insert;
b_Cancel = true;
break;
case ActionResult.Error:
Utility.ShowMsg("Lỗi trong quá trình sửa phiếu", "Thông báo lỗi", MessageBoxIcon.Error);
break;
}
}
/// <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 UpdatePhieuXuatKho()
{
TPhieuNhapxuatthuoc objPhieuNhap = CreatePhieuNhapKho();
ActionResult actionResult = new XuatThuoc().UpdatePhieuXuatKho(objPhieuNhap, CreateArrPhieuChiTiet());
switch (actionResult)
{
case ActionResult.Success:
TPhieuNhapxuatthuoc objTPhieuNhapxuatthuoc = TPhieuNhapxuatthuoc.FetchByID(Utility.Int32Dbnull(txtIDPhieuNhapKho.Text));
DataRow[] arrDr =
p_mDataPhieuNhapKho.Select(string.Format("{0}={1}", TPhieuNhapxuatthuoc.Columns.IdPhieu,
Utility.Int32Dbnull(txtIDPhieuNhapKho.Text)));
if (arrDr.GetLength(0) > 0)
{
arrDr[0].Delete();
}
DataRow newDr = p_mDataPhieuNhapKho.NewRow();
Utility.FromObjectToDatarow(objTPhieuNhapxuatthuoc, ref newDr);
DmucChung objNhaCC = THU_VIEN_CHUNG.LaydoituongDmucChung("NHACUNGCAP", txtNhacungcap.myCode);
if (objNhaCC != null)
{
newDr["ten_nhacungcap"] = Utility.sDbnull(objNhaCC.Ten);
}
TDmucKho objKho = TDmucKho.FetchByID(Utility.Int32Dbnull(cboKhoXuat.SelectedValue, -1));
if (objKho != null)
{
newDr["ten_khoxuat"] = Utility.sDbnull(objKho.TenKho);
}
p_mDataPhieuNhapKho.Rows.Add(newDr);
Utility.GonewRowJanus(grdList, TPhieuNhapxuatthuoc.Columns.IdPhieu, Utility.sDbnull(txtIDPhieuNhapKho.Text));
//Utility.ShowMsg("Bạn sửa phiếu thành công", "Thông báo");
m_enAction = action.Insert;
this.Close();
b_Cancel = true;
break;
case ActionResult.Error:
Utility.ShowMsg("Lỗi trong quá trình sửa phiếu", "Thông báo lỗi", MessageBoxIcon.Error);
break;
}
}
private void UpdatePhieuXuatKho()
{
TPhieutrathuocKholeVekhochan objPhieuNhap = CreatePhieuNhapKho();
ActionResult actionResult = new PhieuTraLai().UpdatePhieuTraLaiKho(objPhieuNhap, CreateArrPhieuChiTiet());
switch (actionResult)
{
case ActionResult.Success:
TPhieutrathuocKholeVekhochan objDPhieuNhap = TPhieutrathuocKholeVekhochan.FetchByID(Utility.Int32Dbnull(txtIDPhieuNhapKho.Text));
DataRow[] arrDr =
p_dtPhieuNhapTra.Select(string.Format("{0}={1}", TPhieutrathuocKholeVekhochan.Columns.IdPhieu,
Utility.Int32Dbnull(txtIDPhieuNhapKho.Text)));
if (arrDr.GetLength(0) > 0)
{
arrDr[0].Delete();
}
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);
}
p_dtPhieuNhapTra.Rows.Add(newDr);
Utility.GonewRowJanus(grdList, TPhieutrathuocKholeVekhochan.Columns.IdPhieu, Utility.sDbnull(txtIDPhieuNhapKho.Text));
Utility.ShowMsg("Bạn sửa phiếu thành công", "Thông báo");
em_Action = action.Insert;
this.Close();
b_Cancel = true;
break;
case ActionResult.Error:
Utility.ShowMsg("Lỗi trong quá trình sửa phiếu", "Thông báo lỗi", MessageBoxIcon.Error);
break;
}
}
/// <summary>
/// hàm thực hiện việc cập nhập lại thông tin thành công
/// </summary>
private void UpdateData()
{
try
{
TDmucKho objDmuckho = CreateKhoThuoc();
objDmuckho.Save();
m_blnCancel = false;
objDmuckho = TDmucKho.FetchByID(Utility.Int32Dbnull(txtIDKHO.Text, -1));
DataRow[] arrDr =
p_dtDataChung.Select(string.Format("{0}={1}", TDmucKho.Columns.IdKho, Utility.Int32Dbnull(txtIDKHO.Text)));
if (arrDr.GetLength(0) > 0)
{
arrDr[0].Delete();
}
p_dtDataChung.AcceptChanges();
if (objDmuckho != null)
{
DataRow dataRow = p_dtDataChung.NewRow();
Utility.FromObjectToDatarow(objDmuckho, ref dataRow);
p_dtDataChung.Rows.Add(dataRow);
Utility.GonewRowJanus(grdList, TDmucKho.Columns.IdKho, Utility.sDbnull(txtIDKHO.Text));
}
new Delete().From(QheDoituongKho.Schema)
.Where(QheDoituongKho.Columns.IdKho).IsEqualTo(Utility.Int32Dbnull(txtIDKHO.Text, -1))
.Execute();
foreach (QheDoituongKho objdoituongkho in CreateDoiTuongKhoThem())
{
QuanHeDoiTuongKho.THEM_DOITUONG_KHO(objdoituongkho);
}
Utility.ShowMsg("Bạn đã cập nhật dữ liệu thành công", "Thông báo", MessageBoxIcon.Information);
if (chkTrangThaiForm.Checked)
{
this.Close();
}
}
catch (Exception)
{
throw;
}
}
void SelectStock()
{
if (Utility.Int32Dbnull(cboKho.SelectedValue, -1) < 0)
_item = null;
else
{
_item = new Select().From(TDmucKho.Schema).Where(TDmucKho.IdKhoColumn).IsEqualTo(Utility.Int32Dbnull(cboKho.SelectedValue)).ExecuteSingle<TDmucKho>();
GetKieuThuocVT();
BindThuocVT();
}
}
private TDmucKho CreateKhoThuoc()
{
TDmucKho objDmuckho = new TDmucKho();
if (em_Action == action.Update)
{
objDmuckho.IsLoaded = true;
objDmuckho.MarkOld();
objDmuckho.IdKho = Utility.Int32Dbnull(txtIDKHO.Text, -1);
objDmuckho.NgaySua = globalVariables.SysDate;
objDmuckho.NguoiSua = globalVariables.UserName;
}
objDmuckho.MaKho = Utility.sDbnull(txtMa.Text.ToUpper());
objDmuckho.ChophepChongia = Utility.Bool2byte(chkChongiakhikedon.Checked);
objDmuckho.TenKho = txtTEN.Text;
objDmuckho.SttHthi = Utility.Int32Dbnull(txt_STT_HTHI.Value);
objDmuckho.IdKhoaphong = Utility.Int16Dbnull(txtKhoanoitru.MyID, -1);
objDmuckho.KhoThuocVt = optThuoc.Checked ? "THUOC" : (optVT.Checked ? "VT":"THUOCVT");
objDmuckho.KtraTon = Utility.ByteDbnull(chkSoLuongTon.Checked, 0);
objDmuckho.LaTuthuoc = Utility.ByteDbnull(chkTuThuoc.Checked, 0);
objDmuckho.MotaThem = Utility.sDbnull(txtGhiChu.Text);
objDmuckho.LaQuaythuoc = (byte?)(chkKhoBan.Checked ? 1 : 0);
objDmuckho.TrangThai = (byte?)(chkHienThi.Checked ? 1 : 0);
objDmuckho.KieuBiendong = txtKieubiendong.myCode;
objDmuckho.NgayTao = globalVariables.SysDate;
objDmuckho.NguoiTao = globalVariables.UserName;
objDmuckho.LoaiKho = Utility.Bool2byte(optKhoAo.Checked);
byte kieukho = 0;
//if(radKhoTong.Checked) kieukho = 0;
if (radKhoLe.Checked)
{
kieukho = 1;
}
if (radKhoChan.Checked)
{
kieukho = 2;
}
if (optChanle.Checked)
{
kieukho = 3;
}
objDmuckho.KieuKho = kieukho == 1 ? "LE" : (kieukho == 2 ? "CHAN" : "CHANLE");
string loaiBN = "TATCA";
if (radTatCa.Checked)
{
loaiBN = "TATCA";
}
if (radNgoaiTru.Checked)
{
loaiBN = "NGOAITRU";
}
if (radNoiTru.Checked)
{
loaiBN = "NOITRU";
}
objDmuckho.LoaiBnhan = loaiBN;
return(objDmuckho);
}
private void cboStock_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if ((this.blnHasLoaded && (this.cboStock.Items.Count > 0)) && ((this.cboStock.SelectedValue == null) || (this.cboStock.SelectedValue.ToString() != "-1")))
{
globalVariables.KHOKEDON = Utility.Int32Dbnull(this.cboStock.SelectedValue, -1);
if (KIEU_THUOC_VT == "THUOC")
PropertyLib._ThamKhamProperties.IDKho = globalVariables.KHOKEDON;
else
PropertyLib._ThamKhamProperties.IDKhoVT = globalVariables.KHOKEDON;
PropertyLib.SaveProperty(PropertyLib._ThamKhamProperties);
int num = Utility.Int32Dbnull(this.cboStock.SelectedValue, -1);
if ((num > 0) && (this.blnHasLoaded && (this.cboStock.Items.Count > 0)))
{
this.m_dtDanhmucthuoc = this._KEDONTHUOC.LayThuoctrongkhokedon(num, KIEU_THUOC_VT, Utility.sDbnull(this.objLuotkham.MaDoituongKcb, "DV"), Utility.Int32Dbnull(this.objLuotkham.DungTuyen.Value, 0), noitru, globalVariables.MA_KHOA_THIEN);
this.ProcessData();
objDKho = ReadOnlyRecord<TDmucKho>.FetchByID(num);
this.rowFilter = "1=1";
this.txtdrug.AllowedSelectPrice = Utility.Byte2Bool(objDKho.ChophepChongia);
this.txtdrug.dtData = this.m_dtDanhmucthuoc;
this.txtdrug.ChangeDataSource();
this.txtdrug.Focus();
this.txtdrug.SelectAll();
}
else
{
objDKho = null;
}
}
}
catch (Exception exception)
{
Utility.CatchException(exception);
}
}
private TDmucKho CreateKhoThuoc()
{
TDmucKho objDmuckho = new TDmucKho();
if (em_Action == action.Update)
{
objDmuckho.IsLoaded = true;
objDmuckho.MarkOld();
objDmuckho.IdKho = Utility.Int32Dbnull(txtIDKHO.Text, -1);
objDmuckho.NgaySua = globalVariables.SysDate;
objDmuckho.NguoiSua = globalVariables.UserName;
}
objDmuckho.MaKho = Utility.sDbnull(txtMa.Text.ToUpper());
objDmuckho.ChophepChongia = Utility.Bool2byte(chkChongiakhikedon.Checked);
objDmuckho.TenKho = txtTEN.Text;
objDmuckho.SttHthi = Utility.Int32Dbnull(txt_STT_HTHI.Value);
objDmuckho.IdKhoaphong = Utility.Int16Dbnull(txtKhoanoitru.MyID, -1);
objDmuckho.KhoThuocVt = optThuoc.Checked ? "THUOC" : (optVT.Checked ? "VT":"THUOCVT") ;
objDmuckho.KtraTon = Utility.ByteDbnull(chkSoLuongTon.Checked, 0);
objDmuckho.LaTuthuoc = Utility.ByteDbnull(chkTuThuoc.Checked, 0);
objDmuckho.MotaThem = Utility.sDbnull(txtGhiChu.Text);
objDmuckho.LaQuaythuoc = (byte?)(chkKhoBan.Checked ? 1 : 0);
objDmuckho.TrangThai = (byte?) (chkHienThi.Checked ? 1 : 0);
objDmuckho.KieuBiendong = txtKieubiendong.myCode;
objDmuckho.NgayTao = globalVariables.SysDate;
objDmuckho.NguoiTao = globalVariables.UserName;
objDmuckho.LoaiKho = Utility.Bool2byte(optKhoAo.Checked);
byte kieukho = 0;
//if(radKhoTong.Checked) kieukho = 0;
if (radKhoLe.Checked) kieukho = 1;
if (radKhoChan.Checked) kieukho = 2;
if (optChanle.Checked) kieukho = 3;
objDmuckho.KieuKho = kieukho == 1 ? "LE" : (kieukho == 2 ? "CHAN" : "CHANLE");
string loaiBN = "TATCA";
if (radTatCa.Checked) loaiBN = "TATCA";
if (radNgoaiTru.Checked) loaiBN = "NGOAITRU";
if (radNoiTru.Checked) loaiBN = "NOITRU";
objDmuckho.LoaiBnhan = loaiBN;
return objDmuckho;
}
void chkThekhochitiet_CheckedChanged(object sender, EventArgs e)
{
if (!allowChanged) return;
if(_item==null)
_item = new Select().From(TDmucKho.Schema).Where(TDmucKho.IdKhoColumn).IsEqualTo(Utility.Int32Dbnull(cboKho.SelectedValue)).ExecuteSingle<TDmucKho>();
GetKieuThuocVT();
}
public void Insert(string MaKho,string TenKho,int? SttHthi,string KieuKho,string KhoThuocVt,short IdKhoaphong,string MotaThem,byte? LaQuaythuoc,byte? KtraTon,DateTime? NgaySua,DateTime? NgayTao,string NguoiSua,string NguoiTao,byte? LaTuthuoc,string LoaiBnhan,byte? TrangThai,byte? TuTuc,byte? ChophepChongia,string KieuBiendong,byte? LoaiKho)
{
TDmucKho item = new TDmucKho();
item.MaKho = MaKho;
item.TenKho = TenKho;
item.SttHthi = SttHthi;
item.KieuKho = KieuKho;
item.KhoThuocVt = KhoThuocVt;
item.IdKhoaphong = IdKhoaphong;
item.MotaThem = MotaThem;
item.LaQuaythuoc = LaQuaythuoc;
item.KtraTon = KtraTon;
item.NgaySua = NgaySua;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NguoiTao = NguoiTao;
item.LaTuthuoc = LaTuthuoc;
item.LoaiBnhan = LoaiBnhan;
item.TrangThai = TrangThai;
item.TuTuc = TuTuc;
item.ChophepChongia = ChophepChongia;
item.KieuBiendong = KieuBiendong;
item.LoaiKho = LoaiKho;
item.Save(UserName);
}
