/// <summary>
/// 删除订单信息之前必须要先删除订单对应的商品信息，不然有垃圾数据
/// </summary>
/// <param name="sqlWhere"></param>
/// <returns></returns>
public bool DeleteEntity(string sqlWhere)
{
string sql = string.Format("delete from SalesOrders where 1=1 {0}", sqlWhere);
return(OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, CommandType.Text, sql, null) > 0);
}
private int GetNewID()
{
string sql = "select s_SalesOrders.nextval from dual";
return(int.Parse(OracleHelper.ExecuteScalar(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null).ToString()));
}