Esempio n. 1
0
        public virtual bool EditKeywordBiddingKeyword(KeywordBiddingKeywordInfo entity)
        {
            string    SqlAdd = null;
            DataTable DtAdd  = null;
            DataRow   DrAdd  = null;

            SqlAdd = "SELECT * FROM KeywordBidding_Keyword WHERE Keyword_ID = " + entity.Keyword_ID;
            DtAdd  = DBHelper.Query(SqlAdd);
            try {
                if (DtAdd.Rows.Count > 0)
                {
                    DrAdd = DtAdd.Rows[0];
                    DrAdd["Keyword_ID"]       = entity.Keyword_ID;
                    DrAdd["Keyword_Name"]     = entity.Keyword_Name;
                    DrAdd["Keyword_MinPrice"] = entity.Keyword_MinPrice;

                    DBHelper.SaveChanges(SqlAdd, DtAdd);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex) {
                throw ex;
            }
            finally {
                DtAdd.Dispose();
            }
            return(true);
        }
Esempio n. 2
0
        public virtual KeywordBiddingKeywordInfo GetKeywordBiddingKeywordByName(string Keyword)
        {
            KeywordBiddingKeywordInfo entity  = null;
            SqlDataReader             RdrList = null;

            try
            {
                string SqlList;
                SqlList = "SELECT * FROM KeywordBidding_Keyword WHERE Keyword_Name = '" + Keyword + "'";
                RdrList = DBHelper.ExecuteReader(SqlList);
                if (RdrList.Read())
                {
                    entity = new KeywordBiddingKeywordInfo();

                    entity.Keyword_ID       = Tools.NullInt(RdrList["Keyword_ID"]);
                    entity.Keyword_Name     = Tools.NullStr(RdrList["Keyword_Name"]);
                    entity.Keyword_MinPrice = Tools.NullDbl(RdrList["Keyword_MinPrice"]);
                }

                return(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (RdrList != null)
                {
                    RdrList.Close();
                    RdrList = null;
                }
            }
        }
Esempio n. 3
0
        public virtual bool AddKeywordBiddingKeyword(KeywordBiddingKeywordInfo entity)
        {
            string    SqlAdd = null;
            DataTable DtAdd  = null;
            DataRow   DrAdd  = null;

            SqlAdd = "SELECT TOP 0 * FROM KeywordBidding_Keyword";
            DtAdd  = DBHelper.Query(SqlAdd);
            DrAdd  = DtAdd.NewRow();

            DrAdd["Keyword_ID"]       = entity.Keyword_ID;
            DrAdd["Keyword_Name"]     = entity.Keyword_Name;
            DrAdd["Keyword_MinPrice"] = entity.Keyword_MinPrice;

            DtAdd.Rows.Add(DrAdd);
            try {
                DBHelper.SaveChanges(SqlAdd, DtAdd);
                return(true);
            }
            catch (Exception ex) {
                throw ex;
            }
            finally {
                DtAdd.Dispose();
            }
        }
Esempio n. 4
0
    public void EditKeywordBidding_Keyword()
    {
        int    Keyword_ID       = tools.CheckInt(Request.Form["Keyword_ID"]);
        double Keyword_MinPrice = tools.CheckFloat(Request.Form["Keyword_MinPrice"]);

        if (Keyword_MinPrice == 0)
        {
            Public.Msg("error", "错误信息", "请填写起步价", false, "{back}"); return;
        }

        KeywordBiddingKeywordInfo entity = GetKeywordBiddingKeywordID(Keyword_ID);

        if (entity != null)
        {
            entity.Keyword_MinPrice = Keyword_MinPrice;

            if (MyBLL.EditKeywordBiddingKeyword(entity, Public.GetUserPrivilege()))
            {
                Public.Msg("positive", "操作成功", "操作成功", true, "keyword_list.aspx");
            }
            else
            {
                Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}");
            }
        }
        else
        {
            Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}");
        }
    }
Esempio n. 5
0
 public virtual bool EditKeywordBiddingKeyword(KeywordBiddingKeywordInfo entity, RBACUserInfo UserPrivilege)
 {
     if (RBAC.CheckPrivilege(UserPrivilege, "0f39c533-9740-427f-ae56-649518a414c3"))
     {
         return(MyDAL.EditKeywordBiddingKeyword(entity));
     }
     else
     {
         throw new TradePrivilegeException("没有权限,权限代码:0f39c533-9740-427f-ae56-649518a414c3错误");
     }
 }
Esempio n. 6
0
    //获取指定竞价关键词
    public virtual string GetKeywordBiddingKeywordByID(int Keyword_ID)
    {
        string Keyword_Name = "";
        KeywordBiddingKeywordInfo entity = MyBLL.GetKeywordBiddingKeywordByID(Keyword_ID, Public.GetUserPrivilege());

        if (entity != null)
        {
            Keyword_Name = entity.Keyword_Name;
        }
        return(Keyword_Name);
    }
Esempio n. 7
0
        public virtual IList <KeywordBiddingKeywordInfo> GetKeywordBiddingKeywords(QueryInfo Query)
        {
            int PageSize;
            int CurrentPage;
            IList <KeywordBiddingKeywordInfo> entitys = null;
            KeywordBiddingKeywordInfo         entity = null;
            string        SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
            SqlDataReader RdrList = null;

            try
            {
                CurrentPage = Query.CurrentPage;
                PageSize    = Query.PageSize;
                SqlTable    = "KeywordBidding_Keyword";
                SqlField    = "*";
                SqlParam    = DBHelper.GetSqlParam(Query.ParamInfos);
                SqlOrder    = DBHelper.GetSqlOrder(Query.OrderInfos);
                SqlList     = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
                RdrList     = DBHelper.ExecuteReader(SqlList);
                if (RdrList.HasRows)
                {
                    entitys = new List <KeywordBiddingKeywordInfo>();
                    while (RdrList.Read())
                    {
                        entity                  = new KeywordBiddingKeywordInfo();
                        entity.Keyword_ID       = Tools.NullInt(RdrList["Keyword_ID"]);
                        entity.Keyword_Name     = Tools.NullStr(RdrList["Keyword_Name"]);
                        entity.Keyword_MinPrice = Tools.NullDbl(RdrList["Keyword_MinPrice"]);

                        entitys.Add(entity);
                        entity = null;
                    }
                }
                return(entitys);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (RdrList != null)
                {
                    RdrList.Close();
                    RdrList = null;
                }
            }
        }
Esempio n. 8
0
 public virtual bool AddKeywordBiddingKeyword(KeywordBiddingKeywordInfo entity)
 {
     return(MyDAL.AddKeywordBiddingKeyword(entity));
 }