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()); }