学步园

/// <summary><br /> /// 导出业绩的个人数据<br /> /// </summary><br /> /// <param name="id"></param><br /> /// <returns></returns><br /> public ActionResult showexcelone(string id)<br /> {<br /> try<br /> {<br /> string idFrom64 = DecodeBase6("gb2312", id);<br /> string[] idArray = idFrom64.Split(new char[] { ';' });<br /> Account account = (Account)Session["Account"];<br /> //List<TGSEXPORTOUTACHIVE> totalmodels = new List<TGSEXPORTOUTACHIVE>();;<br /> //List<TGSEXPORTOUTACHIVE> tempmodels = null;<br /> DataSet tempmodels = null;<br /> DataSet totalmodels = null;<br /> if (account.AREAID.ToString() == "0")<br /> for (int i = 4; i <= 35; i++)<br /> {<br /> tempmodels = SP.TGSExportOutAchiveDS(i, idArray[0].ToString(), DateTime.Parse(idArray[1].ToString()), DateTime.Parse(idArray[2].ToString()));<br /> //for (int j = 0; j < tempmodels.Count; j++)<br /> // totalmodels.Add(tempmodels[j]);<br /> if (i == 4)<br /> totalmodels = tempmodels;<br /> totalmodels.Merge(tempmodels);<br /> }<br /> else if (account.AREAID.ToString() == "1" || account.AREAID.ToString() == "2" || account.AREAID.ToString() == "3")<br /> {<br /> List<TGSAREASHOW> AreaList = SP.TgsAreaShow(int.Parse(account.AREAID.ToString())).ToList();<br /> int j = 0;<br /> foreach (TGSAREASHOW ar in AreaList)<br /> {</p> <p> tempmodels = SP.TGSExportOutAchiveDS(int.Parse(ar.AREAID.ToString()), idArray[0].ToString(), DateTime.Parse(idArray[1].ToString()), DateTime.Parse(idArray[2].ToString()));<br /> if (j == 0)<br /> totalmodels = tempmodels;<br /> totalmodels.Merge(tempmodels);<br /> j++;<br /> //for (int j = 0; j < tempmodels.Count; j++)<br /> // totalmodels.Add(tempmodels[j]);<br /> //if (i == 4)<br /> // totalmodels = tempmodels;<br /> //totalmodels.Merge(tempmodels);<br /> }<br /> }<br /> else<br /> totalmodels = SP.TGSExportOutAchiveDS(int.Parse(account.AREAID.ToString()), idArray[0].ToString(), DateTime.Parse(idArray[1].ToString()), DateTime.Parse(idArray[2].ToString()));</p> <p> DataView dv = new DataView(totalmodels.Tables[0]);//将DataSet转换成DataView<br /> if (totalmodels != null)<br /> {<br /> CreateExcelone("OutachiveExcelOne.xls", dv);<br /> // return View();<br /> return null;<br /> }<br /> //return View();<br /> return null;<br /> }<br /> catch (System.Exception e)<br /> {<br /> return null;<br /> }<br /> }</p> <p> /// <summary><br /> /// 导出个人数据（通过excel）<br /> /// </summary><br /> /// <param name="FileName"></param><br /> /// <param name="dv"></param><br /> public static void CreateExcelone(string FileName, DataView dv)<br /> {<br /> //HttpResponse resp;<br /> //resp = System.Web.HttpContext.Current.Response;<br /> //resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");<br /> //resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);<br /> //string colHeaders = "";<br /> //string ls_item = "";<br /> //colHeaders = "大区" + "/t" + "办事处" + "/t" + "姓名" + "/t" + "职位" + "/t" + "帐号" + "/t" + "入职日期" + "/t" + "离职日期" + "/t" + "基础工作（打卡网吧）" + "/t" + "基础工作（打卡次数）" + "/t" + "基础工作（投票）" + "/t" + "直接推广（绑定）" + "/t" + "直接推广（领取）" + "/t" + "直接推广（有效）" + "/t" + "直接推广（消费）" + "/t" + "直接推广（金额）" + "/t" + "间接推广（消费）" + "/t" + "间接推广（金额）" + "/t" + "线上推广（绑定）" + "/t" + "线上推广（领取）" + "/t" + "线上推广（消费）" + "/t" + "线上推广（金额）" + "/t" + "其他推广（绑定）" + "/t" + "其他推广（领取）" + "/t" + "其他推广（有效）" + "/t" + "其他推广（消费）" + "/t" + "其他推广（金额）" + "/t" + "录入网吧" + "/t" + "绑定网吧" + "/t" + "锁定网吧" + "/t" + "考核次数" + "/t" + "考核得分" + "/t" + "活动次数" + "/t" + "活动评估" + "/t" + "帐号封停" +"/n";<br /> //resp.Write(colHeaders);<br /> //for (int i = 0; i < models.Count; i++)<br /> //{<br /> // ls_item += models[i].ZONENAME + "/t";<br /> // ls_item += models[i].AREANAME + "/t";<br /> // ls_item += models[i].USERNAME + "/t";<br /> // ls_item += models[i].PLACENAME + "/t";<br /> // ls_item += models[i].UACCOUNT + "/t";<br /> // ls_item += models[i].ENTERTIME + "/t";<br /> // ls_item += models[i].DIMISSIONTIME + "/t";<br /> // ls_item += models[i].CINNETBAR + "/t";<br /> // ls_item += models[i].CINTIMES + "/t";<br /> // ls_item += models[i].VOTETIMES + "/t";<br /> // ls_item += models[i].BINDNUM + "/t";<br /> // ls_item += models[i].ZJGETNUM + "/t";<br /> // ls_item += models[i].ZJAVAILNUM + "/t";<br /> // ls_item += models[i].ZJCONSNUM + "/t";<br /> // ls_item += models[i].ZJCONSSUM + "/t";<br /> // ls_item += models[i].IDCONSNUM + "/t";<br /> // ls_item += models[i].IDCONSSUM + "/t";<br /> // ls_item += models[i].BINDNUM + "/t";<br /> // ls_item += models[i].XTGETNUM + "/t";<br /> // ls_item += models[i].XTCONSNUM + "/t";<br /> // ls_item += models[i].XTCONSSUM + "/t";<br /> // ls_item += models[i].BINDNUM + "/t";<br /> // ls_item += models[i].QTGETNUM + "/t";<br /> // ls_item += models[i].QTAVAILNUM + "/t";<br /> // ls_item += models[i].QTCONSNUM + "/t";<br /> // ls_item += models[i].QTCONSSUM + "/t";<br /> // ls_item += models[i].APPLYNUM + "/t";<br /> // ls_item += models[i].BINDNUM + "/t";<br /> // ls_item += models[i].LOCKNUM + "/t";<br /> // ls_item += models[i].CS + "/t";<br /> // ls_item += models[i].POINT + "/t";<br /> // ls_item += models[i].ACTTIMES + "/t";<br /> // ls_item += models[i].ACTGRADE + "/t";<br /> // ls_item += models[i].BANNUM + "/t";<br /> // ls_item += "/n";<br /> //}<br /> //ls_item += "/n";<br /> //ls_item += "/n";<br /> //ls_item += "/n";<br /> //ls_item += "数据说明： " + "/n";<br /> //ls_item += "·打卡网吧：该推广人员打卡的网吧数量，一个网吧在一天内无论推广员打几次卡都只统计为一次。" + "/n";<br /> //ls_item += "·打卡次数：该推广人员打卡总次数，同网吧同天的多次打卡最多统计2次。" + "/n";<br /> //ls_item += "·投票：同一IP每款游戏每天只计算一次。投票统计只区分帐号，不论是否在推广员绑定或锁定的网吧内进行。" + "/n";<br /> //ls_item += "·线上推广：线推帐号业绩，非线推帐号则为零 " + "/n";<br /> //ls_item += "·其它推广：推广员帐号产生的非地推业绩 " + "/n";<br /> //ls_item += "·绑定：该帐号被玩家（久游通行证）绑定的数量 " + "/n";<br /> //ls_item += "·领取：该帐号被玩家绑定后发生新手卡道具领取的数量。单款游戏单独统计。 " + "/n";<br /> //ls_item += "·有效：根据游戏和推广阶段分别定义的有效用户数量，如无特殊定义则等同与消费数。 " + "/n";<br /> //ls_item += "·消费：有效用户中将M币划分或直接消费的用户数量 " + "/n";<br /> //ls_item += "·录入网吧：所查询的结束日期时由该推广员录入并已通过审核的网吧数量。 " + "/n";<br /> //ls_item += "·绑定网吧：所查询的结束日期时该推广员绑定的网吧数量" + "/n";<br /> //ls_item += "·锁定网吧：所查询的结束日期时该推广员锁定的网吧数量 " + "/n";<br /> //ls_item += "·考核次数：查询周期内该推广员下属网吧被考核的次数，包含主管考核和督察考核。" + "/n";<br /> //ls_item += "·活动次数：查询周期内该推广员执行活动的次数，以执行完毕的活动（有评估结果）为准。 " + "/n";<br /> //ls_item += "·帐号封停：查询周期内该推广员帐号被封停的天数。" + "/n";<br /> //ls_item += "·网吧主管帐号数据为其下属推广人员数据的总和" + "/n";</p> <p> //resp.Write(ls_item);<br /> //resp.End();<br /> try<br /> {</p> <p> int sheetRows = 65535;//设置Sheet的行数,此为最大上限,本来是65536,因表头要占去一行<br /> int sheetCount = (dv.Table.Rows.Count - 1) / sheetRows + 1;//计算Sheet数<br /> GC.Collect();//垃圾回收<br /> Application excel;<br /> _Workbook xBk;<br /> _Worksheet xSt = null;<br /> excel = new ApplicationClass();<br /> xBk = excel.Workbooks.Add(true);<br /> //定义循环中要使用的变量<br /> int dvRowStart;<br /> int dvRowEnd;<br /> int rowIndex = 0;<br /> int colIndex = 0;<br /> //对全部Sheet进行操作<br /> for (int sheetIndex = 0; sheetIndex < sheetCount; sheetIndex++)<br /> {<br /> //初始化Sheet中的变量<br /> rowIndex = 1;<br /> colIndex = 1;<br /> //计算起始行<br /> dvRowStart = sheetIndex * sheetRows;<br /> dvRowEnd = dvRowStart + sheetRows - 1;<br /> if (dvRowEnd > dv.Table.Rows.Count - 1)<br /> {<br /> dvRowEnd = dv.Table.Rows.Count - 1;<br /> }<br /> //创建一个Sheet<br /> if (null == xSt)<br /> {<br /> xSt = (_Worksheet)xBk.Worksheets.Add(Type.Missing, Type.Missing, 1, Type.Missing);<br /> }<br /> else<br /> {<br /> xSt = (_Worksheet)xBk.Worksheets.Add(Type.Missing, xSt, 1, Type.Missing);<br /> }<br /> //设置Sheet的名称<br /> xSt.Name = "个人数据";<br /> if (sheetCount > 1)<br /> {<br /> xSt.Name += ((int)(sheetIndex + 1)).ToString();<br /> }<br /> //取得标题<br /> foreach (DataColumn col in dv.Table.Columns)<br /> {<br /> //设置标题格式<br /> //xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex]).Interior.ColorIndex = 19; //设置标题居中对齐<br /> //xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex]).Font.Bold = true;//设置标题为粗体<br /> //填值，并进行下一列<br /> switch (col.ColumnName)<br /> {<br /> case "ZONENAME":<br /> excel.Cells[rowIndex, colIndex++] = "大区";<br /> break;<br /> case "AREANAME":<br /> excel.Cells[rowIndex, colIndex++] = "办事处";<br /> break;<br /> case "USERNAME":<br /> excel.Cells[rowIndex, colIndex++] = "姓名";<br /> break;<br /> case "PLACENAME":<br /> excel.Cells[rowIndex, colIndex++] = "职位";<br /> break;<br /> case "UACCOUNT":<br /> excel.Cells[rowIndex, colIndex++] = "帐号";<br /> break;<br /> case "ENTERTIME":<br /> excel.Cells[rowIndex, colIndex++] = "入职日期";<br /> break;<br /> case "DIMISSIONTIME":<br /> excel.Cells[rowIndex, colIndex++] = "离职日期";<br /> break;<br /> case "ZJGETNUM":<br /> excel.Cells[rowIndex, colIndex] = "直接推广";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 3]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 3]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> excel.Cells[rowIndex + 1, colIndex++] = "领取";<br /> break;<br /> case "ZJAVAILNUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "有效";<br /> break;<br /> case "ZJCONSNUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "消费";<br /> break;<br /> case "ZJCONSSUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "金额";<br /> break;<br /> case "IDCONSNUM":<br /> excel.Cells[rowIndex, colIndex] = "间接推广";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 1]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 1]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> excel.Cells[rowIndex + 1, colIndex++] = "消费";<br /> break;<br /> case "IDCONSSUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "金额";<br /> break;<br /> case "XTGETNUM":<br /> excel.Cells[rowIndex, colIndex] = "线上推广";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 2]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 2]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> excel.Cells[rowIndex + 1, colIndex++] = "领取";<br /> break;<br /> case "XTCONSNUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "消费";<br /> break;<br /> case "XTCONSSUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "金额";<br /> break;<br /> case "QTGETNUM":<br /> excel.Cells[rowIndex, colIndex] = "其他推广";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 3]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 3]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> excel.Cells[rowIndex + 1, colIndex++] = "领取";<br /> break;<br /> case "QTAVAILNUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "有效";<br /> break;<br /> case "QTCONSNUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "消费";<br /> break;<br /> case "QTCONSSUM":<br /> excel.Cells[rowIndex + 1, colIndex++] = "金额";<br /> break;<br /> //case "EXECNUM":<br /> // excel.Cells[rowIndex, colIndex++] = "执行";<br /> // break;<br /> //case "DIMNUM":<br /> // excel.Cells[rowIndex, colIndex++] = "离职";<br /> // break;<br /> //case "NOVNUM":<br /> // excel.Cells[rowIndex, colIndex++] = "见习";<br /> // break;</p> <p> case "APPLYNUM":<br /> excel.Cells[rowIndex, colIndex++] = "申请网吧";<br /> break;<br /> //case "FREENUM":<br /> // excel.Cells[rowIndex, colIndex++] = "游离网吧";<br /> // break;<br /> case "BINDNUM":<br /> excel.Cells[rowIndex, colIndex++] = "绑定网吧";<br /> break;<br /> case "LOCKNUM":<br /> excel.Cells[rowIndex, colIndex++] = "锁定网吧";<br /> break;<br /> case "CINTIMES":<br /> excel.Cells[rowIndex, colIndex] = "基础工作";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 2]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 2]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> excel.Cells[rowIndex + 1, colIndex++] = "打卡次数";<br /> break;<br /> case "VOTETIMES":<br /> excel.Cells[rowIndex + 1, colIndex++] = "投票";<br /> break;<br /> case "CINNETBAR":<br /> excel.Cells[rowIndex + 1, colIndex++] = "打卡网吧";<br /> break;<br /> case "ACTIVENUM":<br /> excel.Cells[rowIndex, colIndex++] = "消费";<br /> break;<br /> case "BANNUM":<br /> excel.Cells[rowIndex, colIndex++] = "帐号封停";<br /> break;<br /> case "ACTTIMES":<br /> excel.Cells[rowIndex, colIndex++] = "活动次数";<br /> break;<br /> case "ACTGRADE":<br /> excel.Cells[rowIndex, colIndex++] = "活动评估";<br /> break;<br /> case "POINT":<br /> excel.Cells[rowIndex, colIndex++] = "考核得分";<br /> break;<br /> case "CS":<br /> excel.Cells[rowIndex, colIndex++] = "考核次数";<br /> break;<br /> case "AREAID":<br /> excel.Cells[rowIndex, colIndex++] = "办事处ID";<br /> break;<br /> }<br /> //excel.Cells[rowIndex, colIndex++] = col.ColumnName;<br /> }<br /> //取得表格中数量<br /> int drvIndex;<br /> rowIndex++;<br /> for (drvIndex = dvRowStart; drvIndex <= dvRowEnd; drvIndex++)<br /> {<br /> DataRowView row = dv[drvIndex];<br /> //新起一行，当前单元格移至行首<br /> rowIndex++;<br /> colIndex = 1;<br /> foreach (DataColumn col in dv.Table.Columns)<br /> {<br /> //if (col.DataType == System.Type.GetType("System.DateTime"))<br /> //{<br /> // excel.Cells[rowIndex, colIndex] = (Convert.ToDateTime(row[col.ColumnName].ToString())).ToString("yyyy-MM-dd");<br /> //}<br /> //else if (col.DataType == System.Type.GetType("System.String"))<br /> //{<br /> // excel.Cells[rowIndex, colIndex] = "'" + row[col.ColumnName].ToString();<br /> //}<br /> //else<br /> //{<br /> excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();<br /> //}<br /> colIndex++;<br /> }<br /> }</p> <p> //使用最佳宽度<br /> Range allDataWithTitleRange = xSt.get_Range(excel.Cells[1, 1], excel.Cells[rowIndex, colIndex - 1]);<br /> allDataWithTitleRange.Select();<br /> allDataWithTitleRange.Columns.AutoFit();<br /> allDataWithTitleRange.Borders.LineStyle = 1;//将导出Excel加上边框<br /> rowIndex++;<br /> rowIndex++;<br /> rowIndex++;<br /> colIndex = 1;</p> <p> excel.Cells[rowIndex, colIndex] = "数据说明： " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·打卡网吧：该推广人员打卡的网吧数量，一个网吧在一天内无论推广员打几次卡都只统计为一次。" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·打卡次数：该推广人员打卡总次数，同网吧同天的多次打卡最多统计2次。" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·投票：同一IP每款游戏每天只计算一次。投票统计只区分帐号，不论是否在推广员绑定或锁定的网吧内进行。" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·线上推广：线推帐号业绩，非线推帐号则为零 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·其它推广：推广员帐号产生的非地推业绩 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·绑定：该帐号被玩家（久游通行证）绑定的数量 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·领取：该帐号被玩家绑定后发生新手卡道具领取的数量。单款游戏单独统计。 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·有效：根据游戏和推广阶段分别定义的有效用户数量，如无特殊定义则等同与消费数。 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·消费：有效用户中将M币划分或直接消费的用户数量 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·录入网吧：所查询的结束日期时由该推广员录入并已通过审核的网吧数量。 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·绑定网吧：所查询的结束日期时该推广员绑定的网吧数量" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·锁定网吧：所查询的结束日期时该推广员锁定的网吧数量 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·考核次数：查询周期内该推广员下属网吧被考核的次数，包含主管考核和督察考核。" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·活动次数：查询周期内该推广员执行活动的次数，以执行完毕的活动（有评估结果）为准。 " + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·帐号封停：查询周期内该推广员帐号被封停的天数。" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;<br /> excel.Cells[rowIndex, colIndex] = "·网吧主管帐号数据为其下属推广人员数据的总和" + "/n";<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).Select();<br /> xSt.get_Range(excel.Cells[rowIndex, colIndex], excel.Cells[rowIndex, colIndex + 20]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;<br /> rowIndex++;</p> <p> }<br /> //设置导出文件在服务器上的文件夹<br /> string exportDir = "~/ExcelFile/";//注意:该文件夹您须事先在服务器上建好才行<br /> //设置文件在服务器上的路径<br /> string absFileName = System.Web.HttpContext.Current.Server.MapPath(System.IO.Path.Combine(exportDir, FileName));<br /> xBk.SaveCopyAs(absFileName);<br /> xBk.Close(false, null, null);<br /> excel.Quit();<br /> System.Runtime.InteropServices.Marshal.ReleaseComObject(xBk);<br /> System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);<br /> System.Runtime.InteropServices.Marshal.ReleaseComObject(xSt);<br /> xBk = null;<br /> excel = null;<br /> xSt = null;<br /> GC.Collect();<br /> HttpContext curContext = System.Web.HttpContext.Current;<br /> curContext.Response.ContentType = "application/vnd.ms-excel";<br /> curContext.Response.ContentEncoding = System.Text.Encoding.Default;<br /> curContext.Response.AppendHeader("Content-Disposition", ("attachment;filename=" + FileName));<br /> curContext.Response.Charset = "";<br /> curContext.Response.WriteFile(absFileName);<br /> curContext.Response.Flush();<br /> curContext.Response.End();<br /> }<br /> catch (System.Exception e)<br /> {<br /> }<br /> }<br />