Esempio n. 1
0
        private void ImportToDB(string fileName)
        {
            var       checkInBll = new EmployeeCheckInBLL();
            DataTable dtErr      = null;
            int       nSuccess   = 0;

            if (checkInBll.CheckOutBatch(fileName, out nSuccess, out dtErr))
            {
                var str = string.Format("批量退房,{0}人成功", nSuccess);
                ShowMessage(str, true);
                hidFailXls.Value = "";
                return;
            }
            else
            {
                var nFailed = (dtErr == null) ? 0 : dtErr.Rows.Count;
                if (nFailed > 0)
                {
                    EmployeeCheckInBLL mEmployeeCheckInBLL = new EmployeeCheckInBLL();
                    string             strFileName         = mEmployeeCheckInBLL.Export(dtErr, "批量退房失败");
                    btnDownFails.Enabled = true;
                    hidFailXls.Value     = strFileName;
                    //this.DownLoadFile(this.Request, this.Response, Path.GetFileName(strFileName), File.ReadAllBytes(strFileName), 10240000);
                }
                var str = string.Format("批量退房,{0}人成功,{1}人失败", nSuccess, nFailed);
                ShowMessage(str, false);
            }
        }