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 decimal find_hs_chat_luong_by_nv_thang_nam(decimal ip_dc_id_nv, decimal ip_dc_thang, decimal ip_dc_nam) { US_GD_HE_SO_CHAT_LUONG v_us = new US_GD_HE_SO_CHAT_LUONG(); DS_GD_HE_SO_CHAT_LUONG v_ds = new DS_GD_HE_SO_CHAT_LUONG(); v_us.FillDataset(v_ds); string v_str_filter = "ID_NHAN_VIEN = " + ip_dc_id_nv + " AND THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam; DataRow[] v_dr = v_ds.GD_HE_SO_CHAT_LUONG.Select(v_str_filter); if (v_dr.Count() == 0) { return 0; } else { return CIPConvert.ToDecimal(v_dr.First()["HE_SO_K"].ToString()); } }
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 load_data_2_grid(decimal ip_dc_id_nv, decimal ip_dc_thang, decimal ip_dc_nam) { CHRMCommon.make_stt(m_grv_hs_chat_luong); US_GD_HE_SO_CHAT_LUONG v_us = new US_GD_HE_SO_CHAT_LUONG(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); v_us.FillDatasetHeSoCL(v_ds, ip_dc_id_nv, ip_dc_thang, ip_dc_nam); //v_us.FillDatasetWithQuery(v_ds,"SELECT * FROM V_GD_HE_SO_CHAT_LUONG WHERE ID_NHAN_VIEN = " + ip_dc_id_nv + " AND THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam); m_grc_hs_chat_luong.DataSource = v_ds.Tables[0]; }
private void form_2_us_gd_hs_cl(US_GD_HE_SO_CHAT_LUONG ip_us) { decimal v_id_gd_hs_cl = 0; v_id_gd_hs_cl = find_id_gd_hs_chat_luong(CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue), m_txt_thang, m_txt_nam); ip_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue); ip_us.dcTHANG = m_txt_thang; ip_us.dcNAM = m_txt_nam; ip_us.dcHE_SO_K = CIPConvert.ToDecimal(m_txt_hs.Text.Trim()); if (v_id_gd_hs_cl > 0) { ip_us.dcID = v_id_gd_hs_cl; ip_us.datNGAY_SUA = DateTime.Now.Date; //nguoi sua ip_us.strNGUOI_SUA = CAppContext_201.getCurrentUserName(); } else { ip_us.datNGAY_LAP = DateTime.Now.Date; //nguoi lap ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); ip_us.strDA_XOA = "N"; } }
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++; } } } }