SQL与前端技巧集锦-优快云博客

select * from table1 where isnull(aa, '' ) = ''

isnull(aa, '' )的意思：如果列“aa”中的数据是NULL的话，就将NULL替换成 ''

上面的SQL语句等价于：

select * from table1 where aa is null or aa = ''

SQL Cast()变量类型转换

cast(@DanYuanHao as varchar):SQL中变量的类型转换

@HouseNumber为varchar

@DanYuanHao为int

SET @HouseNumber = (@CodeBefore + @DaiMaFenGeHao + cast(@DanYuanHao as varchar) + cast(@DaiMaFenGeHao as varchar) + cast(@LouCengHao as varchar) + cast(@FangJianHao as varchar))

SET @Address = (@AddressBefore + cast(@DanYuanHao as varchar) + ' 单元 ' + cast(@LouCengHao as varchar) + cast(@FangJianHao as varchar))

数字的正则表达式： ValidationExpression = " ^[0-9]*$ "
浮点数的正则表达式： ValidationExpression = " ^\d+(\.\d+)?$ "

代码

< script language = " javascript " type = " text/javascript " >
function checkboxchange(CBID) {
if (document.getElementById(CBID).checked == true ) {
switch (CBID) {
case " CBBuildID " :
document.getElementById( ' DDLBuildID ' ).removeAttribute( " disabled " );
break ;
}
}
else {
switch (CBID) {
case " CBBuildID " :
document.getElementById( " DDLBuildID " ).setAttribute( " disabled " , " disabled " );
break ;
}
}
}
< / script>
前台：
< input type = " checkbox " id = " CBBuildID " onclick = " checkboxchange(CBBuildID.id); " / >
后台：
DDLBuildID.Enabled = false ;

NumericUpDownExtender控件

WebService1.asmx服务
【
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;

namespace BeidouWY.Web.HouseManage
{
/// <summary>
/// WebService1 的摘要说明
/// </summary>
[WebService(Namespace = " http://tempuri.org/ " )]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem( false )]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
// [System.Web.Script.Services.ScriptService]
[System.Web.Script.Services.ScriptService()]
public class WebService1 : System.Web.Services.WebService
{

[WebMethod]
public string HelloWorld()
{
return " Hello World " ;
}
[WebMethod]
public int UpMethod( int current, string tag)
{
int newcurrent = current + 1 ;
if (newcurrent == 0 )
newcurrent += 1 ;
return newcurrent;
}
[WebMethod]
public int DownMethod( int current, string tag)
{
int newcurrent = current - 1 ;
if (newcurrent == 0 )
newcurrent -= 1 ;
return newcurrent;
}
}
}
】

.aspx页面：
< cc1:NumericUpDownExtender ID = " txtLouCengHao_NumericUpDownExtender " runat = " server "
Enabled = " True " Maximum = " 88 " Minimum = " -1 " RefValues = ""
ServiceDownMethod = " DownMethod " ServiceDownPath = " ~/HouseManage/WebService1.asmx "
ServiceUpMethod = " UpMethod " Tag = "" TargetButtonDownID = ""
TargetButtonUpID = "" TargetControlID = " txtLouCengHao "
Width = " 50 " ServiceUpPath = " ~/HouseManage/WebService1.asmx " >
</ cc1:NumericUpDownExtender >
可以参见：http: // www.cnblogs.com/qc1984326/archive/2007/03/20/681909.html

Sys错误

在.aspx页面上加了ScriptManager后浏览页面出现：Sys未定义错误：
在Web.config文件的system.web节点下添加：
< httpHandlers >
< remove verb = " * " path = " *.asmx " />
< add verb = " * " path = " *.asmx " validate = " false " type = " System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35 " />
< add verb = " * " path = " *_AppService.axd " validate = " false " type = " System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35 " />
< add verb = " GET,HEAD " path = " ScriptResource.axd " validate = " false " type = " System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35 " />
</ httpHandlers >

异步线程的调用

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Threading;

