Beispiel #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public XCLCMS.Data.Model.FriendLinks GetModel(FriendLinks_TitleCondition condition)
        {
            Database  db        = base.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand("select top 1 * from FriendLinks with(nolock) where Title=@Title and FK_MerchantID=@FK_MerchantID and FK_MerchantAppID=@FK_MerchantAppID");

            db.AddInParameter(dbCommand, "Title", DbType.String, condition.Title);
            db.AddInParameter(dbCommand, "FK_MerchantID", DbType.Int64, condition.FK_MerchantID);
            db.AddInParameter(dbCommand, "FK_MerchantAppID", DbType.Int64, condition.FK_MerchantAppID);
            using (var dr = db.ExecuteReader(dbCommand))
            {
                return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToEntity <XCLCMS.Data.Model.FriendLinks>(dr));
            }
        }
Beispiel #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public XCLCMS.Data.Model.FriendLinks GetModel(FriendLinks_TitleCondition condition)
        {
            Database  db        = base.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand("select top 1 * from FriendLinks with(nolock) where Title=@Title and FK_MerchantID=@FK_MerchantID and FK_MerchantAppID=@FK_MerchantAppID");

            db.AddInParameter(dbCommand, "Title", DbType.String, condition.Title);
            db.AddInParameter(dbCommand, "FK_MerchantID", DbType.Int64, condition.FK_MerchantID);
            db.AddInParameter(dbCommand, "FK_MerchantAppID", DbType.Int64, condition.FK_MerchantAppID);
            DataSet ds  = db.ExecuteDataSet(dbCommand);
            var     lst = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.FriendLinks>(ds.Tables[0]);

            return(null != lst && lst.Count > 0 ? lst[0] : null);
        }
Beispiel #3
0
 /// <summary>
 /// 判断指定标题是否存在
 /// </summary>
 public bool IsExist(FriendLinks_TitleCondition condition)
 {
     return(null != this.GetModel(condition));
 }
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public XCLCMS.Data.Model.FriendLinks GetModel(FriendLinks_TitleCondition condition)
 {
     return(dal.GetModel(condition));
 }
 /// <summary>
 /// 判断指定标题是否存在
 /// </summary>
 public bool IsExist(FriendLinks_TitleCondition condition)
 {
     return(dal.IsExist(condition));
 }