private void delete_gd_da_co_trong_thang_cua_nhan_vien(US_DUNG_CHUNG v_us_dc, DataRow v_data_row, decimal ip_dc_id_nv) { decimal v_id_gd_thu_nhap_khac = 0; DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_THU_NHAP_KHAC WHERE ID_NHAN_VIEN =" + ip_dc_id_nv + " AND THANG = " + CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()) + " AND NAM = " + CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim())); if (v_ds.Tables[0].Rows.Count > 0) { v_id_gd_thu_nhap_khac = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString()); US_GD_HE_SO_CHAT_LUONG v_us_gd_hs_cl = new US_GD_HE_SO_CHAT_LUONG(v_id_gd_thu_nhap_khac); v_us_gd_hs_cl.BeginTransaction(); v_us_gd_hs_cl.Delete(); v_us_gd_hs_cl.CommitTransaction(); } else { return; } }
private void save_data() { US_GD_HE_SO_CHAT_LUONG v_us_gd_hs_cl = new US_GD_HE_SO_CHAT_LUONG(); form_2_us_gd_hs_cl(v_us_gd_hs_cl); try { if (v_us_gd_hs_cl.dcID > 0) { US_GD_HE_SO_CHAT_LUONG v_us = new US_GD_HE_SO_CHAT_LUONG(v_us_gd_hs_cl.dcID); v_us.dcHE_SO_K = CIPConvert.ToDecimal(m_txt_hs.Text.Trim()); v_us.datNGAY_SUA = DateTime.Now.Date; //nguoi sua v_us.BeginTransaction(); v_us.Update(); v_us.CommitTransaction(); } else { v_us_gd_hs_cl.BeginTransaction(); v_us_gd_hs_cl.Insert(); v_us_gd_hs_cl.CommitTransaction(); } } catch (Exception v_e) { throw v_e; } }
private void kiem_tra_va_thuc_hien_nhap_hs(ref decimal v_count, ref int v_int_khong_nhap_duoc, decimal v_selectedRowCount) { if (CHRMCommon.thang_da_chot_bang_luong(CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()), CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim()))) { CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_THANG_DA_CHOT_BANG_LUONG); return; } else { for (int i = 0; i < v_selectedRowCount; i++) { decimal v_id_nv = 0; US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG(); US_GD_HE_SO_CHAT_LUONG v_us_hs_cl = new US_GD_HE_SO_CHAT_LUONG(); var v_data_row = m_grv_them_hs.GetDataRow(m_grv_them_hs.GetSelectedRows()[i]); try { get_id_nhan_vien_tu_data_row(v_us_dc, v_data_row, ref v_id_nv); } catch (Exception) { CHRM_BaseMessages.MsgBox_Error("Mã nhân viên " + v_data_row[1].ToString() + " không tồn tại trong hệ thống. Vui lòng kiểm tra lại thông tin!"); v_int_khong_nhap_duoc++; continue; } v_us_hs_cl.dcID_NHAN_VIEN = v_id_nv; v_us_hs_cl.dcHE_SO_K = Convert.ToDecimal(v_data_row["HSK"]); v_us_hs_cl.dcTHANG = CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()); v_us_hs_cl.dcNAM = CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim()); v_us_hs_cl.datNGAY_LAP = DateTime.Now.Date; v_us_hs_cl.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); v_us_hs_cl.strDA_XOA = "N"; try { delete_gd_da_co_trong_thang_cua_nhan_vien(v_us_dc, v_data_row, v_id_nv); v_us_hs_cl.BeginTransaction(); v_us_hs_cl.Insert(); v_us_hs_cl.CommitTransaction(); v_count++; } catch (Exception) { CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_DA_CO_LOI_XAY_RA); v_int_khong_nhap_duoc++; } } } }