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" })); }