/// <summary>
/// 获得某条的信息,通过属性返回数据
/// </summary>
/// <param name="InfoID">信息ID</param>
/// <returns>如果操作成功返回true，否则返回false</returns>
public virtual bool HasGetInfoItemForManage(long InfoID)
{
bool blRet = false;
try
{
long PageCount = 0;
long CurrentPage = 1;
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = mCF.GetListSet(
"MainInfoTabList",
"*",
"(InfoID=" + InfoID.ToString() + ")",
"publishT DESC, InfoID ASC",
ref CurrentPage,
1,
ref PageCount);
if (dv != null && dv.Count == 1)
{
//Fill(dv);
blRet = true;
}
}
catch (Exception err)
{
throw err;
}
return(blRet);
}
/// <summary>
/// 获取全部的信息列表“显示在网站前台”
/// </summary>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>返回全部的信息列表，查询记录的总页数</returns>
public virtual DataView GetInfoListForFrontView(
string Criteria,
ref long CurrentPage,
long PageSize,
ref long PageCount // 返回该查询有多少条记录
)
{
if (Criteria.Trim() != "")
{
Criteria = "(" + Criteria + " AND DelStatus=0 AND AuditingStatus=1)";
}
else
{
Criteria = "(DelStatus=0 AND AuditingStatus=1)";
}
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"MainInfoTabList",
"*",
Criteria,
"publishT DESC, InfoID ASC",
ref CurrentPage,
PageSize,
ref PageCount));
}
public virtual DataView GetInfoFrontList(
string SelectCol,
string Criteria,
ref long CurrentPage,
long PageSize,
ref long PageCount // 返回该查询有多少条记录
)
{
if (Criteria.Trim() != "")
{
Criteria = "(" + Criteria + " AND DelStatus=0)";
}
else
{
Criteria = "(DelStatus=0)";
}
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"MainInfoTab_FrontList",
SelectCol,
Criteria,
"ApproveTime DESC, InfoID ASC",
ref CurrentPage,
PageSize,
ref PageCount));
}
/// <summary>
/// 获取某个具体的个人发布的信息“我的信息”
/// </summary>
/// <param name="loginName">用户的登陆名</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>具体的个人发布的信息列表，查询记录的总页数</returns>
public virtual DataView GetInfoListBySelf(
string Criteria,
string loginName,
ref long CurrentPage,
long PageSize,
ref long PageCount // 返回该查询有多少条记录
)
{
if (Criteria.Trim() != "")
{
Criteria = "(" + Criteria + " AND LoginName='" + loginName + "' AND DelStatus=0)";
}
else
{
Criteria = "(LoginName='" + loginName + "' AND DelStatus=0)";
}
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"MainInfoTabList",
"*",
Criteria,
"publishT DESC, InfoID ASC",
ref CurrentPage,
PageSize,
ref PageCount));
}
public DataSet dsGetNewsList(string SelectStr, string Criteria, string Sort, long Page, long CurrentPageRow, ref long TotalCount)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.dsGetListNewsTopNums(
"NewsTabViewList",
SelectStr,
Criteria,
Sort,
Page,
CurrentPageRow,
ref TotalCount));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询条件</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>查询列表</returns>
public DataView GetList(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
Common.CommonFunction comm = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = comm.GetList("CommendTabList", "ID", SelectCol, Criteria, OrderBy, ref CurrentPage, PageSize, ref PageCount);
return(dv);
}
/// <summary>
/// 取得会员
/// </summary>
/// <returns></returns>
public DataView GetMemberInfoByLoginName(string LoginName)
{
long tintCurrentPage = 1;
long intCurrentPageSize = 10;
long tintTotalCount = 0;
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = mCF.GetListSet("MemberPreVIW_list", "*", "LoginName='" + LoginName + "'",
"LoginName ASC",
ref tintCurrentPage,
(long)intCurrentPageSize,
ref tintTotalCount);
return(dv);
}
/// <summary>
/// 查询对应记录
/// </summary>
/// <param name="Key">关键字</param>
/// <returns>是否操作成功（true成功，false失败）</returns>
public bool GetDetail(string Key)
{
long PageCount = 0;
long CurrentPage = 1;
Common.CommonFunction comm = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = comm.GetList("CommendTabList", "ID", "*", "(ID=" + Key.Trim() + ")", "ID Asc", ref CurrentPage, 1, ref PageCount);
if (dv != null && dv.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 评论信息列表
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询条件</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>查询列表</returns>
public DataView InfoCommentList(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"InfoComment_list",
SelectCol,
Criteria,
OrderBy,
ref CurrentPage,
PageSize,
ref PageCount));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询条件</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>查询列表</returns>
public DataView GetListForMemberKeyword(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"KeywordForMemberTabList",
SelectCol,
Criteria,
OrderBy,
ref CurrentPage,
PageSize,
ref PageCount));
}
/// <summary>
/// 网站精华查询列表
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询条件</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>头条查询列表</returns>
public virtual DataView GetWebTrendList(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"WebTrend_Front_List",
SelectCol,
Criteria,
OrderBy,
ref CurrentPage,
PageSize,
ref PageCount));
}
public virtual DataView GetRefreshList(
string SelectCol,
string Criteria,
string Sort,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSet(
"GetRefreshList",
SelectCol,
Criteria,
"FrontDisplayTime DESC",
ref CurrentPage,
PageSize,
ref PageCount));
}
/// <summary>
/// 获取投资的查询结果列表
/// </summary>
/// <param name="SelectCol"></param>
/// <param name="Criteria"></param>
/// <param name="CurrentPage"></param>
/// <param name="PageSize"></param>
/// <param name="PageCount"></param>
/// <returns></returns>
public virtual DataView GetSearchResultCapital(
string SelectCol,
string Criteria,
ref long CurrentPage,
long PageSize,
ref long PageCount // 返回该查询有多少条记录
)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetListSetForFirstTopNum(
"CapitalInfo_List_NoIndex",
SelectCol,
Criteria,
"MemberGradeID desc,InfoID asc ",
ref CurrentPage,
PageSize,
0,
ref PageCount));
}
/// <summary>
/// 查询推荐的次数
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询推荐的信息ID号</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>查询列表</returns>
public int GetListCount(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
int count = 0;
Common.CommonFunction comm = new Tz888.SQLServerDAL.Common.CommonFunction();
DataTable dt = comm.GetDataTable("CommendTabList", SelectCol, Criteria, OrderBy, ref CurrentPage, PageSize, ref PageCount);
if (dt != null && dt.Rows != null)
{
count = dt.Rows.Count;
}
return(count);
}
/// <summary>
/// 获取DataSet类型的资讯查询结果列表
/// </summary>
/// <param name="SelectCol"></param>
/// <param name="Criteria"></param>
/// <param name="CurrentPage"></param>
/// <param name="PageSize"></param>
/// <param name="PageCount"></param>
/// <returns></returns>
public DataTable dsGetSearchResultNews(
string SelectCol,
string Criteria,
string SortBy,
ref long CurrentPage,
long PageSize,
ref long PageCount
)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetDataTable(
"NewsTabList",
SelectCol,
Criteria,
SortBy,
ref CurrentPage,
PageSize,
ref PageCount));
}
/// <summary>
/// 获取DataSet类型的招商查询结果列表
/// </summary>
/// <param name="SelectCol"></param>
/// <param name="Criteria"></param>
/// <param name="CurrentPage"></param>
/// <param name="PageSize"></param>
/// <param name="PageCount"></param>
/// <returns></returns>
public DataSet dsGetSearchResultMerchant(
string SelectCol,
string Criteria,
string SortBy,
ref long CurrentPage,
long PageSize,
ref long PageCount // 返回该查询有多少条记录
)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.dsGetListSetForFirstTopNum(
"MerchantInfo_List_NoIndex",
SelectCol,
Criteria,
SortBy,
ref CurrentPage,
PageSize,
0,
ref PageCount));
}
/// <summary>
/// 获取全部的信息列表
/// </summary>
/// <param name="mySql">连接数据库类</param>
/// <param name="FNStrName">函数字符串</param>
/// <param name="Key">关键字</param>
/// <param name="SelectStr">选择列字符串</param>
/// <param name="Criteria">查询条件</param>
/// <param name="Sort">排序字符串</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="TotalCount">通过该查询条件，返回的查询记录的总页数</param>
/// <returns>返回当前页的信息列表</returns>
public DataView GetList(
string FNStrName,
string Key,
string SelectStr,
string Criteria,
string Sort,
ref long CurrentPage,
long PageSize,
ref long TotalCount
)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetList(
FNStrName,
Key,
SelectStr,
Criteria,
Sort,
ref CurrentPage,
PageSize,
ref TotalCount
));
}
/// <summary>
/// 用视图查询专业服务信息
/// </summary>
/// <param name="SelectStr"></param>
/// <param name="Criteria">条件</param>
/// <param name="Sort">排序</param>
/// <param name="Page">每页显示多少条</param>
/// <param name="CurrentPageRow"></param>
/// <param name="TotalCount">总数</param>
/// <returns></returns>
public DataSet GetProViewInfoAll(string SelectStr, string Criteria, string Sort, long Page, long CurrentPageRow, ref long TotalCount)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
// return (mCF.dsGetListNewsTopNums("ProfessionalServiceList", SelectStr, Criteria, Sort, Page, CurrentPageRow, ref TotalCount));
return(mCF.dsGetListNewsTopNums("ProfessionalinfoTab", SelectStr, Criteria, Sort, Page, CurrentPageRow, ref TotalCount));
}
public Tz888.Model.Search.SearchInfo objGetSearchInfoByInfoID(long InfoID)
{
Tz888.Model.Search.SearchInfo sI = new Tz888.Model.Search.SearchInfo();
long PageCount = 0;
long CurrentPage = 1;
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
DataView dv = mCF.GetListSet(
"MainInfoTabList",
"*",
"(InfoID=" + InfoID.ToString() + ")",
"publishT DESC, InfoID ASC",
ref CurrentPage,
1,
ref PageCount);
if (dv != null && dv.Count == 1)
{
sI.InfoID = Convert.ToInt64(dv[0]["InfoID"]);
sI.Title = dv[0]["Title"].ToString().Trim();
sI.InfoCode = dv[0]["InfoCode"].ToString().Trim();
sI.PublishDate = Convert.ToDateTime(dv[0]["publishT"]);
sI.Hit = Convert.ToInt64(dv[0]["Hit"]);
sI.InfoTypeID = dv[0]["InfoTypeID"].ToString().Trim();
sI.IsCore = Convert.ToBoolean(dv[0]["IsCore"]);
sI.IndexOrderNum = Convert.ToInt64(dv[0]["IndexOrderNum"]);
sI.IndexTopValidateDate = Convert.ToInt32(dv[0]["IndexTopValidateDate"]);
sI.IndexPicInfoNum = Convert.ToInt64(dv[0]["IndexPicInfoNum"]);
sI.IndexPicInfoNum = Convert.ToInt64(dv[0]["InfoTypeOrderNum"]);
sI.InfoTypeTopValidateDate = Convert.ToInt32(dv[0]["InfoTypeTopValidateDate"]);
sI.InfoTypePicInfoNum = Convert.ToInt64(dv[0]["InfoTypePicInfoNum"]);
sI.LoginName = dv[0]["LoginName"].ToString().Trim();
sI.InfoOriginRoleName = dv[0]["InfoOriginRoleName"].ToString().Trim();
sI.GradeID = dv[0]["GradeID"].ToString().Trim();
sI.GradeName = dv[0]["GradeName"].ToString().Trim();
sI.FixPriceID = dv[0]["FixPriceID"].ToString().Trim();
sI.FixPriceName = dv[0]["FixWorthPointName"].ToString().Trim();
sI.FeeStatus = Convert.ToByte(dv[0]["FeeStatus"]);
sI.AuditingStatus = Convert.ToByte(dv[0]["AuditingStatus"]);
sI.DelStatus = Convert.ToByte(dv[0]["DelStatus"]);
sI.ApproveBy = Convert.ToString(dv[0]["ApproveBy"]);
sI.ContentKeyword = dv[0]["ContentKeyword"].ToString().Trim();
sI.KeyWord = dv[0]["KeyWord"].ToString().Trim();
sI.Descript = dv[0]["Descript"].ToString().Trim();
sI.DisplayTitle = dv[0]["DisplayTitle"].ToString().Trim();
sI.FrontDisplayTime = Convert.ToDateTime(dv[0]["FrontDisplayTime"].ToString().Trim());
sI.ValidateStartTime = Convert.ToDateTime(dv[0]["ValidateStartTime"].ToString().Trim());
sI.ValidateTerm = Convert.ToInt32(dv[0]["ValidateTerm"].ToString().Trim());
if (sI.ValidateTerm == 0)
{
sI.ValidateTerm = 12;
}
sI.TemplateID = dv[0]["TemplateID"].ToString().Trim();
sI.HtmlFile = dv[0]["HtmlFile"].ToString().Trim();
if (dv[0]["UserEvaluation"].ToString() == null || dv[0]["UserEvaluation"].ToString() == "")
{
sI.UserEvaluation = 0;
}
else
{
sI.UserEvaluation = Convert.ToInt32(dv[0]["UserEvaluation"]);
}
//新添加主表
sI.IsIntegralInfo = Convert.ToInt16(dv[0]["IsIntegralInfo"]);
sI.MainPointCoun = Convert.ToSingle(dv[0]["MainPointCount"]);
sI.MainEvaluation = Convert.ToInt32(dv[0]["MainEvaluation"]);
}
return(sI);
}
