public ActionResult Index() { return(ActionResultHelper.TryCatchWithLogger(() => { PreservationVerifyIndexModel model = new PreservationVerifyIndexModel(); CustomerCompanyViewModel customerCompany = Session["idCompany"] as CustomerCompanyViewModel; if (WCFUtility.GetSettingValue("DBAdminLoginConnection") == "false") { DocumentCondition conditions = new DocumentCondition(); List <DocumentSortCondition> sortConditions = new List <DocumentSortCondition>(); conditions.DocumentAttributeConditions = new System.ComponentModel.BindingList <DocumentCondition>(); conditions.DocumentAttributeConditions.Add(new DocumentCondition() { Name = "IsLegal", Value = 1, Operator = Library.Common.Enums.DocumentConditionFilterOperator.IsEqualTo, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); sortConditions.Add(new DocumentSortCondition { Name = "Name", Dir = "ASC" }); model.archives = ArchiveService.GetArchives(0, int.MaxValue, conditions, sortConditions, out int total, customerCompany.CompanyId).ToList(); } else { model.archives = UserArchive.GetUserArchivesPaged(User.Identity.Name, 0, int.MaxValue, out int total, customerCompany.CompanyId); } return View(model); }, _loggerService)); }
public ActionResult ReadTasks(Guid id, [DataSourceRequest] DataSourceRequest request) { var result = new DataSourceResult(); try { DocumentCondition conditions = new DocumentCondition(); List <DocumentSortCondition> sortConditions = new List <DocumentSortCondition>(); conditions.DocumentAttributeConditions = new System.ComponentModel.BindingList <DocumentCondition>(); conditions.DocumentAttributeConditions.Add(new DocumentCondition() { Name = "IsLegal", Value = 1, Operator = Library.Common.Enums.DocumentConditionFilterOperator.IsEqualTo, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); if (request.Filters != null) { foreach (var item in request.Filters) { //conditions.DocumentAttributeConditions.Add(new DocumentCondition { Name = item., Value = item.Value, Operator = Library.Common.Enums.DocumentConditionFilterOperator.Contains, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); } } if (request.Sorts != null) { foreach (var item in request.Sorts) { sortConditions.Add(new DocumentSortCondition { Name = item.Member, Dir = item.SortDirection }); } } else { sortConditions.Add(new DocumentSortCondition { Name = "Name", Dir = "ASC" }); } var query = new PreservationService().GetPreservationTasks(new System.ComponentModel.BindingList <DocumentArchive> { new DocumentArchive(id) }, (request.Page - 1) * request.PageSize, request.PageSize); result.Total = (int)query.TotalRecords; result.Data = query.Tasks; } catch (Exception ex) { result.Errors = ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public static int CreateDocument(DogTable.Record dogRecord) { var undog = dogRecord.Undog; //var dgt = Cursor.GetFieldValue<string>("KDGT"); var dgt = (dogRecord.Undog_pr == 0) ? dogRecord.Kdgt : DogTable.GetRecord(dogRecord.Undog_pr, new String[] { "KDGT" }).Kdgt; //var dogstatus = Cursor.GetFieldValue<string>("KDGD"); //var docType = SqlClient.Main.CreateCommand("select KDMT from DOGC_ where KDGT = @KDGT and KDGD = @KDGD", // new SqlParam("KDGT", dgt), // new SqlParam("KDGD", dogstatus)).ExecScalar<string>(); //var docType = SqlClient.Main.CreateCommand(@"select PROTTYPE_ from dgt wher"); var docType = DgtTable.GetRecord(dgt, new[] { "PROTTYPE_" }).GetFieldValue <string>("PROTTYPE_").Split(',').FirstOrDefault(); //Формирование документа var document = new Document(); document.FillDocConfig(docType); document.ContractorCode = dogRecord.Org; document.ContractCode = undog; document.Status = DocStatus.Project; //Добавление документа в SQL var docRepo = new HeadersRepository(); docRepo.Add(document); //Установка документа на 1ю стадию var dmz = new DataEditor.StartInfo("DMZ10") { TemplateId = "DMZ", StartMode = new DataEditor.StartInfo.DataEditorStartMode( new DataEditor.StartInfo.WorkflowStartMode(WorkflowProcessMode.SetRoute) { ExitAfterCall = true }), PrimaryKeyFilter = new Dictionary <string, object>() { { "UNDOC", document.Undoc } }, Editable = true }; var dc = new DocumentCondition(ConditionDbType.Dmz); dmz.Cursors["DMZ"].CustomProperties.Add(DocumentCaller.DocumentConditionPropertyName, dc); DataEditor.Call(dmz); return(document.Undoc); }
public static BindingList <DocumentArchive> GetArchives(int skip, int take, DocumentCondition filter, List <DocumentSortCondition> sort, out int totalItems, Guid idCompany) { try { return(DbProvider.GetArchives(skip, take, filter, sort, out totalItems, idCompany)); } catch (Exception e) { Logging.WriteLogEvent(LoggingSource.BiblosDS_General, "ArchiveService." + MethodBase.GetCurrentMethod().Name, e.ToString(), LoggingOperationType.BiblosDS_General, LoggingLevel.BiblosDS_Errors); throw e; } }
public ActionResult GridArchives([DataSourceRequest] DataSourceRequest request) { var result = new DataSourceResult(); try { int total = 0; int skip = request.Page - 1; int take = request.PageSize; skip = (skip < 1) ? 0 : skip * take; CustomerCompanyViewModel customerCompany = Session["idCompany"] as CustomerCompanyViewModel; if (WCFUtility.GetSettingValue("DBAdminLoginConnection") == "false") { DocumentCondition conditions = new DocumentCondition(); List <DocumentSortCondition> sortConditions = new List <DocumentSortCondition>(); conditions.DocumentAttributeConditions = new System.ComponentModel.BindingList <DocumentCondition>(); conditions.DocumentAttributeConditions.Add(new DocumentCondition() { Name = "IsLegal", Value = 1, Operator = Library.Common.Enums.DocumentConditionFilterOperator.IsEqualTo, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); if (request.Filters != null) { foreach (var item in request.Filters) { //conditions.DocumentAttributeConditions.Add(new DocumentCondition { Name = item., Value = item.Value, Operator = Library.Common.Enums.DocumentConditionFilterOperator.Contains, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); } } if (request.Sorts != null) { foreach (var item in request.Sorts) { sortConditions.Add(new DocumentSortCondition { Name = item.Member, Dir = item.SortDirection }); } } else { sortConditions.Add(new DocumentSortCondition { Name = "Name", Dir = "ASC" }); } result.Data = ArchiveService.GetArchives(skip, take, conditions, sortConditions, out total, customerCompany.CompanyId).ToList(); } else { result.Data = UserArchive.GetUserArchivesPaged(User.Identity.Name, skip, take, out total, customerCompany.CompanyId); } result.Total = total; } catch (Exception ex) { result.Errors = ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GridPreservationVerify([DataSourceRequest] DataSourceRequest request) { var result = new DataSourceResult(); try { int total = 0; int skip = (request.Page - 1) * request.PageSize; int take = request.PageSize; if (skip < 0) { skip = 0; } var service = new PreservationService(); const int ARCHIVES_TAKE = 5; int archiveSkip = 0, totalArchives; List <DocumentArchive> archivi = null; CustomerCompanyViewModel customerCompany = Session["idCompany"] as CustomerCompanyViewModel; if (WCFUtility.GetSettingValue("DBAdminLoginConnection") == "false") { DocumentCondition conditions = new DocumentCondition(); List <DocumentSortCondition> sortConditions = new List <DocumentSortCondition>(); conditions.DocumentAttributeConditions = new System.ComponentModel.BindingList <DocumentCondition>(); conditions.DocumentAttributeConditions.Add(new DocumentCondition() { Name = "IsLegal", Value = 1, Operator = Library.Common.Enums.DocumentConditionFilterOperator.IsEqualTo, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); if (request.Filters != null) { foreach (var item in request.Filters) { //conditions.DocumentAttributeConditions.Add(new DocumentCondition { Name = item., Value = item.Value, Operator = Library.Common.Enums.DocumentConditionFilterOperator.Contains, Condition = Library.Common.Enums.DocumentConditionFilterCondition.And }); } } if (request.Sorts != null) { foreach (var item in request.Sorts) { sortConditions.Add(new DocumentSortCondition { Name = item.Member, Dir = item.SortDirection }); } } else { sortConditions.Add(new DocumentSortCondition { Name = "Name", Dir = "ASC" }); } archivi = ArchiveService.GetArchives(skip, take, conditions, sortConditions, out total, customerCompany.CompanyId).ToList(); } else { archivi = UserArchive.GetUserArchivesPaged(User.Identity.Name, archiveSkip, ARCHIVES_TAKE, out totalArchives, customerCompany.CompanyId); if (archivi.Count < totalArchives) { for (archiveSkip += ARCHIVES_TAKE; archiveSkip < totalArchives; archiveSkip += ARCHIVES_TAKE) { archivi.AddRange(UserArchive.GetUserArchivesPaged(User.Identity.Name, archiveSkip, ARCHIVES_TAKE, out totalArchives, customerCompany.CompanyId)); } } if (archivi.Any()) { result.Data = service.GetPreservationVerify(archivi.Select(x => x.IdArchive).ToArray <Guid>(), skip, take, out total, null); } else { result.Data = archivi; } } result.Total = total; } catch (Exception ex) { result.Errors = ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }