2009-04-29Code

public abstract class DbTableCommand{public DbTableCommand(){}public DbTableCommand(bool initTableOperateScript){}public virtual DataTable Load(){return Search(this.SelectText);}public virtual DataTable Search(string searchText){SqlDataAdapter adpt = new SqlDataAdapter(new SqlCommand(searchText));DataTable dt = new DataTable();adpt.Fill(dt);return dt;}public virtual void Save(DataTable dt){SqlDataAdapter adpt = new SqlDataAdapter();adpt.InsertCommand = new SqlCommand(this.InsertText);adpt.UpdateCommand = new SqlCommand(this.UpdateText);adpt.DeleteCommand = new SqlCommand(this.DeleteText);adpt.Update(dt);}protected virtual void Save(DataTable dt,DataRowState state,SqlDataAdapter adapter){DataTable ChangedData = dt.GetChanges(state);if(ChangedData == null){return;}adapter.Update(ChangedData);}public virtual void Insert(DataTable dt){SqlDataAdapter adpt = new SqlDataAdapter(); adpt.InsertCommand = new SqlCommand(this.InsertText);this.Save(dt,DataRowState.Added,adpt);}public virtual void Update(DataTable dt){SqlDataAdapter adpt = new SqlDataAdapter(); adpt.UpdateCommand = new SqlCommand(this.UpdateText);this.Save(dt,DataRowState.Modified,adpt);}public virtual void Delete(DataTable dt){SqlDataAdapter adpt = new SqlDataAdapter(); adpt.DeleteCommand = new SqlCommand(this.DeleteText);this.Save(dt,DataRowState.Deleted,adpt);}private string mebSelectText;private string mebInsertText;private string mebUpdateText;private string mebDeleteText;public string SelectText{get{ return mebSelectText;}set{ mebSelectText = value;}}public string InsertText{get{ return mebInsertText;}set{ mebInsertText = value;}}public string UpdateText{get{ return mebUpdateText;}set{ mebUpdateText = value;}}public string DeleteText{get{ return mebDeleteText;}set{ mebDeleteText = value;}}}public class DbTableOperator{public DataTable ReadTableData(){return null;}public void WriteTableData(){}public DataRow ReadRowData(){return null;}public void WriteRowData(){}public object ReadFieldData(){return null;}public void WriteFieldData(){}}