예제 #1
0
        /// <summary>
        /// 功能:根据公积金申报基数由规则得到公积金申报缴存额
        /// 日期:2013-03-25
        /// </summary>
        /// <param name="gjjBase">公积申报基数</param>
        /// <returns>公积金申报缴存额</returns>
        /// 公积金缴存额计算规则:公积金基数乘以12%后四舍五入到整数,再乘以2,生成缴存额。计算的缴存额不允许超过上限,不能小于0
        public static int GetGjjFeeByBase(decimal gjjBase)
        {
            decimal dRate   = DecimalHelper.ToDecimal(WebConfigHelper.GetConfigurationApp("GjjFeeCalculator"));//0.12
            decimal decRate = decimal.Parse(dRate.ToString());
            decimal decData = gjjBase * decRate;
            int     iR      = Convert.ToInt32(MathRound(decData, 2));

            return(iR * 2);
        }
예제 #2
0
        public static ImportResultEntity GetExcelData(HttpPostedFileBase fileBase)
        {
            HttpPostedFile     file     = HttpContext.Current.Request.Files["Files"];
            ImportResultEntity model    = new ImportResultEntity();
            string             fileName = Path.GetFileName(file.FileName);
            int    fileSize             = file.ContentLength;                         //获取上传文件的大小单位为字节byte
            string fileEx     = System.IO.Path.GetExtension(fileName);                //获取上传文件的扩展名
            string NoFileName = System.IO.Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
            int    maxSize    = 5000 * 1024;                                          //定义上传文件的最大空间大小为5M

            if (!string.IsNullOrEmpty(WebConfigHelper.GetConfigurationApp("importFileMaxSize")))
            {
                maxSize = Int32Helper.ToInt32(WebConfigHelper.GetConfigurationApp("importFileMaxSize")) * 1024 * 1000;
            }
            string FileType = ".xls,.xlsx";//定义上传文件的类型字符串

            fileName = NoFileName + "_" + Guid.NewGuid().ToString().Replace("-", "") + fileEx;
            if (!FileType.Contains(fileEx))
            {
                model.Status  = 1;
                model.Message = "导入的文件必须是Excel文件。";
                return(model);
            }
            if (fileSize > maxSize)
            {
                model.Status  = 1;
                model.Message = "导入的文件Excel大小不能超过" + (maxSize / 1000 / 1024) + "MB.";
                return(model);
            }
            string path = AppDomain.CurrentDomain.BaseDirectory + "uploads/EXCEL/" + DateTime.Now.ToString("yyyyMMdd");

            if (!System.IO.File.Exists(path))
            {
                System.IO.Directory.CreateDirectory(path);
            }
            string savePath = Path.Combine(path, fileName);

            file.SaveAs(savePath);
            model.Status   = 2;
            model.FileName = fileName;
            model.Message  = "您的文件已上传成功。";
            return(model);
        }