public void load_data_2_export_bao_cao_706(DS_RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM op_ds_v_gd_cv_moi, decimal ip_dc_thang_dat_hang, decimal ip_dc_nam_dat_hang, decimal ip_dc_id_trang_thai_cv) { CStoredProc v_cstore = new CStoredProc("pr_GD_GV_CONG_VIEC_MOI_Load_Cong_Viec_Export_Bao_Cao_706"); v_cstore.addDecimalInputParam("@THANG_DAT_HANG", ip_dc_thang_dat_hang); v_cstore.addDecimalInputParam("@NAM_DAT_HANG", ip_dc_nam_dat_hang); v_cstore.addDecimalInputParam("@ID_TRANG_THAI_CV", ip_dc_id_trang_thai_cv); v_cstore.fillDataSetByCommand(this, op_ds_v_gd_cv_moi); }
public US_RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM(decimal i_dbID) { pm_objDS = new DS_RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM(); 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 decimal get_sum_tien(DS_RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM ip_ds_gd_gv_cong_viec) { decimal v_dc_sum_tien = 0; for (int v_i = 0; v_i < ip_ds_gd_gv_cong_viec.RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM.Rows.Count; v_i++) { if (ip_ds_gd_gv_cong_viec.RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM.Rows[v_i][RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM.THANH_TIEN].GetType() == typeof(DBNull)) { v_dc_sum_tien += 0; } else { v_dc_sum_tien += CIPConvert.ToDecimal(ip_ds_gd_gv_cong_viec.RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM.Rows[v_i][RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM.THANH_TIEN]); } } return(v_dc_sum_tien); }
public US_RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM() { pm_objDS = new DS_RPT_BAO_CAO_TONG_HOP_CONG_VIEC_GVCM(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }