/// <summary> /// /// </summary> /// <param name="MoudleId"></param> /// <returns></returns> public MoudleInfo GetMoudleInfo(string MoudleId) { MoudleInfo info = null; string sql = _SelectSql + " where moudleid='" + MoudleId + "'"; using (DbDataReader reader = DataBaseManage.ExecuteReader(sql)) { if (reader.Read()) { info = BuilderEntity(reader); } } return(info); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private MoudleInfo BuilderEntity(DbDataReader reader) { MoudleInfo info = new MoudleInfo(); info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString(); info.MoudleName = (reader.IsDBNull(reader.GetOrdinal("moudlename"))) ? "" : reader["moudlename"].ToString(); info.Url = (reader.IsDBNull(reader.GetOrdinal("url"))) ? "" : reader["url"].ToString(); info.ParentId = (reader.IsDBNull(reader.GetOrdinal("parentid"))) ? "" : reader["parentid"].ToString(); info.Img = (reader.IsDBNull(reader.GetOrdinal("img"))) ? "" : reader["img"].ToString(); info.IsEnable = (reader.IsDBNull(reader.GetOrdinal("isenable"))) ? "" : reader["isenable"].ToString(); info.IsRoot = (reader.IsDBNull(reader.GetOrdinal("isroot"))) ? "" : reader["isroot"].ToString(); info.Sort = (reader.IsDBNull(reader.GetOrdinal("Sort"))) ? "" : reader["Sort"].ToString(); info.YWLX = (reader.IsDBNull(reader.GetOrdinal("ywlx"))) ? "" : reader["ywlx"].ToString(); return(info); }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool ModifyMoudle(MoudleInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Update moudleinfo "); sql.Append(" Set moudlename = '" + info.MoudleName + "',"); sql.Append(" url = '" + info.Url + "', "); sql.Append(" parentid = '" + info.ParentId + "', "); sql.Append(" img = '" + info.Img + "', "); sql.Append(" isenable = '" + info.IsEnable + "',"); sql.Append(" isroot = '" + info.IsRoot + "',"); sql.Append(" ywlx = '" + info.YWLX + "',"); sql.Append(" Sort = '" + info.Sort + "'"); sql.Append(" Where moudleid = '" + info.MoudleId + "'"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreateMoudle(MoudleInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into moudleinfo "); sql.Append(" ( moudlename, url, parentid, img, isenable, isroot,ywlx,Sort) "); sql.Append(" Values( "); sql.Append(" '" + info.MoudleName + "',"); sql.Append(" '" + info.Url + "',"); sql.Append(" '" + info.ParentId + "',"); sql.Append(" '" + info.Img + "',"); sql.Append(" '" + info.IsEnable + "',"); sql.Append(" '" + info.IsRoot + "',"); sql.Append(" '" + info.YWLX + "',"); sql.Append(" '" + info.Sort + "'"); sql.Append(" ) "); return DataBaseManage.ExecuteSql(sql.ToString())>0; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool CreateMoudle(MoudleInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into moudleinfo "); sql.Append(" ( moudlename, url, parentid, img, isenable, isroot,ywlx,Sort) "); sql.Append(" Values( "); sql.Append(" '" + info.MoudleName + "',"); sql.Append(" '" + info.Url + "',"); sql.Append(" '" + info.ParentId + "',"); sql.Append(" '" + info.Img + "',"); sql.Append(" '" + info.IsEnable + "',"); sql.Append(" '" + info.IsRoot + "',"); sql.Append(" '" + info.YWLX + "',"); sql.Append(" '" + info.Sort + "'"); sql.Append(" ) "); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <returns></returns> private MoudleInfo SetInfo() { MoudleInfo info = new MoudleInfo(); info.MoudleName = this.TXT_MOUDLENAME.Text.Trim(); info.Url = this.TXT_URL.Text.Trim(); if (this.DDL_PARENTID.SelectedValue != "") info.ParentId = this.DDL_PARENTID.SelectedValue; else info.ParentId = "0"; info.Img = this.DDL_IMG.SelectedValue; info.IsEnable = this.DDL_ISENABLE.SelectedValue; info.IsRoot = this.DDL_ISROOT.SelectedValue; info.Sort = this.TXT_SORT.Text.Trim(); info.MoudleId = this.ViewState["ID"].ToString(); info.YWLX = "";// ddlYWLX.SelectedValue; return info; }
public bool ModifyMoudle(MoudleInfo info) { return _Dao.ModifyMoudle(info); }
public bool CreateMoudle(MoudleInfo info) { return _Dao.CreateMoudle(info); }
public bool ModifyMoudle(MoudleInfo info) { return(_Dao.ModifyMoudle(info)); }
public bool CreateMoudle(MoudleInfo info) { return(_Dao.CreateMoudle(info)); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private MoudleInfo BuilderEntity(DbDataReader reader) { MoudleInfo info = new MoudleInfo(); info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString(); info.MoudleName = (reader.IsDBNull(reader.GetOrdinal("moudlename"))) ? "" : reader["moudlename"].ToString(); info.Url = (reader.IsDBNull(reader.GetOrdinal("url"))) ? "" : reader["url"].ToString(); info.ParentId = (reader.IsDBNull(reader.GetOrdinal("parentid"))) ? "" : reader["parentid"].ToString(); info.Img = (reader.IsDBNull(reader.GetOrdinal("img"))) ? "" : reader["img"].ToString(); info.IsEnable = (reader.IsDBNull(reader.GetOrdinal("isenable"))) ? "" : reader["isenable"].ToString(); info.IsRoot = (reader.IsDBNull(reader.GetOrdinal("isroot"))) ? "" : reader["isroot"].ToString(); info.Sort = (reader.IsDBNull(reader.GetOrdinal("Sort"))) ? "" : reader["Sort"].ToString(); info.YWLX = (reader.IsDBNull(reader.GetOrdinal("ywlx"))) ? "" : reader["ywlx"].ToString(); return info; }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool ModifyMoudle(MoudleInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Update moudleinfo "); sql.Append(" Set moudlename = '" + info .MoudleName+ "',"); sql.Append(" url = '" + info .Url+ "', "); sql.Append(" parentid = '" + info.ParentId + "', "); sql.Append(" img = '" + info.Img + "', "); sql.Append(" isenable = '" + info.IsEnable + "',"); sql.Append(" isroot = '" + info.IsRoot + "',"); sql.Append(" ywlx = '" + info.YWLX + "',"); sql.Append(" Sort = '" + info.Sort + "'"); sql.Append(" Where moudleid = '" + info.MoudleId + "'"); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }