public string aj_FUpload(int id, string filekind, string fileName) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region string tpl_File = string.Empty; try { //代表圖片 if (filekind == "Photo1") handleImageSave(fileName, id, ImageFileUpParm.NewsBasicSingle, filekind, "Activities", "ActivitiesDetail"); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = fileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = ex.Message; } #endregion return defJSON(rAjaxResult); }
public string aj_FSort(int id, string filekind, IList<JsonFileInfo> file_object) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); rewriteJsonFile(id, filekind, "Banner", "Banner", file_object); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public string aj_FDelete(int id, string filekind, string filename) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); DeleteSysFile(id, filekind, filename, ImageFileUpParm.NewsBasicSingle, "Activities", "ActivitiesDetail"); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public string aj_FUpload(int id, string filekind, string fileName) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region string tpl_File = string.Empty; try { //廣告圖 4張 if (filekind == "Photo1") handleImageSave(fileName, id, ImageFileUpParm.BannerRotator, filekind, "Banner", "Banner"); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = fileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = ex.Message; } #endregion return defJSON(rAjaxResult); }
public string aj_FDelete(int id, string filekind, string filename) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); DeleteSysFile(id, filekind, filename, ImageFileUpParm.BannerRotator, "Banner", "Banner"); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public string aj_FList(int id, string filekind) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); rAjaxResult.filesObject = listDocFiles(id, filekind, "DocManage", "DocManage"); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public string aj_FList(int id, string filekind) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); rAjaxResult.filesObject = listImgFiles(id, filekind, "Banner", "Banner"); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public string aj_FList(int id, string filekind) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); rAjaxResult.filesObject = ListSysFiles(id, filekind, true, "Activities", "ActivitiesDetail"); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public String aj_FDelete(int id, String FileKind, String FileName) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); //if (FileKind == "TypeImg") //{ // DeleteSysFile(id, FileKind, FileName, ImageFileUpParm.NewsBasicSingle, "PT"); //} //else //{ // DeleteSysFile(id, FileKind, FileName, ImageFileUpParm.NewsBasicSingle); //} DeleteSysFile(id, FileKind, FileName, ImageFileUpParm.NewsBasicSingle); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public String aj_FList(int id, String FileKind) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); //if (FileKind == "TypeImg") //{ // rAjaxResult.filesObject = ListSysFiles(id, FileKind, "PT"); //} //else //{ // rAjaxResult.filesObject = ListSysFiles(id, FileKind); //} rAjaxResult.filesObject = ListSysFiles(id, FileKind); rAjaxResult.result = true; return defJSON(rAjaxResult); }
public string aj_ApplyfileUpload(HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region try { string FN = file.FileName; int id = GetNewId(ProcCore.Business.CodeTable.Apply); string filePath = Server.MapPath("~/_Code/SysUpFiles/ApplyData/" + id); if (Directory.Exists(filePath)) { Directory.Delete(filePath, true); Directory.CreateDirectory(filePath); } else { Directory.CreateDirectory(filePath); } var path = Path.Combine(filePath, FN); file.SaveAs(path); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.id = id; rAjaxResult.FileName = FN; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = ex.Message; } #endregion return defJSON(rAjaxResult); }
public string ajax_delFile(int y, string fname, string userid) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); string uid = string.Empty; if (this.LoginUserFlag == "Y") { uid = this.UserId; } else { uid = userid; } try { string pathTpl = string.Format("~/_Code/SysUpFiles/Apply.Loading/{0}/{1}", y, uid); string serverPath = Server.MapPath(pathTpl); if (System.IO.File.Exists(Path.Combine(serverPath, fname))) { System.IO.File.Delete(Path.Combine(serverPath, fname)); } rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = fname; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = ex.Message; } return defJSON(rAjaxResult); }
public String aj_FUpload(Int32 id, String FilesKind, HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region String tpl_File = String.Empty; try { //代表圖片 if (FilesKind == "SingleImg") ImageFile(file, id, ImageFileUpParm.NewsBasicSingle, FilesKind); //多張圖片 if (FilesKind == "DoubleImg") ImageFile(file, id, ImageFileUpParm.NewsBasicDouble, FilesKind); //if (FilesKind == "TypeImg") // ImageFile(file, id, ImageFileUpParm.NewsBasicSingle, FilesKind, "PT"); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = file.FileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = ex.Message; } #endregion return defJSON(rAjaxResult); }
public string aj_excelEvaporateApplyUploadForTest(HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region string tpl_File = string.Empty; HSSFWorkbook wbXLS; try { db0 = getDB0(); wbXLS = new HSSFWorkbook(file.InputStream); ISheet getSheet = wbXLS.GetSheet("年度申報表"); var getUserId = GetCellValueString(getSheet, "G3"); if (getUserId != this.UserId) { rAjaxResult.result = false; rAjaxResult.message = "User Id驗證不符"; return defJSON(rAjaxResult); } double getYear = GetCellValueInt(getSheet, "C4"); if (getYear > allowApplyYear) { rAjaxResult.message = string.Format("{0}年度不充許申報!", getYear); rAjaxResult.result = false; return defJSON(rAjaxResult); } var isExist = db0.Apply.Any(x => x.y == getYear && x.userid == this.UserId); int startRow = 7; int getLastRow = getSheet.LastRowNum; int apply_id = 0; Apply apply = new Apply(); if (!isExist)//如果申報表不存在就新增 { //Apply apply = new Apply(); apply.apply_id = GetNewId(ProcCore.Business.CodeTable.Apply); apply.doc_date = DateTime.Now; apply_id = apply.apply_id;//取得id var getLast_1 = getSheet.GetRow(getLastRow - 1); apply.doc_name = getLast_1.Cells[1].StringCellValue; apply.doc_gender = true; apply.doc_rank = getLast_1.Cells[3].StringCellValue; ; apply.doc_tel = getLast_1.Cells[5].StringCellValue; ; var getLast_2 = getSheet.GetRow(getLastRow); apply.mng_name = getLast_2.Cells[1].StringCellValue; apply.mng_gender = true; apply.mng_rank = getLast_2.Cells[3].StringCellValue; apply.mng_tel = getLast_2.Cells[5].StringCellValue; apply.y = Convert.ToInt16(getYear); apply.start_date = DateTime.Parse(getYear + "/01/01"); apply.end_date = DateTime.Parse(getYear + "/12/31"); apply.i_InsertDateTime = DateTime.Now; apply.userid = this.UserId; apply.Apply_Detail_Condenser = new List<Apply_Detail_Condenser>(); apply.Apply_Detail_Evaporate = new List<Apply_Detail_Evaporate>(); } else {//存在就修改資料 apply_id = db0.Apply.SingleOrDefault(x => x.y == getYear && x.userid == this.UserId).apply_id;//取得id //apply = await db0.Apply.FindAsync(apply_id); var getLast_1 = getSheet.GetRow(getLastRow - 1); apply.doc_name = getLast_1.Cells[1].StringCellValue; apply.doc_gender = true; apply.doc_rank = getLast_1.Cells[3].StringCellValue; ; apply.doc_tel = getLast_1.Cells[5].StringCellValue; ; var getLast_2 = getSheet.GetRow(getLastRow); apply.mng_name = getLast_2.Cells[1].StringCellValue; apply.mng_gender = true; apply.mng_rank = getLast_2.Cells[3].StringCellValue; apply.mng_tel = getLast_2.Cells[5].StringCellValue; apply.i_UpdateDateTime = DateTime.Now; } int equiCount = db0.Equipment_Chiller.Where(x => x.USERID == this.UserId).Count();//計算該廠商有幾筆設備 for (int i = 0; i < equiCount; i++) { //int monthstart = 0;//起始一月行數 IRow getRow = getSheet.GetRow(startRow); ICell getCell = getRow.Cells[0]; //取得設備編號 string getEquipmentSN = getRow.Cells[0].StringCellValue; var checkEquip = db0.Equipment_Chiller.Where(x => x.equipment_sn == getEquipmentSN && x.USERID == this.UserId).Select(x => new { x.equipment_chiller_id, x.equipment_sn }).FirstOrDefault(); if (checkEquip == null) { rAjaxResult.result = false; rAjaxResult.message = "此設備編號不存在:" + getEquipmentSN; return defJSON(rAjaxResult); } //判斷設備是否已申請過 int getEquid = checkEquip.equipment_chiller_id;//取得設備id Boolean checkDetail = db0.Apply_Detail_Evaporate.Any(x => x.equipment_id == getEquid && x.y == getYear && x.userid == this.UserId); if (checkDetail) { rAjaxResult.result = false; rAjaxResult.message = "此設備編號已存在:" + getEquipmentSN + ",請點選刪除後再重新上傳"; return defJSON(rAjaxResult); } decimal get設計值 = (decimal)getRow.Cells[1].NumericCellValue; string[] getAbnormal = new string[12];//異常狀況陣列 decimal[] getTd_value = new decimal[12]; //每月資料填入 for (int j = 0; j < 12; j++) { getRow = getSheet.GetRow(startRow); getTd_value[j] = (decimal)getRow.Cells[3].NumericCellValue; getAbnormal[j] = getRow.Cells[4].StringCellValue; startRow += 1; } Apply_Detail_Evaporate makeEvaporateDetail = new Apply_Detail_Evaporate() { apply_detail_evaporate_id = GetNewId(ProcCore.Business.CodeTable.Apply_Detail_Evaporate), apply_id = apply_id, equipment_id = checkEquip.equipment_chiller_id, equipment_sn = checkEquip.equipment_sn, td_set = get設計值, abnormal_01 = getAbnormal[0], abnormal_02 = getAbnormal[1], abnormal_03 = getAbnormal[2], abnormal_04 = getAbnormal[3], abnormal_05 = getAbnormal[4], abnormal_06 = getAbnormal[5], abnormal_07 = getAbnormal[6], abnormal_08 = getAbnormal[7], abnormal_09 = getAbnormal[8], abnormal_10 = getAbnormal[9], abnormal_11 = getAbnormal[10], abnormal_12 = getAbnormal[11], td_value_01 = getTd_value[0], td_value_02 = getTd_value[1], td_value_03 = getTd_value[2], td_value_04 = getTd_value[3], td_value_05 = getTd_value[4], td_value_06 = getTd_value[5], td_value_07 = getTd_value[6], td_value_08 = getTd_value[7], td_value_09 = getTd_value[8], td_value_10 = getTd_value[9], td_value_11 = getTd_value[10], td_value_12 = getTd_value[11], i_InsertDateTime = DateTime.Now, y = Convert.ToInt16(getYear), userid = this.UserId }; apply.Apply_Detail_Evaporate.Add(makeEvaporateDetail); } if (!isExist) { db0.Apply.Add(apply); } // await db0.SaveChangesAsync(); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = file.FileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = ex.Message + ex.StackTrace; } finally { db0.Dispose(); } #endregion return defJSON(rAjaxResult); }
public string aj_excelEquipmentUploadForTest(HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); dicEquipmentIsNew = new Dictionary<string, bool>(); dicEquipmentIsNew.Add("即設", false); dicEquipmentIsNew.Add("新設", true); #region string tpl_File = string.Empty; HSSFWorkbook wbXLS; try { db0 = getDB0(); wbXLS = new HSSFWorkbook(file.InputStream); ISheet getSheet = wbXLS.GetSheet("設備表"); var getUserId = GetCellValueString(getSheet, "E3"); if (getUserId != this.UserId) { rAjaxResult.result = false; rAjaxResult.message = "User Id驗證不符"; return defJSON(rAjaxResult); } int startRow = 5; int getLastRow = getSheet.LastRowNum; var getEquipments = db0.Equipment_Chiller.Where(x => x.USERID == this.UserId).ToList(); //匯入之前要先移除設備資料 已在申報中的不移除 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(); for (var i = startRow; i <= getLastRow; i++) { IRow getRow = getSheet.GetRow(i); Equipment_Chiller getImportData = SetEquipmentImportData(getRow); if (getImportData != null) { var isExist = db0.Equipment_Chiller.Any(x => x.equipment_sn == getImportData.equipment_sn); if (!isExist) { db0.Equipment_Chiller.Add(getImportData); } } } //await db0.SaveChangesAsync(); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = file.FileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = ex.Message + ex.StackTrace; } finally { db0.Dispose(); } #endregion return defJSON(rAjaxResult); }
public async Task<string> aj_excelEquipmentUpload(HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); dicEquipmentIsNew = new Dictionary<string, bool>(); dicEquipmentIsNew.Add("即設", false); dicEquipmentIsNew.Add("新設", true); var fileName = "Manager-" + this.UserId + "-設備-" + DateTime.Now.ToString("yyyyMMddHHmm") + ".xls"; var path = Path.Combine(Server.MapPath("~/_Code/SysUpFiles/ExcelUpLoadData/Equi"), fileName); file.SaveAs(path); string successMessage = string.Empty; int countSuccessImport = 0; List<Equipment_Chiller> excelEquipment = new List<Equipment_Chiller>(); #region string tpl_File = string.Empty; HSSFWorkbook wbXLS; try { db0 = getDB0(); wbXLS = new HSSFWorkbook(file.InputStream); ISheet getSheet = wbXLS.GetSheet("設備表"); var getUserId = GetCellValueString(getSheet, "E3"); if (getUserId != this.UserId) { rAjaxResult.result = false; rAjaxResult.message = "User Id驗證不符"; return defJSON(rAjaxResult); } int startRow = 5; int getLastRow = getSheet.LastRowNum; 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 for (var i = startRow; i <= getLastRow; i++) { IRow getRow = getSheet.GetRow(i); Equipment_Chiller getImportData = null; try { if (getCellValue(getRow, 1) == "" && getCellValue(getRow, 2) == "" && getCellValue(getRow, 3) == "" && getCellValue(getRow, 4) == "") {//欄位都空白就略過 } else if (getCellValue(getRow, 1) == "" || getCellValue(getRow, 2) == "" || getCellValue(getRow, 3) == "" || getCellValue(getRow, 4) == "") {//其中一個直空白不匯入,彈出錯誤訊息告知他資料填寫不完整 rAjaxResult.result = false; rAjaxResult.message = "Excel檔案第" + (i + 1) + "列設備資料填寫不完整!"; return defJSON(rAjaxResult); } getImportData = SetEquipmentImportData(getRow); } catch { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = "Excel檔案第" + (i + 1) + "列資料型態錯誤!"; return defJSON(rAjaxResult); } if (getImportData != null) { var isExist = db0.Equipment_Chiller.Any(x => x.equipment_sn == getImportData.equipment_sn && x.USERID == getImportData.USERID); var isExcelExist = excelEquipment.Any(x => x.equipment_sn == getImportData.equipment_sn && x.USERID == getImportData.USERID); if (!isExist && !isExcelExist) { if (getImportData.equipment_sn.Length > 20) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = "Excel檔案第" + (i + 1) + "列設備編號長度超過20字!"; return defJSON(rAjaxResult); } db0.Equipment_Chiller.Add(getImportData); excelEquipment.Add(getImportData); countSuccessImport += 1; } else { if (isExist) { rAjaxResult.message = "Excel檔案第" + (i + 1) + "列設備編號已存在,請勿重複匯入!"; } else { rAjaxResult.message = "Excel檔案第" + (i + 1) + "列,在Excel檔內與其他設備編號重複!"; } rAjaxResult.result = false; return defJSON(rAjaxResult); } } } await db0.SaveChangesAsync(); successMessage = successMessage + "共" + countSuccessImport + "筆資料匯入成功!"; rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = file.FileName; rAjaxResult.message = successMessage; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; //rAjaxResult.message = getRecMessage(ex.Message); rAjaxResult.message = getRecMessage("excel檔案格式錯誤"); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; //rAjaxResult.message = ex.Message + ex.StackTrace; rAjaxResult.message = getRecMessage("excel檔案格式錯誤"); } finally { db0.Dispose(); } #endregion return defJSON(rAjaxResult); }
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); }
public async Task<string> aj_excelMonthUpload(HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region string tpl_File = string.Empty; HSSFWorkbook wbXLS; try { #region MyRegion db0 = getDB0(); wbXLS = new HSSFWorkbook(file.InputStream); ISheet getSheet = wbXLS.GetSheet("每月監控平均值"); var getUserId = GetCellValueString(getSheet, "E3"); if (getUserId != this.UserId) { rAjaxResult.result = false; rAjaxResult.message = "User Id驗證不符"; return defJSON(rAjaxResult); } double getYear = GetCellValueInt(getSheet, "C4"); if (getYear > allowApplyYear) { rAjaxResult.message = string.Format("{0}年度不充許申報!", getYear); rAjaxResult.result = false; return defJSON(rAjaxResult); } var isExist = db0.Apply_Detail_Condenser.Any(x => x.y == getYear); if (isExist) { rAjaxResult.message = string.Format("{0}年度資料已存在無法新增!", getYear); rAjaxResult.result = false; return defJSON(rAjaxResult); } int startRow = 7; int getLastRow = getSheet.LastRowNum; var getEquipments = db0.Equipment_Chiller.Where(x => x.USERID == this.UserId).ToList(); for (int i = startRow; i < getLastRow; i++) { #region MyRegion var getRow = getSheet.GetRow(i); var getEquip = getRow.Cells[1]; if (getEquip.StringCellValue != "") { var getEquipment = getEquipments.Where(x => x.equipment_sn == getEquip.StringCellValue).FirstOrDefault(); if (getEquipment != null) { var md = new Apply_Detail_Condenser() { y = Convert.ToInt16(getYear), userid = this.UserId, apply_detail_condenser_id = GetNewId(ProcCore.Business.CodeTable.Apply_MonthAverage), equipment_id = getEquipment.equipment_chiller_id, td_value_01 = (decimal)getRow.Cells[3].NumericCellValue, td_value_02 = (decimal)getRow.Cells[4].NumericCellValue, td_value_03 = (decimal)getRow.Cells[5].NumericCellValue, td_value_04 = (decimal)getRow.Cells[6].NumericCellValue, td_value_05 = (decimal)getRow.Cells[7].NumericCellValue, td_value_06 = (decimal)getRow.Cells[8].NumericCellValue, td_value_07 = (decimal)getRow.Cells[9].NumericCellValue, td_value_08 = (decimal)getRow.Cells[10].NumericCellValue, td_value_09 = (decimal)getRow.Cells[11].NumericCellValue, td_value_10 = (decimal)getRow.Cells[12].NumericCellValue, td_value_11 = (decimal)getRow.Cells[13].NumericCellValue, td_value_12 = (decimal)getRow.Cells[14].NumericCellValue, abnormal_01 = getRow.Cells[16].StringCellValue, abnormal_02 = getRow.Cells[17].StringCellValue, abnormal_03 = getRow.Cells[18].StringCellValue, abnormal_04 = getRow.Cells[19].StringCellValue, abnormal_05 = getRow.Cells[20].StringCellValue, abnormal_06 = getRow.Cells[21].StringCellValue, abnormal_07 = getRow.Cells[22].StringCellValue, abnormal_08 = getRow.Cells[23].StringCellValue, abnormal_09 = getRow.Cells[24].StringCellValue, abnormal_10 = getRow.Cells[25].StringCellValue, abnormal_11 = getRow.Cells[26].StringCellValue, abnormal_12 = getRow.Cells[27].StringCellValue, i_InsertDateTime = DateTime.Now }; db0.Apply_Detail_Condenser.Add(md); } } #endregion } #endregion await db0.SaveChangesAsync(); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = file.FileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.message = ex.Message + ex.StackTrace; } finally { db0.Dispose(); } #endregion return defJSON(rAjaxResult); }
public string aj_loadingFileUpload(string userid, int y, HttpPostedFileBase file) { ReturnAjaxFiles rAjaxResult = new ReturnAjaxFiles(); #region try { if (file.ContentLength > (5 * 1024 * 1024)) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = "檔案超過5MB"; } string uid = string.Empty; if (this.UserId != null && this.UserId != "") { uid = this.UserId; } else { uid = userid; } string fileName = uid + "-冰水機負載調控申報-" + DateTime.Now.ToString("yyyyMMddHHmm") + "-" + file.FileName; string pathTpl = string.Format("~/_Code/SysUpFiles/Apply.Loading/{0}/{1}", y, uid); string serverPath = Server.MapPath(pathTpl); if (!Directory.Exists(serverPath)) Directory.CreateDirectory(serverPath); string path = Path.Combine(serverPath, fileName); //只能有一筆 所先刪除 string[] filePaths = Directory.GetFiles(serverPath); foreach (string filePath in filePaths) System.IO.File.Delete(filePath); file.SaveAs(path); rAjaxResult.result = true; rAjaxResult.success = true; rAjaxResult.FileName = file.FileName; } catch (LogicError ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = getRecMessage(ex.Message); } catch (Exception ex) { rAjaxResult.result = false; rAjaxResult.success = false; rAjaxResult.error = ex.Message; } #endregion return defJSON(rAjaxResult); }