class FormBase class BizFormBase :FormBase class ViewFormBase : BizFormBase class EditFormBase : BizFormBase class QueryFormBase : FormBase |
QueryPeopleForm OnQueryButtonClick() { string peopleName = txtPeopleName.Text; string peopleAge = txtPeopleAge.Text; string sql; sql = string.Format(“Name Like‘%{0}%’and Age = {1}, PeopleName, peopleAge); PeopleManager manager = new PeopleManager(); this.gridMain.DataSource = manager.GetDataTable(sql); this.gridMain.DataBind(); } |
QueryPeopleForm : QueryFormBase OnQueryButtonClick() { string peopleName = txtPeopleName.Text; string peopleAge = txtPeopleAge.Text; sql = string.Format(“Name Like‘%{0}%’and Age = {1}, PeopleName, peopleAge); QueryAndBind(new PeopleManager(), sql); } |
public enum QueryOperator { //等于比較。 Equal = 0, // 不等于 NotEqual = 1, // Like比較 Like = 6 } class Query { void Add(string fieldName, string value, QueryOperator oper); string GetSql(); } QueryPeopleForm : QueryFormBase OnQueryButtonClick() { Query query = new Query(); query.Add(“Name”, txtPeopleName.Text, QueryOperator.Like); query.Add(“Age”, txtPeopleAge.Text, QueryOperator.Equal); QueryAndBind(new PeopleManager(), query.GetSql()); } |
QueryPeopleForm : QueryFormBase OnQueryButtonClick() { InitControls(gridMain); Query query = new Query(); query.Add(“Name”, txtPeopleName.Text, QueryOperator.Like); query.Add(“Age”, txtPeopleAge.Text, QueryOperator.Equal); QueryAndBind(new PeopleManager(), query.GetSql()); } |
QueryPeopleForm : QueryFormBase void Initialize() { // 指定頁面對(duì)應(yīng)的Manager Manager = new PeopleManager(); // 綁定控件 InitControls(gridMain, btnQuery); } void GetQueryInfo(Query query) { //獲得查詢條件 query.Add(“Name”, txtPeopleName.Text, QueryOperator.Like); query.Add(“Age”, txtPeopleAge.Text, QueryOperator.Equal); } QueryFormBase: private IManager manager = null; public IManager Manager { get { return manager; } set { manager = value; } } void InitControls(GridView grid, Button queryButton) { this.defaultGrid = grid; this.queryButton = queryButton; queryButton.Click += new EventHandler(QueryButton_Click); } void QueryButton_Click(object sender, EventArgs e) { Query query = new Query(); GetQueryInfo(Query); QueryAndBind(manager, query.GetSql()); } |
聯(lián)系客服