public int Delete(DataTable t)
{
return((int)DataBase.ExecuteNone(DataUtil.BuildDeleteSQL(t)));
}
//public int UpdateParams(DataRow r){
// OleDbParameter[] ps;
// string cmd = DataUtil.BuildUpdateSQL(r, out ps);
// return (int)DataBase.ExecuteNone(cmd, ps);
//}
#endregion endupdate
#region delete 限制: 仅支持第一列为主键的数据操作
public int Delete(DataRow r)
{
return((int)DataBase.ExecuteNone(DataUtil.BuildDeleteSQL(r)));
}
public int Insert(DataTable t)
{
return((int)DataBase.ExecuteNone(DataUtil.BuildInsertSQL(t)));
}
public int Insert(DataRow r)
{
return((int)DataBase.ExecuteNone(DataUtil.BuildInsertSQL(r)));
}
public void AddDeleteData(DataRow r)
{
patchSQL.Append(DataUtil.BuildDeleteSQL(r));
}
//public int DeleteParams(DataRow r) {
// OleDbParameter[] ps;
// string cmd = DataUtil.BuildDeleteSQL(r, out ps);
// return (int)DataBase.ExecuteNone(cmd, ps);
//}
#endregion
#region Select
//代码已经重构，参见DataBase中的Select操作
#endregion
public void AddInsertData(DataRow r)
{
patchSQL.Append(DataUtil.BuildInsertSQL(r));
}