protected void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� DataTable dt = new DataTable(); string sql = "Select semployeeid,semployeename from FCS_EMPLOYEE "; DBConn myCn= new DBConn(); myCn.DBOpen(); OleDbCommand myCommand = new OleDbCommand(sql,new OleDbConnection(myCn.strConn)); OleDbDataAdapter sdap = new OleDbDataAdapter(myCommand); sdap.Fill(dt); myCn.DBClose(); StringBuilder sb = new StringBuilder(); sb.Append("<table cellpadding=\"0\" id=\"tab\" name=\"tab\" cellspacing=\"0\" height=\"25\" width=\"100%\" frame=border>"); if (dt.Rows.Count >0) { foreach(DataRow iRow in dt.Rows) { sb.Append("<tr class=\"alternate2\" >"); sb.Append("<td width = \"100px\">"+ iRow["semployeename"].ToString()+"</td>"); sb.Append("<td><input type='checkbox' id='chkDisabled' name='chkDisabled'> ���� <input type='checkbox' id='chkDisplay' name='chkDisplay'> ���� <input type='checkbox' id='chkRead' name='chkRead'> ֻ��</td>"); sb.Append("</tr>"); } } sb.Append("</table>"); if (dt != null) dt.Dispose(); div1.InnerHtml = sb.ToString(); }
protected void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� try { //��ֹ�ⲿ�����ύ�Ľű� /*string sHttp=Request.Headers["referer"]; string sServer=Request.Headers["host"]; if (sServer.Equals(sHttp.Substring(7,sServer.Length))==false) { Console.WriteLine("���ύ��·������ֹ��վ���ⲿ�ύ����! "+sHttp); return ; }*/ //�ύ������ string strOperator = Request.QueryString.ToString(); StreamReader sr=new StreamReader(Request.InputStream); string strXml =sr.ReadToEnd(); DBConn myCn= new DBConn(); //OleDbConnection myConn = myCn.myCn ; WebBillDll.PathFile pathfile = new WebBillDll.PathFile(strXml,Request.PhysicalApplicationPath);//����web.config�����Ӵ� string strReturn = pathfile.returnXml(strOperator,Request); Response.Write(strReturn); } catch (Exception ex) { Response.Write(ex.Message); } }
protected void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 try { //防止外部数据提交的脚本 /*string sHttp=Request.Headers["referer"]; string sServer=Request.Headers["host"]; if (sServer.Equals(sHttp.Substring(7,sServer.Length))==false) { Console.WriteLine("你提交的路径有误,禁止从站点外部提交数据! "+sHttp); return ; }*/ //提交的名称 string strOperator = Request.QueryString.ToString(); StreamReader sr=new StreamReader(Request.InputStream); string strXml =sr.ReadToEnd(); //if(strOperator.Equals("test") ){ // Response.Write(SetSessionTest(strXml)); // return ; //} //string MDBFile = Server.MapPath("sample.mdb"); //WebBillDll.WebBill webbill = new WebBillDll.WebBill(strXml,MDBFile);//access file path // Request.PhysicalApplicationPath 为root路径,c:\inetpub\wwwroot\webbill // Request.MapPath("/")=c:\inetpub\wwwroot\ DBConn myCn= new DBConn(); //OleDbConnection myConn = myCn.myCn ; WebBillDll.WebBill webbill = new WebBillDll.WebBill(strXml,Request.PhysicalApplicationPath,myCn.strConn);//访问web.config的连接串 if(strOperator.IndexOf('&')>0){ strOperator = Request.Params["key"]; } string strReturn = webbill.returnXml(strOperator,Request); Response.Write(strReturn); } catch (Exception ex) { Response.Write(ex.Message); } }
protected void Page_Load(object sender, System.EventArgs e) { try { // �ڴ˴������û������Գ�ʼ��ҳ�� //��ֹ�ⲿ�����ύ�Ľű� /*string sHttp=Request.Headers["referer"]; string sServer=Request.Headers["host"]; if (sServer.Equals(sHttp.Substring(7,sServer.Length))==false) { Console.WriteLine("���ύ��·������ֹ��վ���ⲿ�ύ����! "+sHttp); return ; }*/ // �ڴ˴������û������Գ�ʼ��ҳ�� string strOperator=Request.Params["key"]; DBConn myCn= new DBConn(); //OleDbConnection myConn = myCn.myCn ; cn.com.fcsoft.report.run.ebfile ebfile = new cn.com.fcsoft.report.run.ebfile(Request,myCn.strConn);//����web.config�����Ӵ� //OleDbConnection myConn = null; // string strXml = ""; // if(strOperator == "ToInDs") //ת�ڽ����ݼ� // { //DBConn myCn= new DBConn(); //myConn = myCn.myCn ; //myConn.Open(); // StreamReader sr=new StreamReader(Request.InputStream); // strXml =sr.ReadToEnd(); // } string strReturn = ebfile.returnXml(strOperator); Response.Write(strReturn); } catch(System.Exception e1){ Response.Write(e1.Message ); } }
protected void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� //��ֹ�ⲿ�����ύ�Ľű� /*string sHttp=Request.Headers["referer"]; string sServer=Request.Headers["host"]; if(sHttp != null) { if (sServer.Equals(sHttp.Substring(7,sServer.Length))==false) { Console.WriteLine("���ύ��·������ֹ��վ���ⲿ�ύ����! "+sHttp); return ; } }*/ // �ڴ˴������û������Գ�ʼ��ҳ�� string strOperator=Request.Params["key"]; DBConn myCn= new DBConn(); //OleDbConnection myConn = myCn.myCn ; cn.com.fcsoft.report.run.RunReport ebfile = new cn.com.fcsoft.report.run.RunReport(Request,myCn.strConn);//����web.config�����Ӵ� ebfile.returnXml(Response); }