public partial class _Default : System.Web.UI.Page
{
public static Thread t1;
public static string readme;
protected void Page_Load( object sender, EventArgs e)
{
t1 = new Thread( new ThreadStart(Thread1));
// t1.IsBackground = true;
}
protected void Button1_Click( object sender, EventArgs e)
{

t1.Priority = ThreadPriority.Normal;
t1.Start();

Response.Write( " <script language='javascript'>alert('线程1执行完毕');</script> " );

Response.Write( " <script language='javascript'>alert(' " + readme + " ');</script> " );

}
public static void Thread1()
{
Thread.Sleep( 10000 );
readme = " OK " ;
}
protected void Timer1_Tick( object sender, EventArgs e)
{
if (readme == " OK " )
{
Response.Write( " <script language='javascript'>alert('OK');</script> " );
readme = "" ;
}
}
}

网站搜索

< META http - equiv = " Content-Type " content = " text/html; charset=gbk " > // charset=gbk：网站编码，不指定有可能在浏览器上出现乱码
< META content = " 搜索关键字 " name = keywords >
< META content = " 搜索描述 " name = description >
< title > 搜索标题 </ title >

www.seomachine.cn

创建一个进程，对文件进行加压解压

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.Win32;
using System.Diagnostics;

public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{ }
private void Zip( string file, string src)
{
String the_rar;
RegistryKey the_Reg;
Object the_Obj;
String the_Info;
ProcessStartInfo the_StartInfo;
Process the_Process = new Process();
try
{
the_Reg = Registry.ClassesRoot.OpenSubKey( @" Applications\WinRAR.exe\Shell\Open\Command " );
the_Obj = the_Reg.GetValue( "" );
the_rar = the_Obj.ToString();
the_Reg.Close();
the_rar = the_rar.Substring( 1 , the_rar.Length - 7 );
the_Info = " a -ep1 " + file + " " + src;
the_StartInfo = new ProcessStartInfo();
the_StartInfo.FileNa me = the_rar;
the_StartInfo.Arguments = the_Info;
the_StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
// the_StartInfo.WorkingDirectory =""; // 获取或设置要启动的进程的初始目录。

the_Process.StartInfo = the_StartInfo;
the_Process.Start();
the_Process.WaitForExit();
the_Process.Close();
// Response.Write("压缩成功");

}
catch (Exception ex)
{
the_Process.Close();
Response.Write(ex.ToString());
}

}
private void unZip( string file, string src)
{
String the_rar;
RegistryKey the_Reg;
Object the_Obj;
String the_Info;
ProcessStartInfo the_StartInfo;
Process the_Process = new Process();
try
{
the_Reg = Registry.ClassesRoot.OpenSubKey( @" Applications\WinRar.exe\Shell\Open\Command " );
the_Obj = the_Reg.GetValue( "" );
the_rar = the_Obj.ToString();
the_Reg.Close();
the_rar = the_rar.Substring( 1 , the_rar.Length - 7 );
the_Info = " X -o+ " + file + " " + src;
the_StartInfo = new ProcessStartInfo();
the_StartInfo.FileName = the_rar;
the_StartInfo.Arguments = the_Info;
the_StartInfo.WindowStyle = ProcessWindowStyle.Hidden;

the_Process.StartInfo = the_StartInfo;
the_Process.Start();
the_Process.WaitForExit();
the_Process.Close();
// Response.Write("");
}
catch (Exception ex)
{
the_Process.Close();
Response.Write(ex.ToString());
// the_Process.Dispose();
}

}

}

SQL安装挂起

