private void Budget(Budget budget, decimal incomesTotal, string path)
{
Console.WriteLine();
File.AppendAllText(path, $"+{new string('-', 53)}+\n");
File.AppendAllText(
path,
string.Format(
"|{0,-43}{1,-10}|\n",
$"TOTAL {budget.Name.ToUpper()}: {budget.Total()} lv.",
$"({budget.TotalPercent(incomesTotal):P1})"));
File.AppendAllText(path, $"+{new string('-', 53)}+\n");
File.AppendAllText(path, string.Format("|{0,20}|{1,10}|{2,10}|{3,10}|\n", "Name", "Value", "Percent", "Status"));
File.AppendAllText(path, $"+{new string('-', 53)}+\n");
for (int i = 0; i < budget.Count; i++)
{
string financeName = budget.GetFinanceNames()[i];
decimal financeValue = budget.GetFinanceValues()[i];
FinanceStatus financeStatus = budget.GetFinanceStatuses()[i];
File.AppendAllText(
path,
string.Format(
"|{0,-20}|{1,-10}|{2,-10}|{3,-10}|\n",
financeName,
$"{financeValue} lv.",
$"{financeValue / incomesTotal:P1}",
financeStatus));
}
}
private void PrintBudget(Budget budget, decimal incomesTotal)
{
for (int i = 0; i < budget.Count; i++)
{
string financeName = budget.GetFinanceNames()[i].Length > 20
? budget.GetFinanceNames()[i].Substring(0, 20 - 3) + "..."
: budget.GetFinanceNames()[i];
decimal financeValue = budget.GetFinanceValues()[i];
FinanceStatus financeStatus = budget.GetFinanceStatuses()[i];
string value = incomesTotal > 0 ? (financeValue / incomesTotal).ToString("P1") : "N/A";
Console.WriteLine(string.Format(
"|{0,-20}|{1,-10}|{2,-10}|{3,-10}|",
financeName,
$"{financeValue} lv.",
value,
financeStatus));
}
}
public List <CommissionSettlementItemInfo> GetCommissionSettlementItemInfoListByUserSysNo(int userSysNo, DateTime beginDate, DateTime endDate, FinanceStatus status)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetCommissionSettlementItemInfoListByUserSysNo");
dc.SetParameterValue("@UserSysNo", userSysNo);
dc.SetParameterValue("@BeginDate", beginDate);
dc.SetParameterValue("@EndDate", endDate);
dc.SetParameterValue("@Status", status);
return(dc.ExecuteEntityList <CommissionSettlementItemInfo>());
}
public List <int> GetHavingOrderUserList(DateTime beginDate, DateTime endDate, FinanceStatus status)
{
var list = new List <int>();
DataCommand dc = DataCommandManager.GetDataCommand("GetHavingOrderUserList");
dc.SetParameterValue("@BeginDate", beginDate);
dc.SetParameterValue("@EndDate", endDate);
dc.SetParameterValue("@Status", status);
using (IDataReader reader = dc.ExecuteDataReader())
{
while (reader.Read())
{
list.Add(reader.GetInt32(0));
}
}
return(list);
}
