static void build_Dynamic_Row(IRow cells, QuickType.PaymentItemList list) { cells.CreateCell(5).SetCellValue(Check_dataset(list.PaymentItemTypeName)); //Fsi data科目代码 cells.CreateCell(6).SetCellValue(list.PaymentItemTypeName); //科目名称 cells.CreateCell(9).SetCellValue(list.Amount.ToString()); //原币金额 cells.CreateCell(10).SetCellValue(list.Amount.ToString()); //借方??? cells.CreateCell(19).SetCellValue(list.PaymentItemName); //item description 描述 cells.CreateCell(32).SetCellValue("1"); //id 分录序号 cells.CreateCell(33).SetCellValue("部门--" + Org_name(list.OwnerOrgName) + "--" + list.OwnerOrgName + "||职员---" + Emp_name(list.CreatorName) + "---" + list.CreatorName); //org info 部门,员工,creater name Console.WriteLine(cells.Sheet.SheetName); }
static void Add_Row(IRow cells, QuickType.PaymentItemList list) { build_static_Row(cells); build_Dynamic_Row(cells, list); }