在xp和2003系统上安装SQLServer2000数据库，一般都要打SP4补丁，这次打补丁是因为虽然能ping通局域网内的服务器，
也能用SQL企业管理器打开服务器上的数据库中的表，但是将项目挂在IIS上浏览的时候不能连接上数据库
解决方案：打SP4补丁
SQLServerSP4补丁：
文件挂起解决办法：运行regedit:HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Session Manager -> PendingFileRenameOperations删除
安装：写密码，选下面的复选框
另外：遇到此类问题时最直接的测试数据库连接的方法是利用控制面板 - 》管理工具 - 》ODBC数据源管理器直接添加一个连接，看能不能连接上对方的数据库
操作方法：打开ODBC数据源管理器 - 》添加 - 》选择SQL Server，完成
- 》起个名字（随便起），描述不用写，（你想连接哪一个SQL Server)填写对方的IP地址或者计算机名称，下一步 - 》选择使用用户输入登录ID和密码的SQL Server验证，点击链接SQL Server以获得其他配置选项的默认配置，输入登录ID和密码，点击客户端配置选择TCP / IP 选择动态决定端口确定
下一步（此时如果能连接到服务器上的SQLServer则能显示下一个界面，说明连接没有问题，如果不能显示下一个界面，则说明连接有问题
另外：如果同一台电脑上即安装了SQL2000又安装了SQL2005，则应该在安装的时候把他俩的端口改为不同的，默认他俩的端口号是相同的（都是1443），如果链接到同一个服务器（同一个端口，计算机名称又相同，则很有可能出现连接错乱）

1 、安装个人版（xp系统，或2000专业版）或企业版（2003系统或2000企业版）
2 、安装组件
3 、安装数据库服务器
4 、本地
5 、创建新的实例
6 、服务器和客户端
7 、典型，两个都改成D盘
8 、使用本地系统账户
9 、混合模式

框架写法

< iframe name = " Left " height = " 500px " width = " 180 " src = " LeftTree.aspx " border = " 0 " frameborder = " 0 "
scrolling = " no " ></ iframe >
< iframe name = " Content " id = " Content " height = " 100% " width = " 100% " border = " 0 " frameborder = " 0 " style = " height: 450px; "
scrolling = " auto " ></ iframe >
< li >< a href = " HouseManage/CommnunManage.aspx " target = " Content " > 小区设置 </ a > </ li >
< li >< a href = " HouseManage/FloorManage.aspx " target = " Content " > 楼房设置 </ a ></ li >
< li >< a href = " HouseManage/RoomManage.aspx " target = " Content " > 房间设置 </ a ></ li >
< li > 快速初始化 </ li >

实现类似于CS结构中的文本框选择

< td class = " tdcatag " >
< asp:TextBox ID = " txtHouseID " runat = " server " Width = " 200px " onfocus = " RoomFocus() " onblur = " RoomBlur() " ></ asp:TextBox >
< img src = " ../Images/open.gif " id = " Img1 " onclick = " JavaScript:window.open('/HouseManage/RoomManage.aspx') "
style = " position:relative; z-index: auto; vertical-align:absmiddle; display:none " />
< input id = " HidHouseID " type = " hidden " runat = " server " />
</ td >
< script language = " javascript " type = " text/javascript " >
function RoomFocus() {
var a = document.getElementById( " Img1 " );
a.style.left = - 20 ;
a.style.display = '' ;
}

<% @ Page Language = " C# " AutoEventWireup = " true " CodeBehind = " CRHoldList.aspx.cs " Inherits = " BeidouWY.Web.CRManager.CRHoldList " %>

<! 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 runat = " server " >
< title ></ title >
< link href = " ../Css/CommStyle.css " rel = " Stylesheet " type = " text/css " />
< script language = " javascript " type = " text/javascript " >
function RowDoubleClick(obj) {
// debugger;
var renstr = obj.cells[ 1 ].innerText;
var a = parent.window.opener;
if (a != null ) {
a.document.getElementById( " txtComustonID " ).value = renstr;
a.document.getElementById( " HidCustID " ).value = obj.cells[ 0 ].innerText;
parent.window.close();
}
}

</ script >
</ head >
< body >
< form id = " form1 " runat = " server " >
< div >

