public US_V_GD_LUONG_CUNG(decimal i_dbID) { pm_objDS = new DS_V_GD_LUONG_CUNG(); 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]); }
private void load_data_2_grid() { CHRMCommon.make_stt(m_grv_luong_cung_cua_nhan_vien); //US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); //DataSet v_ds = new DataSet(); //v_ds.Tables.Add(new DataTable()); //v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_LUONG_CUNG WHERE DA_XOA = 'N' ORDER BY ID_NHAN_VIEN"); //v_v_us_luong_cung = new US_V_GD_LUONG_CUNG(); DS_V_GD_LUONG_CUNG v_ds = new DS_V_GD_LUONG_CUNG(); //v_ds.Tables.Add(new DataTable()); //SqlCommand cmd = new SqlCommand("SELECT * FROM V_GD_LUONG_CUNG WHERE DA_XOA = 'N' ORDER BY ID_NHAN_VIEN"); v_v_us_luong_cung.FillDataset(v_ds, "WHERE DA_XOA = 'N' ORDER BY ID_NHAN_VIEN"); m_grc_luong_cung_cua_nhan_vien.DataSource = v_ds.Tables[0]; }
public US_V_GD_LUONG_CUNG() { pm_objDS = new DS_V_GD_LUONG_CUNG(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }