public US_GD_CHAM_CONG_LAM_THEM(decimal i_dbID) { pm_objDS = new DS_GD_CHAM_CONG_LAM_THEM(); 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 decimal get_so_luong_cham_cong() { US_GD_CHAM_CONG_LAM_THEM v_us = new US_GD_CHAM_CONG_LAM_THEM(); DS_GD_CHAM_CONG_LAM_THEM v_ds = new DS_GD_CHAM_CONG_LAM_THEM(); v_us.FillDatasetGetChamCongTheoThang(v_ds, m_txt_thang.Text, m_txt_nam.Text); return v_ds.Tables[0].Rows.Count; }
public US_GD_CHAM_CONG_LAM_THEM() { pm_objDS = new DS_GD_CHAM_CONG_LAM_THEM(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void FillDatasetGetChamCongTheoThang(DS_GD_CHAM_CONG_LAM_THEM v_ds, string ip_str_thang, string ip_str_nam) { CStoredProc v_cstore = new CStoredProc("pr_CC_lam_them_Get_theo_thang"); v_cstore.addDecimalInputParam("@ip_thang", ip_str_thang); v_cstore.addDecimalInputParam("@ip_nam", ip_str_nam); v_cstore.fillDataSetByCommand(this, v_ds); }