/// <summary>
/// 获取符合条件的数据
/// </summary>
/// <param name="where">查询条件</param>
/// <returns>符合条件的数据集</returns>
public static List <Order> GetOrderByWhere(String where)
{
List <Order> orders = new List <Order>();
String sql = String.Format("SELECT * FROM orders WHERE {0}", where);
using (SQLiteDataReader reader = SQLiteHelper.ExecuteReader(SQLiteHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql)){
while (reader.Read())
{
Order order = DataRowToModel(reader);
order.Details = OrderDetailDAL.GetDetailsByWhere("order_id = " + order.Id);
orders.Add(order);
}
}
return(orders);
}
public static bool DelToatlOut(SqlTransaction tr, string orderid)
{
bool state = true;
IList <OrderDetailModel> orderdetails = OrderDetailDAL.GetOrderDetail(orderid);
foreach (OrderDetailModel orderdetail in orderdetails)
{
string sql = "update LogicProductInventory set TotalOut=TotalOut-@count where ProductID=@productid";
SqlParameter[] paras = new SqlParameter[2];
paras[0] = new SqlParameter("@count", orderdetail.Quantity);
paras[1] = new SqlParameter("@productid", orderdetail.ProductId);
if (DBHelper.ExecuteNonQuery(tr, sql, paras, CommandType.Text) != 1)
{
state = false;
}
}
return(state);
}