コード例 #1
0
        public Budget_Deals SelectByOID(Guid guidDealOID)
        {
            Budget_Deals deal = null;

            try
            {
                string         sSQL     = "SELECT * FROM Deals WHERE DealOID=@DealOID";
                SqlParameter[] sqlParam = new SqlParameter[1];
                sqlParam[0]       = new SqlParameter("@DealOID", SqlDbType.UniqueIdentifier);
                sqlParam[0].Value = guidDealOID;
                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    deal                = new Budget_Deals();
                    deal.DealOID        = new Guid(ds.Tables[0].Rows[0]["DealOID"].ToString());
                    deal.Enable         = Convert.ToBoolean(ds.Tables[0].Rows[0]["Enable"].ToString());
                    deal.Seq            = Convert.ToInt32(ds.Tables[0].Rows[0]["Seq"].ToString());
                    deal.FileName       = ds.Tables[0].Rows[0]["FileName"].ToString();
                    deal.Title          = ds.Tables[0].Rows[0]["Title"].ToString();
                    deal.ShortDes       = ds.Tables[0].Rows[0]["ShortDes"].ToString();
                    deal.TextInButton   = ds.Tables[0].Rows[0]["TextInButton"].ToString();
                    deal.ButtonURL      = ds.Tables[0].Rows[0]["ButtonURL"].ToString();
                    deal.Descriptions   = ds.Tables[0].Rows[0]["Descriptions"].ToString();
                    deal.BannerFileName = ds.Tables[0].Rows[0]["BannerFileName"].ToString();
                }
            }
            catch (Exception ex) { }
            return(deal);
        }
コード例 #2
0
        public List <Budget_Deals> SelectAll()
        {
            List <Budget_Deals> DealsList = null;

            try
            {
                string sSQL = "SELECT * FROM Deals ORDER BY Seq";

                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    DealsList = new List <Budget_Deals>();
                    Budget_Deals deal = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        deal                = new Budget_Deals();
                        deal.DealOID        = new Guid(ds.Tables[0].Rows[i]["DealOID"].ToString());
                        deal.Enable         = Convert.ToBoolean(ds.Tables[0].Rows[i]["Enable"].ToString());
                        deal.Seq            = Convert.ToInt32(ds.Tables[0].Rows[i]["Seq"].ToString());
                        deal.FileName       = ds.Tables[0].Rows[i]["FileName"].ToString();
                        deal.Title          = ds.Tables[0].Rows[i]["Title"].ToString();
                        deal.ShortDes       = ds.Tables[0].Rows[i]["ShortDes"].ToString();
                        deal.TextInButton   = ds.Tables[0].Rows[i]["TextInButton"].ToString();
                        deal.ButtonURL      = ds.Tables[0].Rows[i]["ButtonURL"].ToString();
                        deal.Descriptions   = ds.Tables[0].Rows[i]["Descriptions"].ToString();
                        deal.BannerFileName = ds.Tables[0].Rows[i]["BannerFileName"].ToString();
                        DealsList.Add(deal);
                    }
                }
            }
            catch (Exception ex) { }
            return(DealsList);
        }