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 save_data() { if (!check_validate_data()) { return; } if (!check_tong_tien_grid_textbox()) { return; } decimal v_dc_id_phieu_thu = 0; try { switch (m_e_form_mode) { case DataEntryFormMode.InsertDataState: if (!is_exist_so_phieu(ref v_dc_id_phieu_thu)) { insert_phieu_thu_ct_phieu_thu(); } else { BaseMessages.MsgBox_Infor("Số phiếu này đã được nhập trước đây rồi!"); return; } //insert_chi_tiet_phieu_thu(v_dc_id_phieu_thu); if (check_phieu_is_exist() == true && dong_y == 0) { DialogResult v_dlg = BaseMessages.MsgBox_YES_NO_CANCEL("Đã cập nhật thành công phiếu này. Bạn có muốn nhập phiếu khác"); switch (v_dlg) { case DialogResult.Yes: refresh_form(); break; case DialogResult.No: this.Close(); break; case DialogResult.Cancel: break; default: break; } } break; case DataEntryFormMode.UpdateDataState: form_2_us_gd_phieu_thu(); m_us_gd_phieu_thu.BeginTransaction(); m_us_gd_phieu_thu.Update(); //Delete het chi tiet phieu thu tu id_phieu_thu US_GD_CHI_TIET_PHIEU_THU v_us_gd_ct_pt = new US_GD_CHI_TIET_PHIEU_THU(); v_us_gd_ct_pt.deleteAllFromIDPhieuThu(m_us_gd_phieu_thu.dcID); //Insert lai chi tiet phieu thu 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.dcID_GD_PHIEU_THU = m_us_gd_phieu_thu.dcID; 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.UseTransOfUSObject(m_us_gd_phieu_thu); m_us_gd_ct_phieu_thu.Insert(); } m_us_gd_phieu_thu.CommitTransaction(); BaseMessages.MsgBox_Infor("Đã cập nhật thành công"); break; default: break; } } catch (Exception v_e) { if (m_us_gd_phieu_thu.is_having_transaction()) { m_us_gd_phieu_thu.Rollback(); } throw v_e; } }