/// <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;
}
