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 List <DocumentFileModel> GetDocumentFileList(DocumentFileQueryModel QueryModel)
{
List <DocumentFileModel> models = new List <DocumentFileModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
if (QueryModel == null)
{
QueryModel = new DocumentFileQueryModel();
}
models = new DocumentFileBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List<DocumentFileModel> GetModels(DocumentFileQueryModel ObjQueryModel, SqlTransaction Transaction)
{
DocumentFileDAL edal = new DocumentFileDAL(Transaction);
return edal.Select(ObjQueryModel);
}
public List <DocumentFileModel> GetModels(DocumentFileQueryModel ObjQueryModel, SqlConnection Connection)
{
DocumentFileDAL edal = new DocumentFileDAL(Connection);
return(edal.Select(ObjQueryModel));
}
public List <DocumentFileModel> Select(DocumentFileQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <DocumentFileModel> Select()
{
DocumentFileQueryModel qmObj = new DocumentFileQueryModel();
return(this._Select(qmObj));
}