< asp:GridView ID = " GridView1 " runat = " server " AutoGenerateColumns = " False "
SkinID = " GridView1 " Width = " 100% " onrowcreated = " GridView1_RowCreated "
onrowdatabound = " GridView1_RowDataBound " >
< Columns >
< asp:BoundField DataField = " ID " />
< asp:BoundField DataField = " CustomerNumber " HeaderText = " 代码 " />
< asp:BoundField DataField = " CustomerName " HeaderText = " 名称 " />
< asp:BoundField DataField = " Sex " HeaderText = " 性别 " />
< asp:BoundField DataField = " Tel " HeaderText = " 电话 " />
< asp:BoundField DataField = " Mobile " HeaderText = " 手机号 " />
< asp:BoundField DataField = " CustomerType " HeaderText = " 客户类别 " />
< asp:BoundField DataField = " PersonID " HeaderText = " 身份证号 " />
< asp:BoundField DataField = " WorkUnits " HeaderText = " 工作单位 " />
< asp:BoundField DataField = " Education " HeaderText = " 文化程度 " />
< asp:BoundField />
</ Columns >
</ asp:GridView >

</ div >
</ form >
</ body >
</ html >
protected void GridView1_RowCreated( object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add( " onDblClick " , " RowDoubleClick(this) " );
}
}

protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header)
{
// 如果想使第1列不可见,则将它的可见性设为false
e.Row.Cells[ 0 ].Attributes.Add( " style " , " display:none " );
}
}

重写TreeNode基类方法，添加一个新属性，将要传值的属性存放在此属性中

前台脚本：
< script language = " javascript " type = " text/javascript " >
function SelectCheckBox() {
var o = window. event .srcElement; // 获得触发此事件的对象

var inputobj ;
if (o.tagName == " INPUT " && o.type == " checkbox " )
{

var parentobj = o.parentNode ;
inputobj = o ;
while (parentobj.tagName != " TABLE " ) // 循环找到table下的子节点
{
parentobj = parentobj.parentNode

}
// var aobj = parentobj.getElementsByTagName("A");
// var nextobj = parentobj.nextSibling
// if (nextobj.tagName != "DIV")
// return ;

var x = parentobj.getElementsByTagName( " A " );
var s = "" ;
s = x[ 0 ].NodeData; // 自定义的属性
if (s != "" ) {
// var housenumber = s.split('|')[0].split('=')[1];
document.getElementById( " Hidden1 " ).value = s; // 给隐藏字段赋值
}
// for ( var i = 0 ; i < x.length;i ++ )
// {
// if (x[i].tagName == "INPUT" && x[i].type == "checkbox")
// {
// if(inputobj.checked)
// x[i].checked = true
// else
// x[i].checked = false
//
// }
// }
}
}

function WindowClose() {
var s = document.getElementById( " Hidden1 " ).value;
var housenumber = s.split( ' | ' )[ 0 ].split( ' = ' )[ 1 ]; // 对隐藏字段中的值进行拆分
var houseid = s.split( ' | ' )[ 1 ].split( ' = ' )[ 1 ];
var custid = s.split( ' | ' )[ 2 ].split( ' = ' )[ 1 ];
var custname = s.split( ' | ' )[ 3 ].split( ' = ' )[ 1 ];
var Regid = s.split( ' | ' )[ 4 ].split( ' = ' )[ 1 ];
if (window.opener != null ) { // 获得打开此窗体的父窗体
window.opener.document.getElementById( " txtHouseID " ).value = housenumber; // 在父窗体中找到对应的控件并赋值
window.opener.document.getElementById( " HidhouseID " ).value = houseid;
window.opener.document.getElementById( " txtCustomerID " ).value = custname;
window.opener.document.getElementById( " HidCustomerID " ).value = custid;
window.opener.document.getElementById( " Regid " ).value = Regid;
window.opener = null ;
window.close(); // 关闭子窗体

}
}

</ script >

后台内容：
public partial class CROutTree : PageBase
{
protected void Page_Load( object sender, EventArgs e)
{
this .TreeView1.Attributes.Add( " onclick " , " SelectCheckBox() " ); // 为TreeView添加客户端事件

if ( ! IsPostBack)
{
this .TreeCompBind();

}
}
#region 树控件绑定
private void TreeCompBind()
{
DataTable dt;
BLL.JC_Company_Info bll = new BeidouWY.BLL.JC_Company_Info();
dt = bll.GetList( " ParentCode='0' " ).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
TreeNode tn = new TreeNode();
tn.Text = dr[ " CompName " ].ToString();
tn.Value = dr[ " CompCode " ].ToString();
tn.NavigateUrl = " # " ;
// tn.Target = "Right";

this .TreeView1.Nodes.Add(tn);
CommunBind(tn.Value, tn.ChildNodes);
}

}

