/// <summary>
/// Insert một bản ghi vào bảng Danh mục dùng chung
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public void InsertList(DmucKieukham obj, int intSTTCu, ref string ActResult)
{
try
{
ActionResult _act = isExistedRecord(obj.MaKieukham);
if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception)
{
ActResult = _act.ToString();
return;
}
//B1: Tim ban ghi co STT=STT moi
DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi));
if (v_lstDmuc.Count > 0)
{
new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu)
.Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(v_lstDmuc[0].IdKieukham).Execute();
}
obj.IsNew = true;
obj.Save();
ActResult = ActionResult.Success.ToString();
}
catch
{
ActResult = ActionResult.Exception.ToString();
}
}
/// <summary>
/// Insert một bản ghi vào bảng Danh mục dùng chung
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public void InsertList(DmucKieukham obj, int intSTTCu, ref string ActResult)
{
try
{
ActionResult _act = isExistedRecord(obj.MaKieukham);
if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception)
{
ActResult = _act.ToString();
return;
}
//B1: Tim ban ghi co STT=STT moi
DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi));
if (v_lstDmuc.Count > 0)
{
new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu)
.Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(v_lstDmuc[0].IdKieukham).Execute();
}
obj.IsNew = true;
obj.Save();
ActResult = ActionResult.Success.ToString();
}
catch
{
ActResult = ActionResult.Exception.ToString();
}
}
/// <summary>
/// Đóng gói dữ liệu vào DataTable để gửi lên Webservice xử lý
/// </summary>
/// <returns></returns>
private DmucKieukham GetObject()
{
try
{
DmucKieukham obj = new DmucKieukham();
obj.MaKieukham = Utility.DoTrim(txtMa.Text);
obj.TenKieukham = Utility.DoTrim(txtTen.Text);
obj.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1");
obj.TrangThai = Convert.ToByte(chkTrangthai.Checked ? 1 : 0);
obj.DonGia = nmrDongia.Value;
obj.MaDoituongkcb = cbodoituongkcb.SelectedIndex == 0 ? "ALL" : cbodoituongkcb.SelectedValue.ToString();
if (m_enAct == action.Update)
{
obj.IdKieukham = Utility.Int16Dbnull(txtID.Text);
obj.NguoiSua = globalVariables.UserName;
obj.NgaySua = globalVariables.SysDate;
}
else
{
obj.NguoiTao = globalVariables.UserName;
obj.NgayTao = globalVariables.SysDate;
}
obj.SttHthi = short.Parse(txtSTT.Text);
return(obj);
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi xảy ra khi đóng gói dữ liệu vào DataTable để gửi lên Webservice\n" + ex.Message, "Thông báo");
return(null);
}
}
private void cboLoaiKham_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (!m_blnLoaded)
{
return;
}
string _RowFilter = "1=1";
DmucKieukham objExamTypeList = DmucKieukham.FetchByID(Utility.Int32Dbnull(cboLoaiKham.SelectedValue));
if (objExamTypeList != null)
{
if (objExamTypeList.MaDoituongkcb == "ALL")
{
_RowFilter = string.Format("{0}", "1=1");
}
else
{
_RowFilter = string.Format("{0}='{1}'", DmucDoituongkcb.Columns.MaDoituongKcb,
objExamTypeList.MaDoituongkcb);
}
}
v_ObjectTypeList.DefaultView.RowFilter = _RowFilter;
v_ObjectTypeList.AcceptChanges();
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi:" + ex.Message);
// throw;
}
}
/// <summary>
/// Update một bản ghi vào bảng Danh mục dùng chung
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public void UpdateList(DmucKieukham obj, string strOldCode, int intSTTCu, ref string ActResult)
{
try
{
ActionResult _act = isExistedRecord4Update(obj.MaKieukham, strOldCode);
if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception)
{
ActResult = _act.ToString();
return;
}
//B1: Tim ban ghi co STT=STT moi
DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi));
if (v_lstDmuc.Count > 0)
{
new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu)
.Where(DmucKieukham.Columns.MaKieukham).IsEqualTo(v_lstDmuc[0].MaKieukham)
.Execute();
}
int record = new Update(DmucKieukham.Schema)
.Set(DmucKieukham.Columns.MaKieukham).EqualTo(obj.MaKieukham)
.Set(DmucKieukham.Columns.TenKieukham).EqualTo(obj.TenKieukham)
.Set(DmucKieukham.Columns.DonGia).EqualTo(obj.DonGia)
.Set(DmucKieukham.Columns.SttHthi).EqualTo(obj.SttHthi)
.Set(DmucKieukham.Columns.MaDoituongkcb).EqualTo(obj.MaDoituongkcb)
.Set(DmucKieukham.Columns.NhomBaocao).EqualTo(obj.NhomBaocao)
.Set(DmucKieukham.Columns.TrangThai).EqualTo(obj.TrangThai)
.Set(DmucKieukham.Columns.NgaySua).EqualTo(obj.NgaySua)
.Set(DmucKieukham.Columns.NguoiSua).EqualTo(obj.NguoiSua)
.Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(obj.IdKieukham)
.Execute();
if (record > 0)
{
ActResult = ActionResult.Success.ToString();
}
else
{
ActResult = ActionResult.Error.ToString();
}
}
catch
{
ActResult = ActionResult.Exception.ToString();
}
}
public ActionResult isExistedRecord4Update(string MaMoi, string MaCu)
{
try
{
DmucKieukhamCollection v_obj = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery()
.AddWhere(DmucKieukham.Columns.MaKieukham, Comparison.NotEquals, MaCu)
);
List <DmucKieukham> q = (from p in v_obj
where p.MaKieukham == MaMoi
select p).ToList <DmucKieukham>();
if (q.Count() > 0)
{
return(ActionResult.ExistedRecord);
}
return(ActionResult.Success);
}
catch
{
return(ActionResult.Exception);
}
}
public short GetMaxSTT(string m_strListType)
{
try
{
DmucKieukhamCollection CollectionData = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery());
Int16 shtMaxSTT = 0;
//Phải kiểm tra nếu Có dữ liệu mới lấy STT hiện tại=MaxSTT+1
if (CollectionData.Count > 0)
{
shtMaxSTT = CollectionData.Max(c => c.SttHthi).Value;
}
return(Convert.ToInt16(shtMaxSTT + 1));
}
catch
{
return(Convert.ToInt16(1));
}
}
public void Insert(string MaKieukham,string TenKieukham,decimal? DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,short? SttHthi,string MaDoituongkcb,string NhomBaocao,byte? TrangThai,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua)
{
DmucKieukham item = new DmucKieukham();
item.MaKieukham = MaKieukham;
item.TenKieukham = TenKieukham;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.SttHthi = SttHthi;
item.MaDoituongkcb = MaDoituongkcb;
item.NhomBaocao = NhomBaocao;
item.TrangThai = TrangThai;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.Save(UserName);
}
/// <summary>
/// Thực hiện thêm mới dữ liệu
/// </summary>
private bool PerformInserAct()
{
try
{
//Kiem tra su hop le cua du lieu
if (!IsValidInputData())
{
return(false);
}
m_intOldOrder = Convert.ToInt32(txtSTT.Text);
string ActResult = "";
DmucKieukham _item = GetObject();
m_BusRules.InsertList(_item, m_intOldOrder, ref ActResult);
if (ActResult == ActionResult.Success.ToString())
{
txtID.Text = _item.IdKieukham.ToString();
//Cho phép chọn trên lưới để fill dữ liệu xuống Vùng nhập liệu
m_blnAllowCurrentCellChanged = true;
//Thêm mới dòng này vào DataTable để phản ánh lại lên lưới
InsertDataTable();
//Update lại STT nếu có
UpdateSTT(m_intOldOrder);
//Tự động nhảy đến dòng mới thêm trên lưới
Utility.GonewRowJanus(grdList, DmucKieukham.Columns.IdKieukham, txtID.Text.Trim());
//Gán biến dòng hiện thời trên lưới
m_intCurrIdx = grdList.CurrentRow.Position;
//Quay về trạng thái cancel
PerformCancelAction();
//Hiển thị thông báo thành công
Utility.SetMsg(lblMsg, "Thêm mới dịch vụ khám thành công", false);
if (chkAutoNew.Checked)
{
cmdNew_Click(cmdNew, new EventArgs());
}
else
{
//Tự động Focus vào nút Sửa
cmdNew.Focus();
}
}
else if (ActResult == ActionResult.ExistedRecord.ToString())
{
Utility.SetMsg(lblMsg, m_lstHeaders[0] + "(" + txtMa.Text + ") đã được sử dụng. Đề nghị bạn nhập mã khác!", true);
txtMa.Focus();
return(false);
}
else if (ActResult == ActionResult.Exception.ToString())
{
Utility.ShowMsg("Lỗi khi thực hiện thêm mới " + m_strListName + "\n" + ActResult, "Thông báo");
return(false);
}
return(true);
}
catch (Exception ex)
{
return(false);
Utility.ShowMsg(ex.Message);
}
}
/// <summary>
/// Đóng gói dữ liệu vào DataTable để gửi lên Webservice xử lý
/// </summary>
/// <returns></returns>
private DmucKieukham GetObject()
{
try
{
DmucKieukham obj = new DmucKieukham();
obj.MaKieukham = Utility.DoTrim(txtMa.Text);
obj.TenKieukham = Utility.DoTrim(txtTen.Text);
obj.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1");
obj.TrangThai = Convert.ToByte(chkTrangthai.Checked ? 1 : 0);
obj.DonGia =nmrDongia.Value;
obj.MaDoituongkcb = cbodoituongkcb.SelectedIndex == 0 ? "ALL" : cbodoituongkcb.SelectedValue.ToString();
if (m_enAct == action.Update)
{
obj.IdKieukham = Utility.Int16Dbnull(txtID.Text);
obj.NguoiSua = globalVariables.UserName;
obj.NgaySua = globalVariables.SysDate;
}
else
{
obj.NguoiTao = globalVariables.UserName;
obj.NgayTao = globalVariables.SysDate;
}
obj.SttHthi = short.Parse(txtSTT.Text);
return obj;
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi xảy ra khi đóng gói dữ liệu vào DataTable để gửi lên Webservice\n" + ex.Message, "Thông báo");
return null;
}
}
/// <summary>
/// Update một bản ghi vào bảng Danh mục dùng chung
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public void UpdateList(DmucKieukham obj, string strOldCode, int intSTTCu, ref string ActResult)
{
try
{
ActionResult _act = isExistedRecord4Update(obj.MaKieukham, strOldCode);
if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception)
{
ActResult = _act.ToString();
return;
}
//B1: Tim ban ghi co STT=STT moi
DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi));
if (v_lstDmuc.Count > 0)
{
new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu)
.Where(DmucKieukham.Columns.MaKieukham).IsEqualTo(v_lstDmuc[0].MaKieukham)
.Execute();
}
int record = new Update(DmucKieukham.Schema)
.Set(DmucKieukham.Columns.MaKieukham).EqualTo(obj.MaKieukham)
.Set(DmucKieukham.Columns.TenKieukham).EqualTo(obj.TenKieukham)
.Set(DmucKieukham.Columns.DonGia).EqualTo(obj.DonGia)
.Set(DmucKieukham.Columns.SttHthi).EqualTo(obj.SttHthi)
.Set(DmucKieukham.Columns.MaDoituongkcb).EqualTo(obj.MaDoituongkcb)
.Set(DmucKieukham.Columns.NhomBaocao).EqualTo(obj.NhomBaocao)
.Set(DmucKieukham.Columns.TrangThai).EqualTo(obj.TrangThai)
.Set(DmucKieukham.Columns.NgaySua).EqualTo(obj.NgaySua)
.Set(DmucKieukham.Columns.NguoiSua).EqualTo(obj.NguoiSua)
.Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(obj.IdKieukham)
.Execute();
if (record > 0)
{
ActResult = ActionResult.Success.ToString();
}
else
ActResult = ActionResult.Error.ToString();
}
catch
{
ActResult = ActionResult.Exception.ToString();
}
}
/// <summary>
/// /hàm thực heien thông tin update thông tin lại
/// </summary>
private void PerformActionUpdate()
{
string MaDoituongKcb = "ALL";
string NhomBaocao = "-1";
DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(Utility.Int16Dbnull(cboDoituong.SelectedValue, -1));
if (objectType != null)
{
MaDoituongKcb = objectType.MaDoituongKcb;
}
else
{
MaDoituongKcb = "ALL";
}
DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1));
if (objKieukham != null)
{
NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, "");
}
else
{
NhomBaocao = "-1";
}
int record = new Update(DmucDichvukcb.Schema)
.Set(DmucDichvukcb.Columns.IdKhoaphong).EqualTo(Utility.Int16Dbnull(cboDepartment1.SelectedValue, 1))
.Set(DmucDichvukcb.Columns.MaDichvukcb).EqualTo(txtCode.Text.Trim())
.Set(DmucDichvukcb.Columns.HoatDong).EqualTo(chkhoatdong.Checked)
.Set(DmucDichvukcb.Columns.MaGia).EqualTo(txtmagiabhyt.Text.Trim())
.Set(DmucDichvukcb.Columns.TenDichvukcb).EqualTo(txtName.Text.Trim())
.Set(DmucDichvukcb.Columns.MotaThem).EqualTo(txtDesc.Text.Trim())
.Set(DmucDichvukcb.Columns.SttHthi).EqualTo(Utility.Int16Dbnull(nmrSTT.Value))
.Set(DmucDichvukcb.Columns.NhomBaocao).EqualTo(NhomBaocao)
.Set(DmucDichvukcb.Columns.MaDoituongKcb).EqualTo(MaDoituongKcb)
.Set(DmucDichvukcb.Columns.IdPhongkham).EqualTo(Utility.Int16Dbnull(cboRoomDept.SelectedValue, 1))
.Set(DmucDichvukcb.Columns.IdBacsy).EqualTo(
Convert.ToInt16(cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, 1) : -1))
.Set(DmucDichvukcb.Columns.IdKieukham).EqualTo(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, 1))
.Set(DmucDichvukcb.Columns.IdDoituongKcb).EqualTo(Utility.Int16Dbnull(cboDoituong.SelectedValue, -1))
.Set(DmucDichvukcb.Columns.DonGia).EqualTo(Utility.DecimaltoDbnull(txtDongia.Text, 0))
.Set(DmucDichvukcb.Columns.DongiaNgoaigio).EqualTo(Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0))
.Set(DmucDichvukcb.Columns.PhuthuNgoaigio).EqualTo(Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0))
.Set(DmucDichvukcb.Columns.TuTuc).EqualTo(Utility.Bool2byte(chkTutuc.Checked))
.Set(DmucDichvukcb.Columns.PhuthuDungtuyen).EqualTo(Utility.DecimaltoDbnull(txtPTDT.Text, 0))
.Set(DmucDichvukcb.Columns.PhuthuTraituyen).EqualTo(Utility.DecimaltoDbnull(txtPTTT.Text, 0))
.Where(DmucDichvukcb.Columns.IdDichvukcb).IsEqualTo(Utility.DecimaltoDbnull(txtInsObject_ID.Text, -1)).
Execute();
if (record > 0)
{
DataRow[] dr =
m_dtDataRelation.Select(DmucDichvukcb.Columns.IdDichvukcb + "=" +
Utility.Int32Dbnull(txtInsObject_ID.Text, -1));
if (dr.GetLength(0) > 0)
{
dr[0][DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue);
dr[0][DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
dr[0][DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1);
dr[0][DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1;
dr[0][DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
dr[0][DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text;
dr[0]["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text;
dr[0]["ten_phong"] = cboRoomDept.Text;
dr[0][DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim();
dr[0][DmucDichvukcb.Columns.MaBhyt] = txtMaBhyt.Text.Trim();
dr[0][DmucDichvukcb.Columns.MaGia] = txtmagiabhyt.Text.Trim();
dr[0][DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim();
dr[0]["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : "";
dr[0][DmucDichvukcb.Columns.MaDoituongKcb] = objectType != null ? objectType.MaDoituongKcb : "ALL";
dr[0][DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null
? cboDoituong.Text
: "Tất cả các đối tượng";
dr[0][DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text);
dr[0][DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1);
dr[0][DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0);
dr[0][DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
dr[0][DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
dr[0][DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked);
dr[0][DmucDichvukcb.Columns.HoatDong] = Utility.Bool2byte(chkhoatdong.Checked);
dr[0][DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
dr[0][DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
}
m_dtDataRelation.AcceptChanges();
Close();
}
else
{
Utility.ShowMsg("Lỗi trong quá trình cập nhập dữ liệu");
return;
}
}
private void PerformActionInsert()
{
var objDmucDichvukcb = new DmucDichvukcb();
objDmucDichvukcb.MaDichvukcb = Utility.sDbnull(txtCode.Text.Trim(), "");
objDmucDichvukcb.MaGia = Utility.sDbnull(txtmagiabhyt.Text.Trim(), "");
objDmucDichvukcb.HoatDong = chkhoatdong.Checked;
objDmucDichvukcb.TenDichvukcb = Utility.sDbnull(txtName.Text, "");
objDmucDichvukcb.IdKieukham = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
objDmucDichvukcb.IdKhoaphong = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
objDmucDichvukcb.IdBacsy = Convert.ToInt16(cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1);
objDmucDichvukcb.MotaThem = Utility.DoTrim(txtDesc.Text);
objDmucDichvukcb.SttHthi = Utility.Int16Dbnull(nmrSTT.Value);
objDmucDichvukcb.IdDoituongKcb = Utility.Int16Dbnull(cboDoituong.SelectedValue, -1);
DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(objDmucDichvukcb.IdDoituongKcb);
if (objectType != null)
{
objDmucDichvukcb.MaDoituongKcb = Utility.sDbnull(objectType.MaDoituongKcb, "");
}
else
{
objDmucDichvukcb.MaDoituongKcb = "ALL";
}
DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1));
if (objKieukham != null)
{
objDmucDichvukcb.NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, "");
}
else
{
objDmucDichvukcb.NhomBaocao = "-1";
}
objDmucDichvukcb.IdPhongkham = Utility.Int16Dbnull(cboRoomDept.SelectedValue);
objDmucDichvukcb.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
objDmucDichvukcb.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
objDmucDichvukcb.DonGia = Utility.DecimaltoDbnull(txtDongia.Text, 0);
objDmucDichvukcb.DongiaNgoaigio = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
objDmucDichvukcb.PhuthuNgoaigio = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
objDmucDichvukcb.TuTuc = Utility.Bool2byte(chkTutuc.Checked);
objDmucDichvukcb.MaBhyt = Utility.sDbnull(txtMaBhyt.Text.Trim(), "");
objDmucDichvukcb.IsNew = true;
objDmucDichvukcb.Save();
DataRow dr = m_dtDataRelation.NewRow();
dr[DmucDichvukcb.Columns.IdDichvukcb] = Utility.Int32Dbnull(
_Query.GetMax(DmucDichvukcb.Columns.IdDichvukcb), -1);
dr[DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue);
dr[DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1);
dr[DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1);
dr[DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0
? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1)
: -1;
dr[DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0);
dr[DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0);
dr[DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0);
dr[DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text);
dr[DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1);
dr[DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked);
dr[DmucDichvukcb.Columns.HoatDong] = Utility.Bool2byte(chkhoatdong.Checked);
dr["ten_phong"] = cboRoomDept.Text;
dr[DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1);
dr[DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text;
dr[DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim();
dr[DmucDichvukcb.Columns.MaBhyt] = txtMaBhyt.Text.Trim();
dr[DmucDichvukcb.Columns.MaGia] = txtmagiabhyt.Text.Trim();
dr[DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim();
dr["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text;
dr["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : "";
dr[DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null ? cboDoituong.Text : "Tất cả các đối tượng";
m_dtDataRelation.Rows.Add(dr);
//this.Close();
}
