##后臺處理獲取打印數據 ``` using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using NetWing.Common.Data.SqlServer; using System.Data; using System.Data.Sql; using System.Data.SqlClient; namespace NetWing.BPM.Admin { public partial class print : System.Web.UI.Page { public DataRow homemasterdr = null;//戶主信息 public DataTable huzhuxxdt = null;//戶主信息 public DataTable peoples = null;//除戶主外家庭成員信息 public DataTable jydt = null;//教育情況DataTable public DataTable yldt = null;//養老保險DataTable public DataTable dbdt = null;//低保情況 public DataTable cldt = null;//其它情況(車輛信息) public DataTable hbdt = null;//其它情況(患病情況) public DataTable yzdt = null;//養殖收入 public DataTable zzdt = null;//種植收入 public DataTable gzdt = null;//工資收入 public DataTable qtdt = null;//其它收入 public DataTable zcdt = null;//其它支出 public DataTable jtdt = null;//家庭屬性 public DataTable jcdt = null;//車輛圖片 public DataRow fwdr = null;//房屋圖片 public DataRow dbdr = null; public string nf = ""; public string sqlwhere = ""; public string[] strArr = { }; protected void Page_Load(object sender, EventArgs e) { nf = Request["nf"]; if (!string.IsNullOrEmpty(nf))//不為空 { sqlwhere = " and years='"+ nf + "'"; } else//空 { } if (!IsPostBack) { string homemasteridcard = Request["homemasteridcard"];//戶主身份證號 homemasterdr = SqlEasy.ExecuteDataRow("select top 1 * from No1_people where idcard='" + homemasteridcard + "'");//得到戶主信息 //戶主信息 huzhuxxdt = SqlEasy.ExecuteDataTable("select top 1 * from No1_people where idcard='" + homemasteridcard + "'"); //得到家庭成員戶主除外 peoples = SqlEasy.ExecuteDataTable("select * from No1_people where idcard<>'" + homemasteridcard + "' and homemasteridcard='" + homemasteridcard + "'"); //教育情況處理思路 //1.把戶主，家庭成員身份證信息取出來列成 'a','b', //2.算出有幾個人參加過教育培訓 //3.把教育培訓的人返回datatable //例子：SQL codeselect * from student where name in ('張三','李四')- string peoplesidcards = "'" + homemasteridcard + "'"; foreach (DataRow psdr in peoples.Rows) { peoplesidcards = peoplesidcards + ",'" + psdr["idcard"].ToString() + "'"; } //家庭屬性 jtdt = SqlEasy.ExecuteDataTable("select * from No1_people where idcard in (" + peoplesidcards + ")"); //教育情況 jydt = SqlEasy.ExecuteDataTable("select * from No1_jiaoyu where idcard in (" + peoplesidcards + ")"); //養老保險 yldt = SqlEasy.ExecuteDataTable("select * from No1_yanglaobx where idcard in (" + peoplesidcards + ")" + sqlwhere); //低保情況 //string sqlff = "select * from No1_dibao where idcard in (" + peoplesidcards + ")"; dbdt = SqlEasy.ExecuteDataTable("select * from No1_dibao where idcard in (" + peoplesidcards + ")" + sqlwhere); //其它情況 cldt = SqlEasy.ExecuteDataTable("select * from No1_cheliangxinxi where idcard in (" + peoplesidcards + ")");//車輛信息 hbdt = SqlEasy.ExecuteDataTable("select * from No1_huanbingqk where idcard in (" + peoplesidcards + ")");//患病情況 //養殖收入 yzdt = SqlEasy.ExecuteDataTable("select * from No1_yangzhishr where idcard in (" + peoplesidcards + ") " + sqlwhere); //種植收入 zzdt = SqlEasy.ExecuteDataTable("select * from No1_zhongzhishr where idcard in (" + peoplesidcards + ")" + sqlwhere); //工資收入 gzdt = SqlEasy.ExecuteDataTable("select * from No1_gongzishr where idcard in (" + peoplesidcards + ")" + sqlwhere); //其它收入 qtdt=SqlEasy.ExecuteDataTable("select * from No1_zhuanyishr where idcard in (" + peoplesidcards + ")" + sqlwhere); //其他支出 zcdt = SqlEasy.ExecuteDataTable("select * from No1_zhichuqk where idcard in (" + peoplesidcards + ")" + sqlwhere); //車輛圖片 jcdt = SqlEasy.ExecuteDataTable("select top 2 * from No1_cheliangxinxi where idcard in (" + peoplesidcards + ")"); //房屋照片 string sqlcha = "select photos from No1_people where idcard='" + homemasteridcard + "'"; DataRow fwdt = SqlEasy.ExecuteDataRow(sqlcha); strArr = fwdt["photos"].ToString().Split(';'); } } /// <summary> /// 判斷是否有殘疾證 /// </summary> /// <param name="idcard">身份證號</param> /// <returns></returns> public static string IsCanji(string idcard) { //判斷庫里是否有這條數據，有一條返回1有N條返回N沒有返回0 int k= (int)SqlEasy.ExecuteScalar("select count(keyid) from No1_canji where cardno='" + idcard + "'" ); if (k==0) { return "否"; } else { return "是"; } } /// <summary> /// 判斷是否是低保 /// </summary> /// <param name="idcard">身份證號</param> /// <returns></returns> public static string IsDibao(string idcard) { //判斷庫里是否有這條數據，有一條返回1有N條返回N沒有返回0 int d = (int)SqlEasy.ExecuteScalar("select count(keyid) from No1_dibao where idcard='" + idcard + "'"); if (d == 0) { return "否"; } else { return "是"; } } /// <summary> /// 判斷是否參保養老保險 /// </summary> /// <param name="idcard">身份證號</param> /// <returns></returns> public static string IsYlbx(string idcard) { //判斷庫里是否有這條數據，有一條返回1有N條返回N沒有返回0 int d = (int)SqlEasy.ExecuteScalar("select count(keyid) from No1_yanglaobx where idcard='" + idcard + "'"); if (d == 0) { return "否"; } else { return "是"; } } /// <summary> /// 判斷是否參保養老保險 /// </summary> /// <param name="idcard">身份證號</param> /// <returns></returns> public static string Isylbx(string idcard) { //判斷庫里是否有這條數據，有一條返回1有N條返回N沒有返回0 int d = (int)SqlEasy.ExecuteScalar("select count(keyid) from No1_yiliaobx where idcard='" + idcard + "'"); if (d == 0) { return "否"; } else { return "是"; } } protected void Button1_Click(object sender, EventArgs e) { } } } ```