private void StudentPrint(String id) { IWorkbook workbook = spreadsheetControl1.Document; //string printsuffixs = CRMPublicDA.GetGlobalPrintSuffixs(); //if (printsuffixs == "xinlicheng") //{ DataTable dt = StudentDA.getStudents(id); workbook.LoadDocument("Resources/PrintTemplate/student.xlsx"); int maxcolornum = 28; //每页最大行数 int pagnum = ((dt.Rows.Count - 1) / maxcolornum) + 1; for (int p = 0; p < pagnum; p++) //遍历页 { Worksheet sheet = workbook.Worksheets["Sheet" + (p + 1)]; if (pagnum > p + 1) //打完本页之后,还有其他页需要打印,先把本页模板拷贝到下一页 { workbook.Worksheets.Add("Sheet" + (p + 2)); workbook.Worksheets["Sheet" + (p + 2)].CopyFrom(sheet); } sheet.Cells["b3"].Value = dt.Rows[0]["name"].ToString(); sheet.Cells["e3"].Value = dt.Rows[0]["id"].ToString(); //sheet.Cells["h3"].Value = dt.Rows[0]["pbly"].ToString(); //sheet.Cells["e4"].Value = dt.Rows[0]["ht"].ToString(); //sheet.Cells["h4"].Value = dt.Rows[0]["cler"].ToString(); //sheet.Cells["A24"].Value = dt.Rows[0]["dre"].ToString(); //sheet.Cells["e6"].Value = dt.Rows[0]["tpzl"].ToString(); //sheet.Cells["B28"].Value = dt.Rows[0]["FullName"].ToString(); //sheet.Cells["e5"].Value = Convert.ToDateTime(dt.Rows[0]["cjrq"]).ToString("yyyy-MM-dd"); //sheet.Cells["b4"].Value = Convert.ToDateTime(dt.Rows[0]["jhrq"]).ToString("yyyy-MM-dd"); int startno = 8; string saleorderno = "a"; string cellcardno = "b"; string cellpinming = "c"; string cellsehao = "d"; string cellseming = "e"; string cellpishu = "f"; string cellnewpro = "g"; string cellrmk = "h"; int k = 0; int sumjs = 0; //decimal summs = 0; //decimal sumjz = 0; //decimal summz = 0; for (int j = 0; j < maxcolornum; j++) { int a = p * maxcolornum + j; if (a < dt.Rows.Count) { sheet.Cells[saleorderno + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["name"].ToString(); sheet.Cells[cellcardno + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["id"].ToString(); sheet.Cells[cellpinming + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["sex"].ToString(); //sheet.Cells[cellsehao + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["ep_ColorOrColorway"].ToString(); //sheet.Cells[cellseming + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["ep_quantity"].ToString(); //sheet.Cells[cellpishu + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["unit"].ToString(); //sheet.Cells[cellnewpro + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["fsize"].ToString(); //sheet.Cells[cellrmk + (startno + k)].Value = dt.Rows[(p * maxcolornum) + j]["clre"].ToString(); k++; // sumjs += Convert.ToInt32(dt.Rows[(p * maxcolornum) + j]["ep_quantity"]); //summs += Convert.ToDecimal(dt.Rows[(p * maxcolornum) + j]["ms"]); //// summz += Convert.ToDecimal(dt.Rows[(p * maxcolornum) + j]["mzh"]); //sumjz += Convert.ToDecimal(dt.Rows[(p * maxcolornum) + j]["zl"]); // sheet.Cells["e23"].Value = sumjs.ToString(); //sheet.Cells["d18"].Value = summs.ToString(); ////sheet.Cells["f18"].Value = summz.ToString(); //sheet.Cells["h18"].Value = sumjz.ToString(); } } //} } }