/// <summary>
/// 获取一条
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Memos GetMemos(int id)
{
Memos me = new Memos();
string sql = "select * from Memos where id=@id";
SqlParameter[] para =
{
new SqlParameter("@id", id)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
if (ds.Tables.Count == 1 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
me.UserName = dr["UserName"].ToString();
me.TelPhone = dr["TelPhone"].ToString();
me.Cop = dr["Cop"].ToString();
me.Zhiwei = dr["Zhiwei"].ToString();
me.MemosContent = dr["MemosContent"].ToString();
me.SubTime = dr["SubTime"].ToString();
me.Hanye = dr["Hanye"].ToString();
me.BrandName = dr["BrandName"].ToString();
me.BrandWeb = dr["BrandWeb"].ToString();
me.Email = dr["Email"].ToString();
}
return(me);
}
/// <summary>
/// 根据id去获取ViewPoint
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public ViewPointExtend GetViewPointTpName(int id)
{
ViewPointExtend vp = new ViewPointExtend();
string sql = "select b.ID, a.AddTime, Title,TypeName,tag,Article,MetaKey,MetaDesc,vtag from ViewPoint a inner join PointType b on a.TpId=b.ID where a.ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", id)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
vp.Title = dr["Title"].ToString();
vp.TypeName = dr["TypeName"].ToString();
vp.Tag = dr["tag"].ToString();
vp.Article = dr["Article"].ToString();
vp.AddTime = Convert.ToDateTime(dr["AddTime"]);
vp.ID = Convert.ToInt32(dr["ID"]);
vp.MetaKey = dr["MetaKey"].ToString();
vp.MetaDesc = dr["MetaDesc"].ToString();
vp.vtag = dr["vtag"].ToString();
}
return(vp);
}
/// <summary>
/// 获取案例分类列表
/// </summary>
/// <returns></returns>
public List <BoCaseType> GetBoCaseType()
{
List <BoCaseType> list = new List <BoCaseType>();
string sql = "select ID,TypeName from BoCaseType";
DataSet ds = DbHelper.GetDataSetBySql(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
BoCaseType tp = new BoCaseType();
tp.ID = Convert.ToInt32(dr["ID"]);
tp.TypeName = dr["TypeName"].ToString();
list.Add(tp);
}
return(list);
}
/// <summary>
/// 获取观点列表
/// </summary>
/// <returns></returns>
public List <PointType> GetPointTypeList()
{
List <PointType> list = new List <PointType>();
string sql = "select ID,TypeName from PointType";
DataSet ds = DbHelper.GetDataSetBySql(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PointType pt = new PointType();
pt.ID = Convert.ToInt32(dr["ID"]);
pt.TypeName = dr["TypeName"].ToString();
list.Add(pt);
}
return(list);
}
/// <summary>
/// 获取所有链接
/// </summary>
/// <param name="txts"></param>
/// <returns></returns>
public List <FriendShip> GetLinkList_all()
{
List <FriendShip> list = new List <FriendShip>();
string sql = "select ID,Fword,FUrl from FriendShip";
DataSet ds = DbHelper.GetDataSetBySql(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
FriendShip fri = new FriendShip();
fri.Fword = dr["Fword"].ToString();
fri.FUrl = "http://" + dr["FUrl"].ToString();
fri.ID = Convert.ToInt32(dr["ID"]);
list.Add(fri);
}
return(list);
}
/// <summary>
/// 推荐观点6条(按时间排序)
/// </summary>
/// <returns></returns>
public List <ViewPointExtend> GetViewPointList()
{
List <ViewPointExtend> list = new List <ViewPointExtend>();
string sql = "select top 4 a.ID,Title,TypeName from ViewPoint a inner join PointType b on a.TpId=b.ID";
DataSet ds = DbHelper.GetDataSetBySql(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ViewPointExtend vpe = new ViewPointExtend();
vpe.ID = Convert.ToInt32(dr["ID"]);
vpe.Title = dr["Title"].ToString();
vpe.TypeName = dr["TypeName"].ToString();
list.Add(vpe);
}
return(list);
}
/// <summary>
/// 获取前6条数据
/// </summary>
/// <param name="p">id</param>
/// <returns></returns>
public List <ViewPoint> GetViewPointListById_top6()
{
List <ViewPoint> list = new List <ViewPoint>();
string sql = "select top 6 ID,Title,AddTime from ViewPoint order by AddTime desc";
DataSet ds = DbHelper.GetDataSetBySql(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ViewPoint vp = new ViewPoint();
vp.ID = Convert.ToInt32(dr["ID"]);
vp.Title = dr["Title"].ToString();
vp.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(vp);
}
return(list);
}
/// <summary>
/// 获取9条数据
/// </summary>
/// <returns></returns>
public List <BoutiqueCase> GetBoutiqueList_Top6()
{
List <BoutiqueCase> list = new List <BoutiqueCase>();
string sql = "select ID,Logo,Client,Hanye,item from BoutiqueCase order by Addtime desc";
DataSet ds = DbHelper.GetDataSetBySql(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
BoutiqueCase BCase = new BoutiqueCase();
BCase.ID = Convert.ToInt32(dr["ID"]);
BCase.Logo = dr["Logo"].ToString();
BCase.Client = dr["Client"].ToString();
BCase.Hanye = dr["Hanye"].ToString();
BCase.item = dr["item"].ToString();
list.Add(BCase);
}
return(list);
}
/// <summary>
/// 下一页
/// </summary>
/// <returns></returns>
public ViewPoint GetViewPointUp(int id)
{
string sql = "select top 1 * from ViewPoint where @id>ID order by ID asc";
ViewPoint vp = new ViewPoint();
SqlParameter[] para =
{
new SqlParameter("@id", id)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
vp.Title = dr["Title"].ToString();
vp.ID = Convert.ToInt32(dr["ID"]);
}
return(vp);
}
/// <summary>
/// 获取前十个案例图
/// </summary>
/// <param name="p">id</param>
/// <returns></returns>
public List <Cases> GetCasesListById_top10()
{
List <Cases> list = new List <Cases>();
string sql = "select top 10 ID,CName,IsTop,AddTime,ImgSrc from Cases where 1=1 order by IsTop desc, AddTime desc";
SqlParameter[] para = { };
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Cases vp = new Cases();
vp.ID = Convert.ToInt32(dr["ID"]);
vp.ImgSrc = dr["ImgSrc"].ToString();
vp.CName = dr["CName"].ToString();
vp.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(vp);
}
return(list);
}
/// <summary>
/// 获取一个
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public NsyNews GetNsyNews(int d)
{
NsyNews news = new NsyNews();
string sql = "select * from NsyNews where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", d)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
news.ID = Convert.ToInt32(dr["ID"]);
news.Title = dr["Title"].ToString();
news.Contents = dr["Contents"].ToString();
news.AddTime = Convert.ToDateTime(dr["AddTime"]);
}
return(news);
}
/// <summary>
/// 获取前6条数据
/// </summary>
/// <param name="p">id</param>
/// <returns></returns>
public List <ViewPoint> GetViewPointListById_top6(int p)
{
List <ViewPoint> list = new List <ViewPoint>();
string sql = "select top 6 ID,Title,Istop,AddTime from ViewPoint where TpId=@tpid order by Istop desc, AddTime desc";
SqlParameter[] para =
{
new SqlParameter("@tpid", p)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ViewPoint vp = new ViewPoint();
vp.ID = Convert.ToInt32(dr["ID"]);
vp.Title = dr["Title"].ToString();
vp.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(vp);
}
return(list);
}
/// <summary>
/// 得到一条案例
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public BoutiqueCase GetBCase(int d)
{
BoutiqueCase BCase = new BoutiqueCase();
string sql = "select * from BoutiqueCase where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", d)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
BCase.Logo = dr["Logo"].ToString();
BCase.Background = dr["background"].ToString();
BCase.Challenge = dr["Challenge"].ToString();
BCase.Client = dr["Client"].ToString();
BCase.gain = dr["gain"].ToString();
BCase.Hanye = dr["Hanye"].ToString();
BCase.item = dr["item"].ToString();
}
return(BCase);
}
/// <summary>
/// 获得一个观点
/// </summary>
/// <param name="d">id</param>
/// <returns></returns>
public ViewPoint GetViewPoint(int d)
{
ViewPoint vp = new ViewPoint();
string sql = "select Title,Article,TpId,Istop,MetaKey,MetaDesc,vtag,CShortDes from ViewPoint where ID=@id";
SqlParameter[] para =
{
new SqlParameter("@id", d)
};
DataSet ds = DbHelper.GetDataSetBySql(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
vp.Title = dr["Title"].ToString();
vp.Article = dr["Article"].ToString();
vp.TpId = Convert.ToInt32(dr["TpId"]);
vp.Istop = Convert.ToInt32(dr["Istop"]);
vp.MetaKey = (Convert.IsDBNull(dr["MetaKey"]) ? "" : Convert.ToString(dr["MetaKey"]));
vp.MetaDesc = (Convert.IsDBNull(dr["MetaDesc"]) ? "" : Convert.ToString(dr["MetaDesc"]));
vp.vtag = (Convert.IsDBNull(dr["vtag"]) ? "" : Convert.ToString(dr["vtag"]));
vp.CShortDes = (Convert.IsDBNull(dr["CShortDes"]) ? "" : Convert.ToString(dr["CShortDes"]));
}
return(vp);
}