WebService架构提交数据-生成仅包含修改了字段的数据表

C# Code:

private void btnSubmit_Click(object sender, EventArgs e)
{
   //生成仅包含修改了字段的数据
   DataSet ds = new DataSet();
   ds.Tables.Add(_master.ChangedFieldTable);
   ds.Tables.Add(_detail.ChangedFieldTable);
   
   //调用WebService层提交数据
   bool success = MyWebService.Submit(ds);
   
   if (success)
   MessageBox.Show("Submit data successfully!");
   else
   MessageBox.Show("An error occurred while submit data via webservice!");
}

//来源:C/S框架网(www.csframework.com) QQ:1980854898

C# Code:

//观察字段
_master = new FieldChangedObserver(ds.Tables[0], "SONO");
_detail = new FieldChangedObserver(ds.Tables[1], "ISID");

C# Code:

/// <summary>
/// 观察的数据表是否被用户修改数据
/// </summary>
public class FieldChangedObserver
{
   private DataTable _observedTable;//被观察的数据表
   private List<DataColumn> _changedColumns;//观察到已修改的栏位
   private string _primaryKeyFieldName;//主键
   
   /// <summary>
   /// 构造器
   /// </summary>
   /// <param name="observedTable">被观察的数据表</param>
   /// <param name="primaryKeyFieldName">主键</param>
   public FieldChangedObserver(DataTable observedTable, string primaryKeyFieldName)
   {
      _observedTable = observedTable;
      _changedColumns = new List<DataColumn>();
      _primaryKeyFieldName = primaryKeyFieldName;
      _observedTable.ColumnChanged = new DataColumnChangeEventHandler(_observedTable_ColumnChanged);
   }
   
   //当用户修改数据时触发的事件
   private void _observedTable_ColumnChanged(object sender, DataColumnChangeEventArgs e)
   {
      if (_changedColumns.IndexOf(e.Column) >= 0) return;
      _changedColumns.Add(e.Column);
   }
   
   /// <summary>
   /// 返回仅包含已修改栏位的数据表。
   /// </summary>
   public DataTable ChangedFieldTable
   {
      get
      {
         //获取用户已修改的数据
         DataTable changes = _observedTable.GetChanges();
         if (changes == null) return _observedTable.Clone();
         
         //删除未修改的栏位
         foreach (DataColumn column in _observedTable.Columns)
         {
            //不处理主键
            if (column.ColumnName.ToUpper() == _primaryKeyFieldName.ToUpper()) continue;
            
            //找到未修改的栏位则删除。
            if (_changedColumns.IndexOf(column) < 0)
            changes.Columns.Remove(column.ColumnName);
         }
         
         return changes;
      }
   }
   
}

//来源:C/S框架网(www.csframework.com) QQ:1980854898