/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_Click(object sender, EventArgs e)
{
TB_EmployeeCheckIn mTB_EmployeeCheckIn = new TB_EmployeeCheckIn();
EmployeeCheckInBLL mEmployeeCheckInBLL = new EmployeeCheckInBLL();
mTB_EmployeeCheckIn.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_EmployeeCheckIn.EmployeeNo = this.txtWorkDayNo.Text.Trim();
mTB_EmployeeCheckIn.Name = this.txtName.Text.Trim();
mTB_EmployeeCheckIn.CardNo = this.txtScanCardNO.Text.Trim();
mTB_EmployeeCheckIn.BUID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_EmployeeCheckIn.BU = GetSelectedBu();//this.txtBu.Text.Trim();
mTB_EmployeeCheckIn.Telephone = this.txtMobile.Text.Trim();
DateTime dtVal = DateTime.Now;
if (DateTime.TryParse(this.txtStartDay.Text.Trim(), out dtVal))
{
mTB_EmployeeCheckIn.CheckInDateBegin = dtVal;
}
if (DateTime.TryParse(this.txtEndDay.Text.Trim(), out dtVal))
{
mTB_EmployeeCheckIn.CheckInDateEnd = dtVal;
}
int iDormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
int iRoomTypeID = Convert.ToInt32(this.ddlRoomType.SelectedValue);
string sRoomName = Convert.ToString(this.txtRoom.Text);
string strFileName = mEmployeeCheckInBLL.Export(mTB_EmployeeCheckIn, iDormAreaID, iRoomTypeID, sRoomName);
this.DownLoadFile(this.Request, this.Response, "入住记录.xls", File.ReadAllBytes(strFileName), 10240000);
//File.Delete(strFileName);
}
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);
}
}
