private void writeAccountReport(TB_User sales, int year, int month, int line, decimal totalScore)
{
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].PutValue(sales.USER_NAME);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].Style.Copy(cellstyle);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].PutValue(GlobalBusiness.getUserRoleType(sales.ROLEID));
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].Style.Copy(cellstyle);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].PutValue(Math.Round(totalScore, 2));
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].Style.Copy(this.cellstyle);
}
private void writeAccountReport(TB_User sales, int year, int month, int line, DataTable tb)
{
decimal tmpTotal = 0;
for (int i = 0; i < tb.Rows.Count; i++)
{
tmpTotal += Utils.NvDecimal(tb.Rows[i]["提成金额"].ToString());
}
Total += tmpTotal;
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].PutValue(sales.Id);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 2].Style.Copy(cellstyle);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].PutValue(GlobalBusiness.getUserRoleType(sales.ROLEID));
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 3].Style.Copy(cellstyle);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].PutValue(tmpTotal);
AccountSheet.Cells[ACCOUNTDATA_STARTLINE_INDEX + line, 4].Style.Copy(this.cellstyle);
}
