Exemple #1
0
        public void CreateReport(HttpContext context)
        {
            RP_Report report = new RP_Report()
            {
                Title       = context.Request["title"],
                SubTitle    = context.Request["subTitle"],
                bgfl        = ConvertInt32(context.Request["bgfl"]),
                ztfl        = context.Request["ztfl"],
                KeyWords    = context.Request["keyword"],
                Abstract    = context.Request["abstract"],
                Directory   = context.Request["directory"],
                Content     = context.Request["content"],
                Status      = (int)ReportStatus.NotAudit,
                FileName    = context.Request["fileName"],
                FilePath    = context.Request["filePath"],
                FilePage    = ConvertInt32(context.Request["filePage"]),
                zdgzfl      = context.Request["zdgz"],
                hyfl        = context.Request["hyfl"],
                Level       = ConvertInt32(context.Request["level"]),
                Author      = context.Request["author"],
                Company     = context.Request["company"],
                Source      = context.Request["source"],
                Language    = context.Request["language"],
                Country     = context.Request["country"],
                Area        = context.Request["area"],
                IsMain      = ConvertBoolen(context.Request["zdbg"]),
                PublishDate = ConvertDateTime(context.Request["publishDate"]),
                CreateBy    = "Session",
                CreateDate  = DateTime.Now,
            };

            db.Report.Add(report);
        }
        public IHttpActionResult ResourceInfoToReport()
        {
            int count = db.resource_info.Where(en => en.old == 0).Count();

            try
            {
                while (count / 100 > 0)
                {
                    var iReport = db.resource_info.Where(en => en.old == 0).Take(100).ToList();
                    iReport.ForEach(item =>
                    {
                        RP_Report rpt   = new RP_Report();
                        rpt.Title       = CheckLength(item.x_title, 200);
                        rpt.SubTitle    = CheckLength(item.x_subtitle, 200);
                        rpt.WebTitle    = CheckLength(item.x_webtitle, 2000);
                        rpt.KeyWords    = CheckLength(item.x_keywords, 400);
                        rpt.Abstract    = CheckLength(item.x_remark, 4000);
                        rpt.Directory   = CheckLength(item.x_directory, 4000);
                        rpt.Content     = CheckLength(item.x_content, 4000);
                        rpt.Status      = ConvertStatus(item.x_verifystate);
                        rpt.FileName    = CheckLength(item.x_file, 100);
                        rpt.FilePage    = item.x_page;
                        rpt.bgfl        = ConvertBgfl(item.x_reportId);
                        rpt.ztfl        = ConvertZtfl(item.x_zhongtuId);
                        rpt.zdgzfl      = ConvertZdgz(item.x_watchId);
                        rpt.hyfl        = ConvertHyfl(item.rec_id);
                        rpt.Level       = item.x_level;
                        rpt.Author      = CheckLength(item.x_author, 200);
                        rpt.Company     = CheckLength(item.x_company, 200);
                        rpt.Source      = CheckLength(item.x_infosource, 200);
                        rpt.Language    = CheckLength(item.x_language, 50);
                        rpt.Country     = CheckLength(item.x_country, 50);
                        rpt.Area        = CheckLength(item.x_area, 50);
                        rpt.IsMain      = item.is_main;
                        rpt.PublishDate = item.x_publishdate;
                        rpt.CreateBy    = ConvertUser(item.x_manager);
                        rpt.CreateDate  = item.create_date;
                        rpt.docmain_id  = item.docmain_id;
                        rpt.rec_id      = item.rec_id;

                        db.Report.Add(rpt);

                        item.old             = 1;
                        db.Entry(item).State = System.Data.Entity.EntityState.Modified;
                    });
                    db.SaveChanges();
                    count -= 100;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(Json <dynamic>(new { result = count, sucess = "successed" }));
        }