public bool isReturn = false;//是否有退货员使用
public FormSystemSetup(BakeryOrderSet bakeryOrderSet, int id, PrintInfo printer, int posID, int storeID, string cashierName)
{
m_CashierID = id;
m_BakeryOrderSet = bakeryOrderSet;
m_Printer = printer;
m_PosID = posID;
m_StoreID = storeID;
m_CashierName = cashierName;
InitializeComponent();
}
public bool LoadData(BakeryOrderSet bakeryOrderSet, int month, int day)
{
int count = bakeryOrderSet.Header.Rows.Count;
if (count == 0)
{
return(false);
}
if (month < 1 || month > 12)
{
return(false);
}
if (day < 1 || day > 31)
{
return(false);
}
BakeryOrderSet.HeaderRow row;
foreach (BakeryOrderSet.HeaderRow r in bakeryOrderSet.Header.Rows)
{
if (r.DataDate.Year != MyFunction.IntHeaderYear)
{
continue;
}
if (r.DataDate.Month != month)
{
continue;
}
if (r.DataDate.Day == day)
{
row = r;
goto Yes;
}
}
return(false);
Yes:
string sql = CreateSql(row.DataDate.Month, row.DataDate.Day);
try
{
m_OrderAdapter.FillBySelectStr(bakeryOrderSet.Order, "Select * From [Order] " + sql + " Order by ID");
m_WorkingDay.Set(row.DataDate);
return(true);
}
catch (Exception ex)
{
LastErrorString = ex.Message;
if (MessageBox.Show(ex.Message, "", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
{
throw ex;
}
}
return(false);
}
bool isReturn;//是否有退货窗体调用
public FormStatics(BakeryOrderSet bakeryOrderSet, BakeryOrderSetTableAdapters.OrderTableAdapter adapter, int cashierID, PrintInfo printer, bool dataSealed, int posID, int storeID, bool IsReturn)
{
m_BakeryOrderSet = bakeryOrderSet;
m_OrderTableAdapter = adapter;
m_CashierID = cashierID;
m_Printer = printer;
m_DataSealed = dataSealed;
m_PosID = posID;
m_StoreID = storeID;
isReturn = IsReturn;
InitializeComponent();
}
public ModifyPassword(BakeryOrderSet bakeryOrderSet, int id)
{
m_CashierID = id;
m_BakeryOrderSet = bakeryOrderSet;
InitializeComponent();
}
public MonthlyReportData Statics(BakeryOrderSet orderSet)
#endif
{
decimal cash = 0, credit = 0, deduct = 0, alipay = 0, couponA = 0, couponB = 0, wxpay = 0;
decimal deletedMoney = 0, returnedMoney = 0, TwentyPDMoney = 0, FifteenPDMoney = 0, TenPDMoney = 0;
int orderCount = 0, deletedCount = 0, returnedCount = 0, TwentyPDCount = 0, FifteenPDCount = 0, TenPDCount = 0;
MonthlyReportData data = new MonthlyReportData();
foreach (var row in orderSet.Order)
{
decimal income;
if (row.IsIncomeNull())
{
income = 0m;
}
else
{
income = row.Income;
}
if (!row.IsDeletedNull() && row.Deleted)
{
deletedMoney += income;
deletedCount++;
continue;
}
if (row.IsPayByNull() || row.PayBy == "A") // A現金 B刷卡 C支付宝 D券
{
cash += income;
}
else if (row.PayBy == "B")
{
credit += income;
}
else if (row.PayBy == "C")
{
alipay += income;
}
else if (row.PayBy == "E")
{
wxpay += income;
}
else if (row.PayBy == "D")
{
if (!row.IsCashIncomeNull())
{
cash += row.CashIncome;
}
if (!row.IsCouponIncomeNull())
{
if (row.CouponIncome > income)
{
couponA += income; // 收券大於應收,只計應收
}
else
{
couponA += row.CouponIncome;
}
}
}
else if (row.PayBy == "F")
{
if (!row.IsCashIncomeNull())
{
cash += row.CashIncome;
}
if (!row.IsCouponIncomeNull())
{
if (row.CouponIncome > income)
{
couponB += income; // 收券大於應收,只計應收
}
else
{
couponB += row.CouponIncome;
}
}
}
if (!row.IsDeductNull())
{
deduct += row.Deduct;
}
if (income >= 0) // 退貨的不計入單數
{
orderCount++; // 一單一人
}
else
{
returnedMoney += income;
returnedCount++;
}
if (!row.IsDiscountRateNull())
{
if (row.DiscountRate == (decimal)0.80)
{
TwentyPDMoney += income;
TwentyPDCount++;
}
if (row.DiscountRate == (decimal)0.85)
{
FifteenPDMoney += income;
FifteenPDCount++;
}
if (row.DiscountRate == (decimal)0.90)
{
TenPDMoney += income;
TenPDCount++;
}
}
}
data.OrderCount = orderCount;
data.Cash = Math.Round(cash);
data.Alipay = Math.Round(alipay);
data.Wxpay = Math.Round(wxpay);
data.CouponA = Math.Round(couponA);
data.CouponB = Math.Round(couponB);
data.Deduct = Math.Round(deduct);
data.Date = m_WorkingDay.Date;
data.CreditCard = Math.Round(credit);
data.CreditFee = Math.Round(FeeRate * data.CreditCard, 2);
data.CreditNet = data.CreditCard - data.CreditFee;
if (orderCount != 0)
{
data.AvePerPerson = Math.Round((cash + credit + alipay + wxpay + couponA + couponB) / orderCount, 1);
}
data.Revenue = Math.Round(cash + credit + alipay + wxpay + couponA + couponB);
data.DeletedCount = deletedCount;
data.DeletedMoney = Math.Round(deletedMoney);
data.ReturnedCount = returnedCount;
data.ReturnedMoney = Math.Round(returnedMoney);
data.TwentyPDCount = TwentyPDCount;
data.TwentyPDMoney = Math.Round(TwentyPDMoney);
return(data);
}
