asp.Net
发布时间:2022-04-07 发布网站:大佬教程 code.js-code.com
大佬教程收集整理的这篇文章主要介绍了ASP.NET开发常用简单实用的方法,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
<p style="text-align: center"><span style="font-size: 18px">ASP.NET开发简单实用的方法
打印和导出EXCEL在目前ASP.NET开发中可以说是必要的,有时候针对不同数据难易程度下,用有效快速的方法是解决办法的有效途径之一。
/// /// 调用GOOGLE自带打印格式 /// /// /// protected void Btn_Printf_Click(object sender,EventArgs E) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(),"","",falsE);//后台打印事件 }
/// /// 导出 /// /// /// protected void Btn_Output_Click(object sender,EventArgs E) { var Filename = datetiR_503_11845@e.Now.ToString("yyyy-MM-dd"); System.Data.DataTable dt =需要打印数据; if (dt != null && dt.Rows.Count > 0) { CreateExcel_t(dt,FileName); } else { Response.Write(""); return; } }
/// /// 生成EXCEL /// /// /// ename">生成EXCEL名称 public void CreateExcel_t(DataTable dt,String FileName) { httpContext.Current.Response.Clear(); httpContext.Current.Response.Charset = "UTF-8"; httpContext.Current.Response.ContentType = "application/vnd.ms-xls";
httpContext.Current.Response.AddHeader("content-disposition","attachment;filename=" + Filename + "导出EXEL名称.xls"); StringBuilder table = new StringBuilder(); //
EXCEL标题
); for (int j = 0; j < dt.
column
s.Count; j++)
{ table.Append("
"); table.Append(dt.columns[j].Caption.ToString());//表格的标题 table.Append(" | ); } table.Append("); for (int i = 0; i < dt.Row
s.Count; i++)
{ table.Append("
); for (int j = 0; j < dt.columns.Count; j++) { table.Append(""); table.Append(dt.Rows[i][j].ToString()); table.Append(" | ); } table.Append("
); } table.Append(");
httpCo
ntext.Current.Response.Write(tabl
E);
httpCo
ntext.Current.Response.End(
); }
//在aspx网页中
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
//在Page_Load中
AspNetPager1.RecordCount = (int)Cqzxw.SqlData.ExecuteScalar("SELEct count(*) From 表名");
ShowData();
//在数据绑定时
{
SELEct * From 表名",AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1),AspNetPager1.PageSizE);
source = ds;
);
}
ject sender,EventArgs E)
{
);
}
前端
:10%;"> @H_
674_100@
后端
protected void AspNetPager1_PageChanged(object sender,EventArgs E) { //ShowData(); aspnetpager(); }
public void aspnetpager() { DataTable dt = 需要打印数据; String Msg = ToJson(dt); this.Lab_Count.Text = dt.Rows.Count.ToString(); //设置数量为DataTable的行数 AspNetPager2.RecordCount = dt.Rows.Count; //分页数据源对象 PagedDatasource pds = new PagedDatasource(); //设置为允许分页 pds.AllowPaging = true; //设置每一页的大小 (ASPNetPager1.PageSize在控件属性里面设置) pds.PageSize = this.AspNetPager2.PageSize; //当前页面索引是 aspnetpager控件页面索引-1,因为后者的CurrentPageIndex是1开始 pds.CurrentPageIndex = this.AspNetPager2.CurrentPageIndex - 1; //设置PageDatasource的数据源(DataView) pds.Datasource = dt.DefaultView; //设置repeater的数据源(是PageDatasource) Repeater1.Datasource = pds; //绑定数据 Repeater1.DataBind(); }
WriteLog(String.Format(@"参数={0}、参数={1}、参数={2}、参数={3}、参数={4}、参数={5}",对应参数,对应参数));//编写日志方法
WriteLog("提示字符串"+需要传递的参数);
/// /// 在本地写入错误日志 /// private static readonly object writeFile = new object(); /// /// 在本地写入错误日志 /// /// public static void WriteLog(String debugstr) { lock (writeFilE) { FileStream fs = null; StreamWriter sw = null;
try { //String filename = datetiR_503_11845@e.Now.ToString("yyyy-MM-dd") + ".txt"; String filename = datetiR_503_11845@e.Now.ToString("yyyy-MM-dd") + ".Log.txt"; //服务器中日志目录 //String folder = httpContext.Current.Server.MapPath("~/Log"); String folder = AppDomain.CurrentDomain.baseDirectory + @"Log\"; if (!Directory.Exists(folder)) Directory.CreateDirectory(folder); fs = new FileStream(folder + "/" + filename,System.IO.FileMode.Append,System.IO.FileAccess.WritE); sw = new StreamWriter(fs,Encoding.UTF8); sw.WriteLine(datetiR_503_11845@e.Now.ToString() + " " + debugstr + "\r\n"); } finally { if (sw != null) { sw.Flush(); sw.Dispose(); sw = null; } if (fs != null) { // fs.Flush(); fs.Dispose(); fs = null; } } } }
/// /// DataTable解析Json数据【方法一】 /// /// /// public static String ToJson(DataTable dt) { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); DataRowCollection drc = dt.Rows; for (int i = 0; i < drc.Count; i++) { jsonString.Append("{"); for (int j = 0; j < dt.columns.Count; j++) { String strKey = dt.columns[j].columnName; String strValue = drc[i][j].ToString(); Type type = dt.columns[j].DataType; jsonString.Append("\"" + strKey + "\":"); strValue = StringFormat(strValue,typE); if (j < dt.columns.Count - 1) { jsonString.Append(strValue + ","); } else { jsonString.Append(strvalue); } } jsonString.Append("},"); } jsonString.Remove(jsonString.Length - 1,1); jsonString.Append("]"); return jsonString.ToString(); }
/// /// dataTable转换成Json格式 【方法二】 /// /// /// public static String Datatable2Json(DataTable dt) { StringBuilder jsonBuilder = new StringBuilder(); jsonBuilder.Append("["); for (int i = 0; i < dt.Rows.Count; i++) { jsonBuilder.Append("{"); for (int j = 0; j < dt.Columns.Count; j++) { jsonBuilder.Append("\""); jsonBuilder.Append(dt.Columns[j].ColumnName); jsonBuilder.Append("\":\""); jsonBuilder.Append(dt.Rows[i][j].ToString()); jsonBuilder.Append("\","); } jsonBuilder.Remove(jsonBuilder.Length - 1,1); jsonBuilder.Append("},"); } if (dt.Rows.Count > 0) { jsonBuilder.Remove(jsonBuilder.Length - 1,1); } jsonBuilder.Append("]"); return jsonBuilder.ToString(); }
/// /// 格式化字符型、日期型、布尔型 /// private static String StringFormat(String str,Type typE) { if (type == typeof(String)) { str = String2Json(str); str = "\"" + str + "\""; } else if (type == typeof(datetiR_503_11845@E)) { str = "\"" + str + "\""; } else if (type == typeof(bool)) { str = str.ToLower(); } else if (type != typeof(String) && String.IsNullOrEmpty(str)) { str = "\"" + str + "\""; } return str; }
大佬总结
以上是大佬教程为你收集整理的ASP.NET开发常用简单实用的方法全部内容,希望文章能够帮你解决ASP.NET开发常用简单实用的方法所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签: