|
|
|
|
Автор:
|
Duhanin Alexandr
|
|
Тема:
|
aspx и c#
|
|
Дата:
|
8/7/2006 6:41:00 PM
|
код на aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<%@ Import Namespace="System.Web"%>
<%@ Import Namespace="System.Web.Security"%>
<%@ Import Namespace="System.Web.UI"%>
<%@ Import Namespace="System.Web.UI.WebControls"%>
<%@ Import Namespace="System.Web.UI.WebControls.WebParts"%>
<%@ Import Namespace="System.Web.UI.HtmlControls"%>
<%@ Import Namespace="System.Data.SqlClient"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head id="Head1" runat="server">
<title>Untitled Page</title>
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="content-type" content="text/html; charset=windows-1251">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 marginheight='0' marginwidth='0'>
<form id='form1' runat='server'>
<div>
</div>
<table>
</table>
</form>
</body>
</html>
---------------------------------------------
код на с#
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
public string SQLEX, SID;
public SqlConnection cnn;
public SqlDataReader reader;
int GroupId, BaseId;
public string DefSelTName, DefLayerVal, nameDB, URLPREFIX;
public SqlConnection sqlConn;
public SqlCommand Cmd, Cnt;
public string Dt;
public int X = 0, Y = 0, Size = 0, Q = 0, USERID = 1;
public string UNID, Act;
public int SizeMapX = 545, SizeMapY = 350, MaxMapMash = 1000000, MinMapMash = 15625, minX = -1350000, maxX = -350000, minY = -590000, maxY = 410000;
private void db_param()
{
GroupId = 1; //Идентификатор группы, к которой принадлежит пользователь
DefSelTName = "L_House"; //Таблица, открывающаяся в диалоге поиска по умолчанию
BaseId = 1; //Идентификатор графической базы
//строка активности слоев по умолчанию
DefLayerVal = "*-49,*-54,--36,--37,--45,--44,--43,--42,--11,--33,--1,--2,*-57,*-51,*-50,**19,*-26,*-30,--10,--9,--7,*-5,*-4,--14,*-32,*-27,*-18,*-29,*-20,*-23,*-24,*-17,*-21,*-22,*-31,*-28";
nameDB = "ZW"; //Константа названия БД
string Connstr = "строка подключения";
sqlConn = new SqlConnection(Connstr);
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
}
public void Sprav()
{
SQLEX = "SQL-запрос";
cnn = new SqlConnection("строка подключения");
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
Cmd = new SqlCommand(SQLEX, cnn);
reader = Cmd.ExecuteReader();
while (reader.Read())
{
string G_ID = reader[0].ToString();
string Nm = reader[1].ToString();
Response.Write("<td><input type='checkbox' name='T1' checked></td>");
Response.Write("<input type='checkbox' name='T2'>");
string buf = @"<img alt='png' width='16' height='16' src='./img/lay1_1_" + G_ID + ".png' visible='true'/>";
Response.Write(buf);
Response.Write("<span style='font-size:10px;'/>");
Response.Write(" " + Nm + "<br>");
}
reader.Close();
}
}
private string[] explode(char Razd, string Legend)
{
string[] aLegend = new string[Legend.Length + 1];
int cnt = 0;
string buf = "";
for (int i = 0; i < Legend.Length; i++)
{
if (Legend[i] == Razd) { aLegend[cnt] = buf; buf = ""; cnt++; }
else buf += Legend[i];
}
return aLegend;
}
private void Session_Start()
{
}
protected void Layer_html()
{
int count = 0;
string s = "", sbuf = "", buf = "";
char s1 = ' ', s2 = ' ';
cnn = new SqlConnection("строка подключения");
Session_Start();
// DateTime Dt = DateTime.Now;
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
SQLEX = "SQL-запрос '" + SID + "'";
Cmd = new SqlCommand(SQLEX, cnn);
reader = Cmd.ExecuteReader();
while (reader.Read())
{
count += 1;
sbuf = reader[0].ToString();
}
reader.Close();
string UPDLayer = "s='';";
if (count == 0)
{
Response.Write("<div style='PADDING-LEFT: 24px'> Информация о данной сессии отсутствует в БД.</div>");
}
else
{
string[] aS = explode(',', sbuf);
for (int i = 0; i < aS.Length; i++)
{
if (aS[i] == null) break;
//if (i == 0) { i = 1; } else { UPDLayer += "s=s+',';"; }
sbuf = aS[i];
s1 = sbuf[0];
s2 = sbuf[1];
s = "";
Response.Write("<span style='font-size:10px;'/>");
for (int j = 2; j < sbuf.Length; j++) { s += sbuf[j]; }
Response.Write("<tr>");
if (s1 == '*') { Response.Write("<td><input type='checkbox' name='V" + s + "' checked></td>"); }
else { Response.Write("<td><input type='checkbox' name='V" + s + "' ></td>"); };
if (s2 == '*') { Response.Write("<td><input type='checkbox' name='T" + s + "' checked></td>"); }
else { Response.Write("<td><input type='checkbox' name='T" + s + "' ></td>"); };
Response.Write("<td>");
buf = "<img alt='png" + s + "' width='16' height='16' src='./img/lay1_1_" + s + ".png' visible='true'/>";
Response.Write(buf);
Response.Write("</td>");
SQLEX = "SQL-запрос " + s;
Cmd = new SqlCommand(SQLEX, cnn);
reader = Cmd.ExecuteReader();
count = 0;
while (reader.Read())
{
count += 1;
sbuf = reader[0].ToString();
Response.Write("<td> " + sbuf + "</td><br>");
}
//цикл возврата
UPDLayer = UPDLayer + "if (document.getElementById('V" + s + "').checked == true){s=s+'*';}else{s=s+'-';}; ";
UPDLayer = UPDLayer + "if (document.getElementById('T" + s + "').checked == true){s=s+'*';}else{s=s+'-';}; ";
UPDLayer = UPDLayer + "s=s+'" + s + "';";
reader.Close();
if (count == 0) Response.Write("<td> Отсутствует наименование слоя.</td><br>");
}
}
buf = "<input type=hidden name='JS' value=\"" + UPDLayer + "; document.getElementById('alertimg').src='./WMSaveLegend.exe?SID=" + SID + "&P='+s+'&R='+Math.random();\" /> ";
Response.Write(buf);
}
else { Response.Write("<div style='PADDING-LEFT: 24px'> Ошибка соединения с базой данных G__TABLES </div>"); }//
}
private void Start_Session()
{
SID = Session.SessionID;
}
protected void Page_Load(object sender, EventArgs e)
{
//s=Request.QueryString["s"];
//Start_Session();
SID = Request.QueryString["SID"];
//SID = "d51031fbe08e7320ac2ec4c2eaba9bde";
//Sprav();
// SID = Session.SessionID;
// Session_Start();
//Layer_html();
}
}
---------------------------------
Вообщем, вопрос такой. Как сделать так, чтобы результат выполнения кода на c# помещался на html-странице между тегами <form></form>?
|
|
|
|
