public int InsertNewsTab(Tz888.Model.NewsTab newstab, Tz888.Model.NewsTypeTab newstypetab, Tz888.Model.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_InsertList", parameters, out rowsAffected);
return(rowsAffected);
}
public int UpdateNewTypeTab(Tz888.Model.NewsTypeTab newstypetab)
{
return(newstabdal.UpdateNewTypeTab(newstypetab));
}
public int InsertNewsTab(Tz888.Model.NewsTab newstab, Tz888.Model.NewsTypeTab newstypetab, Tz888.Model.NewsViewTab newsviewtab)
{
return(newstabdal.InsertNewsTab(newstab, newstypetab, newsviewtab));
}
public string SetDaikuanType(string loanstypes)
{
Tz888.SQLServerDAL.news.NewsTypeTabDAL newtype = new Tz888.SQLServerDAL.news.NewsTypeTabDAL();
Tz888.Model.NewsTypeTab newtypemod = newtype.GetNewsTypeByTypeId(Convert.ToInt32(loanstypes.Trim()));
return(newtypemod.TypeName.ToString());
}
