public string GetMaxNewsId()
{
string sql = "select Max(Newsid)as Newsid from NewsTab";
DataSet set = DBHelpe.Query(sql);
string par = "";
foreach (DataRow row in set.Tables[0].Rows)
{
par = row["Newsid"].ToString().Trim();
}
return(par);
}
public Tz888.Model.NewsTypeTab GetNewsTypeByTypeId(int typeId)
{
string sql = "select TypeID ,TypeName from NewsTypeTab where TypeID=@typeid";
DataSet set = DBHelpe.Query(sql, new SqlParameter("typeid", typeId));
Tz888.Model.NewsTypeTab newstypetab = null;
foreach (DataRow row in set.Tables[0].Rows)
{
newstypetab = new Tz888.Model.NewsTypeTab();
newstypetab.TypeID = Convert.ToInt32(row["TypeID"]);
newstypetab.TypeName = row["TypeName"].ToString().Trim();
}
return(newstypetab);
}
//通过ID获取一个实体对象
public ErrowTab GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,LoginName,createtime,updatetime from ErrowTab ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
ErrowTab model = new ErrowTab();
DataSet ds = DBHelpe.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.LinkURL = ds.Tables[0].Rows[0]["LinkURL"].ToString();
model.QuestionDescript = ds.Tables[0].Rows[0]["QuestionDescript"].ToString();
model.Connetions = ds.Tables[0].Rows[0]["Connetions"].ToString();
if (ds.Tables[0].Rows[0]["BoolChuLi"].ToString() != "")
{
model.BoolChuLi = int.Parse(ds.Tables[0].Rows[0]["BoolChuLi"].ToString());
}
if (ds.Tables[0].Rows[0]["BoolReturn"].ToString() != "")
{
model.BoolReturn = int.Parse(ds.Tables[0].Rows[0]["BoolReturn"].ToString());
}
model.ReturnContext = ds.Tables[0].Rows[0]["ReturnContext"].ToString();
model.Descript = ds.Tables[0].Rows[0]["Descript"].ToString();
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.createtime = ds.Tables[0].Rows[0]["createtime"].ToString();
}
if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
{
model.updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString();
}
return(model);
}
else
{
return(null);
}
}
public List <Tz888.Model.NewsTypeTab> GetAllNewsType()
{
string sql = "select TypeID ,TypeName from NewsTypeTab where BoolStar=1 and outid=1";
List <Tz888.Model.NewsTypeTab> list = new List <NewsTypeTab>();
DataSet set = null;
set = DBHelpe.Query(sql);
foreach (DataRow row in set.Tables[0].Rows)
{
Tz888.Model.NewsTypeTab newstypetab = new Tz888.Model.NewsTypeTab();
newstypetab.TypeID = Convert.ToInt32(row["TypeID"]);
newstypetab.TypeName = row["TypeName"].ToString().Trim();
list.Add(newstypetab);
}
return(list);
}
//获取实体对象集合
public List <ErrowTab> GetModelList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,LinkURL,QuestionDescript,Connetions,BoolChuLi,BoolReturn,ReturnContext,Descript,LoginName,createtime,updatetime from ErrowTab ");
List <ErrowTab> list = new List <ErrowTab>();
DataSet ds = DBHelpe.Query(strSql.ToString());
foreach (DataRow row in ds.Tables[0].Rows)
{
ErrowTab model = new ErrowTab();
if (row["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.LinkURL = ds.Tables[0].Rows[0]["LinkURL"].ToString();
model.QuestionDescript = ds.Tables[0].Rows[0]["QuestionDescript"].ToString();
model.Connetions = ds.Tables[0].Rows[0]["Connetions"].ToString();
if (ds.Tables[0].Rows[0]["BoolChuLi"].ToString() != "")
{
model.BoolChuLi = int.Parse(ds.Tables[0].Rows[0]["BoolChuLi"].ToString());
}
if (ds.Tables[0].Rows[0]["BoolReturn"].ToString() != "")
{
model.BoolReturn = int.Parse(ds.Tables[0].Rows[0]["BoolReturn"].ToString());
}
model.ReturnContext = ds.Tables[0].Rows[0]["ReturnContext"].ToString();
model.Descript = ds.Tables[0].Rows[0]["Descript"].ToString();
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.createtime = ds.Tables[0].Rows[0]["createtime"].ToString();
}
if (ds.Tables[0].Rows[0]["updatetime"].ToString() != "")
{
model.updatetime = ds.Tables[0].Rows[0]["updatetime"].ToString();
}
list.Add(model);
}
return(list);
}
public Tz888.Model.NewsTab GetNewsTabByNewId(int NewId)
{
string sql = "select * from NewsTab where Newsid=@newid";
Tz888.Model.NewsTab newstab = null;
DataSet set = DBHelpe.Query(sql, new SqlParameter("newid", NewId));
foreach (DataRow row in set.Tables[0].Rows)
{
newstab = new Tz888.Model.NewsTab();
newstab.Newsid = Convert.ToInt32(row["Newsid"]);
newstab.NTitle = row["NTitle"].ToString().Trim();
newstab.UserName = row["UserName"].ToString().Trim();
newstab.TypeID = Convert.ToInt32(row["TypeID"]);
newstab.Audit = Convert.ToInt32(row["Audit"]);
newstab.FromID = Convert.ToInt32(row["FromID"]);
newstab.Urlhtml = row["urlhtml"].ToString().Trim();
newstab.Createdate = row["Createdate"].ToString().Trim();
newstab.RecommendID = Convert.ToInt32(row["RecommendID"]);
}
return(newstab);
}
public Tz888.Model.NewsViewTab GetNewsViewByNewId(int NewId)
{
string sql = "select * from NewsViewTab where Newsid=@newid";
Tz888.Model.NewsViewTab newsviewtab = null;
DataSet set = DBHelpe.Query(sql, new SqlParameter("newid", NewId));
foreach (DataRow row in set.Tables[0].Rows)
{
newsviewtab = new Tz888.Model.NewsViewTab();
newsviewtab.NViewID = Convert.ToInt32(row["NViewID"]);
newsviewtab.Newsid = newstab.GetNewsTabByNewId(Convert.ToInt32(row["Newsid"]));
newsviewtab.Title = row["Title"].ToString().Trim();
newsviewtab.Keywords = row["Keywords"].ToString().Trim();
newsviewtab.Description = row["Description"].ToString().Trim();
newsviewtab.NewView = row["NewView"].ToString().Trim();
newsviewtab.Formid = row["form"].ToString().Trim();
newsviewtab.Author = row["Author"].ToString().Trim();
newsviewtab.Zhaiyao = row["Zhaiyao"].ToString().Trim();
}
return(newsviewtab);
}
public string GetStringPerson(string name, int status, int index, int loantype, string loanstitles)
{
string loansinfoIds = "";
string loansTitles = "";
string loanscreatetimes = "";
string loanstypes = "";
string LoginNames = "";
string auditings = "";
string htmls = "";
string updatetimes = "";
StringBuilder sb = new StringBuilder();
string sdt = " and 1=1";
if (loanstitles != "")
{
sdt += " and NTitle like '" + loanstitles + "%'";
}
if (loantype != -1)
{
sdt += " and TypeID=" + loantype + "";
}
string sql = "select top 20 Newsid,UserName,NTitle,TypeID,audit,urlhtml,createdate,recommendID from NewsTab where "
+ " audit=@statu and UserName=@name " + sdt + " and Newsid not in (select top " + 20 * index + " Newsid from NewsTab where audit=@statu " + sdt + " and UserName=@name"
+ " order by createdate desc) order by createdate desc";
SqlParameter[] para =
{
new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@statu", SqlDbType.Int, 4)
};
para[0].Value = name;
para[1].Value = status;
DataSet ds = DBHelpe.Query(sql, para);
sb.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><thead><tr>");
sb.Append("<td width=\"12%\"><a href=\"javascript:SelectAll();\">全选</a>│<a href=\"javascript:ReSelect();\">反选</a></td>");
sb.Append("<td width=\"8%\">类别</td>");
sb.Append("<td width=\"20%\">标题</td>");
sb.Append("<td width=\"12%\">发布时间</td>");
sb.Append("<td width=\"12%\">是否推荐</td>");
sb.Append("<td width=\"33%\">管理</td></tr></thead>");
if (ds != null & ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < (ds.Tables[0].Rows.Count > 20 ? 20 : ds.Tables[0].Rows.Count); i++)
{
DataRow row = ds.Tables[0].Rows[i];
loansinfoIds = row["Newsid"].ToString().Trim(); //编号
loansTitles = row["NTitle"].ToString().Trim(); //标题
loanscreatetimes = row["createdate"].ToString().Trim(); // 发布时间
loanstypes = row["TypeID"].ToString().Trim(); // 类别
LoginNames = row["UserName"].ToString().Trim(); // 用户名
auditings = row["audit"].ToString().Trim(); //审核状态
htmls = row["urlhtml"].ToString().Trim(); // html
updatetimes = row["recommendID"].ToString().Trim(); // 是否推荐
DateTime beg = Convert.ToDateTime(loanscreatetimes);
string begTime = beg.ToString("yyyy-MM-dd");
sb.Append("<tr><td><input id=\"cbxSelect\" name=\"cbxSelect\" type=\"checkbox\" value=\"" + loansinfoIds + "\" /></td>");
sb.Append("<td>" + SetDaikuanType(loanstypes) + "</td>");
sb.Append("<td><span class=\"lanl\"><a href='http://www.topfo.com/" + htmls + "' target=\"_blank\" class=\"lan1\" title='" + loansTitles + "'>" + StrLength(loansTitles) + "</a></span></td>");
sb.Append("<td>" + begTime + "</td>");
sb.Append("<td>" + Tuijian(updatetimes) + "</td>");
sb.Append("<td>");
sb.Append("<a href='javascript:updateloans(" + 0 + "," + loansinfoIds + ");' class=\"lan1\">修改</a> ");
sb.Append("<a href='javascript:DelNav(" + loansinfoIds + ");' onclick='javascript:Del()' class=\"lan1\">删除</a></td></tr>");
}
}
sb.Append("</table>");
return(sb.ToString());
}
