/// <summary>
/// 订单付款
/// </summary>
/// <param name="StaffName">工作人员登陆名</param>
/// <param name="OrderID">订单ID</param>
/// <param name="KM">实际行驶里程</param>
/// <returns></returns>
public bool LastCheakOrder(String StaffName, int OrderID, int KM)
{
Order_ViewModel Summery = DB_ViewModel.Select(P => P.Order_ID == OrderID).Single();
Summery.Checkout_Time = DateTime.Now;
Summery.Checkout_KM = KM;
//管理类声明并共享数据库操作实体
Checkout Checkout_Manager = new Checkout();
//实体类声明并获得实体
Car_Checkout old_checkout = Checkout_Manager.SelectCheckout_ID(Summery.Checkout_ID);
Car_Checkout new_Checkout = old_checkout;
new_Checkout.Checkout_KM = KM;
new_Checkout.Checkout_User = (Guid)Membership.GetUser(StaffName).ProviderUserKey;
new_Checkout.Checkout_Time = DateTime.Now;
//将信息保存到数据库以完整信息
if (!Checkout_Manager.UpdateCheckout(new_Checkout))
{
return(false);
}
return(true);
}
/// <summary>
/// 更改收款单信息
/// </summary>
/// <param name="New_Checkout">新的收款单实体</param>
/// <returns></returns>
public bool UpdateCheckout(Car_Checkout TempCheckout)
{
Car_Checkout OldCheckout = DB_Checkout.Select(P => P.Checkout_ID == TempCheckout.Checkout_ID).Single();
Car_Checkout NewCheckout = OldCheckout;
NewCheckout.Checkout_KM = TempCheckout.Checkout_KM;
NewCheckout.Checkout_Mark = TempCheckout.Checkout_Mark;
NewCheckout.Checkout_Order = TempCheckout.Checkout_Order;
NewCheckout.Checkout_Time = TempCheckout.Checkout_Time;
NewCheckout.Checkout_User = TempCheckout.Checkout_User;
return(DB_Checkout.Update(OldCheckout, NewCheckout));
}
public bool Pay_Order(int OrderID)
{
Account Account_Manager = new Account();
Checkout Checkout_Manager = new Checkout();
Checkout_Manager.DB_Checkout.dt = Account_Manager.DB_Account.dt;
Order_ViewModel Summery = DB_ViewModel.Select(P => P.Order_ID == OrderID).Single();
Car_Checkout old_checkout = Checkout_Manager.SelectCheckout_ID(Summery.Checkout_ID);
Car_Checkout new_Checkout = old_checkout;
new_Checkout.Checkout_Mark = true;
//定义付款操作所需要的实体成员
Car_Account account = new Car_Account()
{
Account_Price = GetPrice_OrderID(Summery.Order_ID),
Account_Shop = Summery.Shop_ID,
Account_Time = DateTime.Now,
Account_User = (Guid)new_Checkout.Checkout_User,
Account_Info = String.Format("第{0}号的订单进行了买单操作!", Summery.Order_ID)
};
using (TransactionScope tc = new TransactionScope())
{
try
{
Account_Manager.AddAccount_Trans(account);
Checkout_Manager.UpdateCheckout_Trans(new_Checkout);
Account_Manager.DB_Account.SubmitChanges();
tc.Complete();
}
catch
{
return(false);
}
}
return(true);
}
/// <summary>
/// 删除收款单信息
/// </summary>
/// <param name="Checkout">要删除的收款单实体</param>
/// <returns></returns>
public bool DeleteCheckout(int CheckoutID)
{
Car_Checkout Che = DB_Checkout.Select(P => P.Checkout_ID == CheckoutID).Single();
return(DB_Checkout.Delete(Che));
}
/// <summary>
/// 新增收款单信息
/// </summary>
/// <param name="Checkout">要增加的收款单实体</param>
/// <returns></returns>
public bool AddCheckout(Car_Checkout Checkout)
{
return(DB_Checkout.Insert(Checkout));
}
/// <summary>
/// 删除收款单连带删除订单
/// </summary>
/// <param name="OrderID"></param>
/// <returns></returns>
public bool DeleteCheckout_Trans(int OrderID)
{
Car_Checkout TempCheckout = DB_Checkout.Select(P => P.Checkout_Order == OrderID).Single();
return(DB_Checkout.Delete_NoSub(TempCheckout));
}
/// <summary>
/// 更改收款单信息
/// </summary>
/// <param name="New_Checkout">新的收款单实体</param>
/// <returns></returns>
public bool UpdateCheckout_Trans(Car_Checkout NewCheckout)
{
Car_Checkout OldCheckout = DB_Checkout.Select(P => P.Checkout_ID == NewCheckout.Checkout_ID).Single();
return(DB_Checkout.Update_NoSub(OldCheckout, NewCheckout));
}
