生成性DatenerzeugungExcel

工作需要请给我一个密码direkt am代码。很简单keine Notwendigkeit zuerklrenprotectedvoidbtnexport _ Click(object sender，EventArgse){ListBonus .模型LogMemberBonusOutExportExcel=新奖金BLL。LogMemberBonusOut()GetList(1，10000，Session['strWhere']).ToString()；DataSetds=ChangeParantIDToParentExcel(导出excel)；string excel name=' PlayerFundOutListing _ ' style=' color : rgba(0，0，0，1)'DateTime .现在。ToString('yyyyMMdd ')'xls 'CreateExcelFromTable(ds .表[0]，excel名称)；} #地区生成擅长的代码privatevoidCreateExcelFromTable(DataTabletable，string){ httpresponse response=Page .回应；回应ContentEncoding=System .文字。编码。获取编码(“GBK”)；回应AddHeader('内容-处置'

pan style="color: rgba(0, 0, 0, 1)">, "attachment;" + );
            int index = 0;
            string headers = "";
            for (index = 0; index < table.Columns.Count; index++)
            {
                headers += table.Columns[index].ColumnName + "\t";
            }
            headers += "\n";
            response.Write(headers);
            response.Flush();

            foreach (DataRow row in table.Rows)
            {
                string rowContent = "";
                foreach (DataColumn column in table.Columns)
                {
                    rowContent += row[column.ColumnName].ToString() + "\t";
                }
                rowContent += "\n";
                response.Write(rowContent);
                response.Flush();
            }
            response.End();
        }

        private DataSet ChangeParantIDToParentExcel(List<Bonus.Model.LogMemberBonusOut> ListData)
        {
            DataSet ds = new DataSet();
            DataTable tmpDt = new DataTable();

            tmpDt.Columns.Add("TranID");
            tmpDt.Columns.Add("Member Code");
            tmpDt.Columns.Add("Fund Out Amt");
            tmpDt.Columns.Add("Bonus");
            tmpDt.Columns.Add("Product");
            tmpDt.Columns.Add("Fund Out Date");
            tmpDt.Columns.Add("Status");
            tmpDt.Columns.Add("Verified By");
            tmpDt.Columns.Add("Verified Date");

            DataRow dr;

            foreach (var item in ListData)
            {
                dr = tmpDt.NewRow();

                dr["TranID"] = item.OrderID;
                dr["Member Code"] = item.MemberCode;
                dr["Fund Out Amt"] = item.OutMoney;
                dr["Bonus"] = item.Bonus;
                dr["Product"] = GetPname(Convert.ToInt16(item.ProductIDInfo));
                dr["Fund Out Date"] = item.OutDate.ToString("yyyy-MM-dd hh:mm:ss");
                dr["Status"] = item.StatusID;
                dr["Verified By"] = item.CreateBy;
                dr["Verified Date"] = item.CreateDate.ToString("yyyy-MM-dd hh:mm:ss").Replace("0001-01-01 12:00:00", "");

                tmpDt.Rows.Add(dr);
            }

            tmpDt.AcceptChanges();
            ds.Tables.Add(tmpDt);

            return ds;
        }