protected void Page_Show(object sender, EventArgs e)
{
Utility.buildListBox(ddlType.Items, "select typeID,Name from bm_PavilionType", "typeID", "Name", null, "");
Utility.buildListBox(ddlSunny.Items, "select ID,Name from bm_Sunny", "ID", "Name", null, "");
if (p_theID.Value.Length > 0)
{
string sWhere = "";
sWhere += "paID=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
string sSQL = "select * from Pavilion where " + sWhere;
SqlDataAdapter dsCommand = new SqlDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "Table") > 0)
{
row = ds.Tables[0].Rows[0];
theID.Value = CCUtility.GetValue(row, "paID");
//System.Web.UI.WebControls.TextBox[] tempBox={tbName,tb,btNote,btP1,btP2,btPhone,btMemo};
tbName.Text = CCUtility.GetValue(row, "Name");
tbHigh.Text = CCUtility.GetValue(row, "High");
tbArea.Text = CCUtility.GetValue(row, "Area");
tbLayer.Text = CCUtility.GetValue(row, "Layer");
tbBuildDate.Text = CCUtility.GetValue(row, "BuildDate");
tbMemo.Text = CCUtility.GetValue(row, "Memo");
//类型
string s = CCUtility.GetValue(row, "typeID");
try
{
ddlType.SelectedIndex = ddlType.Items.IndexOf(ddlType.Items.FindByValue(s));
}
catch {}
//朝向
s = CCUtility.GetValue(row, "sunnyID");
try
{
ddlSunny.SelectedIndex = ddlSunny.Items.IndexOf(ddlSunny.Items.FindByValue(s));
}
catch {}
}
}
}
private void Search_Show()
{
Utility.buildListBox(ddlDMList.Items, "select ID,Name from bm_bm", "ID", "Name", null, "");
string s = Utility.GetParam("paID");
try
{
ddlDMList.SelectedIndex = ddlDMList.Items.IndexOf(ddlDMList.Items.FindByValue(s));
}
catch { }
}
void Search_Show()
{
Utility.buildListBox(ddlPavilion.Items, "select paID,Name from Pavilion ", "paID", "Name", "请选择", "");
string s;
s = Utility.GetParam("search");
tbRoom.Text = s;
s = Utility.GetParam("paID");
try
{
ddlPavilion.SelectedIndex = ddlPavilion.Items.IndexOf(ddlPavilion.Items.FindByValue(s));
}
catch { }
}
protected void Page_Show(object sender, EventArgs e)
{
Utility.buildListBox(ddlCell.Items, "select ID,Name from bm_Cell", "ID", "Name", null, "");
Utility.buildListBox(ddlSunny.Items, "select ID,Name from bm_Sunny", "ID", "Name", null, "");
Utility.buildListBox(ddlType.Items, "select ID,Name from bm_Indoor", "ID", "Name", null, "");
//楼名称
tbPaName.Text = Utility.Dlookup("pavilion", "Name", "paID=" + CCUtility.ToSQL(paID.Value, FieldTypes.Number));
tbPaName.Enabled = false;
if (p_theID.Value.Length > 0)
{
string sWhere = "";
sWhere += "hoID=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
string sSQL = "select * from House where " + sWhere;
SqlDataAdapter dsCommand = new SqlDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "Table") > 0)
{
row = ds.Tables[0].Rows[0];
theID.Value = CCUtility.GetValue(row, "hoID");
paID.Value = CCUtility.GetValue(row, "paID");
tbRoom.Text = CCUtility.GetValue(row, "hoRoom");
tbLayer.Text = CCUtility.GetValue(row, "hoFloor");
tbArea.Text = CCUtility.GetValue(row, "hoArchArce");
tbArea2.Text = CCUtility.GetValue(row, "hoUseArce");
tbClientName.Text = CCUtility.GetValue(row, "Client_Name");
tbClientID.Text = CCUtility.GetValue(row, "CLIENT_CARD");
tbPhone.Text = CCUtility.GetValue(row, "CLIENT_PHONE");
tbClientCard.Text = CCUtility.GetValue(row, "CLIENT_ACCOUNT_NUMBER");
tbUseDate.Text = CCUtility.GetValue(row, "USE_DATE");
tbUnit.Text = CCUtility.GetValue(row, "COMPANY_NAME");
tbMemo.Text = CCUtility.GetValue(row, "Memo");
//类型
string s = CCUtility.GetValue(row, "indoorID");
try
{
ddlType.SelectedIndex = ddlType.Items.IndexOf(ddlType.Items.FindByValue(s));
}
catch { }
//单元
s = CCUtility.GetValue(row, "cellID");
try
{
ddlCell.SelectedIndex = ddlCell.Items.IndexOf(ddlCell.Items.FindByValue(s));
}
catch { }
//朝向
s = CCUtility.GetValue(row, "sunnyID");
try
{
ddlSunny.SelectedIndex = ddlSunny.Items.IndexOf(ddlSunny.Items.FindByValue(s));
}
catch { }
}
}
}