public void LoadDataGird(IEnumerable <Timekeeping> listData)
{
int i = 0;
dataDS.Rows.Clear();
totalCashAdvance = 0;
totalWeight = 0;
txtWriteMoney.ResetText();
foreach (var item in listData)
{
dataDS.Rows.Add();
dataDS.Rows[i].Cells[0].Value = item.MSNV;
dataDS.Rows[i].Cells[1].Value = timekeepingBO.GetNameEmployee(item.MSNV);
dataDS.Rows[i].Cells[2].Value = item.Date.Value.ToShortDateString();
dataDS.Rows[i].Cells[3].Value = item.TimeStart;
dataDS.Rows[i].Cells[4].Value = item.TimeEnd;
dataDS.Rows[i].Cells[5].Value = item.Time;
dataDS.Rows[i].Cells[6].Value = item.Weight;
dataDS.Rows[i].Cells[7].Value = item.Type;
dataDS.Rows[i].Cells[8].Value = item.TotalWeight;
dataDS.Rows[i].Cells[9].Value = item.AdvancePayment;
dataDS.Rows[i].Cells[10].Value = item.Note;
totalCashAdvance += item.AdvancePayment.Value;
totalWeight += int.Parse(item.TotalWeight);
i++;
}
lbCashAdvance.Text = string.Format("{0:0,0 (VNĐ)}", totalCashAdvance);
lbTotalWeight.Text = string.Format("{0:0,0 (KG)}", totalWeight);
if (totalCashAdvance > 0)
{
txtWriteMoney.Text = "(" + UnitMoney(totalCashAdvance) + ")";
}
}
public void loadListTimekeeping()
{
int i = 0;
dataDS.Rows.Clear();
foreach (var item in list)
{
dataDS.Rows.Add();
dataDS.Rows[i].Cells[0].Value = item.MSNV;
dataDS.Rows[i].Cells[1].Value = timekeepingBO.GetNameEmployee(item.MSNV);
dataDS.Rows[i].Cells[2].Value = item.Date.Value.ToShortDateString();
dataDS.Rows[i].Cells[3].Value = item.TimeStart;
dataDS.Rows[i].Cells[4].Value = item.TimeEnd;
dataDS.Rows[i].Cells[5].Value = item.Time;
dataDS.Rows[i].Cells[6].Value = item.Weight;
dataDS.Rows[i].Cells[7].Value = item.Type;
dataDS.Rows[i].Cells[8].Value = item.TotalWeight;
dataDS.Rows[i].Cells[9].Value = item.AdvancePayment;
dataDS.Rows[i].Cells[10].Value = item.Note;
i++;
}
}
public void LoadDataGird(IEnumerable <Timekeeping> listData)
{
dataDS.Columns.Clear();
#region DataGridView
dataDS.ColumnCount = 16;
dataDS.Columns[0].Name = "MSNV";
dataDS.Columns[1].Name = "Họ tên";
dataDS.Columns[2].Name = "Ngày";
dataDS.Columns[3].Name = "Thời gian bắt đầu";
dataDS.Columns[4].Name = "Thời gian kết thúc";
dataDS.Columns[5].Name = "Tăng ca";
dataDS.Columns[6].Name = "Thời gian(h)";
dataDS.Columns[7].Name = "Số bao";
dataDS.Columns[8].Name = "Loại bao(KG)";
dataDS.Columns[9].Name = "Số lượng";
dataDS.Columns[10].Name = "Tiền ứng";
dataDS.Columns[11].Name = "Tiền cơm";
dataDS.Columns[12].Name = "Tiền phạt";
dataDS.Columns[13].Name = "Tiền thưởng";
dataDS.Columns[14].Name = "Ghi chú";
dataDS.Columns[15].Name = "Nghỉ";
dataDS.Columns[0].Width = 80;
dataDS.Columns[1].Width = 150;
dataDS.Columns[2].Width = 110;
dataDS.Columns[3].Width = 110;
dataDS.Columns[4].Width = 110;
dataDS.Columns[5].Width = 100;
dataDS.Columns[6].Width = 100;
dataDS.Columns[7].Width = 100;
dataDS.Columns[8].Width = 100;
dataDS.Columns[9].Width = 100;
dataDS.Columns[10].Width = 120;
dataDS.Columns[11].Width = 100;
dataDS.Columns[12].Width = 100;
dataDS.Columns[13].Width = 100;
dataDS.Columns[14].Width = 200;
dataDS.Columns[15].Width = 100;
#endregion
txtCountWork.Visible = true;
int i = 0;
dataDS.Rows.Clear();
totalCashAdvance = 0;
totalWeight = 0;
txtCountWork.Text = (listData.Count() - listData.Where(u => u.isRest == true).Count()).ToString("#,###");
foreach (var item in listData)
{
dataDS.Rows.Add();
dataDS.Rows[i].Cells[0].Value = item.MSNV;
dataDS.Rows[i].Cells[1].Value = timekeepingBO.GetNameEmployee(item.MSNV);
dataDS.Rows[i].Cells[2].Value = item.Date.Value.ToShortDateString();
dataDS.Rows[i].Cells[3].Value = item.TimeStart;
dataDS.Rows[i].Cells[4].Value = item.TimeEnd;
dataDS.Rows[i].Cells[5].Value = String.Format("{0:0.0}", item.OverTime);;
dataDS.Rows[i].Cells[6].Value = String.Format("{0:0.0}", item.Time);
dataDS.Rows[i].Cells[7].Value = item.Weight;
dataDS.Rows[i].Cells[8].Value = item.Type;
dataDS.Rows[i].Cells[9].Value = item.TotalWeight;
dataDS.Rows[i].Cells[10].Value = item.AdvancePayment;
dataDS.Rows[i].Cells[11].Value = item.Food;
dataDS.Rows[i].Cells[12].Value = item.Punish;
dataDS.Rows[i].Cells[13].Value = item.Bunus;
dataDS.Rows[i].Cells[14].Value = item.Note;
if (item.isRest == true)
{
dataDS.Rows[i].Cells[15].Value = "Yes";
}
else
{
dataDS.Rows[i].Cells[15].Value = "No";
}
totalCashAdvance += item.AdvancePayment;
totalWeight += item.TotalWeight;
i++;
}
lbCashAdvance.Text = totalCashAdvance == 0 ? "0" : string.Format("{0:0,0 (VNĐ)}", totalCashAdvance);
lbTotalWeight.Text = totalWeight == 0 ? "0" : string.Format("{0:0,0 (KG)}", totalWeight);
txtTotalTime.Text = listData.Sum(u => u.Time) == 0 ? "0" : listData.Sum(u => u.Time).ToString();
txtFood.Text = listData.Sum(u => u.Food).ToString("#,###") == string.Empty ? "0" : listData.Sum(u => u.Food).ToString("#,###") + "VNĐ";
txtPunish.Text = listData.Sum(u => u.Punish).ToString("#,###") == string.Empty ? "0" : listData.Sum(u => u.Punish).ToString("#,###") + "VNĐ";
txtBonus.Text = listData.Sum(u => u.Bunus).ToString("#,###") == string.Empty ? "0" : listData.Sum(u => u.Bunus).ToString("#,###") + "VNĐ";
if (totalCashAdvance > 0)
{
//txtWriteMoney.Text = "(" + UnitMoney(totalCashAdvance) + ")";
}
}
