DataTable _dtColumnValue
=
QianBianWanHua_Common.DBHelper.getTable(
"
SELECT * FROM QB_ProductColumnValue
"
);
Hashtable _htColumnValue = new Hashtable();
DataRow[] _drColumnValue = _dtColumnValue.Select( " ColumnsValue=' " + _strColumnValue + " ' " );
if (_drColumnValue.Length > 0 )
... {
continue;
}
_htColumnValue.Add( " ColumnsValue " , _strColumnValue);
QianBianWanHua_Common.DBHelper.DataTableNewRow( ref _dtColumnValue, _htColumnValue);
_htColumnValue.Clear();
if (BatchInsertColumnValue( ref _dtColumnValue))
... {
QianBianWanHua_Common.MessageBox.Show(this, "操作成功");
}
else
... {
QianBianWanHua_Common.MessageBox.Show(this, "操作失败");
}
/**/ /// <summary>
/// 批量添加
/// </summary>
/// <param name="dt">DataTable</param>
/// <returns>bool</returns>
private bool BatchInsertColumnValue( ref DataTable dt)
... {
SqlCommand _cmdInsert = new SqlCommand("INSERT INTO QB_ProductColumnValue(ColumnsValue) VALUES (@ColumnsValue)");
Hashtable _htColumnValue = new Hashtable();
_htColumnValue.Add("@ColumnsValue", "ColumnsValue");
if (QianBianWanHua_Common.DBHelper.BuildBatchUpdateCommand(ref dt, ref _cmdInsert, _htColumnValue))
...{
return QianBianWanHua_Common.DBHelper.BatchUpdateDataTable(ref dt, _cmdInsert, null, null);
}
else
...{
return false;
}
}
Hashtable _htColumnValue = new Hashtable();
DataRow[] _drColumnValue = _dtColumnValue.Select( " ColumnsValue=' " + _strColumnValue + " ' " );
if (_drColumnValue.Length > 0 )
... {
continue;
}
_htColumnValue.Add( " ColumnsValue " , _strColumnValue);
QianBianWanHua_Common.DBHelper.DataTableNewRow( ref _dtColumnValue, _htColumnValue);
_htColumnValue.Clear();
if (BatchInsertColumnValue( ref _dtColumnValue))
... {
QianBianWanHua_Common.MessageBox.Show(this, "操作成功");
}
else
... {
QianBianWanHua_Common.MessageBox.Show(this, "操作失败");
}
/**/ /// <summary>
/// 批量添加
/// </summary>
/// <param name="dt">DataTable</param>
/// <returns>bool</returns>
private bool BatchInsertColumnValue( ref DataTable dt)
... {
SqlCommand _cmdInsert = new SqlCommand("INSERT INTO QB_ProductColumnValue(ColumnsValue) VALUES (@ColumnsValue)");
Hashtable _htColumnValue = new Hashtable();
_htColumnValue.Add("@ColumnsValue", "ColumnsValue");
if (QianBianWanHua_Common.DBHelper.BuildBatchUpdateCommand(ref dt, ref _cmdInsert, _htColumnValue))
...{
return QianBianWanHua_Common.DBHelper.BatchUpdateDataTable(ref dt, _cmdInsert, null, null);
}
else
...{
return false;
}
}