Пример #1
0
        //--------------------------------------------------------//
        //      Method
        //--------------------------------------------------------//

        public object Clone()
        {
            YearVolumeData cloneData = new YearVolumeData();

            cloneData.VolumeID         = this.VolumeID;
            cloneData.TaskCode         = this.TaskCode;
            cloneData.OfficeCode       = this.OfficeCode;
            cloneData.Department       = this.Department;
            cloneData.YearMonth        = this.YearMonth;
            cloneData.Volume           = this.Volume;
            cloneData.VolUncomp        = this.VolUncomp;
            cloneData.VolClaimRem      = this.VolClaimRem;
            cloneData.VolClaim         = this.VolClaim;
            cloneData.Claim            = this.Claim;
            cloneData.VolPaid          = this.VolPaid;
            cloneData.BalanceClaim     = this.BalanceClaim;
            cloneData.BalanceIncom     = this.BalanceIncom;
            cloneData.Deposit1         = this.Deposit1;
            cloneData.Cost             = this.Cost;
            cloneData.ClaimDate        = this.ClaimDate;
            cloneData.PaidDate         = this.PaidDate;
            cloneData.Deposit2         = this.Deposit2;
            cloneData.CarryOverPlanned = this.CarryOverPlanned;

            return(cloneData);
        }
Пример #2
0
        public YearVolumeData[] SelectYearVolume(string officeCode, string department, int yymm)
        {
            SqlHandling sh = new SqlHandling("D_YearVolume");
            DataTable   dt = sh.SelectAllData("WHERE OfficeCode = '" + officeCode + "' AND Department = '" + department + "' AND YearMonth = " + yymm);

            if (dt == null || dt.Rows.Count == 0)
            {
                return(null);
            }
            YearVolumeData[] yVolA = new YearVolumeData[dt.Rows.Count];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                yVolA[i] = new YearVolumeData(dt.Rows[i]);
            }
            return(yVolA);
        }
Пример #3
0
        public YearVolumeData SelectSummaryYearVolume(string officeCode, string department, int yymm)
        {
            SqlHandling sh = new SqlHandling();
            DataTable   dt = sh.SelectFullDescription(sumPara + " OfficeCode = '" + officeCode + "' AND Department = '" + department + "' AND YearMonth = " + yymm);

            if (dt.Rows.Count == 0)
            {
                return(null);
            }
            DataRow        dr    = dt.Rows[0];
            YearVolumeData yvold = setYearVolumeData(dr);

            yvold.OfficeCode = officeCode;
            yvold.Department = department;
            return(yvold);
        }
Пример #4
0
        public YearVolumeData setYearVolumeData(DataRow dr)
        {
            YearVolumeData vol = new YearVolumeData();

            vol.Volume           = (Convert.ToString(dr["sMV"]) == "") ? 0M : Convert.ToDecimal(dr["sMV"]);
            vol.VolUncomp        = (Convert.ToString(dr["sVU"]) == "") ? 0M : Convert.ToDecimal(dr["sVU"]);
            vol.VolClaimRem      = (Convert.ToString(dr["sVCR"]) == "") ? 0M : Convert.ToDecimal(dr["sVCR"]);
            vol.VolClaim         = (Convert.ToString(dr["sVC"]) == "") ? 0M : Convert.ToDecimal(dr["sVC"]);
            vol.Claim            = (Convert.ToString(dr["sMC"]) == "") ? 0M : Convert.ToDecimal(dr["sMC"]);
            vol.VolPaid          = (Convert.ToString(dr["sVP"]) == "") ? 0M : Convert.ToDecimal(dr["sVP"]);
            vol.BalanceClaim     = (Convert.ToString(dr["sBC"]) == "") ? 0M : Convert.ToDecimal(dr["sBC"]);
            vol.BalanceIncom     = (Convert.ToString(dr["sBI"]) == "") ? 0M : Convert.ToDecimal(dr["sBI"]);
            vol.Cost             = (Convert.ToString(dr["sMCO"]) == "") ? 0M : Convert.ToDecimal(dr["sMCO"]);
            vol.CarryOverPlanned = (Convert.ToString(dr["sCOP"]) == "") ? 0M : Convert.ToDecimal(dr["sCOP"]);
            vol.Deposit1         = (Convert.ToString(dr["sDP1"]) == "") ? 0M : Convert.ToDecimal(dr["sDP1"]);
            vol.Deposit2         = (Convert.ToString(dr["sDP2"]) == "") ? 0M : Convert.ToDecimal(dr["sDP2"]);

            return(vol);
        }