コード例 #1
0
        /// <summary>
        /// 导入逻辑
        /// </summary>
        /// <param name="context"></param>
        public void ProcessRequest(HttpContext context)
        {
            try
            {
                var service = new ImportService();
                var rSvr    = new EARuleService();
                var newsvr  = new ImportService();
                context.Response.ContentType = "text/plain";
                var    ruleid   = context.Request.Form.Get("ruleid");
                var    ruleInfo = rSvr.GetRuleInfo(ruleid);
                var    op       = context.Request.Form.Get("op");
                var    data     = context.Request.Form.Get("data");
                object res      = "";
                var    tips     = "";
                switch (op)
                {
                case "BeginUpload":    //开始上传从中间表---正式表
                    var delData = context.Request.Form.Get("rdata");

                    service.UploadData(ruleInfo, data, delData, (string mes) =>
                    {
                    }, (string mes) =>
                    {
                        throw new Exception(mes);
                    }, (string mes) =>
                    {
                        res = mes;
                    }, out tips);
                    break;

                case "UploadDataRef":    //上传关联表
                    var delData1 = context.Request.Form.Get("rdata");

                    service.UploadDataRef(ruleInfo, data, delData1, (string mes) =>
                    {
                    }, (string mes) =>
                    {
                        throw new Exception(mes);
                    }, (string mes) =>
                    {
                        res = mes;
                    });
                    break;

                case "CancelUpload":    //取消上传中间表
                    service.CancelUpload(ruleInfo, data, (string mes) =>
                    {
                        res = mes;
                    }, (string mes) =>
                    {
                        throw new Exception(mes);
                    }, (string mes) =>
                    {
                        res = mes;
                    });
                    break;

                case "RefreshData":    //刷新界面
                    res = newsvr.GetDBData(ruleInfo);
                    break;

                case "LoadExcelData":    //导入本地excelk导入
                    var list    = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ExportModel> >(context.Request.Form.Get("tmpdata"));
                    var mapdata = GetDataMap(ruleInfo, list);

                    res = newsvr.ImportTmpTable(mapdata, ruleInfo, out tips);
                    break;

                case "LoadExcelDataLocal":    //导入本地数据源

                    res = newsvr.ImportTmpTable(Newtonsoft.Json.JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(context.Request.Form.Get("tmpdata")), ruleInfo, out tips);
                    break;

                case "loadExcelDataNew":    //导入关联表
                {
                    var list1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ExportModel> >(context.Request.Form.Get("tmpdata"));
                    res = newsvr.ImportTmpTableREF(list1[0].dt, ruleInfo);
                }

                break;

                case "removeRef":    //删除引用
                {
                    var date = context.Request.Form.Get("date");
                    res = newsvr.RemoveDate(ruleInfo, date);
                }

                break;

                case "deleteRow":    //删除上传行数据
                {
                    var ids = context.Request.Form.Get("ids");
                    res = newsvr.DeleteUpload(ruleInfo, ids);
                }

                break;

                case "Custom":    //自定义按钮点击
                    service.CustomDealData(data, ruleInfo, (string mes) =>
                    {
                        res = mes;
                    }, (string mes) =>
                    {
                        throw new Exception(mes);
                    }, (string mes) =>
                    {
                        res = mes;
                    });
                    break;



                default:
                    break;
                }
                context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { res = true, data = res, tips = tips }));
            }
            catch (Exception ex)
            {
                var mes = Regex.Replace(ex.Message, @"[\u4e00-\u9fa5]", ""); //去除汉字


                var mes2 = Regex.Replace(ex.Message, @"[^\u4e00-\u9fa5]", ""); //只留汉字



                context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { res = false, msg = ex.Message, stack = ex.StackTrace }));
            }
        }