private void CommunBind( string CompCode, TreeNodeCollection TNC)
{
DataTable dt;
BLL.WC_Community_Info bll = new BeidouWY.BLL.WC_Community_Info();
dt = bll.GetList( " ComanyCode=' " + CompCode + " ' " ).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
TreeNode tn = new TreeNode();
tn.Text = dr[ " CommunityName " ].ToString();
tn.Value = dr[ " CommunityCode " ].ToString();
// tn.NavigateUrl = "CRList.aspx?type=2&ID=" + tn.Value;
// tn.Target = "Right";

tn.NavigateUrl = " # " ;
TNC.Add(tn);
BuildBind(tn.Value, tn.ChildNodes);
}

}

private void BuildBind( string CommunityCode, TreeNodeCollection TNC)
{
DataTable dt;
BLL.WC_Build_Info bll = new BeidouWY.BLL.WC_Build_Info();
dt = bll.GetList( " CommunityCode=' " + CommunityCode + " ' " ).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
TreeNode tn = new TreeNode();
tn.Text = dr[ " BuildName " ].ToString();
tn.Value = dr[ " ID " ].ToString();
// tn.NavigateUrl = "CRList.aspx?type=3&ID=" + tn.Value;
// tn.Target = "Right";
tn.NavigateUrl = " # " ;
TNC.Add(tn);
RoomCustBind(tn.Value, tn.ChildNodes);
}

}
#endregion

protected void TreeView1_TreeNodeExpanded( object sender, TreeNodeEventArgs e)
{

}

protected void TreeView1_SelectedNodeChanged( object sender, EventArgs e)
{
TreeView tv = (TreeView)sender;
if (tv.SelectedNode.Depth == 2 && tv.SelectedNode.ChildNodes.Count == 0 )
{
this .RoomCustBind(tv.SelectedNode.Value, tv.SelectedNode.ChildNodes);
}
}

private void RoomCustBind( string sID, TreeNodeCollection TNC)
{
string strSQL = " SELECT a.HouseNumber, b.houseid,c.CustomerName,c.id,c.customernumber,b.id as Regid "
+ " FROM WC_House_Info a INNER JOIN "
+ " CR_Occupation_Reg b ON "
+ " a.ID = b.HouseID "
+ " inner join CR_HouseHold_Info c "
+ " on b.comustonid=c.id "
+ " where b.INFlag='1' and OutFlag='0' and a.buildid=' " + sID + " ' " ;
DataTable dt;
dt = DbHelperSQL.Query(strSQL).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
// TreeNode tn = new TreeNode();
BeidouWY.Web.Controls.CustTreeNode tn = new BeidouWY.Web.Controls.CustTreeNode(); // 初始化的是重写基类的方法的类
string tname = dr[ " CustomerName " ].ToString() != "" ? " [ " + dr[ " CustomerName " ].ToString() + " ] " : "" ;
tn.Text = dr[ " HouseNumber " ].ToString() + tname;
tn.Value = dr[ " HouseID " ].ToString();
tn.ShowCheckBox = true ; // 节点前面有个CheckBox
tn.NavigateUrl = " # " ;
tn.NodeData = " HouseNumber= " + dr[ " HouseNumber " ].ToString() + " |HouseID= " + dr[ " HouseID " ].ToString() + " |ID= " + dr[ " ID " ].ToString() + " |CustomerNumber= " + dr[ " CustomerNumber " ].ToString() + " - " + dr[ " CustomerName " ].ToString() + " |Regid= " + dr[ " Regid " ].ToString();
// 自定义的NodeData属性，为了存放数据用的
// tn.NavigateUrl = "CRHoldList.aspx?type=4&ID=" + tn.Value;
// tn.Target = "Right";
// tn.SelectAction = TreeNodeSelectAction.Expand;
TNC.Add(tn);
}
}

