示例#1
0
        public List <YF_AssetMainRecordModel> GetYF_AssetMainRecordList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, int FKCodeEqual, string ContentEqual, int CostTimeEqual, decimal CostMoneyEqual, string ChangeDetailEqual, string UserSignEqual, string MainUserEqual, DateTime MainTimeEqual, string ResultEqual)
        {
            List <YF_AssetMainRecordModel> models        = new List <YF_AssetMainRecordModel>();
            YF_AssetMainRecordQueryModel   objQueryModel = new YF_AssetMainRecordQueryModel();

            objQueryModel.StartRecord       = StartRecord;
            objQueryModel.MaxRecords        = MaxRecords;
            objQueryModel.SortColumns       = SortColumns;
            objQueryModel.CodeEqual         = CodeEqual;
            objQueryModel.FKCodeEqual       = FKCodeEqual;
            objQueryModel.ContentEqual      = ContentEqual;
            objQueryModel.CostTimeEqual     = CostTimeEqual;
            objQueryModel.CostMoneyEqual    = CostMoneyEqual;
            objQueryModel.ChangeDetailEqual = ChangeDetailEqual;
            objQueryModel.UserSignEqual     = UserSignEqual;
            objQueryModel.MainUserEqual     = MainUserEqual;
            objQueryModel.MainTimeEqual     = MainTimeEqual;
            objQueryModel.ResultEqual       = ResultEqual;
            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                try
                {
                    connection.Open();
                    models = new YF_AssetMainRecordBLL().GetModels(objQueryModel, connection);
                    connection.Close();
                }
                catch (SqlException exception)
                {
                    throw exception;
                }
            }
            return(models);
        }
示例#2
0
        private List <YF_AssetMainRecordModel> _Select(YF_AssetMainRecordQueryModel qmObj)
        {
            List <YF_AssetMainRecordModel> list = new List <YF_AssetMainRecordModel>();
            StringBuilder builder = new StringBuilder();

            builder.Append("select * from YF_AssetMainRecord ");
            builder.Append(qmObj.QueryConditionStr);
            if (qmObj.SortColumns.Length == 0)
            {
                builder.Append(" ORDER BY Code desc");
            }
            else
            {
                builder.Append(" ORDER BY " + qmObj.SortColumns);
            }
            this._DataProcess.CommandText   = builder.ToString();
            this._DataProcess.SqlParameters = qmObj.Parameters;
            SqlDataReader sqlDataReader = null;
            int           num           = 0;

            try
            {
                try
                {
                    sqlDataReader = this._DataProcess.GetSqlDataReader();
                    while (sqlDataReader.Read())
                    {
                        if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
                        {
                            YF_AssetMainRecordModel model = new YF_AssetMainRecordModel();
                            this.Initialize(sqlDataReader, model);
                            list.Add(model);
                        }
                        num++;
                    }
                }
                catch (SqlException exception)
                {
                    throw exception;
                }
            }
            finally
            {
                if (sqlDataReader != null)
                {
                    sqlDataReader.Close();
                }
            }
            return(list);
        }
示例#3
0
        public string GetMainRecordCodeByMainCode(string incode)
        {
            string text = null;
            int    result;

            if (int.TryParse(incode, out result))
            {
                YF_AssetMainRecordBFL          dbfl       = new YF_AssetMainRecordBFL();
                YF_AssetMainRecordQueryModel   queryModel = new YF_AssetMainRecordQueryModel();
                List <YF_AssetMainRecordModel> list       = new List <YF_AssetMainRecordModel>();
                queryModel.FKCodeEqual = result;
                list = dbfl.GetYF_AssetMainRecordList(queryModel);
                if (list.Count > 0)
                {
                    text = list[0].Code.ToString();
                }
            }
            return(text);
        }
