示例#1
0
        public structCamperGrantInfo GetCamperGrantInfo(string FJCID)
        {
            structCamperGrantInfo CamperGrantInfo = new structCamperGrantInfo();
            DataSet dsCamperGrant;
            DataRow drCamperGrant;

            CamperApplication oCA = new CamperApplication();

            dsCamperGrant = oCA.getCamperGrantInfo(FJCID);
            if (dsCamperGrant.Tables[0].Rows.Count > 0)
            {
                drCamperGrant = dsCamperGrant.Tables[0].Rows[0];

                if (!Convert.IsDBNull(drCamperGrant["FJCID"]))
                {
                    CamperGrantInfo.FJCID = Convert.ToInt64(drCamperGrant["FJCID"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["FederationID"]))
                {
                    CamperGrantInfo.FederationID = Convert.ToInt32(drCamperGrant["FederationID"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["CampID"]))
                {
                    CamperGrantInfo.CampID = Convert.ToInt32(drCamperGrant["CampID"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["TimeInCamp"]))
                {
                    CamperGrantInfo.TimeInCamp = Convert.ToInt32(drCamperGrant["TimeInCamp"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["CampYearID"]))
                {
                    CamperGrantInfo.CampYearID = Convert.ToInt32(drCamperGrant["CampYearID"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["DaysInCamp"]))
                {
                    CamperGrantInfo.DaysInCamp = Convert.ToInt32(drCamperGrant["DaysInCamp"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["OverProjection"]))
                {
                    CamperGrantInfo.OverProjection = Convert.ToBoolean(drCamperGrant["OverProjection"]);
                }


                if (!Convert.IsDBNull(drCamperGrant["GrantAmount"]))
                {
                    CamperGrantInfo.GrantAmount = Convert.ToDecimal(drCamperGrant["GrantAmount"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["StandardGrant"]))
                {
                    CamperGrantInfo.StandardGrant = Convert.ToDecimal(drCamperGrant["StandardGrant"]);
                }

                if (!Convert.IsDBNull(drCamperGrant["FJCMatch"]))
                {
                    CamperGrantInfo.FJCMatch = Convert.ToDecimal(drCamperGrant["FJCMatch"]);
                }
            }

            return(CamperGrantInfo);
        }