Example #1
0
        public List <FlowUseSealModel> GetFlowUseSealList(string SortColumns, int StartRecord, int MaxRecords, int UseSealCodeEqual, DateTime ApplySealDateEqual, DateTime UseSealDateEqual, DateTime QianShouDateEqual, string UserCodeEqual, string UnitCodeEqual, string DepartmentCodeEqual, string FileNameEqual, string ArchivesCodeEqual, string RemarkEqual, string KeptFlagEqual, string AuditingEqual)
        {
            List <FlowUseSealModel> models        = new List <FlowUseSealModel>();
            FlowUseSealQueryModel   objQueryModel = new FlowUseSealQueryModel();

            objQueryModel.StartRecord         = StartRecord;
            objQueryModel.MaxRecords          = MaxRecords;
            objQueryModel.SortColumns         = SortColumns;
            objQueryModel.UseSealCodeEqual    = UseSealCodeEqual;
            objQueryModel.ApplySealDateEqual  = ApplySealDateEqual;
            objQueryModel.UseSealDateEqual    = UseSealDateEqual;
            objQueryModel.QianShouDateEqual   = QianShouDateEqual;
            objQueryModel.UserCodeEqual       = UserCodeEqual;
            objQueryModel.UnitCodeEqual       = UnitCodeEqual;
            objQueryModel.DepartmentCodeEqual = DepartmentCodeEqual;
            objQueryModel.FileNameEqual       = FileNameEqual;
            objQueryModel.ArchivesCodeEqual   = ArchivesCodeEqual;
            objQueryModel.RemarkEqual         = RemarkEqual;
            objQueryModel.KeptFlagEqual       = KeptFlagEqual;
            objQueryModel.AuditingEqual       = AuditingEqual;
            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                try
                {
                    connection.Open();
                    models = new FlowUseSealBLL().GetModels(objQueryModel, connection);
                    connection.Close();
                }
                catch (SqlException exception)
                {
                    throw exception;
                }
            }
            return(models);
        }
Example #2
0
        public List <FlowUseSealModel> GetFlowUseSealList(FlowUseSealQueryModel QueryModel)
        {
            List <FlowUseSealModel> models = new List <FlowUseSealModel>();

            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                try
                {
                    connection.Open();
                    if (QueryModel == null)
                    {
                        QueryModel = new FlowUseSealQueryModel();
                    }
                    models = new FlowUseSealBLL().GetModels(QueryModel, connection);
                    connection.Close();
                }
                catch (SqlException exception)
                {
                    throw exception;
                }
            }
            return(models);
        }
Example #3
0
        public List <FlowUseSealModel> GetModels(FlowUseSealQueryModel ObjQueryModel, SqlTransaction Transaction)
        {
            FlowUseSealDAL ldal = new FlowUseSealDAL(Transaction);

            return(ldal.Select(ObjQueryModel));
        }