예제 #1
0
        public void LoadQuotas()
        {
            Database data = new Database();
            SqlDataReader reader = data.GetQuotaFunnel(EmployeeID, ReportMonth);

            if (reader.Read())
            {
                RMRQuota = DataUtility.RetrieveDecimal(reader, "mnyRMRQuota", 0.0m);
                RMRFunnel = DataUtility.RetrieveDecimal(reader, "mnyRMRFunnel", 0.0m);
                RSSQuota = DataUtility.RetrieveDecimal(reader, "mnyRSSQuota", 0.0m);
                RSSFunnel = DataUtility.RetrieveDecimal(reader, "mnyRSSFunnel", 0.0m);

                tblQuotaFunnels.Rows[1].Cells[0].Text = RMRQuota.ToString("C");
                tblQuotaFunnels.Rows[1].Cells[1].Text = RMRFunnel.ToString("C");
                tblQuotaFunnels.Rows[1].Cells[2].Text = RSSQuota.ToString("C");
                tblQuotaFunnels.Rows[1].Cells[3].Text = RSSFunnel.ToString("C");
            }

            data.Close();
            data.Dispose();
        }