/// <summary>
/// 读取所有
/// </summary>
/// <returns></returns>
public List <FriendShip> GetLinksList(Pages pg)
{
List <FriendShip> list = new List <FriendShip>();
string sql = "proc_FriendShipList_fenye";
SqlParameter[] para =
{
new SqlParameter("@pageIndex", pg.PageIndex),
new SqlParameter("@pageSize", pg.PagesSize),
new SqlParameter("@ListName", pg.types),
new SqlParameter("@require", pg.Tiaojian)
};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
FriendShip fri = new FriendShip();
fri.Fword = dr["Fword"].ToString();
fri.FUrl = dr["FUrl"].ToString();
fri.ID = Convert.ToInt32(dr["ID"]);
fri.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(fri);
}
return(list);
}
/// <summary>
/// 读取所有
/// </summary>
/// <returns></returns>
public List <Memos> GetMemosList(int id)
{
List <Memos> list = new List <Memos>();
string sql = "proc_Get_MemosList";
SqlParameter[] para =
{
new SqlParameter("@id", id)
};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Memos me = new Memos();
me.ID = Convert.ToInt32(dr["ID"]);
me.UserName = dr["UserName"].ToString();
me.TelPhone = dr["TelPhone"].ToString();
//me.Cop = dr["Cop"].ToString();
me.Cop = (Convert.IsDBNull(dr["Cop"]) ? "" : Convert.ToString(dr["Cop"]));
me.Email = dr["Email"].ToString();
//me.Zhiwei = dr["Zhiwei"].ToString();
me.SubTime = dr["SubTime"].ToString();
list.Add(me);
}
return(list);
}
public List <NsyNews> GetNsyNewList(Pages pg)
{
List <NsyNews> list = new List <NsyNews>();
string sql = "proc_NsyNews_fenye";
SqlParameter[] para =
{
new SqlParameter("@pageIndex", pg.PageIndex),
new SqlParameter("@pageSize", pg.PagesSize),
new SqlParameter("@ListName", pg.types),
new SqlParameter("@require", pg.Tiaojian)
};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
NsyNews news = new NsyNews();
news.ID = Convert.ToInt32(dr["ID"]);
news.Title = dr["Title"].ToString();
news.Contents = dr["Contents"].ToString();
news.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(news);
}
return(list);
}
/// <summary>
/// 获得案例列表（分页）
/// </summary>
/// <param name="pg"></param>
/// <returns></returns>
public List <BoutiqueCase> GetBoutiqueCaseList(Pages pg)
{
List <BoutiqueCase> list = new List <BoutiqueCase>();
string sql = "proc_BoutiqueCase_fenye";
SqlParameter[] para =
{
new SqlParameter("@pageIndex", pg.PageIndex),
new SqlParameter("@pageSize", pg.PagesSize),
new SqlParameter("@ListName", pg.types),
new SqlParameter("@require", pg.Tiaojian)
};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
BoutiqueCase bcase = new BoutiqueCase();
bcase.ID = Convert.ToInt32(dr["ID"]);
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();
bcase.AddTime = Convert.ToDateTime(dr["AddTime"]);
list.Add(bcase);
}
return(list);
}
/// <summary>
/// 获得观点列表
/// </summary>
/// <param name="pg"></param>
/// <returns></returns>
public List <ViewPointExtend> GetViewPointList(Pages pg)
{
List <ViewPointExtend> list = new List <ViewPointExtend>();
string sql = "proc_ViewPoint_fenye";
SqlParameter[] para =
{
new SqlParameter("@pageIndex", pg.PageIndex),
new SqlParameter("@pageSize", pg.PagesSize),
new SqlParameter("@ListName", pg.types),
new SqlParameter("@require", pg.Tiaojian),
new SqlParameter("@id", pg.id)
};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ViewPointExtend vp = new ViewPointExtend();
vp.ID = Convert.ToInt32(dr["ID"]);
vp.Title = dr["Title"].ToString();
vp.AddTime = Convert.ToDateTime(dr["AddTime"]);
vp.TypeName = dr["TpName"].ToString();
vp.Istop = Convert.ToInt32(dr["Istop"]);
list.Add(vp);
}
return(list);
}
/// <summary>
/// 读取一条
/// </summary>
/// <returns></returns>
public FriendShip GetLinks(int d)
{
FriendShip fir = new FriendShip();
string sql = "proc_get_FriendShip";
SqlParameter[] para =
{
new SqlParameter("@id", d)
};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
DataRow dr = ds.Tables[0].Rows[0];
fir.Fword = dr["Fword"].ToString();
fir.FUrl = dr["FUrl"].ToString();
fir.AddTime = Convert.ToDateTime(dr["AddTime"]);
return(fir);
}
//查询
public List <Recruitment> GetRecruitmentList()
{
List <Recruitment> list = new List <Recruitment>();
string sql = "pro_Get_Recruitment";
SqlParameter[] para = {};
DataSet ds = DbHelper.GetDataSetByProc(sql, para);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Recruitment _info = new Recruitment();
_info.ID = Convert.ToInt32(dr["ID"]);
_info.rcontents = dr["rcontents"].ToString();
list.Add(_info);
}
return(list);
}