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