/// <summary> /// 登录页面取公司(erp系统)列表 /// </summary> public void GetCompany() { string jsonstr = ""; List <MDataRow> RowList = new List <MDataRow>(); int cmpLength = Convert.ToInt32(ConfigurationManager.AppSettings["cmpLength"]); for (int i = 1; i <= cmpLength; i++) { MDataRow MRow = new MDataRow(); MRow.Add("value", ConfigurationManager.AppSettings.Keys[i].ToString().ToLower()); MRow.Add("text", ConfigurationManager.AppSettings[i].ToString().ToLower()); jsonstr += MRow.ToJson() + ","; } jsonstr = "[" + jsonstr.Substring(0, jsonstr.Length - 1).Replace("[", "\"[").Replace("]", "]\"") + "]"; jsonResult = jsonstr; }
/// <summary> /// 从工作表中获取数据,转成DataTable /// </summary> /// <param name="sheet"></param> /// <param name="errorMsgList"></param> /// <param name="colNames"></param> /// <returns></returns> public static MDataTable GetFrom(ISheet sheet, out List <string> errorMsgList, string[] colNames = null) { errorMsgList = new List <string>(); var dataTable = new MDataTable(); int rowCount = sheet.LastRowNum; if (rowCount <= 0) { errorMsgList.Add("没有数据,请检查"); return(null); } var shtColName = sheet.GetRow(0); int colCount = 0; while (shtColName.GetCell(colCount) != null && shtColName.GetCell(colCount).StringCellValue != "") { colCount++; } for (int i = 0; i < colCount; i++) { dataTable.Columns.Add(i.ToString()); } for (int i = 1; i < rowCount + 1; i++) { var shtRow = sheet.GetRow(i); var dataRow = new MDataRow(); // new object[rowCount]; for (var j = 0; j < colCount; j++) { var value = GetCellValue(shtRow.GetCell(j)); if (value == null) { errorMsgList.Add($"第 {i + 1} 行 第{j + 1}列 为公式,请修改。"); } dataRow.Add(j.ToString(), value); //dataRow[j] = shtRow.GetCell(j); } dataTable.Rows.Add(dataRow.GetItemValues()); } SetDataTableColName(dataTable, shtColName, colNames, colCount); return(dataTable); }