protected void TreeView1_TreeNodeCheckChanged( object sender, TreeNodeEventArgs e)
{
TreeView tv = (TreeView)sender;
if (tv.SelectedNode.Depth == 2 && tv.SelectedNode.ChildNodes.Count == 0 )
{
this .RoomCustBind(tv.SelectedNode.Value, tv.SelectedNode.ChildNodes);
}
}
}

重写TreeView基类的方法：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
namespace BeidouWY.Web.Controls
{
public class CustTreeNode :System.Web.UI.WebControls.TreeNode // 继承自TreeNode类
{
private string _nodedata;
public string NodeData
{
set
{
_nodedata = value;
}
get
{
return _nodedata;
}
}
// protected override void Render(HtmlTextWriter writer)
// {
// base.RenderPostText
// }
protected override void RenderPreText(HtmlTextWriter writer) // 重写基类的RenderPreText方法
{

writer.AddAttribute( " NodeData " , this .NodeData); // 添加HTML属性

base .RenderPreText(writer);
}
// protected override void RenderPostText(HtmlTextWriter writer)
// {
// writer.
// base.RenderPostText(writer);
// }
}
}

frameset和iframe的区别

只有前台没有后台
<% @ Page Language = " C# " AutoEventWireup = " true " CodeBehind = " Index.aspx.cs " Inherits = " BeidouWY.Web.Index " %>

<! DOCTYPE html PUBLIC " -//W3C//DTD XHTML 1.0 Transitional//EN "" http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd " >
< html xmlns = " http://www.w3.org/1999/xhtml " >
< head runat = " server " >
< title ></ title >
< link href = " Css/CommStyle.css " rel = " Stylesheet " type = " text/css " />
</ head >
< frameset rows = " 63,*,23 " frameborder = " no " border = " 0 " framespacing = " 0 " > // 框架：必须写在<body>外面？rows:指定长宽高？
< frame src = " top.aspx " name = " topFrame " scrolling = " No " noresize = " noresize " id = " topFrame " />
// 里面嵌套的子框架 src:此框架中的页面地址; name:在子页面中如果要做A连接时Target指向的名字 ;scrolling="No"：不允许滚动;noresize="noresize"不允许调整大小
< frame src = " Center.aspx " name = " mainFrame " id = " mainFrame " />
< frame src = " down.aspx " name = " bottomFrame " scrolling = " No " noresize = " noresize " id = " bottomFrame " />
</ frameset >
</ html >

-----------------------------------------------------------------------------------------------
<% @ Page Language = " C# " AutoEventWireup = " true " CodeBehind = " BaseDataManage.aspx.cs " Inherits = " BeidouWY.Web.SysManage.BaseDataManage " %>

<! 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 runat = " server " >
< title > 辅助资料 </ title >
< link href = " ../Css/CommStyle.css " rel = " Stylesheet " type = " text/css " />
</ head >
< body >
< form id = " form1 " runat = " server " >
< div >
< table width = " 98% " border = " 1 " class = " tablemain " border = " 1 " bordercolor = " #99CC33 " >
< tr >
< td width = " 200 " valign = " top " >
< asp:TreeView ID = " TreeView1 " runat = " server " Width = " 195px " >
</ asp:TreeView >
</ td >
< td valign = " top " >< iframe id = " Cent " name = " Cent " width = " 100% " height = " 400px " frameborder = " 0 " scrolling = " auto " src = " BaseTypeManage.aspx " ></ iframe ></ td >
</ tr > // iframe：在页面中嵌套的子页面：属性和<frameset相同;适用于比较简单的嵌套

</ table >
</ div >
</ form >
</ body >
</ html >

< frameset > 和 < iframe > 的区别：两者都是框架技术， < iframe > 在有些低端浏览器上不支持，但是 < frameset > 在所有浏览器是上都支持
< frameset > 一旦使用一定会占用连接数（一个页面占用一个连接数）但是 < iframe > 浏览时里面有页面会占用一个连接数，没有页面不会占用连接数

TreeView绑定

