学步园

//后台方法<br /> /// <summary><br /> /// 生存CSV文件<br /> /// </summary><br /> /// <param name="Date">统计月份</param><br /> /// <param name="type">数据源</param><br /> /// <param name="filePath">文件路径</param><br /> public void getContractImportCsv(string Date, string type, string filePath)<br /> {<br /> string importsql = returnSql(Date, type);<br /> try<br /> {<br /> using (SqlConnection connection = new SqlConnection(DbHelperSQL.connectionString))<br /> {<br /> int index = 0;<br /> connection.Open();<br /> SqlCommand command = new SqlCommand(importsql, connection);<br /> command.CommandType = CommandType.Text;<br /> SqlDataReader retReader = command.ExecuteReader(CommandBehavior.CloseConnection);<br /> System.IO.StringWriter Ends = new System.IO.StringWriter();<br /> if (type.Equals("合同明细"))<br /> {<br /> while (retReader.Read())<br /> {<br /> Ends.Write(retReader["统计日期"].ToString() + ",");<br /> Ends.Write(retReader["分行号"].ToString() + ",");<br /> Ends.Write(retReader["机构号"].ToString() + ",");<br /> Ends.Write(retReader["借据号"].ToString() + ",");<br /> Ends.Write(retReader["合同编号"].ToString() + ",");<br /> Ends.Write(retReader["基准利率"].ToString() + ",");<br /> Ends.Write(retReader["浮动利率"].ToString() + ",");<br /> Ends.Write(retReader["执行利率"].ToString() + ",");<br /> Ends.Write(retReader["放款日期"].ToString() + ",");<br /> Ends.Write(retReader["到期日期"].ToString() + ",");<br /> Ends.Write(retReader["贷款期限"].ToString() + ",");<br /> Ends.Write(retReader["贷款期限"].ToString() + ",");<br /> Ends.Write(retReader["贷款金额"].ToString() + ",");<br /> Ends.Write(retReader["还款方式"].ToString() + ",");<br /> Ends.Write(retReader["抽取日期"].ToString() + ",");<br /> Ends.Write(Ends.NewLine);<br /> index++;<br /> if (index == 200000)//当记时器等于20万时，进行数据写入，然后关闭，在开启<br /> {<br /> Ends.Close();<br /> StreamWriter sw = new StreamWriter(filePath, true, System.Text.Encoding.GetEncoding("GB2312"));<br /> sw.Write(Ends);<br /> sw.Close();<br /> Ends = new System.IO.StringWriter();<br /> index = 0;//记时器清"0”<br /> }<br /> }<br /> }<br /> else if (type.Equals("还款明细"))<br /> {<br /> while (retReader.Read())<br /> {<br /> Ends.Write(retReader["统计日期"].ToString() + ",");<br /> Ends.Write(retReader["分行号"].ToString() + ",");<br /> Ends.Write(retReader["机构号"].ToString() + ",");<br /> Ends.Write(retReader["借据号"].ToString() + ",");<br /> Ends.Write(retReader["合同编号"].ToString() + ",");<br /> Ends.Write(retReader["还款期次"].ToString() + ",");<br /> Ends.Write(retReader["当期约定还款日期"].ToString() + ",");<br /> Ends.Write(retReader["当期实际还款日期"].ToString() + ",");<br /> Ends.Write(retReader["当期实际还款本金"].ToString() + ",");<br /> Ends.Write(retReader["本次还款后贷款余额"].ToString() + ",");<br /> Ends.Write(retReader["下期计划应还本金"].ToString() + ",");<br /> Ends.Write(retReader["贷款状态"].ToString() + ",");<br /> Ends.Write(retReader["抽取日期"].ToString() + ",");<br /> Ends.Write(Ends.NewLine);<br /> index++;<br /> if (index == 200000)//当记时器等于20万时，进行数据写入，然后关闭，在开启<br /> {<br /> Ends.Close();<br /> StreamWriter sw = new StreamWriter(filePath, true, System.Text.Encoding.GetEncoding("GB2312"));<br /> sw.Write(Ends);<br /> sw.Close();<br /> Ends = new System.IO.StringWriter();<br /> index = 0;//记时器清"0”<br /> }<br /> }<br /> }<br /> retReader.Close();<br /> Ends.Close();<br /> StreamWriter sws = new StreamWriter(filePath, true, System.Text.Encoding.GetEncoding("GB2312"));<br /> sws.Write(Ends);<br /> sws.Close();<br /> Ends = null;<br /> }<br /> }<br /> catch (Exception ex)<br /> {</p> <p> new Exception(ex.Message);<br /> }<br /> }</p> <p> /// <summary><br /> /// 生存txt文件<br /> /// </summary><br /> /// <param name="Date">统计月份</param><br /> /// <param name="type">数据源</param><br /> /// <param name="filePath">文件路径</param><br /> public void getContractImportTxt(string Date, string type, string filePath)<br /> {<br /> string importsql = returnSql(Date, type);<br /> try<br /> {<br /> using (SqlConnection connection = new SqlConnection(DbHelperSQL.connectionString))<br /> {<br /> int index = 0;<br /> connection.Open();<br /> SqlCommand command = new SqlCommand(importsql, connection);<br /> command.CommandType = CommandType.Text;<br /> SqlDataReader retReader = command.ExecuteReader(CommandBehavior.CloseConnection);</p> <p> StringBuilder strhtm = new StringBuilder();<br /> if (type.Equals("合同明细"))<br /> {<br /> while (retReader.Read())<br /> {<br /> strhtm.AppendFormat("{0}", retReader["统计日期"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["分行号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["机构号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["借据号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["合同编号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["基准利率"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["浮动利率"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["执行利率"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["放款日期"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["到期日期"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["贷款期限"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["贷款期限"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["贷款金额"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["还款方式"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["抽取日期"].ToString() + "/t");<br /> strhtm.Append("/r/n");<br /> index++;<br /> if (index == 200000)//当记时器等于20万时，进行数据写入，然后关闭，在开启<br /> {<br /> StreamWriter sw = new StreamWriter(filePath, true, System.Text.Encoding.UTF8);<br /> sw.Write(strhtm.ToString());<br /> sw.Close();<br /> strhtm = new StringBuilder();<br /> index = 0;//记时器清"0”<br /> }<br /> }<br /> }<br /> else if (type.Equals("还款明细"))<br /> {<br /> while (retReader.Read())<br /> {<br /> strhtm.AppendFormat("{0}", retReader["统计日期"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["分行号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["机构号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["借据号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["合同编号"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["还款期次"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["当期约定还款日期"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["当期实际还款日期"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["当期实际还款本金"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["本次还款后贷款余额"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["下期计划应还本金"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["贷款状态"].ToString() + "/t");<br /> strhtm.AppendFormat("{0}", retReader["抽取日期"].ToString() + "/t");<br /> strhtm.Append("/r/n");<br /> index++;<br /> if (index == 200000)//当记时器等于20万时，进行数据写入，然后关闭，在开启<br /> {<br /> StreamWriter sw = new StreamWriter(filePath, true, System.Text.Encoding.UTF8);<br /> sw.Write(strhtm.ToString());<br /> sw.Close();<br /> strhtm = new StringBuilder();<br /> index = 0;//记时器清"0”<br /> }<br /> }<br /> }<br /> retReader.Close();<br /> StreamWriter sws = new StreamWriter(filePath, true, System.Text.Encoding.UTF8);<br /> sws.Write(strhtm);<br /> sws.Close();<br /> strhtm = null;<br /> }<br /> }<br /> catch (Exception ex)<br /> {</p> <p> new Exception(ex.Message);<br /> }<br /> }</p> <p>------------------------------------------------------------</p> <p>//前台调用</p> <p>/// <summary><br /> /// 导出<br /> /// </summary><br /> /// <param name="sender"></param><br /> /// <param name="e"></param><br /> protected void btnExport_Click(object sender, EventArgs e)<br /> {<br /> if (CheckIsNull())<br /> {<br /> string name = this.DropDMonths.SelectedValue.ToString() + this.DropDDataScoure.SelectedValue.ToString() + "." + this.DropDFormat.SelectedValue.ToString();<br /> string FilePath = Server.MapPath(string.Format("~/DpExecl/{0}", name));<br /> try<br /> {<br /> if (this.DropDFormat.SelectedValue == "xls")//以"xls"格式导出<br /> {<br /> icb.getContractImportDataScoure(this.DropDMonths.SelectedValue.ToString(), this.DropDDataScoure.SelectedValue.ToString(), FilePath);</p> <p> }<br /> else if (this.DropDFormat.SelectedValue == "csv")//以"csv"格式导出<br /> {<br /> icb.getContractImportCsv(this.DropDMonths.SelectedValue.ToString(), this.DropDDataScoure.SelectedValue.ToString(), FilePath);<br /> }<br /> else if (this.DropDFormat.SelectedValue == "txt")//以"txt"格式导出<br /> {<br /> icb.getContractImportTxt(this.DropDMonths.SelectedValue.ToString(), this.DropDDataScoure.SelectedValue.ToString(), FilePath);<br /> }<br /> }<br /> catch (Exception es)<br /> {</p> <p> ClientScript.RegisterStartupScript(GetType(), "", "<mce:script type="text/javascript"><!--<br /> alert('" + es.Message + "');<br /> // --></mce:script>");<br /> return;<br /> }<br /> Response.Clear();<br /> Response.Charset = "UTF-8";<br /> Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");<br /> Response.ContentType = "application/octet-stream";<br /> Response.AppendHeader("Content-Disposition", "attachment;filename= " + HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8));<br /> System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);<br /> if (File.Exists(FilePath))//是否存在所指定的文件，如果存在进行下载<br /> {<br /> FileInfo file = new FileInfo(FilePath);<br /> Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); //解决中文乱码<br /> Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name)); //解决中文文件名乱码<br /> Response.AddHeader("Content-length", file.Length.ToString());<br /> Response.ContentType = "appliction/octet-stream";<br /> Response.WriteFile(file.FullName);<br /> Response.Flush();<br /> if (file.Exists)<br /> {<br /> file.Delete();<br /> }<br /> Response.End();<br /> }<br /> }<br /> }