示例#4
0
        public List <YF_AssetMainRecordModel> GetYF_AssetMainRecordList(YF_AssetMainRecordQueryModel QueryModel)
        {
            List <YF_AssetMainRecordModel> models = new List <YF_AssetMainRecordModel>();

            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                try
                {
                    connection.Open();
                    if (QueryModel == null)
                    {
                        QueryModel = new YF_AssetMainRecordQueryModel();
                    }
                    models = new YF_AssetMainRecordBLL().GetModels(QueryModel, connection);
                    connection.Close();
                }
                catch (SqlException exception)
                {
                    throw exception;
                }
            }
            return(models);
        }
示例#5
0
        public List <YF_AssetMainRecordModel> GetYF_AssetMainRecordList(string SortColumns, int StartRecord, int MaxRecords, string CodeEqual, string FKCodeEqual, string ContentEqual, string CostTimeEqual, string CostMoneyEqual, string ChangeDetailEqual, string UserSignEqual, string MainUserEqual, string MainTimeEqual, string ResultEqual)
        {
            List <YF_AssetMainRecordModel> models        = new List <YF_AssetMainRecordModel>();
            YF_AssetMainRecordQueryModel   objQueryModel = new YF_AssetMainRecordQueryModel();

            objQueryModel.StartRecord = StartRecord;
            objQueryModel.MaxRecords  = MaxRecords;
            objQueryModel.SortColumns = SortColumns;
            if (!string.IsNullOrEmpty(CodeEqual))
            {
                objQueryModel.CodeEqual = int.Parse(CodeEqual);
            }
            if (!string.IsNullOrEmpty(FKCodeEqual))
            {
                objQueryModel.FKCodeEqual = int.Parse(FKCodeEqual);
            }
            if (!string.IsNullOrEmpty(ContentEqual))
            {
                objQueryModel.ContentEqual = ContentEqual;
            }
            if (!string.IsNullOrEmpty(CostTimeEqual))
            {
                objQueryModel.CostTimeEqual = int.Parse(CostTimeEqual);
            }
            if (!string.IsNullOrEmpty(CostMoneyEqual))
            {
                objQueryModel.CostMoneyEqual = decimal.Parse(CostMoneyEqual);
            }
            if (!string.IsNullOrEmpty(ChangeDetailEqual))
            {
                objQueryModel.ChangeDetailEqual = ChangeDetailEqual;
            }
            if (!string.IsNullOrEmpty(UserSignEqual))
            {
                objQueryModel.UserSignEqual = UserSignEqual;
            }
            if (!string.IsNullOrEmpty(MainUserEqual))
            {
                objQueryModel.MainUserEqual = MainUserEqual;
            }
            if (!string.IsNullOrEmpty(MainTimeEqual))
            {
                objQueryModel.MainTimeEqual = DateTime.Parse(MainTimeEqual);
            }
            if (!string.IsNullOrEmpty(ResultEqual))
            {
                objQueryModel.ResultEqual = ResultEqual;
            }
            using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
            {
                try
                {
                    try
                    {
                        connection.Open();
                        models = new YF_AssetMainRecordBLL().GetModels(objQueryModel, connection);
                    }
                    catch (SqlException exception)
                    {
                        throw exception;
                    }
                    return(models);
                }
                finally
                {
                    connection.Close();
                }
            }
            return(models);
        }
示例#6
0
        public List <YF_AssetMainRecordModel> GetModels(YF_AssetMainRecordQueryModel ObjQueryModel, SqlTransaction Transaction)
        {
            YF_AssetMainRecordDAL ddal = new YF_AssetMainRecordDAL(Transaction);

            return(ddal.Select(ObjQueryModel));
        }
示例#7
0
 public List <YF_AssetMainRecordModel> Select(YF_AssetMainRecordQueryModel qmObj)
 {
     return(this._Select(qmObj));
 }
示例#8
0
        public List <YF_AssetMainRecordModel> Select()
        {
            YF_AssetMainRecordQueryModel qmObj = new YF_AssetMainRecordQueryModel();

            return(this._Select(qmObj));
        }