/// <summary> /// 获得分页集合 /// </summary> /// <param name="pb">页类</param> /// <param name="count">总数</param> /// <returns>集合</returns> public List <Tunnel.Model.Tunnel_xjbType> GetList(PageBase pb, ref int count) { Tunnel.DAL.Tunnel_xjbType xjb = new Tunnel.DAL.Tunnel_xjbType(); DataTable dt = xjb.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_xjbType> modelList = new List <Tunnel.Model.Tunnel_xjbType>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_xjbType model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_xjbType(); model.Id = Convert.ToInt32(dt.Rows[n]["id"].ToString()); model.Typename = dt.Rows[n]["typename"].ToString().Trim(); model.Typeid = Convert.ToInt32(dt.Rows[n]["typeid"].ToString()); model.Parentid = Convert.ToInt32(dt.Rows[n]["parentid"].ToString()); model.Url = dt.Rows[n]["url"].ToString().Trim(); model.IsStop = dt.Rows[n]["IsStop"].ToString().Trim(); model.UserID = int.Parse(dt.Rows[n]["UserID"].ToString().Trim()); modelList.Add(model); } } return(modelList); }
/// <summary> /// 修改数据 /// </summary> /// <param name="produce">产品实体集</param> /// <returns>修改结果</returns> public int Update(Tunnel.Model.Tunnel_xjbType xjbType) { string strSQL = string.Format("UPDATE Tunnel_xjbType SET typename='{1}',IsStop='{2}',UserID={3} WHERE id={0}", +xjbType.Id, xjbType.Typename, xjbType.IsStop, xjbType.UserID); object obj = DbHelperSQL.ExecuteSql(strSQL); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="produce">实体集</param> /// <returns>新增结果</returns> public int Add(Tunnel.Model.Tunnel_xjbType xjbType) { string strSQL = string.Format("INSERT INTO Tunnel_xjbType (typename,typeid,parentid,url,IsStop,UserID) " + "VALUES ('{0}','{1}','{2}','{3}','{4}',{5})", xjbType.Typename, xjbType.Typeid, xjbType.Parentid, xjbType.Url, xjbType.IsStop, xjbType.UserID); object obj = DbHelperSQL.ExecuteSql(strSQL); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 显示子栏目 /// </summary> /// <param name="Id">用户Id</param> /// <returns></returns> public string Getsectype(object o) { if (Convert.ToInt32(o) == 0) { return("无子栏目"); } else { Tunnel.BLL.Tunnel_xjbType xj = new Tunnel.BLL.Tunnel_xjbType(); Tunnel.Model.Tunnel_xjbType model = new Tunnel.Model.Tunnel_xjbType(); model = xj.GetModel(Convert.ToInt32(o)); string strTemp = string.Empty; if (model != null) { strTemp = model.Typename; } return(strTemp); } }
private List <Tunnel.Model.Tunnel_xjbType> GetModelList(DataTable table) { if (table.Rows.Count > 0) { List <Tunnel.Model.Tunnel_xjbType> list = new List <Tunnel.Model.Tunnel_xjbType>(); foreach (DataRow rows in table.Rows) { Tunnel.Model.Tunnel_xjbType model = new Tunnel.Model.Tunnel_xjbType(); model.Id = Convert.ToInt32(rows["id"]); model.Typename = rows["typename"].ToString(); model.Typeid = Convert.ToInt32(rows["typeid"].ToString()); model.IsStop = rows["IsStop"].ToString().Trim(); model.UserID = int.Parse(rows["UserID"].ToString().Trim()); list.Add(model); } return(list); } else { return(null); } }
public Tunnel.Model.Tunnel_xjbType GetModel(int p) { string where = " id=" + p.ToString();; Tunnel.Model.Tunnel_xjbType model = new Tunnel.Model.Tunnel_xjbType(); DataSet das = xjb.GetList(where); if (das != null) { if (das.Tables.Count > 0) { if (das.Tables[0].Rows.Count > 0) { model.Id = Convert.ToInt32(das.Tables[0].Rows[0]["id"]); model.Typeid = Convert.ToInt32(das.Tables[0].Rows[0]["typeid"]); model.Typename = das.Tables[0].Rows[0]["typename"].ToString(); model.Parentid = Convert.ToInt32(das.Tables[0].Rows[0]["Parentid"]); model.Url = das.Tables[0].Rows[0]["Url"].ToString(); model.IsStop = das.Tables[0].Rows[0]["IsStop"].ToString().Trim(); model.UserID = int.Parse(das.Tables[0].Rows[0]["UserID"].ToString().Trim()); } else { model = null; } } else { model = null; } } else { model = null; } return(model); }
/// <summary> /// 更新数据 /// </summary> /// <param name="xjbInfo">项经部类型实体</param> /// <returns>更新的行数</returns> public int Update(Tunnel.Model.Tunnel_xjbType xjbType) { //throw new NotImplementedException().Message(); return(xjb.Update(xjbType)); }