/// <summary> /// 表格导出 /// </summary> private void TableExport() { string errmsg = ""; string urltype = Request["urltype"]; //请求类型,IIS,Tomcat string pageurl = Request["pageurl"]; //代码 string data = Request["data"]; //数据 string filename = Request["filename"]; //文件名 ResultInfo outjson = new ResultInfo(); if (Session["userinfo"] != null) { UserInfo userinfo = new UserInfo(); userinfo = (UserInfo)Session["userinfo"]; string usercode = userinfo.usercode; bool result = true; string json = ""; #region 获取表格要导出的字段 BLLRequestData mybll = new BLLRequestData(); result = mybll.RequestIISData("/Console/TableSetting.aspx?action=gettableconfiglist", usercode, data, ref json, ref errmsg); ResultTableFieldListInfo[] 表格字段列表 = null; if (result) { ResultTableList tblist = ObjectSeriallizeHelper.JsonToObject <ResultTableList>(json); if (tblist != null && tblist.data != null && tblist.data.Length > 0) { ResultTableListInfo[] 表格列表 = tblist.data; for (int i = 0; i < 表格列表.Length; i++) { if (表格列表[i].页面url.Trim() == pageurl.Trim()) { GetTableFieldInfo finfo = new GetTableFieldInfo(); finfo.usercode = usercode; finfo.tbcode = 表格列表[i].表格代码; result = mybll.RequestIISData("/Console/TableSetting.aspx?action=getusertablefieldinfolist", usercode, ObjectSeriallizeHelper.ObjectToJson(finfo), ref json, ref errmsg); if (result) { ResultTableFieldList rfl = ObjectSeriallizeHelper.JsonToObject <ResultTableFieldList>(json); if (rfl != null && rfl.data != null && rfl.data.Length > 0) { 表格字段列表 = rfl.data; } } } } } } #endregion switch (pageurl) { case "MaterialQSApi.aspx?action=closeoraclematerialqs": //关闭Oracle数据库的物料齐套 RequestMaterialQSCR rq = ObjectSeriallizeHelper.JsonToObject <RequestMaterialQSCR>(data); rq.usercode = userinfo.usercode; data = ObjectSeriallizeHelper.ObjectToJson(rq); break; } switch (urltype) { case "IIS": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIISData(pageurl, userinfo.usercode, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3676": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3676Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3380": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3380Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3382": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3382Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3738": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3738Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "Tomcat": break; default: result = false; outjson.errcode = -1; outjson.errmsg = "请求出错,未找到对应服务器"; break; } if (result) { try { ExcelTable obj = ObjectSeriallizeHelper.JsonToObject <ExcelTable>(json); string str_data = ObjectSeriallizeHelper.ObjectToJson(obj.data); DataTable dt = ObjectSeriallizeHelper.JsonToDataTable(str_data); DataTable 导出表格 = new DataTable(); if (表格字段列表 != null && 表格字段列表.Length > 0) { for (int i = 0; i < 表格字段列表.Length; i++) { if (表格字段列表[i].是否显示 == "1" && 表格字段列表[i].字段名 != "操作") { for (int j = 0; j < dt.Columns.Count; j++) { if (dt.Columns[j].ToString().ToLower().Trim() == 表格字段列表[i].字段名.ToLower().Trim()) { 导出表格.Columns.Add(表格字段列表[i].别名, Type.GetType("System.String")); } } } } for (int i = 0; i < dt.Rows.Count; i++) { DataRow newRow; newRow = 导出表格.NewRow(); for (int j = 0; j < 表格字段列表.Length; j++) { if (表格字段列表[j].是否显示 == "1" && 表格字段列表[j].字段名 != "操作") { string 字段名 = 表格字段列表[j].字段名.ToLower(); try { newRow[表格字段列表[j].别名] = dt.Rows[i][字段名].ToString(); } catch { } } } 导出表格.Rows.Add(newRow); } CreateExcel(导出表格, filename); } else { CreateExcel(dt, filename); } } catch (Exception ex) { errmsg = ex.Message.ToString(); result = false; outjson.errcode = -1; outjson.errmsg = errmsg; } if (!result) { Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } } else { Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } } else { outjson.errcode = -1; outjson.errmsg = "登录信息已过期,请重新登录"; Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } }
/// <summary> /// 请求数据 /// </summary> private void RequestData() { string errmsg = ""; string urltype = Request["urltype"]; //请求类型,IIS,Tomcat string pageurl = Request["pageurl"]; //代码 string data = Request["data"]; //数据 ResultInfo outjson = new ResultInfo(); if (Session["userinfo"] != null) { UserInfo userinfo = new UserInfo(); userinfo = (UserInfo)Session["userinfo"]; switch (pageurl) { case "MaterialQSApi.aspx?action=closeoraclematerialqs": //关闭Oracle数据库的物料齐套 RequestMaterialQSCR rq = ObjectSeriallizeHelper.JsonToObject <RequestMaterialQSCR>(data); rq.usercode = userinfo.usercode; data = ObjectSeriallizeHelper.ObjectToJson(rq); break; } BLLRequestData mybll = new BLLRequestData(); bool result = true; string json = ""; switch (urltype) { case "IIS": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIISData(pageurl, userinfo.usercode, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3676": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3676Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3380": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3380Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3382": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3382Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3738": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3738Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "Tomcat": break; default: result = false; outjson.errcode = -1; outjson.errmsg = "请求出错,未找到对应服务器"; break; } if (result) { Response.Write(json); Response.End(); } else { Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } } else { outjson.errcode = -1; outjson.errmsg = "登录信息已过期,请重新登录"; Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } }
/// <summary> /// 表格导入 /// </summary> private void TableImport() { Response.ContentType = "text/html"; string errmsg = ""; string urltype = Request["urltype"]; //请求类型,IIS,Tomcat string pageurl = Request["pageurl"]; //代码 string data = ""; //数据 ResultInfo outjson = new ResultInfo(); DataTable dt = new DataTable(); string path = HttpRuntime.AppDomainAppPath.ToString(); if (System.Web.HttpContext.Current.Request.Files.Count == 0) { errmsg = "未选择文件"; outjson.errcode = -1; outjson.errmsg = errmsg; Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } else { System.IO.Stream stream = System.Web.HttpContext.Current.Request.Files[0].InputStream; bool result = DataHelp.ExcelFileStreamToDataTable(path, stream, ref dt, ref errmsg); if (result) { data = ObjectSeriallizeHelper.DataTableToJson(dt, ObjectSeriallizeHelper.ColumnNameLetterCase.Original); if (Session["userinfo"] != null) { UserInfo userinfo = new UserInfo(); userinfo = (UserInfo)Session["userinfo"]; BLLRequestData mybll = new BLLRequestData(); string json = ""; switch (urltype) { case "IIS": data = data.Replace("", ""); data = data.Replace(" ", ""); data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIISData(pageurl, userinfo.usercode, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3676": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3676Data(pageurl, data, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "IIS3380": data = data.Replace("\"usercode\":\"\"", "\"usercode\": \"" + userinfo.usercode + "\""); data = data.Replace("\"operation_usercode\":\"\"", "\"operation_usercode\": \"" + userinfo.usercode + "\""); result = mybll.RequestIIS3380Data(pageurl, data, userinfo.usercode, ref json, ref errmsg); if (!result) { outjson.errcode = -1; outjson.errmsg = errmsg; } break; case "Tomcat": break; default: result = false; outjson.errcode = -1; outjson.errmsg = "请求出错,未找到对应服务器"; break; } if (result) { Response.Write(json); Response.End(); } else { Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } } else { outjson.errcode = -1; outjson.errmsg = "登录信息已过期,请重新登录"; Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } } else { outjson.errcode = -1; outjson.errmsg = errmsg; Response.Write(ObjectSeriallizeHelper.ObjectToJson(outjson)); Response.End(); } } }