public void FillDatasetByManhanvien(DS_V_GD_HOP_DONG_LAO_DONG op_ds, string ip_str_ma_nv, decimal ip_dc_id_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_V_GD_HOP_DONG_LAO_DONG_By_Ma_nhan_vien"); v_sp.addDecimalInputParam("@MA_NHAN_VIEN", ip_str_ma_nv); v_sp.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_id_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds); }
private void load_data_2_grid() { m_ds = new DS_V_GD_HOP_DONG_LAO_DONG(); m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
private void load_data_2_grid_search() { m_ds = new DS_V_GD_HOP_DONG_LAO_DONG(); m_us.FillDataset_search(m_ds, m_txt_nhan_vien.Text, CIPConvert.ToDecimal(m_cbo_loai_hop_dong.SelectedValue), m_dat_ngay_bat_dau.Value, m_dat_ngay_ket_thuc.Value); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
public US_V_GD_HOP_DONG_LAO_DONG(decimal i_dbID) { pm_objDS = new DS_V_GD_HOP_DONG_LAO_DONG(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
public void FillDataset_search(DS_V_GD_HOP_DONG_LAO_DONG op_ds, string ip_str_nhan_vien, decimal ip_dc_loai_hop_dong, DateTime ip_dat_ngay_bat_dau, DateTime ip_dat_ngay_ket_thuc) { var command = new CStoredProc("pr_V_GD_HOP_DONG_LAO_DONG_Search"); command.addNVarcharInputParam("@NHAN_VIEN", ip_str_nhan_vien); command.addDecimalInputParam("@ID_LOAI_HOP_DONG", ip_dc_loai_hop_dong); command.addDatetimeInputParam("@NGAY_BAT_DAU", ip_dat_ngay_bat_dau); command.addDatetimeInputParam("@NGAY_KET_THUC", ip_dat_ngay_ket_thuc); command.fillDataSetByCommand(this, op_ds); }
public void SelectHopDongDaHetHanNhungChuaKy(DS_V_GD_HOP_DONG_LAO_DONG op_ds, string ip_str_keyword, decimal ip_dc_loai_hop_dong, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal ip_dc_tim_kiem_ngay_thang_theo, decimal ip_dc_id_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_V_GD_HOP_DONG_LAO_DONG_Search_HDLD_da_het_han_nhung_chua_ky"); v_sp.addNVarcharInputParam("@ip_str_keyword", ip_str_keyword); v_sp.addDecimalInputParam("@id_loai_hop_dong", ip_dc_loai_hop_dong); v_sp.addDatetimeInputParam("@tu_ngay", ip_dat_tu_ngay); v_sp.addDatetimeInputParam("@den_ngay", ip_dat_den_ngay); v_sp.addDecimalInputParam("@tim_kiem_theo_ngay", ip_dc_tim_kiem_ngay_thang_theo); v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds); }
private void auto_suggest_text() { US_V_GD_HOP_DONG_LAO_DONG v_us_v_gd_hop_dong = new US_V_GD_HOP_DONG_LAO_DONG(); DS_V_GD_HOP_DONG_LAO_DONG v_ds_v_gd_hop_dong = new DS_V_GD_HOP_DONG_LAO_DONG(); v_us_v_gd_hop_dong.FillDataset(v_ds_v_gd_hop_dong, "WHERE ID_PHAP_NHAN = " + CAppContext_201.getCurrentIDPhapnhan().ToString()); var v_acsc_search = new AutoCompleteStringCollection(); foreach (DataRow dr in v_ds_v_gd_hop_dong.V_GD_HOP_DONG_LAO_DONG) { v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.HO_DEM].ToString() + " " + dr[V_GD_HOP_DONG_LAO_DONG.TEN].ToString()); v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.MA_NV].ToString()); v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.MA_HOP_DONG].ToString()); v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.TEN].ToString()); v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.HO_DEM].ToString()); } m_txt_tim_kiem.AutoCompleteCustomSource = v_acsc_search; }
public void FillDatasetSearchAll(DS_V_GD_HOP_DONG_LAO_DONG op_ds, string ip_str_keyword, decimal ip_dc_loai_hop_dong, string ip_str_trang_thai_hop_dong, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal ip_dc_tim_kiem_ngay_thang_theo, decimal ip_dc_id_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_GD_HOP_DONG_Search"); v_sp.addNVarcharInputParam("@ip_str_keyword", ip_str_keyword); v_sp.addDecimalInputParam("@id_loai_hop_dong", ip_dc_loai_hop_dong); v_sp.addNVarcharInputParam("@trang_thai_hop_dong", ip_str_trang_thai_hop_dong); v_sp.addDatetimeInputParam("@tu_ngay", ip_dat_tu_ngay); v_sp.addDatetimeInputParam("@den_ngay", ip_dat_den_ngay); v_sp.addDecimalInputParam("@tim_kiem_theo_ngay", ip_dc_tim_kiem_ngay_thang_theo); v_sp.addDecimalInputParam("@id_phap_nhan", ip_dc_id_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds); }
private void load_data_2_grid() { m_ds = new DS_V_GD_HOP_DONG_LAO_DONG(); var v_dc_id_phap_nhan = CAppContext_201.getCurrentIDPhapnhan(); var v_str_search = m_txt_tim_kiem.Text.Trim(); if (v_str_search == m_str_suggest) { v_str_search = ""; } if (m_cbo_loai_hop_dong.SelectedValue == null) { return; } if (m_cbo_trang_thai_hop_dong.SelectedValue == null) { return; } var v_str_trang_thai_hop_dong = ""; if (m_cbo_trang_thai_hop_dong.SelectedIndex == 1) { v_str_trang_thai_hop_dong = "Y"; } if (m_cbo_trang_thai_hop_dong.SelectedIndex == 2) { v_str_trang_thai_hop_dong = "N"; } if (m_cbo_tim_kiem_theo.SelectedIndex == 0) { m_us.FillDatasetSearchAll(m_ds, v_str_search, decimal.Parse(m_cbo_loai_hop_dong.SelectedValue.ToString()), v_str_trang_thai_hop_dong, DateTime.Parse(m_dat_tu_ngay.Value.ToShortDateString()), DateTime.Parse(m_dat_den_ngay.Value.ToShortDateString()), 0, v_dc_id_phap_nhan); } if (m_cbo_tim_kiem_theo.SelectedIndex == 1) { m_us.FillDatasetSearchAll(m_ds, v_str_search, decimal.Parse(m_cbo_loai_hop_dong.SelectedValue.ToString()), v_str_trang_thai_hop_dong, DateTime.Parse(m_dat_tu_ngay.Value.ToShortDateString()), DateTime.Parse(m_dat_den_ngay.Value.ToShortDateString()), 1, v_dc_id_phap_nhan); } if (m_cbo_tim_kiem_theo.SelectedIndex == 2) { m_us.FillDatasetSearchAll(m_ds, v_str_search, decimal.Parse(m_cbo_loai_hop_dong.SelectedValue.ToString()), v_str_trang_thai_hop_dong, DateTime.Parse(m_dat_tu_ngay.Value.ToShortDateString()), DateTime.Parse(m_dat_den_ngay.Value.ToShortDateString()), 2, v_dc_id_phap_nhan); } if (m_cbo_tim_kiem_theo.SelectedIndex == 3) { m_us.FillDatasetSearchAll(m_ds, v_str_search, decimal.Parse(m_cbo_loai_hop_dong.SelectedValue.ToString()), v_str_trang_thai_hop_dong, DateTime.Parse(m_dat_tu_ngay.Value.ToShortDateString()), DateTime.Parse(m_dat_den_ngay.Value.ToShortDateString()), 3, v_dc_id_phap_nhan); } m_lbl_count_record.Text = string.Format("Có {0} Hợp Đồng Lao Động.", m_ds.Tables[0].Rows.Count); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count // chỗ này dùng hàm count tức là để đếm, có thể dùng các hàm khác thay thế , 0 , (int)e_col_Number.MA_NV // chỗ này là tên trường mà mình nhóm , (int)e_col_Number.MA_HOP_DONG // chỗ này là tên trường mà mình Count , "{0}" ); m_fg.Redraw = true; m_fg.Focus(); auto_suggest_text(); }
public US_V_GD_HOP_DONG_LAO_DONG() { pm_objDS = new DS_V_GD_HOP_DONG_LAO_DONG(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }