/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.BasePage DataRowToModel(DataRow row) { Maticsoft.Model.BasePage model = new Maticsoft.Model.BasePage(); if (row != null) { if (row["PageID"] != null && row["PageID"].ToString() != "") { model.PageID = int.Parse(row["PageID"].ToString()); } if (row["PageName"] != null) { model.PageName = row["PageName"].ToString(); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } if (row["Cmds"] != null) { model.Cmds = row["Cmds"].ToString(); } if (row["ParentPageID"] != null && row["ParentPageID"].ToString() != "") { model.ParentPageID = int.Parse(row["ParentPageID"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.BasePage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BasePage("); strSql.Append("PageID,PageName,Note,Cmds,ParentPageID)"); strSql.Append(" values ("); strSql.Append("@PageID,@PageName,@Note,@Cmds,@ParentPageID)"); SqlParameter[] parameters = { new SqlParameter("@PageID", SqlDbType.Int, 4), new SqlParameter("@PageName", SqlDbType.NVarChar, 80), new SqlParameter("@Note", SqlDbType.NVarChar, 200), new SqlParameter("@Cmds", SqlDbType.NVarChar, 100), new SqlParameter("@ParentPageID", SqlDbType.Int, 4) }; parameters[0].Value = model.PageID; parameters[1].Value = model.PageName; parameters[2].Value = model.Note; parameters[3].Value = model.Cmds; parameters[4].Value = model.ParentPageID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.BasePage GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 PageID,PageName,Note,Cmds,ParentPageID from BasePage "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.BasePage model = new Maticsoft.Model.BasePage(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.BasePage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BasePage set "); strSql.Append("PageID=@PageID,"); strSql.Append("PageName=@PageName,"); strSql.Append("Note=@Note,"); strSql.Append("Cmds=@Cmds,"); strSql.Append("ParentPageID=@ParentPageID"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@PageID", SqlDbType.Int, 4), new SqlParameter("@PageName", SqlDbType.NVarChar, 80), new SqlParameter("@Note", SqlDbType.NVarChar, 200), new SqlParameter("@Cmds", SqlDbType.NVarChar, 100), new SqlParameter("@ParentPageID", SqlDbType.Int, 4) }; parameters[0].Value = model.PageID; parameters[1].Value = model.PageName; parameters[2].Value = model.Note; parameters[3].Value = model.Cmds; parameters[4].Value = model.ParentPageID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }