private void delete_v_rpt_f460_tinh_hinh_bo_lop()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_RPT_F460_TINH_HINH_BO_LOP v_us = new US_V_RPT_F460_TINH_HINH_BO_LOP();
grid2us_object(v_us, m_fg.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void delete_v_rpt_450_bao_cao_so_luong_luong_hoc_vien_hien_nay()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_RPT_450_BAO_CAO_SO_LUONG_LUONG_HOC_VIEN_HIEN_NAY v_us = new US_V_RPT_450_BAO_CAO_SO_LUONG_LUONG_HOC_VIEN_HIEN_NAY();
grid2us_object(v_us, m_fg.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void xoaGiaTriTuDien()
{
if (!this.isMaTuDienRow(m_fg.Row))
{
return;
}
if (BaseMessages.askUser_DataCouldBeDeleted(8) == BaseMessages.IsDataCouldBeDeleted.ShouldNotBeDeleted)
{
return;
}
DataRow v_drTuDien = (DataRow) (m_fg.Rows[m_fg.Row].UserData);
US_CM_DM_TU_DIEN v_usTuDien = new US_CM_DM_TU_DIEN();
v_usTuDien.DataRow2Me(v_drTuDien);
try
{
v_usTuDien.BeginTransaction();
//If v_usTuDien.isUpdatable() Then
v_usTuDien.Delete();
m_fg.Rows.Remove(m_fg.Row);
//End If
v_usTuDien.CommitTransaction();
}
catch (System.Exception v_e)
{
v_usTuDien.Rollback();
CDBExceptionHandler v_ErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_ErrHandler.showErrorMessage();
}
}
private void delete_v_tong_hop_cpn_theo_phong_ban()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_TONG_HOP_CPN_THEO_PHONG_BAN v_us = new US_V_TONG_HOP_CPN_THEO_PHONG_BAN();
grid2us_object(v_us, m_fg.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void delete_v_dm_hoc_sinh()
{
if(!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if(!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if(BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_GD_HOC v_us = new US_GD_HOC();
grid2us_object(v_us, m_fg.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
//v_us.DeleteByID(v_us.dcID);
//m_fg.Rows.Remove(m_fg.Row);
}
catch(Exception v_e) {
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void delete_rpt_tong_hop_hien_trang_tsk()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg_tai_san_khac)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg_tai_san_khac, m_fg_tai_san_khac.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_RPT_TONG_HOP_HIEN_TRANG_TSK v_us = new US_RPT_TONG_HOP_HIEN_TRANG_TSK();
grid2us_object(v_us, m_fg_tai_san_khac.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg_tai_san_khac.Rows.Remove(m_fg_tai_san_khac.Row);
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void delete_nguoi_dai_dien()
{
if (!HelpUtils.is_validated_edit_grid_row(m_fg_nguoi_dai_dien.Row, m_fg)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_DM_NGUOI_DAI_DIEN v_us = new US_V_DM_NGUOI_DAI_DIEN();
grid2us_object_nguoi_dai_dien(v_us, m_fg_nguoi_dai_dien.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e) {
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
private void delete_phieu_cu()
{
DS_V_RPT_CHI_TIET_PHIEU_THU v_ds_v_rpt_chi_tiet_phieu_thu = new DS_V_RPT_CHI_TIET_PHIEU_THU();
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu = new US_V_RPT_CHI_TIET_PHIEU_THU();
v_us_v_rpt_chi_tiet_phieu_thu.FillDataset(v_ds_v_rpt_chi_tiet_phieu_thu, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue), m_dat_tai_ngay.Value.Date);
for (int i = 0; i < v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows.Count; i++)
{
US_V_RPT_CHI_TIET_PHIEU_THU v_us_v_rpt_chi_tiet_phieu_thu_detail = new US_V_RPT_CHI_TIET_PHIEU_THU(v_ds_v_rpt_chi_tiet_phieu_thu.Tables[0].Rows[i]);
try
{
v_us_v_rpt_chi_tiet_phieu_thu_detail.BeginTransaction();
v_us_v_rpt_chi_tiet_phieu_thu_detail.DeleteByID(v_us_v_rpt_chi_tiet_phieu_thu_detail.dcID);
v_us_v_rpt_chi_tiet_phieu_thu_detail.CommitTransaction();
}
catch (Exception v_e)
{
v_us_v_rpt_chi_tiet_phieu_thu_detail.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
//BaseMessages.MsgBox_Infor("Không xóa được học sinh này do học sinh này đang học một lớp môn nào đó!");
}
}
}
private void delete_v_hoc_sinh()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
//if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
bool v_lua_chon_xoa = BaseMessages.MsgBox_Confirm("Nếu xóa học sinh này, tất cả dữ liệu của học sinh này về lớp học, phiếu thu, điểm danh,... sẽ bị xóa. Bạn chắc chắn chứ?");
if (v_lua_chon_xoa == false)
{
return;
}
US_V_HOC_SINH v_us = new US_V_HOC_SINH();
grid2us_object(v_us, m_fg.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
BaseMessages.MsgBox_Infor("Đã xóa thành công");
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
//BaseMessages.MsgBox_Infor("Không xóa được học sinh này do học sinh này đang học một lớp môn nào đó!");
}
}
private void m_obj_edit_controller_BeforeUpdate(object sender, CC1InplaceEdittingEventArgs e)
{
try
{
int v_i_grid_row = m_fg.Row;
m_us_cur.ClearAllFields();
grid_2_us_object(m_us_cur, v_i_grid_row);
m_us_cur.BeginTransaction();
if (m_us_cur.isUpdatable())
{
e.continue_editting = true;
}
}
catch (Exception v_e)
{
m_us_cur.Rollback();
e.continue_editting = false;
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void m_obj_edit_controller_BeforeInsert(object sender, CC1InplaceEdittingEventArgs e)
{
try
{
m_us_cur.BeginTransaction();
e.continue_editting = true;
}
catch (Exception v_e)
{
e.continue_editting = false;
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void catch_fg_StartEdit(object sender, C1.Win.C1FlexGrid.RowColEventArgs e)
{
try
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg))
{
return;
}
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row))
{
return;
}
StartUpdate();
}
catch (Exception v_e)
{
e.Cancel = true;
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private static void Initialize_NgayTrongTuan()
{
try
{
US_HT_NGAY_TRONG_TUAN v_us_ht_ngay_trong_tuan = new US_HT_NGAY_TRONG_TUAN();
DS_HT_NGAY_TRONG_TUAN v_ds_ngaytrongtuan = new DS_HT_NGAY_TRONG_TUAN();
v_us_ht_ngay_trong_tuan.FillDataset(v_ds_ngaytrongtuan);
m_View_NgayTrongTuan = new DataView(v_ds_ngaytrongtuan.HT_NGAY_TRONG_TUAN);
}
catch (Exception v_e)
{
CDBExceptionHandler v_handler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_handler.showErrorMessage();
}
}
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
private void delete_v_gd_thong_ke()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_thong_ke_hoc_vien)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_thong_ke_hoc_vien, m_grv_thong_ke_hoc_vien.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_GD_THONG_KE v_us = new US_GD_THONG_KE();
dm_grid2us_object(v_us, m_grv_thong_ke_hoc_vien.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
private void delete_rpt_tang_giam_tai_san()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_RPT_TANG_GIAM_TAI_SAN v_us = new US_RPT_TANG_GIAM_TAI_SAN();
grid2us_object(v_us, m_fg.Row);
try {
private void m_obj_edit_controller_OnCancelDelete(object sender, EventArgs e)
{
try
{
m_us_cur.Rollback();
if (OnCancelDeleteEvent != null)
OnCancelDeleteEvent(this, new EventArgs());
}
catch (Exception v_e)
{
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void delete_ht_user_group()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
var dlg = DevExpress.XtraEditors.XtraMessageBox.Show("Bạn có chắc chắn muốn xóa dữ liệu?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlg != System.Windows.Forms.DialogResult.Yes) return;
US_HT_USER_GROUP v_us = new US_HT_USER_GROUP();
grid2us_object(v_us, m_fg.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void m_obj_edit_controller_OnCancelInsert(object sender, EventArgs e)
{
try
{
m_fg.Rows.Remove(m_fg.Row);
if (OnCancelDeleteEvent != null)
OnCancelDeleteEvent(this, new System.EventArgs());
}
catch (Exception v_e)
{
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
}
private void delete_v_dm_co_so_dinh_muc()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_co_so_dinh_muc)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_co_so_dinh_muc, m_grv_co_so_dinh_muc.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_DM_CO_SO_DINH_MUC v_us = new US_DM_CO_SO_DINH_MUC();
dm_grid2us_object(v_us, m_grv_co_so_dinh_muc.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_grv_co_so_dinh_muc.Rows.Remove(m_grv_co_so_dinh_muc.Row);
}
catch (Exception v_e) {
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
private void m_obj_edit_controller_OnCancelUpdate(object sender, EventArgs e)
{
try
{
m_us_cur.Rollback();
//Dua du lieu cu len grid
restored_old_grid_data(m_fg.Row);
if (OnCancelUpdateEvent != null)
OnCancelUpdateEvent(this, new EventArgs());
}
catch (Exception v_e)
{
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
}
}
base.Dispose( disposing );
}
private void delete_dm_nha_cung_cap()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_nha_cc)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_nha_cc, m_grv_nha_cc.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_DM_NHA_CUNG_CAP v_us = new US_DM_NHA_CUNG_CAP();
grid2us_object(v_us, m_grv_nha_cc.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_grv_nha_cc.Rows.Remove(m_grv_nha_cc.Row);
}
catch (Exception v_e) {
v_us.Rollback();
private void m_obj_edit_controller_OnUpdate(object sender, CC1InplaceEdittingOnEventArgs e)
{
try
{
m_us_cur.Update();
CC1InplaceEdittingOnEventArgs v_e = new CC1InplaceEdittingOnEventArgs(e_CC1_inplace_editting_next_action.success_and_change_to_none_status);
if (OnUpdateEvent != null)
OnUpdateEvent(this, v_e);
if (v_e.next_action == e_CC1_inplace_editting_next_action.success_and_change_to_none_status)
{
m_us_cur.CommitTransaction();
us_object_2_grid(m_us_cur, m_fg.Row);
e.next_action = e_CC1_inplace_editting_next_action.success_and_change_to_none_status;
}
}
catch (Exception v_e)
{
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
e.next_action = e_CC1_inplace_editting_next_action.continue_editting;
}
}
private void delete_v_rpt_bao_cao_danh_sach_phieu_thu()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us = new US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
grid2us_object(v_us, m_fg.Row);
if (!check_ban_giao_is_da_thu_or_admin(v_us))
{
BaseMessages.MsgBox_Infor("Phiếu này đã bàn giao, không được quyền xóa!");
return;
}
try
{
v_us.BeginTransaction();
v_us.DeletePhieuThuVaChiTiet(v_us.dcID);
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
BaseMessages.MsgBox_Infor("Đã xóa thành công");
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
load_data_2_grid();
}
private void insert_chi_tiet_phieu_thu(decimal ip_id_phieu_thu)
{
try
{
m_us_gd_ct_phieu_thu.BeginTransaction();
for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++)
{
US_V_F340_LOP_MON_CUA_HS v_us_lm_hs = new US_V_F340_LOP_MON_CUA_HS();
grid2us_object(v_us_lm_hs, v_i_cur_row);
m_us_gd_ct_phieu_thu.dcID_LOP_MON = v_us_lm_hs.dcID_LOP_MON;
m_us_gd_ct_phieu_thu.dcSO_TIEN = CIPConvert.ToDecimal(m_fg.Rows[v_i_cur_row][(int)e_col_Number.SO_TIEN].ToString().Trim());////Cho nay de chet, can sua sau
m_us_gd_ct_phieu_thu.Insert();
}
m_us_gd_ct_phieu_thu.CommitTransaction();
}
catch (Exception v_e)
{
if (m_us_gd_phieu_thu.is_having_transaction())
{
m_us_gd_phieu_thu.Rollback();
}
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void delete_v_gd_van_thu_all()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL();
US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU();
grid2us_object(v_us, m_fg.Row);
try
{
v_us_gd_van_thu = new US_GD_VAN_THU(v_us.dcID);
v_us_gd_van_thu.BeginTransaction();
v_us_gd_van_thu.Delete();
v_us_gd_van_thu.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us_gd_van_thu.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private static void Initialize()
{
try
{
InitializeMaThamSo();
m_ds_tham_so = new DS_HT_THAM_SO_HE_THONG();
US_HT_THAM_SO_HE_THONG v_us = new US_HT_THAM_SO_HE_THONG();
v_us.FillDataset(m_ds_tham_so);
}
catch (Exception v_e)
{
CDBExceptionHandler v_handler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_handler.showErrorMessage();
Debug.Assert(true, "Không khởi tạo được tham số HT - csung");
}
}
private void delete_ht_phan_quyen_he_thong()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (CHRM_BaseMessages.askUser_DataCouldBeDeleted(8) != CHRM_BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_HT_PHAN_QUYEN_HE_THONG v_us = new US_HT_PHAN_QUYEN_HE_THONG();
grid2us_object(v_us, m_fg.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e) {
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void add_danh_sach_du_lieu()
{
US_DM_BILL v_us_dm_bill = new US_DM_BILL();
DS_DM_BILL v_ds_dm_bill = new DS_DM_BILL();
try
{
m_lbl_loading.Visible = true;
v_us_dm_bill.BeginTransaction();
for (int v_int_row = m_fg_load_file.Rows.Fixed; v_int_row <= m_fg_load_file.Rows.Count - 1; v_int_row++)
{
//IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
//DateTime theDateTime = DateTime.ParseExact(abc, "mm-dd-yyyy", theCultureInfo);
v_us_dm_bill.strNOI_DUNG = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.NOI_DUNG]);
v_us_dm_bill.strNOI_NHAN = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.NOI_NHAN]);
v_us_dm_bill.strNGUOI_NHAN = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.NGUOI_NHAN]);
v_us_dm_bill.strTRONG_NUOC = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.TRONG_NUOC]);
v_us_dm_bill.strNUOC_NGOAI = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.NUOC_NGOAI]);
v_us_dm_bill.strSO_BILL = CIPConvert.ToStr(m_fg_load_file[v_int_row, (int)e_col_Number.SO_BILL]);
v_us_dm_bill.strNGUOI_GUI = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.NGUOI_GUI]);
v_us_dm_bill.datNGAY_GUI = Convert.ToDateTime(m_fg_load_file[v_int_row, (int)e_col_Number.NGAY_GUI].ToString());
v_us_dm_bill.strGHI_CHU = nullToString((string)m_fg_load_file[v_int_row, (int)e_col_Number.GHI_CHU]);
v_us_dm_bill.dcID_PHONG_BAN = CIPConvert.ToDecimal(m_cbo_phong_ban.SelectedValue.ToString());
v_us_dm_bill.SetSO_TIENNull();
v_us_dm_bill.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_THU.ID_DA_NHAN_NOI_BO;
v_us_dm_bill.Insert();
}
v_us_dm_bill.CommitTransaction();
m_lbl_load.Visible = false;
ghi_log_he_thong();
m_i_flag = 0;
BaseMessages.MsgBox_Infor("Đã import dữ liệu nhận từ Bưu cục thành công");
}
catch (Exception v_e)
{
v_us_dm_bill.Rollback();
CDBExceptionHandler v_exceptionHander = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_exceptionHander.showErrorMessage();
}
}
private void delete_v_gd_don_dat_hang()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg_don_dat_hang)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg_don_dat_hang, m_fg_don_dat_hang.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_GD_DON_DAT_HANG v_us = new US_V_GD_DON_DAT_HANG();
grid2us_object(v_us, m_fg_don_dat_hang.Row);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_fg_don_dat_hang.Rows.Remove(m_fg_don_dat_hang.Row);
}
catch (Exception v_e)
{
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void loadData_fromDB_toDatasets()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
try
{
v_us_tu_dien.BeginTransaction();
this.m_ds_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_tu_dien.FillDataset(m_ds_tu_dien);
US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD();
v_us_loai_tu_dien.UseTransOfUSObject(v_us_tu_dien);
this.m_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD();
v_us_loai_tu_dien.FillDataset(m_ds_loai_tu_dien);
v_us_tu_dien.CommitTransaction();
}
catch (Exception v_e)
{
v_us_tu_dien.Rollback();
CDBExceptionHandler v_handler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
v_handler.showErrorMessage();
}
}