private void cap_nhat_ban_giao()
{
if (m_fg.Rows.Count == 1) {
return;
}
for (int v_i_cur_row = m_fg.Rows.Fixed+1; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++) {
US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us_v_rpt = new US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
grid2us_object(v_us_v_rpt, v_i_cur_row);
US_GD_PHIEU_THU v_us_gd_pt = new US_GD_PHIEU_THU(v_us_v_rpt.dcID);
v_us_gd_pt.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_BAN_GIAO.DA_BAN_GIAO;
v_us_gd_pt.Update();
}
load_data_2_grid();
m_txt_tong_tien.Clear();
BaseMessages.MsgBox_Infor("Đã bàn giao tiền!");
}
private void us_object2grid(US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU i_us
, int i_grid_row)
{
DataRow v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData;
i_us.Me2DataRow(v_dr);
m_obj_trans.DataRow2GridRow(v_dr, i_grid_row);
}
private void update_v_rpt_bao_cao_danh_sach_phieu_thu()
{
US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us = new US_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;
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 sửa!");
return;
}
US_GD_PHIEU_THU v_us_gd_pt = new US_GD_PHIEU_THU(v_us.dcID);
f340_lap_phieu_thu v_frm = new f340_lap_phieu_thu();
v_frm.display(v_us, v_us_gd_pt.dcID_LOAI_PHIEU_THU, v_us_gd_pt.dcID_NGUOI_NHAP);
load_data_2_grid();
}
void m_fg_DoubleClick(object sender, EventArgs e)
{
try
{
US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us = new US_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;
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 sửa!");
return;
}
US_GD_PHIEU_THU v_us_gd_pt = new US_GD_PHIEU_THU(v_us.dcID);
f340_lap_phieu_thu v_frm = new f340_lap_phieu_thu();
v_frm.display(v_us, v_us_gd_pt.dcID_LOAI_PHIEU_THU, v_us_gd_pt.dcID_NGUOI_NHAP);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void grid2us_object(US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU i_us
, int i_grid_row)
{
DataRow v_dr;
v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData;
m_obj_trans.GridRow2DataRow(i_grid_row, v_dr);
i_us.DataRow2Me(v_dr);
}
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 bool check_ban_giao_is_da_thu_or_admin(US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU ip_us_rpt)
{
if (US_V_HT_NGUOI_SU_DUNG.isInAdminGroup(CAppContext_201.getCurrentUserID()))
{
return true;
}
US_GD_PHIEU_THU v_us_gd_pt = new US_GD_PHIEU_THU(ip_us_rpt.dcID);
if (v_us_gd_pt.dcID_TRANG_THAI == CONST_ID_TRANG_THAI_BAN_GIAO.DA_BAN_GIAO)
{
return false;
}
return true;
}
private void tao_phieu()
{
US_GD_PHIEU_THU v_us_gd_phieu_thu = new US_GD_PHIEU_THU();
US_GD_CHI_TIET_PHIEU_THU v_us_gd_chi_tiet_phieu_thu = new US_GD_CHI_TIET_PHIEU_THU();
v_us_gd_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_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us_rpt = new US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, v_i_cur_row)) return;
grid2us_object(v_us_rpt, v_i_cur_row);
//form_2_us_gd_phieu_thu
v_us_gd_phieu_thu.strSO_PHIEU = m_fg.Rows[v_i_cur_row][(int)e_col_Number.SO_PHIEU].ToString().Trim();
v_us_gd_phieu_thu.dcID_HOC_SINH = v_us_rpt.dcID_HOC_SINH;
v_us_gd_phieu_thu.dcID_NGUOI_THU = CIPConvert.ToDecimal(m_cbo_nhan_vien_thu.SelectedValue);
v_us_gd_phieu_thu.dcID_NGUOI_NHAP = CIPConvert.ToDecimal(m_cbo_nhan_vien_nhap.SelectedValue);
v_us_gd_phieu_thu.strTEN_NGUOI_NOP_TIEN = m_fg.Rows[v_i_cur_row][(int)e_col_Number.HO_TEN_PH].ToString().Trim();
v_us_gd_phieu_thu.strNOI_DUNG = m_fg.Rows[v_i_cur_row][(int)e_col_Number.NOI_DUNG].ToString().Trim();
v_us_gd_phieu_thu.SetSO_TIENNull();
v_us_gd_phieu_thu.datNGAY_THU = m_dat_tai_ngay.Value.Date;
v_us_gd_phieu_thu.datNGAY_NHAP = m_dat_ngay_nhap.Value.Date;
v_us_gd_phieu_thu.dcID_LOAI_PHIEU_THU = CONST_ID_LOAI_PHIEU_THU.PHIEU_PHAI_THU;
v_us_gd_phieu_thu.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_BAN_GIAO.DA_THU;
v_us_gd_phieu_thu.Insert();
//form_2_us_gd_chi_tiet_phieu_thu
v_us_gd_chi_tiet_phieu_thu.dcID_GD_PHIEU_THU = v_us_gd_phieu_thu.dcID;
v_us_gd_chi_tiet_phieu_thu.dcID_LOP_MON = CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue);
v_us_gd_chi_tiet_phieu_thu.dcSO_TIEN = CIPConvert.ToDecimal(m_fg.Rows[v_i_cur_row][(int)e_col_Number.TIEN_PHAI_THU].ToString());
v_us_gd_chi_tiet_phieu_thu.UseTransOfUSObject(v_us_gd_phieu_thu);
v_us_gd_chi_tiet_phieu_thu.Insert();
}
v_us_gd_phieu_thu.CommitTransaction();
}
private void load_data_2_grid()
{
DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_ds_ds_pt = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us_ds_pt = new US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
v_ds_ds_pt.EnforceConstraints = false;
v_ds_ds_pt.Clear();
v_us_ds_pt.FillThongTinHS(v_ds_ds_pt, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue));
CGridUtils.Dataset2C1Grid(v_ds_ds_pt, m_fg, m_obj_trans);
CGridUtils.MakeSoTT(0, m_fg);
//Fill cac cot con lai
for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++)
{
m_fg.Rows[v_i_cur_row][(int)e_col_Number.NGAY_THU] = m_dat_tai_ngay.Value.Date;
m_fg.Rows[v_i_cur_row][(int)e_col_Number.NOI_DUNG] = m_txt_noi_dung.Text.Trim();
m_fg.Rows[v_i_cur_row][(int)e_col_Number.HO_TEN_PH] = "PH " + m_fg.Rows[v_i_cur_row][(int)e_col_Number.HO_TEN_HS];
US_V_HT_NGUOI_SU_DUNG v_us_ht_nsd = new US_V_HT_NGUOI_SU_DUNG(CAppContext_201.getCurrentUserID());
m_fg.Rows[v_i_cur_row][(int)e_col_Number.NGUOI_THU] = v_us_ht_nsd.strTEN;
m_fg.Rows[v_i_cur_row][(int)e_col_Number.SO_PHIEU] = "PPT" + m_cbo_lop_mon.SelectedValue.ToString() + "_" + m_fg.Rows[v_i_cur_row][(int)e_col_Number.MA_HOC_SINH];
m_fg.Rows[v_i_cur_row][(int)e_col_Number.TIEN_PHAI_THU] = m_txt_thanh_tien.Text;
}
}
public void display(US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU ip_us, decimal ip_dc_id_loai_phieu_thu, decimal ip_dc_id_nguoi_nhap)
{
US_V_GD_PHIEU_THU v_us_v_pt = new US_V_GD_PHIEU_THU(ip_us.dcID);
m_us_v_hoc_sinh.dcID = ip_us.dcID_HOC_SINH;
m_us_gd_phieu_thu.dcID = v_us_v_pt.dcID;
m_txt_so_phieu.Text = ip_us.strSO_PHIEU.Trim();
m_txt_ho_ten_hs.Text = ip_us.strHO_TEN_HS.Trim();
m_txt_ten_nguoi_nop_tien.Text = v_us_v_pt.strTEN_NGUOI_NOP_TIEN.Trim();
m_txt_noi_dung.Text = ip_us.strNOI_DUNG.Trim();
if (ip_dc_id_loai_phieu_thu == ID_LOAI_PHIEU_THU.ID_PHIEU_PHAI_THU)
{
m_txt_so_tien.Text = ip_us.dcTIEN_PHAI_THU.ToString("#,###");
//m_txt_so_tien_bang_chu.Text = CTienNo2Text.So_chu((double)ip_us.dcTIEN_PHAI_THU);
m_lbl_header.Text = "CHI TIẾT PHIẾU PHẢI THU";
m_str_loai_form = "PHAI_THU";
}
else if (ip_dc_id_loai_phieu_thu == ID_LOAI_PHIEU_THU.ID_PHIEU_GIAM_TRU)
{
m_txt_so_tien.Text = ip_us.dcTIEN_GIAM_TRU.ToString("#,###");
//m_txt_so_tien_bang_chu.Text = CTienNo2Text.So_chu((double)ip_us.dcTIEN_GIAM_TRU);
m_lbl_header.Text = "CHI TIẾT PHIẾU GIẢM TRỪ";
m_str_loai_form = "GIAM_TRU";
}
else if (ip_dc_id_loai_phieu_thu == ID_LOAI_PHIEU_THU.ID_PHIEU_THUC_THU)
{
m_txt_so_tien.Text = ip_us.dcTIEN_THUC_THU.ToString("#,###");
//m_txt_so_tien_bang_chu.Text = CTienNo2Text.So_chu((double)ip_us.dcTIEN_THUC_THU);
m_lbl_header.Text = "CHI TIẾT PHIẾU THỰC THU";
m_str_loai_form = "THUC_THU";
}
//lap ham xu ly tien bang so qua bang chu
m_cbo_nhan_vien_thu.SelectedValue = ip_us.dcID_NGUOI_THU;
//m_lbl_header.Text = "LẬP " + v_us_v_pt.strTEN_NGAN;
m_dat_ngay_thu.Value = ip_us.datNGAY_THU;
m_dat_ngay_nhap.Value = v_us_v_pt.datNGAY_NHAP;
load_data_2_cbo();
m_cbo_nhan_vien_nhap.SelectedValue = ip_dc_id_nguoi_nhap;
m_cbo_nhan_vien_thu.SelectedValue = ip_us.dcID_NGUOI_THU;
m_cmd_ds_phieu.Visible = false;
m_str_trang_thai_phieu = "F430";
m_id_gd_phieu_thu = ip_us.dcID;
m_cmd_insert.Text = "Lưu sửa phiếu";
m_e_form_mode = DataEntryFormMode.UpdateDataState;
m_cmd_chon_hs.Visible = false;
m_txt_ho_ten_hs.BackColor = Color.AliceBlue;
m_txt_ho_ten_hs.ReadOnly = true;
m_lbl_ten_hs.Text = ip_us.strHO_TEN_HS.Trim();
//suggest_ma_phieu();
this.ShowDialog();
}
