public int UpdateNewsTab(GZS.Model.news.NewsTab newstab, int newsid) { string sql = "Update NewsTab set NTitle=@ntitle ,TypeID=@typeid,Audit=@audit,urlhtml=@urlhtml,Reason=@Reason,RecommendID=@RecommendID where Newsid=@Newsid "; SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@ntitle", newstab.NTitle) , new SqlParameter("@typeid", newstab.TypeID) , new SqlParameter("@audit", newstab.Audit) , new SqlParameter("@urlhtml", newstab.Urlhtml) , new SqlParameter("@Reason", newstab.Reason) , new SqlParameter("@RecommendID", newstab.RecommendID) , new SqlParameter("@Newsid", newsid) }; int result = DBHelper.ExecuteSql(sql, ps); return(result); }
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 List <GZS.Model.news.NewsTab> GetNewsTabAllByUserName(string UserName) { string sql = "select Newsid,UserName,NTitle,TypeID,audit,FromID,urlhtml,createdate,recommendID,reason,ImagesUrls from NewsTab where UserName=@UserName order by createdate desc"; List <GZS.Model.news.NewsTab> list = new List <GZS.Model.news.NewsTab> (); DataSet set = DBHelper.Query(sql, new SqlParameter("@UserName", UserName)); foreach (DataRow row in set.Tables[0].Rows) { GZS.Model.news.NewsTab newstab = new GZS.Model.news.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"].ToString().Trim()); newstab.Reason = row["Reason"].ToString().Trim(); newstab.Imagesurls = row["Imagesurls"].ToString().Trim(); list.Add(newstab); } return(list); }
public GZS.Model.news.NewsTab GetNewsTabByNewId(int NewId) { string sql = "select Newsid,UserName,NTitle,TypeID,audit,FromID,urlhtml,createdate,recommendID,reason,ImagesUrls from NewsTab where Newsid=@newid"; GZS.Model.news.NewsTab newstab = null; DataSet set = DBHelper.Query(sql, new SqlParameter("newid", NewId)); foreach (DataRow row in set.Tables[0].Rows) { newstab = new GZS.Model.news.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"].ToString().Trim()); newstab.Reason = row["Reason"].ToString().Trim(); newstab.Imagesurls = row["Imagesurls"].ToString().Trim(); } return(newstab); }
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 UpdateNewsTab(GZS.Model.news.NewsTab newstab, int newsid) { return(newstabdal.UpdateNewsTab(newstab, newsid)); }
/// <summary> ///创建贷款静态页面 /// </summary> public int StaticHtml(int newsid, string loginname) { try { string TempFileName = CasesTem.ToString(); string Tem = Compage.Reader(TempFileName); //读取模板内容 string TempSoure = Tem; GZS.Model.news.NewsTab newstab = newstabbll.GetNewsTabByNewId(newsid); GZS.Model.news.NewsViewTab newsviewtab = newsviewtabbll.GetNewsViewByNewId(newsid); string titlelist = sethtmls(); string context = sethtml(); string tupianss = newstab.Imagesurls; string tupians = ""; string[] num = tupianss.Split('$'); for (int t = 0; t < num.Length; t++) { if (num[t].Trim() != "") { tupians += "<input type=\"image\" id=\"" + num[t].Trim() + "\" src=\"" + tupianlu + "" + num[t].Trim() + "\"/>"; } } string contextname = newsviewtab.NewView.ToString().Replace("/images/", "crm.topfo.com/images/").ToString(); TempSoure = TempSoure.Replace("$infoID$", newsid.ToString().Trim()); TempSoure = TempSoure.Replace("$NewsTitle$", newstab.NTitle.ToString().Trim()); TempSoure = TempSoure.Replace("$Createtime$", newstab.Createdate.Substring(0, 9).Trim()); TempSoure = TempSoure.Replace("$FormId$", newsviewtab.Formid.ToString().Trim()); TempSoure = TempSoure.Replace("$Author$", newsviewtab.Author.ToString().Trim()); TempSoure = TempSoure.Replace("$ZhaiYao$", newsviewtab.Zhaiyao.ToString().Trim()); TempSoure = TempSoure.Replace("$NewsView$", contextname); TempSoure = TempSoure.Replace("$tupian$", tupians); TempSoure = TempSoure.Replace("$TitleList$", titlelist.ToString().Trim()); TempSoure = TempSoure.Replace("$Context$", context.ToString().Trim()); TempSoure = TempSoure.Replace("$DisplayTitle$", newsviewtab.Title.ToString().Trim()); TempSoure = TempSoure.Replace("$KeyWord$", newsviewtab.Keywords.ToString().Trim()); TempSoure = TempSoure.Replace("$description$", newsviewtab.Description.ToString().Trim()); string inPathTo = "/news"; string htmlFile = newstab.Urlhtml.ToString().Trim(); string[] html = htmlFile.Split('/'); string[] nn = html[2].Split('_'); string cc = nn[0].Substring(nn[0].Length - 8); string wenjian = MerchantTmpPathTo + html[1].Replace("news", ""); if (Directory.Exists(wenjian) == false) { Directory.CreateDirectory(wenjian); } string htmlpaths = wenjian + inPathTo + cc + "_" + newsid + ".shtml"; Compage.Writer(htmlpaths, TempSoure); return(1); } catch (Exception e) { return(0); } }