private DTO_QUY_THU_NHAP_KHAC create_dto_quy_thu_nhap_khac(decimal ip_dc_id_quy_thu_nhap_khac) { DTO_QUY_THU_NHAP_KHAC v_dto_quy = new DTO_QUY_THU_NHAP_KHAC(); //Lay du lieu tu Db US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC(); DataRow v_dr_quy = v_us_quy.LayThongTinQuyThuNhapKhac(ip_dc_id_quy_thu_nhap_khac); //Chuyen doi du lieu sang dto v_dto_quy.CO_DU_LIEU = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.CO_DU_LIEU].ToString() == "Y" ? true : false; v_dto_quy.DA_XOA = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.DA_XOA].ToString(); v_dto_quy.NGUOI_LAP = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGUOI_LAP].ToString(); v_dto_quy.NGUOI_LAP_PHAN_MEM = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGUOI_LAP_PHAN_MEM].ToString(); v_dto_quy.GHI_CHU = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.GHI_CHU].ToString(); v_dto_quy.LY_DO_THUONG = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.LY_DO_THUONG].ToString(); v_dto_quy.TEN_QUY = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TEN_QUY].ToString(); v_dto_quy.NGAY_LAP = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP] == DBNull.Value ? (DateTime?) null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP]); v_dto_quy.NGAY_LAP_PHAN_MEM = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP_PHAN_MEM] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP_PHAN_MEM]); v_dto_quy.TU_NGAY_XET_THUONG = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TU_NGAY_XET_THUONG] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TU_NGAY_XET_THUONG]); v_dto_quy.DEN_NGAY_XET_THUONG = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.DEN_NGAY_XET_THUONG] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.DEN_NGAY_XET_THUONG]); v_dto_quy.ID = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.ID]); v_dto_quy.ID_LOAI_THU_NHAP_KHAC = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.ID_LOAI_QUY_THU_NHAP_KHAC]); v_dto_quy.THANG = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.THANG]); v_dto_quy.NAM = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NAM]); v_dto_quy.SO_LUONG_NV_TRONG_QUY = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.SO_LUONG_NV_TRONG_QUY]); v_dto_quy.TONG_TIEN = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TONG_TIEN]); v_dto_quy.TONG_TIEN_NOP_THUE = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TONG_TIEN_NOP_THUE]); v_dto_quy.TONG_TIEN_THUC_LINH = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TONG_TIEN_THUC_LINH]); return v_dto_quy; }
internal void display_for_update(US_GD_QUY_THU_NHAP_KHAC v_us) { if (check_quy_tien_dang_su_dung_yn(v_us.dcID) || check_quy_tien_da_chot_yn(v_us.strTHANG, v_us.strNAM)) { m_dat_thang_ap_dung_quy.Enabled = false; m_sle_loai_quy_thu_nhap.Enabled = false; } m_us = v_us; us_to_form(v_us); this.ShowDialog(); }
private void delete_gd_thu_nhap_khac(US_GD_QUY_THU_NHAP_KHAC v_us_gd_quy_tnk) { US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(); DS_GD_THU_NHAP_KHAC v_ds = new DS_GD_THU_NHAP_KHAC(); v_us.XoaTNKTheoIDQuy(v_us_gd_quy_tnk.dcID); //for (int i = 0; i < m_dt_thu_nhap_khac.Rows.Count; i++) //{ // US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(decimal.Parse(m_dt_thu_nhap_khac.Rows[i][0].ToString())); // v_us.Delete(); //} }
public void Display_for_insert(decimal ip_dc_id_quy_thu_nhap_khac) { US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC(ip_dc_id_quy_thu_nhap_khac); m_us_gd_tnk = new US_GD_THU_NHAP_KHAC(); m_us_gd_tnk.dcID_QUY_THU_NHAP_KHAC = v_us_quy.dcID; m_us_gd_tnk.dcID_LOAI_THU_NHAP_KHAC = v_us_quy.dcID_LOAI_QUY_THU_NHAP_KHAC; m_us_gd_tnk.dcNAM = Convert.ToDecimal(v_us_quy.strNAM); m_us_gd_tnk.dcTHANG = Convert.ToDecimal(v_us_quy.strTHANG); m_e_form_mode = DataEntryFormMode.InsertDataState; ShowDialog(); }
private bool check_quy_tien_dang_su_dung_yn(US_GD_QUY_THU_NHAP_KHAC v_us) { m_dt_thu_nhap_khac.Clear(); US_GD_THU_NHAP_KHAC v_us_gd_tnk = new US_GD_THU_NHAP_KHAC(); DS_GD_THU_NHAP_KHAC v_ds_gd_tnk = new DS_GD_THU_NHAP_KHAC(); v_us_gd_tnk.LayDuLieuThuNhapKhacTheoIDQuy(v_ds_gd_tnk, v_us.dcID); if (v_ds_gd_tnk.Tables[0].Rows.Count != 0) { m_dt_thu_nhap_khac = v_ds_gd_tnk.Tables[0]; return true; } else return false; }
private void load_data_to_sle_quy_tien() { DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC(); US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(); v_us.FillDatasetQuyTNKbyIDLoaiQuy(v_ds, 756); m_sle_quy_tien.Properties.DataSource = v_ds.Tables[0]; }
private decimal get_thang_theo_quy(decimal v_id_quy) { US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(); DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC(); v_us.FillDataset(v_ds, "where id=" + v_id_quy); return decimal.Parse(v_ds.Tables[0].Rows[0][2].ToString()); }
private void us_to_form(US_GD_QUY_THU_NHAP_KHAC v_us) { m_sle_loai_quy_thu_nhap.EditValue = v_us.dcID_LOAI_QUY_THU_NHAP_KHAC; m_sle_cach_tinh_thue.EditValue = v_us.dcID_CACH_QUYET_TOAN; m_txt_ten_quy.Text = v_us.strTEN_QUY; m_dat_thang_ap_dung_quy.DateTime = new DateTime(int.Parse(v_us.strNAM), int.Parse(v_us.strTHANG), 1); m_dat_ngay_lap_quy.DateTime = v_us.datNGAY_LAP; m_txt_nguoi_lap_quy.Text = v_us.strNGUOI_LAP; m_dat_tu_ngay.DateTime = v_us.datTU_NGAY_XET_THUONG; m_dat_den_ngay.DateTime = v_us.datDEN_NGAY_XET_THUONG; m_txt_ly_do_lap_quy.Text = v_us.strLY_DO_THUONG; }
private bool kiem_tra_xem_trong_quy_co_nhan_vien_chua() { US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(); return v_us.KiemTraQuyCoNhanVienChua(m_us_gd_tnk.dcID_QUY_THU_NHAP_KHAC, m_us_gd_tnk.dcID_NHAN_VIEN); }
private void load_data_to_grid() { CHRMCommon.make_stt_indicator(m_grv); US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(); DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC(); v_us.FillDatasetQuyTNK(v_ds, m_dat_tu_thang.DateTime, m_dat_den_thang.DateTime); m_grc.DataSource = v_ds.Tables[0]; }
private void delete_gd_quy_tien(US_GD_QUY_THU_NHAP_KHAC v_us) { v_us.strDA_XOA = "Y"; v_us.Update(); }
private void xoa_quy_tien(US_GD_QUY_THU_NHAP_KHAC v_us) { if (check_quy_tien_dang_su_dung_yn(v_us)) { int v_slg_nvien = m_dt_thu_nhap_khac.Rows.Count; string v_str_confirms = "Quỹ tiền đang được sử dụng cho " + v_slg_nvien + " nhân viên.\nBạn có muốn xóa cả khoản thu nhập của " + v_slg_nvien + " nhân viên đang sử dụng quỹ tiền này?"; DialogResult v_dialog = XtraMessageBox.Show(v_str_confirms, "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (v_dialog == DialogResult.No) return; } delete_gd_thu_nhap_khac(v_us); delete_gd_quy_tien(v_us); XtraMessageBox.Show("Đã xóa thành công!"); }
void m_cmd_update_Click(object sender, EventArgs e) { try { var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle); US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(CIPConvert.ToDecimal(v_dr[0].ToString())); if (m_grv.FocusedRowHandle < 0) XtraMessageBox.Show("Bạn chưa chọn dòng dữ liệu để sửa", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); //else if (check_quy_tien_da_chot_yn(v_dr[2].ToString(), v_dr[3].ToString())) // XtraMessageBox.Show("Quỹ tiền hiện đã chốt. Vui lòng không cập nhật!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); //else if (check_quy_tien_dang_su_dung_yn(v_us)) // XtraMessageBox.Show("Quỹ đã chi tiền cho nhân viên, vui lòng không cập nhật!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop); else { f354_danh_sach_quy_thuong_de v_f = new f354_danh_sach_quy_thuong_de(); v_f.display_for_update(v_us); load_data_to_grid(); } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
void m_cmd_delete_Click(object sender, EventArgs e) { try { var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle); if (m_grv.FocusedRowHandle < 0) XtraMessageBox.Show("Bạn chưa chọn dòng dữ liệu để sửa", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (check_quy_tien_da_chot_yn(v_dr[2].ToString(), v_dr[3].ToString())) XtraMessageBox.Show("Bạn không thể xóa quỹ tiền đã chốt!","Thông báo",MessageBoxButtons.OK,MessageBoxIcon.Stop); else { US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(CIPConvert.ToDecimal(v_dr[0].ToString())); string v_str_confirm = "Bạn có chắc chắn muốn xóa quỹ tiền này?"; DialogResult v_dialog = XtraMessageBox.Show(v_str_confirm,"Xác nhận",MessageBoxButtons.YesNo,MessageBoxIcon.Question); if (v_dialog == DialogResult.Yes) { xoa_quy_tien(v_us); load_data_to_grid(); } } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private DataTable create_data_chi_tiet_quy(decimal ip_dc_id_quy_thu_nhap_khac) { US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC(); return v_us_quy.LayChiTietQuy(ip_dc_id_quy_thu_nhap_khac); }