/// <summary> /// 增加一条数据 /// </summary> public int Add(TFXK.Model.Permission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Permission("); strSql.Append("roleID,moduleID)"); strSql.Append(" values ("); strSql.Append("@roleID,@moduleID)"); OleDbParameter[] parameters = { new OleDbParameter("@roleID", OleDbType.Integer, 4), new OleDbParameter("@moduleID", OleDbType.Integer, 4) }; parameters[0].Value = model.roleID; parameters[1].Value = model.moduleID; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); string sql = "select max(id) from [tb_Permission]"; try { return(int.Parse(DbHelperOleDb.GetSingle(sql).ToString())); } catch { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TFXK.Model.Permission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Permission set "); strSql.Append("roleID=@roleID,"); strSql.Append("moduleID=@moduleID"); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@roleID", OleDbType.Integer, 4), new OleDbParameter("@moduleID", OleDbType.Integer, 4),new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.roleID; parameters[1].Value = model.moduleID; parameters[2].Value = model.id; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public TFXK.Model.Permission GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,roleID,moduleID from tb_Permission "); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; TFXK.Model.Permission model = new TFXK.Model.Permission(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["roleID"].ToString() != "") { model.roleID = int.Parse(ds.Tables[0].Rows[0]["roleID"].ToString()); } if (ds.Tables[0].Rows[0]["moduleID"].ToString() != "") { model.moduleID = int.Parse(ds.Tables[0].Rows[0]["moduleID"].ToString()); } return(model); } else { return(null); } }