TreeView的绑定及其用法：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using BeidouWY.DBUtility;
namespace BeidouWY.Web.CRManager
{
public partial class CRTree : PageBase
{
protected void Page_Load( object sender, EventArgs e)
{
this .TreeView1.Attributes.Add( " onclick " , " SelectCheckBox() " );

if ( ! IsPostBack)
{
this .TreeCompBind();

}
}

#region 树控件绑定
private void TreeCompBind()
{
DataTable dt;
BLL.JC_Company_Info bll = new BeidouWY.BLL.JC_Company_Info();
dt = bll.GetList( " ParentCode='0' " ).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
TreeNode tn = new TreeNode();
tn.Text = dr[ " CompName " ].ToString();
tn.Value = dr[ " CompCode " ].ToString();
tn.NavigateUrl = " # " ;
// tn.Target = "Right";

this .TreeView1.Nodes.Add(tn);
CommunBind(tn.Value, tn.ChildNodes);
}

}

private void CommunBind( string CompCode, TreeNodeCollection TNC)
{
DataTable dt;
BLL.WC_Community_Info bll = new BeidouWY.BLL.WC_Community_Info();
dt = bll.GetList( " ComanyCode=' " + CompCode + " ' " ).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
TreeNode tn = new TreeNode();
tn.Text = dr[ " CommunityName " ].ToString();
tn.Value = dr[ " CommunityCode " ].ToString();
// tn.NavigateUrl = "CRList.aspx?type=2&ID=" + tn.Value;
// tn.Target = "Right";

tn.NavigateUrl = " # " ;
TNC.Add(tn);
BuildBind(tn.Value, tn.ChildNodes);
}

}

private void BuildBind( string CommunityCode, TreeNodeCollection TNC)
{
DataTable dt;
BLL.WC_Build_Info bll = new BeidouWY.BLL.WC_Build_Info();
dt = bll.GetList( " CommunityCode=' " + CommunityCode + " ' " ).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
TreeNode tn = new TreeNode();
tn.Text = dr[ " BuildName " ].ToString();
tn.Value = dr[ " ID " ].ToString();
// tn.NavigateUrl = "CRList.aspx?type=3&ID=" + tn.Value;
// tn.Target = "Right";
tn.NavigateUrl = " # " ;
TNC.Add(tn);
RoomCustBind(tn.Value, tn.ChildNodes);
}

}
#endregion

protected void TreeView1_TreeNodeExpanded( object sender, TreeNodeEventArgs e)
{

}

protected void TreeView1_SelectedNodeChanged( object sender, EventArgs e)
{
TreeView tv = (TreeView)sender;
if (tv.SelectedNode.Depth == 2 && tv.SelectedNode.ChildNodes.Count == 0 )
{
this .RoomCustBind(tv.SelectedNode.Value, tv.SelectedNode.ChildNodes);
}
}

private void RoomCustBind( string sID, TreeNodeCollection TNC)
{
string strSQL = " SELECT a.HouseNumber, b.houseid,c.CustomerName,c.id,c.customernumber "
+ " FROM WC_House_Info a INNER JOIN "
+ " CR_Occupation_Reg b ON "
+ " a.ID = b.HouseID "
+ " inner join CR_HouseHold_Info c "
+ " on b.comustonid=c.id "
+ " where b.inflag='0' and a.buildid=' " + sID + " ' " ;
DataTable dt;
dt = DbHelperSQL.Query(strSQL).Tables[ 0 ];
foreach (DataRow dr in dt.Rows)
{
// TreeNode tn = new TreeNode();
BeidouWY.Web.Controls.CustTreeNode tn = new BeidouWY.Web.Controls.CustTreeNode();
string tname = dr[ " CustomerName " ].ToString() != "" ? " [ " + dr[ " CustomerName " ].ToString() + " ] " : "" ;
tn.Text = dr[ " HouseNumber " ].ToString() + tname;
tn.Value = dr[ " HouseID " ].ToString();
tn.ShowCheckBox = true ;
tn.NavigateUrl = " # " ;
tn.NodeData = " HouseNumber= " + dr[ " HouseNumber " ].ToString() + " |HouseID= " + dr[ " HouseID " ].ToString() + " |ID= " + dr[ " ID " ].ToString() + " |CustomerNumber= " + dr[ " CustomerNumber " ].ToString() + " - " + dr[ " CustomerName " ].ToString();
// tn.NavigateUrl = "CRHoldList.aspx?type=4&ID=" + tn.Value;
// tn.Target = "Right";
// tn.SelectAction = TreeNodeSelectAction.Expand;
TNC.Add(tn);
}
}

