private void PerformActionInsert()
{
var objDmucDichvukcb = new DmucDichvukcb();
objDmucDichvukcb.MaDichvukcb = Utility.sDbnull(txtCode.Text, "");
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.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["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.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();
}
public void Update(int IdDichvukcb,string MaDichvukcb,string TenDichvukcb,short IdKieukham,short IdKhoaphong,short IdBacsy,short IdDoituongKcb,short IdPhongkham,decimal DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? DongiaNgoaigio,decimal? PhuthuNgoaigio,string MaDoituongKcb,int? IdPhikemtheo,int? IdPhikemtheongoaigio,string NhomBaocao,byte? TuTuc)
{
DmucDichvukcb item = new DmucDichvukcb();
item.MarkOld();
item.IsLoaded = true;
item.IdDichvukcb = IdDichvukcb;
item.MaDichvukcb = MaDichvukcb;
item.TenDichvukcb = TenDichvukcb;
item.IdKieukham = IdKieukham;
item.IdKhoaphong = IdKhoaphong;
item.IdBacsy = IdBacsy;
item.IdDoituongKcb = IdDoituongKcb;
item.IdPhongkham = IdPhongkham;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.DongiaNgoaigio = DongiaNgoaigio;
item.PhuthuNgoaigio = PhuthuNgoaigio;
item.MaDoituongKcb = MaDoituongKcb;
item.IdPhikemtheo = IdPhikemtheo;
item.IdPhikemtheongoaigio = IdPhikemtheongoaigio;
item.NhomBaocao = NhomBaocao;
item.TuTuc = TuTuc;
item.Save(UserName);
}
public void Insert(string MaDichvukcb,string TenDichvukcb,short IdKieukham,short IdKhoaphong,short IdBacsy,short IdDoituongKcb,short IdPhongkham,decimal DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? DongiaNgoaigio,decimal? PhuthuNgoaigio,string MaDoituongKcb,int? IdPhikemtheo,int? IdPhikemtheongoaigio,string NhomBaocao,byte? TuTuc,short? SttHthi,string MotaThem)
{
DmucDichvukcb item = new DmucDichvukcb();
item.MaDichvukcb = MaDichvukcb;
item.TenDichvukcb = TenDichvukcb;
item.IdKieukham = IdKieukham;
item.IdKhoaphong = IdKhoaphong;
item.IdBacsy = IdBacsy;
item.IdDoituongKcb = IdDoituongKcb;
item.IdPhongkham = IdPhongkham;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.DongiaNgoaigio = DongiaNgoaigio;
item.PhuthuNgoaigio = PhuthuNgoaigio;
item.MaDoituongKcb = MaDoituongKcb;
item.IdPhikemtheo = IdPhikemtheo;
item.IdPhikemtheongoaigio = IdPhikemtheongoaigio;
item.NhomBaocao = NhomBaocao;
item.TuTuc = TuTuc;
item.SttHthi = SttHthi;
item.MotaThem = MotaThem;
item.Save(UserName);
}
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();
}
