public List <FileTemplateVersionModel> GetFileTemplateVersionList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, int FileTemplateCodeEqual, string WorkFlowProcedureNameEqual, string VersionNumberEqual, string IsPigeonholeEqual, string PigeonholeTimeEqual, string SaveTermEqual, string RecordKindEqual, string MarkingSNRuleEqual, string IsAvailabilityEqual)
{
List <FileTemplateVersionModel> models = new List <FileTemplateVersionModel>();
FileTemplateVersionQueryModel objQueryModel = new FileTemplateVersionQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.FileTemplateCodeEqual = FileTemplateCodeEqual;
objQueryModel.WorkFlowProcedureNameEqual = WorkFlowProcedureNameEqual;
objQueryModel.VersionNumberEqual = VersionNumberEqual;
objQueryModel.IsPigeonholeEqual = IsPigeonholeEqual;
objQueryModel.PigeonholeTimeEqual = PigeonholeTimeEqual;
objQueryModel.SaveTermEqual = SaveTermEqual;
objQueryModel.RecordKindEqual = RecordKindEqual;
objQueryModel.MarkingSNRuleEqual = MarkingSNRuleEqual;
objQueryModel.IsAvailabilityEqual = IsAvailabilityEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new FileTemplateVersionBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public int Update(FileTemplateVersionModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new FileTemplateVersionBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public List <DocumentFileModel> GetDocumentFileList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string OperationTypeEqual, string ApplyUserCodeEqual, string ApplyDepartmentCodeEqual, DateTime ApplyDateTimeEqual, string FileCodeEqual, int FileTemplateCodeEqual, string FileTemplateCodeStrEqual, string SubjectEqual, string ContentEqual, string RemarkEqual, string ArchiveTypeEqual, string ArchiveStateEqual, DateTime ArchiveDatetimeEqual, string AuditingStateEqual, DateTime AuditingDatetimeEqual, DateTime CreateDateEqual, string CreateUserCodeEqual, DateTime LastModifyDatetimeEqual, string LastModifyByUserCodeEqual, string DeleteFlagEqual, int CountsEqual, int LeavesEqual)
{
List <DocumentFileModel> models = new List <DocumentFileModel>();
DocumentFileQueryModel objQueryModel = new DocumentFileQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.OperationTypeEqual = OperationTypeEqual;
objQueryModel.ApplyUserCodeEqual = ApplyUserCodeEqual;
objQueryModel.ApplyDepartmentCodeEqual = ApplyDepartmentCodeEqual;
objQueryModel.ApplyDateTimeEqual = ApplyDateTimeEqual;
objQueryModel.FileCodeEqul = FileCodeEqual;
objQueryModel.FileTemplateCodeEqual = FileTemplateCodeEqual;
objQueryModel.FileTemplateCodeIn = FileTemplateCodeStrEqual;
objQueryModel.SubjectEqual = SubjectEqual;
objQueryModel.ContentEqual = ContentEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.ArchiveTypeEqual = ArchiveTypeEqual;
objQueryModel.ArchiveStateEqual = ArchiveStateEqual;
objQueryModel.AuditingStateEqual = AuditingStateEqual;
objQueryModel.AuditingDatetimeEqual = AuditingDatetimeEqual;
objQueryModel.CreateDateEqual = CreateDateEqual;
objQueryModel.CreateUserCodeEqual = CreateUserCodeEqual;
objQueryModel.LastModifyDatetimeEqual = LastModifyDatetimeEqual;
objQueryModel.LastModifyByUserCodeEqual = LastModifyByUserCodeEqual;
objQueryModel.DeleteFlagEqual = DeleteFlagEqual;
objQueryModel.CountsEqual = CountsEqual;
objQueryModel.LeavesEqual = LeavesEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new DocumentFileBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public FileTemplateModel GetFileTemplate(int Code)
{
FileTemplateModel model = new FileTemplateModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new FileTemplateBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public DocumentDirectoryModel GetDocumentDirectory(int Code)
{
DocumentDirectoryModel model = new DocumentDirectoryModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new DocumentDirectoryBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public DataSet GetStartupProcedureListDS()
{
DataSet startupProcedureDS = new DataSet();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
startupProcedureDS = new DocumentDirectoryBLL().GetStartupProcedureDS(connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(startupProcedureDS);
}
public WorkFlowProcedureModel GetWorkFlowProcedure(int Code)
{
WorkFlowProcedureModel model = new WorkFlowProcedureModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new WorkFlowProcedureBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <FileTemplateModel> GetFileTemplateListOne(int Code)
{
List <FileTemplateModel> list = new List <FileTemplateModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
FileTemplateBLL ebll = new FileTemplateBLL();
list.Add(ebll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <DocumentDirectoryModel> GetDocumentDirectoryListOne(int Code)
{
List <DocumentDirectoryModel> list = new List <DocumentDirectoryModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
DocumentDirectoryBLL ybll = new DocumentDirectoryBLL();
list.Add(ybll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <WorkFlowProcedureModel> GetWorkFlowProcedureListOne(int Code)
{
List <WorkFlowProcedureModel> list = new List <WorkFlowProcedureModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
WorkFlowProcedureBLL ebll = new WorkFlowProcedureBLL();
list.Add(ebll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public List <WorkFlowProcedureModel> GetWorkFlowProcedureList(string SortColumns, int StartRecord, int MaxRecords, string ProcedureCodeEqual, string ProcedureNameEqual, string DescriptionEqual, string ApplicationPathEqual, string ApplicationInfoPathEqual, int TypeEqual, string RemarkEqual, string SysTypeEqual, string CreatorEqual, decimal VersionNumberEqual, string ProjectCodeEqual, string CreateUserEqual, DateTime CreateDateEqual, string ModifyUserEqual, DateTime ModifyDateEqual, int ActivityEqual, string VersionDescriptionEqual, string ProcedureRemarkEqual)
{
List <WorkFlowProcedureModel> models = new List <WorkFlowProcedureModel>();
WorkFlowProcedureQueryModel objQueryModel = new WorkFlowProcedureQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.ProcedureCodeEqual = ProcedureCodeEqual;
objQueryModel.ProcedureNameEqual = ProcedureNameEqual;
objQueryModel.DescriptionEqual = DescriptionEqual;
objQueryModel.ApplicationPathEqual = ApplicationPathEqual;
objQueryModel.ApplicationInfoPathEqual = ApplicationInfoPathEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.SysTypeEqual = SysTypeEqual;
objQueryModel.CreatorEqual = CreatorEqual;
objQueryModel.VersionNumberEqual = VersionNumberEqual;
objQueryModel.ProjectCodeEqual = ProjectCodeEqual;
objQueryModel.CreateUserEqual = CreateUserEqual;
objQueryModel.CreateDateEqual = CreateDateEqual;
objQueryModel.ModifyUserEqual = ModifyUserEqual;
objQueryModel.ModifyDateEqual = ModifyDateEqual;
objQueryModel.ActivityEqual = ActivityEqual;
objQueryModel.VersionDescriptionEqual = VersionDescriptionEqual;
objQueryModel.ProcedureRemarkEqual = ProcedureRemarkEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new WorkFlowProcedureBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <FileTemplateModel> GetFileTemplateList(FileTemplateQueryModel QueryModel)
{
List <FileTemplateModel> models = new List <FileTemplateModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new FileTemplateQueryModel();
}
models = new FileTemplateBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <DocumentDirectoryModel> GetDocumentDirectoryList(DocumentDirectoryQueryModel QueryModel)
{
List <DocumentDirectoryModel> models = new List <DocumentDirectoryModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new DocumentDirectoryQueryModel();
}
models = new DocumentDirectoryBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <WorkFlowProcedureModel> GetWorkFlowProcedureList(WorkFlowProcedureQueryModel QueryModel)
{
List <WorkFlowProcedureModel> models = new List <WorkFlowProcedureModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new WorkFlowProcedureQueryModel();
}
models = new WorkFlowProcedureBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}