protected void TreeView1_TreeNodeCheckChanged( object sender, TreeNodeEventArgs e)
{
TreeView tv = (TreeView)sender;
if (tv.SelectedNode.Depth == 2 && tv.SelectedNode.ChildNodes.Count == 0 )
{
this .RoomCustBind(tv.SelectedNode.Value, tv.SelectedNode.ChildNodes);
}
}
}
}
------------------------------------------------------------------------------
if (ds.Tables[ 0 ].Rows.Count == 0 )
{
ds.Tables[ 0 ].Rows.Add(ds.Tables[ 0 ].NewRow());
this .GridView1.DataSource = ds;
this .GridView1.DataBind();

// this.GridView1.Rows[0].Cells[0].FindControl("CheckBox1").Visible = false;
this .GridView1.Rows[ 0 ].Visible = false ;

}
else
{
this .GridView1.DataSource = ds;
this .GridView1.DataBind();
}

display:none和Visible=false的区别

protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header)
{
// 如果想使第1列不可见,则将它的可见性设为false
e.Row.Cells[ 0 ].Attributes.Add( " style " , " display:none " ); // 加上display:none;使整个第一列隐藏掉，但是在查看源文件的时候还可以看到
} // 和.Visible=false的区别：visible=false在加载的时候不对对象进行渲染，完全不显示在页面上，查看源文件也看不到
}

表联和子查询的区别

SELECT dbo.Pub_Meate. * , dbo.Base_Meter_Type.CodeName, dbo.DM_BaseData.CodeName AS gongtan, dbo.WC_Community_Info.CommunityName, DM_BaseData_1.CodeName AS yongtu FROM dbo.Pub_Meate LEFT OUTER JOIN dbo.Base_Meter_Type ON dbo.Pub_Meate.MeterTypeCode = dbo.Base_Meter_Type.ID LEFT OUTER JOIN dbo.WC_Community_Info ON dbo.WC_Community_Info.ID = dbo.Pub_Meate.CommUnId LEFT OUTER JOIN dbo.DM_BaseData ON dbo.DM_BaseData.Code = dbo.Pub_Meate.PubMeterCode LEFT JOIN ( select code,codename from dm_basedata where parentcode = ' 22 ' ) DM_BaseData_1 ON dbo.Pub_Meate.Effect = DM_BaseData_1.Code WHERE (dbo.DM_BaseData.ParentCode = ' 21 ' )
是将左右表进行联接后在用Where条件进行过滤

SELECT dbo.Pub_Meate. * , dbo.Base_Meter_Type.CodeName, dbo.DM_BaseData.CodeName AS ' gongtan ' , dbo.WC_Community_Info.CommunityName, DM_BaseData_1.CodeName AS ' yongtu ' FROM dbo.Pub_Meate LEFT JOIN dbo.Base_Meter_Type ON dbo.Pub_Meate.MeterTypeCode = dbo.Base_Meter_Type.ID LEFT JOIN dbo.WC_Community_Info ON dbo.WC_Community_Info.ID = dbo.Pub_Meate.CommUnId LEFT JOIN dbo.DM_BaseData ON dbo.DM_BaseData.Code = dbo.Pub_Meate.PubMeterCode LEFT JOIN dbo.DM_BaseData DM_BaseData_1 ON dbo.Pub_Meate.Effect = DM_BaseData_1.Code WHERE ( DM_BaseData_1.ParentCode = ' 22 ' ) AND (dbo.DM_BaseData. ParentCode = ' 21 ' )
先将字表查出（用Where条件进行过滤）再将表进行联接，和上面相比，下面这种方法查出的数据有时候要比上面查出的数据多

琐碎小事（添加ing）