private void Loaddata()
{
if (frmDMLoaiDT.isAdd)
{
Reset();
btnDelete.Enabled = false;
}
else
{
txtMaLoaiDT.Enabled = false;
dm = DmLoaiDoiTuongDataProvider.GetListDmLoaiDTInfoFromOid(frmDMLoaiDT.Oid);
txtTenLoaiDT.Text = dm.TenLoaiDT;
txtMaLoaiDT.Text = dm.MaLoaiDT;
txtGhiChu.Text = dm.GhiChu;
txtNhomCha.Text = Convert.ToString(dm.NhomCha);
chkSuDung.Checked = dm.SuDung == 1;
}
if (frmDMLoaiDT.IsSync)
{
//không cho phép người dùng sửa, xóa các thông tin trên form.
txtMaLoaiDT.Enabled = false;
txtTenLoaiDT.Enabled = false;
btnDelete.Enabled = false;
}
}
internal void Delete(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongDelete,
DMLoaiDoiTuongInfor.IdLoaiDT);
//CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongDelete);
//Parameters.AddWithValue("@IdLoaiDT", DMLoaiDoiTuongInfor.IdLoaiDT);
//ExecuteNoneQuery();
}
internal void Update(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongUpdate,
ParseToParams <DmLoaiDoiTuongInfor>(DMLoaiDoiTuongInfor));
//CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongUpdate);
//SetParams(DMLoaiDoiTuongInfor);
//ExecuteNoneQuery();
}
internal List <DmLoaiDoiTuongInfor> Search(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
return(GetListCommand <DmLoaiDoiTuongInfor>(Declare.StoreProcedureNamespace.spLoaiDoiTuongSearch,
DMLoaiDoiTuongInfor.TenLoaiDT));
//CreateGetListCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongSearch);
////Parameters.AddWithValue("@MaLoaiDT", DMLoaiDoiTuongInfor.MaLoaiDT);
//Parameters.AddWithValue("@TenLoaiDT", DMLoaiDoiTuongInfor.TenLoaiDT);
//return FillToList<DmLoaiDoiTuongInfor>();
}
internal int Insert(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
return(GetObjectCommand <int>(Declare.StoreProcedureNamespace.spLoaiDoiTuongInsert,
ParseToParams <DmLoaiDoiTuongInfor>(DMLoaiDoiTuongInfor)));
//CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongInsert);
//SetParams(DMLoaiDoiTuongInfor);
//Parameters["@IdLoaiDT"].Direction = ParameterDirection.Output;
//ExecuteNoneQuery();
//return Convert.ToInt32(Parameters["@IdLoaiDT"].Value.ToString());
}
private DmLoaiDoiTuongInfor SetDanhMuc()
{
DmLoaiDoiTuongInfor dm = new DmLoaiDoiTuongInfor();
dm.TenLoaiDT = txtTenLoaiDT.Text.Trim();
dm.MaLoaiDT = txtMaLoaiDT.Text.Trim();
dm.GhiChu = txtGhiChu.Text.Trim();
dm.NhomCha = Convert.ToInt32(txtNhomCha.Text.Trim());
dm.SuDung = Convert.ToInt32(chkSuDung.Checked);
dm.IdLoaiDT = frmDMLoaiDT.Oid;
return(dm);
}
internal bool Exist(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
return(GetObjectCommand <int>(Declare.StoreProcedureNamespace.spLoaiDoiTuongExist,
DMLoaiDoiTuongInfor.IdLoaiDT,
DMLoaiDoiTuongInfor.MaLoaiDT) > 0);
//CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDoiTuongExist);
//Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output;
//Parameters.AddWithValue("@IdLoaiDT", DMLoaiDoiTuongInfor.IdLoaiDT);
//Parameters.AddWithValue("@MaLoaiDT", DMLoaiDoiTuongInfor.MaLoaiDT);
//ExecuteNoneQuery();
//return Convert.ToInt32(Parameters["@Count"].Value.ToString()) == 1;
}
private void LoadLoaiDT()
{
liLoaiDT = DmLoaiDoiTuongDataProvider.GetListLoaiDoiTuongInfor();
if (liLoaiDT.Count > 0)
{
cboCurrentLoaiDT.DataSource = liLoaiDT;
cboCurrentLoaiDT.DisplayMember = "TenLoaiDT";
cboCurrentLoaiDT.ValueMember = "IdLoaiDT";
cboCurrentLoaiDT.SelectedValue = Declare.IdLoaiKhachHang;
if (cboCurrentLoaiDT.SelectedIndex >= 0)
{
LoaiDTSelected = liLoaiDT[cboCurrentLoaiDT.SelectedIndex];
}
}
else
{
cboCurrentLoaiDT.DataSource = null;
}
}
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;
}
}
public static List<DmLoaiDoiTuongInfor> Search(DmLoaiDoiTuongInfor match)
{
return DmLoaiDoiTuongDAO.Instance.Search(match);
}
public static bool KiemTra(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
return DmLoaiDoiTuongDAO.Instance.Exist(DMLoaiDoiTuongInfor);
}
internal static void Update(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
DmLoaiDoiTuongDAO.Instance.Update(DMLoaiDoiTuongInfor);
}
public static void Delete(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
DmLoaiDoiTuongDAO.Instance.Delete(DMLoaiDoiTuongInfor);
}
internal static void Insert(DmLoaiDoiTuongInfor DMLoaiDoiTuongInfor)
{
DmLoaiDoiTuongDAO.Instance.Insert(DMLoaiDoiTuongInfor);
}
