public FileResult aj_excelEquipmentDown(q_Equipment_Chiller q)
{
HSSFWorkbook wbXLS;
FileStream fileStream = null;
MemoryStream outputStream = new MemoryStream();
try
{
db0 = getDB0();
fileStream = new FileStream(Server.MapPath("~/_Code/RPTExcel/Equipment.xls"), FileMode.Open, FileAccess.ReadWrite);
wbXLS = new HSSFWorkbook(fileStream);
ISheet getSheet = wbXLS.GetSheet("設備表");
Apply_User getUserData = null;
if (this.UserId != null)
{
getUserData = db0.Apply_User.Where(x => x.USERID == this.UserId).FirstOrDefault();
}
SetCellValue(getSheet, "C3", getUserData.USERNAME);
SetCellValue(getSheet, "E2", DateTime.Now.ToString("yyyy/MM/dd"));
SetCellValue(getSheet, "E3", getUserData.USERID);
wbXLS.Write(outputStream);
outputStream.Position = 0;
string setFileName = this.UserId + "-01-設備-" + DateTime.Now.ToString("yyyyMMddHHmm") + ".xls";
if (Request.Browser.Browser == "IE" && Request.Browser.Version == "8.0")
{
byte[] bytes = outputStream.ToArray();
Response.Clear();
Response.ContentType = "application/xls";
Response.AddHeader("content-disposition", "attachment;filename=" + Server.UrlEncode(setFileName));
Response.BinaryWrite(bytes);
Response.End();
}
return File(outputStream, "application/vnd.ms-excel", setFileName);
}
catch (Exception ex)
{
Log.Write(ex.Message + ex.StackTrace);
return null;
}
finally
{
db0.Dispose();
}
}
public async Task<string> aj_excelEquipmentDelete(q_Equipment_Chiller q)
{
ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles();
#region
try
{
db0 = getDB0();
if (q.user_id == null)
{
rAjaxResult.result = false;
rAjaxResult.message = "未選擇userid";
return defJSON(rAjaxResult);
}
var getEquipments = db0.Equipment_Chiller.Where(x => x.USERID == this.UserId).ToList();
#region 刪除設備功能
//已在申報中的不移除
foreach (var equip in getEquipments)
{
var checkCIsExist = db0.Apply_Detail_Condenser.Any(x => x.equipment_id == equip.equipment_chiller_id);
var checkEIsExist = db0.Apply_Detail_Evaporate.Any(x => x.equipment_id == equip.equipment_chiller_id);
if (!checkCIsExist && !checkEIsExist)
{
db0.Equipment_Chiller.Remove(equip);
}
}
await db0.SaveChangesAsync();
#endregion
rAjaxResult.result = true;
rAjaxResult.success = true;
}
catch (LogicError ex)
{
rAjaxResult.result = false;
rAjaxResult.message = getRecMessage(ex.Message);
}
catch (Exception ex)
{
rAjaxResult.result = false;
rAjaxResult.message = ex.Message + ex.StackTrace;
}
finally
{
db0.Dispose();
}
#endregion
return defJSON(rAjaxResult);
}
