/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_SelType model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@TypeID", SqlDbType.Int, 4), new SqlParameter("@TypeName", SqlDbType.VarChar, 50), new SqlParameter("@BumID", SqlDbType.VarChar, 50), new SqlParameter("@BumName", SqlDbType.VarChar, 50), new SqlParameter("@BumUrl", SqlDbType.VarChar, 50), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@IsDel", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.TypeName; parameters[2].Value = model.BumID; parameters[3].Value = model.BumName; parameters[4].Value = model.Url; parameters[5].Value = model.ParentID; parameters[6].Value = model.IsDel; DbHelperSQL.RunProcedure("Tunnel_SelType_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }
/// <summary> /// 文章列表 文章浏览 公告栏 新闻栏 /// </summary> /// <param name="num"></param> public void WriteSiteMap() { if (!string.IsNullOrEmpty(Request.QueryString["bum_id"])) { Master.FindControl("Panel1").Visible = false; System.Web.UI.HtmlControls.HtmlGenericControl div = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Panel2"); string str = div.InnerHtml; div.Visible = true; Style sty = new Style(); div.Style.Add(HtmlTextWriterStyle.Display, "''"); Tunnel.Model.Tunnel_SelType model = new Tunnel.Model.Tunnel_SelType(); Tunnel.BLL.SelType stBll; Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum(); string temp = "项目经理部"; div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>" + "<span> > </span>" + "<span><a title='" + temp + "-" + tbBll.GetModel(Convert.ToInt32(Request.QueryString["bum_id"])).b_name + "' href='/N_Index/xjb2.aspx?bum_id=" + Request.QueryString["bum_id"] + "'>" + temp + "-" + tbBll.GetModel(Convert.ToInt32(Request.QueryString["bum_id"])).b_name + "</a></span>" + "</font>"; string strsql = "select * from tunnel_newstype where TypeID=" + Request.QueryString["typeid"]; DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql); if (das.Tables[0].Rows.Count > 0) { div.InnerHtml += "<span> > </span>" + "<font class='titlefontson'><span>" + das.Tables[0].Rows[0]["TypeName"] + "</span></font>"; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_SelType GetModel(int TypeID) { SqlParameter[] parameters = { new SqlParameter("@TypeID", SqlDbType.Int) }; parameters[0].Value = TypeID; Tunnel.Model.Tunnel_SelType model = new Tunnel.Model.Tunnel_SelType(); DataSet ds = DbHelperSQL.RunProcedure("Tunnel_SelType_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["TypeID"].ToString() != "") { model.TypeID = int.Parse(ds.Tables[0].Rows[0]["TypeID"].ToString()); } model.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString(); model.BumID = ds.Tables[0].Rows[0]["BumID"].ToString(); model.BumName = ds.Tables[0].Rows[0]["BumName"].ToString(); model.Url = ds.Tables[0].Rows[0]["BumUrl"].ToString(); if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "") { model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString().Trim()); } model.KSID = int.Parse(ds.Tables[0].Rows[0]["KSID"].ToString().Trim()); return(model); } else { return(null); } }
/// <summary> /// 文章列表 文章浏览 公告栏 新闻栏 /// </summary> /// <param name="num"></param> public void WriteSiteMap() { if (!string.IsNullOrEmpty(Request.QueryString["bum_id"])) { Master.FindControl("Panel1").Visible = false; System.Web.UI.HtmlControls.HtmlGenericControl div = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Panel2"); string str = div.InnerHtml; div.Visible = true; Style sty = new Style(); div.Style.Add(HtmlTextWriterStyle.Display, "''"); Tunnel.Model.Tunnel_SelType model = new Tunnel.Model.Tunnel_SelType(); Tunnel.BLL.SelType stBll; Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum(); string temp = "项目经理部"; div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>" + "<span> > </span>" + "<span onmouseover='showxjb();'>" + temp + "-" + tbBll.GetModel(Convert.ToInt32(Request.QueryString["bum_id"])).b_name + "</span>" + "</font>"; string strsql = "select a.typename,a.typeid from tunnel_newstype a,tunnel_xjbtype b where a.bumname='项目经理部' and b.typeid in (a.typeid) group by a.typeid,a.typename"; DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql); StringBuilder strhtml = new StringBuilder(); if (das.Tables[0].Rows.Count > 0) { foreach (DataRow rows in das.Tables[0].Rows) { string strtemp = "  <font class='titlfontson'><a href='/N_Index/xjbmenu.aspx?bum_id=" + Request.QueryString["bum_id"] + "&typeid=" + rows["typeid"].ToString() + "'>" + rows["typename"].ToString() + "</a></font> |"; strhtml.Append(strtemp); } } Panel3.InnerHtml = strhtml.ToString(); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_SelType> DataTableToList(DataTable dt) { List <Tunnel.Model.Tunnel_SelType> modelList = new List <Tunnel.Model.Tunnel_SelType>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Tunnel.Model.Tunnel_SelType model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_SelType(); model.TypeID = Convert.ToInt32(dt.Rows[n]["TypeID"].ToString()); model.TypeName = dt.Rows[n]["TypeName"].ToString(); model.BumID = dt.Rows[n]["BumID"].ToString(); model.BumName = dt.Rows[n]["BumName"].ToString(); model.ParentID = Convert.ToInt32(dt.Rows[n]["ParentID"].ToString().Trim()); model.KSID = Convert.ToInt32(dt.Rows[n]["KSID"].ToString().Trim()); modelList.Add(model); } } return(modelList); }
/// <summary> /// 获得数据列表 /// </summary> /// <param name="pb">分页基本信息</param> /// <param name="count">返回总数</param> /// <returns></returns> public List <Tunnel.Model.Tunnel_SelType> GetList(PageBase pb, ref int count) { DataTable dt = dal.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_SelType> modelList = new List <Tunnel.Model.Tunnel_SelType>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_SelType model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_SelType(); model.TypeID = Convert.ToInt32(dt.Rows[n]["TypeID"].ToString().Trim()); model.TypeName = dt.Rows[n]["TypeName"].ToString().Trim(); model.BumID = dt.Rows[n]["BumID"].ToString().Trim(); model.BumName = dt.Rows[n]["BumName"].ToString().Trim(); model.ParentID = Convert.ToInt32(dt.Rows[n]["ParentID"].ToString().Trim()); model.KSID = Convert.ToInt32(dt.Rows[n]["KSID"].ToString().Trim()); modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Tunnel.Model.Tunnel_SelType model) { return(dal.Update(model)); }
public int Add(Tunnel.Model.Tunnel_SelType model) { return(dal.Add(model)); }