/// <summary>
///
/// </summary>
/// <param name="tenantID"></param>
/// <param name="userID"></param>
/// <param name="oStatus">用户指定的状态</param>
/// <param name="paidAmount">支付金额</param>
/// <param name="bankID">银行</param>
/// <param name="db"></param>
/// <returns></returns>
public bool Pay(Guid tenantID, Guid userID, EAP.Logic.Z10.OrderStatus oStatus, decimal paidAmount, long?bankID)
{
int orderSts = Z10Order.OrderStatus ?? 0;
if ((orderSts & (int)EAP.Logic.Z10.OrderStatus.Paid) == (int)EAP.Logic.Z10.OrderStatus.Paid ||
(orderSts & (int)EAP.Logic.Z10.OrderStatus.Finished) == (int)EAP.Logic.Z10.OrderStatus.Finished ||
(orderSts & (int)EAP.Logic.Z10.OrderStatus.Archived) == (int)EAP.Logic.Z10.OrderStatus.Archived)
{
throw new Exception("已经支付的订单，已经结束的订单和已经存档的订单不能支付。");
}
Zippy.Data.IDalProvider db = Zippy.Data.StaticDB.DB;
Z10Order xorder = new Z10Order();
xorder.OrderID = Z10Order.OrderID;
xorder.FeePaid = Z10Order.FeePaid + paidAmount;
if (oStatus == OrderStatus.Paid)
{
xorder.OrderStatus = orderSts & ~(int)OrderStatus.PaidSome;
xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus;
}
else
{
//throw new Exception(orderSts.ToString() + " -- " + oStatus + " -- " + ((Z10Order.OrderStatus ?? 0) | (int)oStatus));
xorder.OrderStatus = orderSts | (int)oStatus;
}
db.Update(xorder);
Z01Beetle.Entity.Z01FinancialFlow dflow = new Z01Beetle.Entity.Z01FinancialFlow();
dflow.FlowID = null;
dflow.OrderID = Z10Order.OrderID;
dflow.Amount = paidAmount;
dflow.Creator = userID;
dflow.TenantID = tenantID;
dflow.BankID = bankID;
dflow.Currency = Z10Order.Currency;
db.Insert(dflow);
//string sqlUpdateStatus = "update Z10Order set OrderStatus=OrderStatus|@paid where OrderID=@orderid ";
//Zippy.Data.StaticDB.DB.ExecuteNonQuery(sqlUpdateStatus,
// Zippy.Data.StaticDB.DB.CreateParameter("paid", (int)EAP.Logic.Z10.OrderStatus.Paid),
// Zippy.Data.StaticDB.DB.CreateParameter("orderid", Z10Order.OrderID ?? 0));
return(true);
}
/// <summary>
/// 采购出入库
/// </summary>
/// <param name="tenantID">租户</param>
/// <param name="userID">操作者</param>
/// <param name="oStatus">当前状态</param>
/// <param name="hsItemCount">各个商品的具体入库数量</param>
/// <param name="db"></param>
/// <returns></returns>
public bool InOutDepot(Guid tenantID, Guid userID, EAP.Logic.Z10.OrderStatus oStatus, Hashtable hsItemCount, Zippy.Data.IDalProvider db)
{
throw new Exception("这个入库方式需要商榷。");
int orderSts = Z10Order.OrderStatus ?? 0;
if ((orderSts & (int)EAP.Logic.Z10.OrderStatus.Outted) == (int)EAP.Logic.Z10.OrderStatus.Inned ||
(orderSts & (int)EAP.Logic.Z10.OrderStatus.Finished) == (int)EAP.Logic.Z10.OrderStatus.Finished ||
(orderSts & (int)EAP.Logic.Z10.OrderStatus.Archived) == (int)EAP.Logic.Z10.OrderStatus.Archived)
{
throw new Exception("已经出入库的订单，已经结束的订单和已经存档的订单不能出入库。");
}
Z10Order xorder = new Z10Order();
xorder.OrderID = Z10Order.OrderID;
if (oStatus == OrderStatus.Inned && ((Z10Order.OrderStatus ?? 0) & (int)OrderStatus.InnedSome) == (int)OrderStatus.InnedSome)
{
oStatus = oStatus & (~OrderStatus.InnedSome);
xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) & (~(int)OrderStatus.InnedSome);
xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus;
}
else if (oStatus == OrderStatus.Outted && ((Z10Order.OrderStatus ?? 0) & (int)OrderStatus.OuttedSome) == (int)OrderStatus.OuttedSome)
{
oStatus = oStatus & (~OrderStatus.OuttedSome);
xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) & (~(int)OrderStatus.OuttedSome);
xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus;
}
else
{
xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) | (int)oStatus;
}
db.Update(xorder);
Z10DepotFlow dflow = new Z10DepotFlow();
foreach (Z10OrderItem item in Items)
{
decimal itemHappened = hsItemCount[item.ItemID].ToDecimal();
if ((oStatus & OrderStatus.Outted) == OrderStatus.Outted || (oStatus & OrderStatus.OuttedSome) == OrderStatus.OuttedSome)
{
db.ColAdd <Z10OrderItem>("CountHappend2", itemHappened, item.ItemID);
}
else
{
db.ColAdd <Z10OrderItem>("CountHappend", itemHappened, item.ItemID);
}
if (item.CountHappend != 0 || item.CountHappend2 != 0)
{
dflow.FlowID = null;
dflow.OrderID = Z10Order.OrderID;
dflow.Count = itemHappened;
dflow.DepotID = item.DepotID;
dflow.Creator = userID;
dflow.ProductID = item.ProductID;
dflow.TenantID = tenantID;
db.Insert(dflow);
if (!db.Exists <Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID",
db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID), db.CreateParameter("TenantID", tenantID)))
{
Z10DepotProduct xProduct = new Z10DepotProduct();
xProduct.TenantID = tenantID;
xProduct.ProductID = item.ProductID;
xProduct.DepotID = item.DepotID;
xProduct.StockSum = itemHappened;
db.Insert(xProduct);
}
else
{
string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" +
" where ProductID=@ProductID and DepotID=@DepotID";
db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened),
db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID));
}
}
}
return(true);
}
