//public DataSet ExecleDs(string filenameurl, string table) //{ // try //如果存在問題 比如說隨便輸入一個execl檔 // { // string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'"; // OleDbConnection conn = new OleDbConnection(strConn); // conn.Open(); // DataSet ds = new DataSet(); // string tablename = "象印"; // //這裡表可能是漢字.解決方法("select * from ["+ tablename+"$]") // OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + tablename + "$]", conn); // //OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn); // odda.Fill(ds, table); // return ds; // } // catch(Exception ex) // { // DataSet dsSet = new DataSet(); // DataTable dtTable = new DataTable(); // dtTable = dsSet.Tables.Add(); // return dsSet; // } //} #endregion public HttpResponseBase InsertBoilerMessage() { int j = 0; string json = string.Empty;//json字符串 int total=0; try { if (Request.Files["ImportFileMsg"] != null && Request.Files["ImportFileMsg"].ContentLength > 0)//判斷文件是否為空 { HttpPostedFileBase excelFile = Request.Files["ImportFileMsg"];//獲取文件流 FileManagement fileManagement = new FileManagement();//實例化 FileManagement //string fileLastName = excelFile.FileName.Substring((excelFile.FileName).LastIndexOf('.')).ToLower().Trim(); string fileLastName = excelFile.FileName; string newExcelName = Server.MapPath(excelPath) + "BoilerRelation" + fileManagement.NewFileName(excelFile.FileName);//處理文件名,獲取新的文件名 excelFile.SaveAs(newExcelName);//上傳文件 DataTable dt = new DataTable(); NPOI4ExcelHelper helper = new NPOI4ExcelHelper(newExcelName); dt = helper.SheetData(); //DataSet ds = ExecleDs(newExcelName, fileLastName);//调用自定义方法 ////excelHelper = new NPOI4ExcelHelper(newExcelName); DataRow[] dr = dt.Select(); //定义一个DataRow数组,读取ds里面所有行 int rowsnum = dt.Rows.Count; if(rowsnum !=0)//判斷是否是這個表 { if (dr[0][2].ToString().Trim() != "外鍋型號 (依款式&字母順序排列)" && dr[0][3].ToString().Trim() != "內鍋型號" && dr[0][4].ToString().Trim() != "對應安康內鍋型號" && dr[0][5].ToString().Trim() != "備註") { rowsnum = 0; } } if (rowsnum == 0) { json = "{success:true,total:0,msg:\"" + "此表內沒有數據或數據有誤,請檢查后再次匯入!" + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } else { _boillationMgr = new BoilerrelationMgr(mySqlConnectionString); j = _boillationMgr.GetintoBoilerrelation(dr,out total); if (j > 0) { json = "{success:true,total:\"" + total + "\",msg:\"" + "匯入安康內鍋型號對照表成功!" + "\"}"; } else { json = "{success:true,total:\"" + total + "\",msg:\"" + "匯入數據標準不對,請嚴格按照模板匯入!" + "\"}"; } } } else//當直接點擊時會產生, { json = "{success:true,msg:\"" + "請匯入安康內鍋型號對照表" + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:\"" + ex.ToString() + "\"}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetBoilerRelationList() { List<boilerrelationQuery> store = new List<boilerrelationQuery>(); string json = string.Empty; try { boilerrelationQuery query = new boilerrelationQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } if (!string.IsNullOrEmpty(Request.Params["boiler_type_describe"])) { query.Boiler_type_describe = Request.Params["boiler_type_describe"].Trim(); } if (!string.IsNullOrEmpty(Request.Params["out_boiler_type"])) { query.out_boiler_number = Request.Params["out_boiler_type"].Trim(); } if (!string.IsNullOrEmpty(Request.Params["innner_boiler_type"])) { query.inner_boiler_number = Request.Params["innner_boiler_type"].Trim(); } _boillationMgr = new BoilerrelationMgr(mySqlConnectionString); int totalCount = 0; store = _boillationMgr.QueryBoilerRelationAll(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + ",}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }