예제 #1
0
        /// <summary>
        /// Convert IDataReader To HotKeyWordInfo
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        public static HotKeyWordInfo SetValue(IDataReader reader)
        {
            HotKeyWordInfo info = new HotKeyWordInfo();

            int keyWordIndex = reader.GetOrdinal("KeyWord");
            int cateIDIndex = reader.GetOrdinal("CateID");
            int orderIDIndex = reader.GetOrdinal("OrderID");

            info.KeyWord = reader.GetString(keyWordIndex);
            info.CateID = reader.GetInt32(cateIDIndex);
            info.OrderID = reader.GetInt32(orderIDIndex);

            return info;
        }
예제 #2
0
        public bool Insert(HotKeyWordInfo hotKeyWordInfo)
        {
            StringBuilder sql=new StringBuilder();
            sql.Append("INSERT INTO");
            sql.Append(" [Tbl_HotKeyWord](");
            sql.Append("[KeyWord],");
            sql.Append("[CateID],");
            sql.Append("[OrderID]");
            sql.Append(") VALUES(");
            sql.Append("@KeyWord,");
            sql.Append("@CateID,");
            sql.Append("@OrderID");
            sql.Append(")");

            using(NetShopHelper dbhelper=new NetShopHelper())
            {
                IDbDataParameter[] p_Parms=new IDbDataParameter[]{
                    dbhelper.CreateParameter("@KeyWord",hotKeyWordInfo.KeyWord),
                    dbhelper.CreateParameter("@CateID",hotKeyWordInfo.CateID),
                    dbhelper.CreateParameter("@OrderID",hotKeyWordInfo.OrderID)
                };
            return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
            }
        }