public int UpdateNewTypeTab(GZS.Model.news.NewsTypeTab newstypetab)
{
string sql = "update NewsTypeTab set TypeName=@typename,BoolStar=@boolstar,outid=@outid where TypeID=@typeid";
SqlParameter[] ps = new SqlParameter[] { new SqlParameter("typename", newstypetab.TypeName), new SqlParameter("boolstar", newstypetab.BoolStar), new SqlParameter("outid", newstypetab.Outid), new SqlParameter("typeid", newstypetab.TypeID) };
int result = DBHelper.ExecuteCommand(sql, ps);
return(result);
}
public int InsertNewTypeTab(GZS.Model.news.NewsTypeTab newstypetab)
{
string sql = "Insert into NewsTypeTab (TypeName,BoolStar,outid) values(@typename,@boolstar,@outid)";
SqlParameter[] ps = new SqlParameter[] { new SqlParameter("typename", newstypetab.TypeName), new SqlParameter("boolstar", newstypetab.BoolStar), new SqlParameter("outid", newstypetab.Outid) };
int result = DBHelper.ExecuteCommand(sql, ps);
return(result);
}
public GZS.Model.news.NewsTypeTab GetNewsTypeByTypeId(int typeId)
{
string sql = "select TypeID ,TypeName,BoolStar,outid from NewsTypeTab where TypeID=@typeid ";
DataSet set = DBHelper.Query(sql, new SqlParameter("typeid", typeId));
GZS.Model.news.NewsTypeTab newstypetab = null;
foreach (DataRow row in set.Tables[0].Rows)
{
newstypetab = new GZS.Model.news.NewsTypeTab();
newstypetab.TypeID = Convert.ToInt32(row["TypeID"]);
newstypetab.TypeName = row["TypeName"].ToString().Trim();
newstypetab.BoolStar = Convert.ToInt32(row["BoolStar"].ToString().Trim());
newstypetab.Outid = Convert.ToInt32(row["Outid"].ToString().Trim());
}
return(newstypetab);
}
public List <GZS.Model.news.NewsTypeTab> GetAllNewsType()
{
string sql = "select TypeID ,TypeName from NewsTypeTab where BoolStar=1";
List <GZS.Model.news.NewsTypeTab> list = new List <GZS.Model.news.NewsTypeTab>();
DataSet set = null;
set = DBHelper.Query(sql);
foreach (DataRow row in set.Tables[0].Rows)
{
GZS.Model.news.NewsTypeTab newstypetab = new GZS.Model.news.NewsTypeTab();
newstypetab.TypeID = Convert.ToInt32(row["TypeID"]);
newstypetab.TypeName = row["TypeName"].ToString().Trim();
list.Add(newstypetab);
}
return(list);
}
public int InsertNewsTab(GZS.Model.news.NewsTab newstab, GZS.Model.news.NewsTypeTab newstypetab, GZS.Model.news.NewsViewTab newsviewtab)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 200),
new SqlParameter("@NTitle", SqlDbType.VarChar, 200),
new SqlParameter("@audit", SqlDbType.Int, 4),
new SqlParameter("@FromID", SqlDbType.Int, 4),
new SqlParameter("@urlhtml", SqlDbType.VarChar, 200),
new SqlParameter("@createdate", SqlDbType.DateTime),
new SqlParameter("@title", SqlDbType.VarChar, 200),
new SqlParameter("@keywords", SqlDbType.VarChar, 200),
new SqlParameter("@description", SqlDbType.VarChar, 200),
new SqlParameter("@NewView", SqlDbType.Text, 10000),
new SqlParameter("@form", SqlDbType.VarChar, 2000),
new SqlParameter("@author", SqlDbType.VarChar, 200),
new SqlParameter("@zhaiyao", SqlDbType.VarChar, 200),
new SqlParameter("@recommendID", SqlDbType.Int, 4),
new SqlParameter("@ImagesUrls", SqlDbType.NVarChar, 400)
};
parameters[0].Value = newstab.TypeID;
parameters[1].Value = newstab.UserName;
parameters[2].Value = newstab.NTitle;
parameters[3].Value = newstab.Audit;
parameters[4].Value = newstab.FromID;
parameters[5].Value = newstab.Urlhtml;
parameters[6].Value = newstab.Createdate;
parameters[7].Value = newsviewtab.Title;
parameters[8].Value = newsviewtab.Keywords;
parameters[9].Value = newsviewtab.Description;
parameters[10].Value = newsviewtab.NewView;
parameters[11].Value = newsviewtab.Formid;
parameters[12].Value = newsviewtab.Author;
parameters[13].Value = newsviewtab.Zhaiyao;
parameters[14].Value = newstab.RecommendID;
parameters[15].Value = newstab.Imagesurls;
DBHelper.RunProcedure("NewsTab_Insert", parameters, out rowsAffected);
return(rowsAffected);
}
public int InsertNewsTab(GZS.Model.news.NewsTab newstab, GZS.Model.news.NewsTypeTab newstypetab, GZS.Model.news.NewsViewTab newsviewtab)
{
return(newstabdal.InsertNewsTab(newstab, newstypetab, newsviewtab));
}
public int UpdateNewTypeTab(GZS.Model.news.NewsTypeTab newstypetab)
{
return(newstabdal.UpdateNewTypeTab(newstypetab));
}