protected override void InitData() {
imagePath.Value = ConfigurationManager.AppSettings["imagesUrl"];
SQLDB sectorDB = new SQLDB("View_AllLocation");
DataSet sectorDS = sectorDB.Select();
DataTable sectorDT = sectorDS.Tables[0];
ListItem defaultItem = new ListItem();
defaultItem.Text = "無";
defaultItem.Value = "null";
DropDownList1.Items.Add(defaultItem);
foreach(DataRow sectorData in sectorDT.Rows){
ListItem sector = new ListItem();
sector.Text = sectorData["Location"].ToString();
sector.Value = sectorData["Location"].ToString();
DropDownList1.Items.Add(sector);
}
if (Request.QueryString["type"].Trim() != null && Request.QueryString["id"].Trim() != null)
{
dataType.Value = Request.QueryString["type"].Trim();
string id = Request.QueryString["id"].Trim();
string table;
SQLDB db;
DataSet ds;
DataTable dt;
if (dataType.Value.Equals("Device"))
{
//設定修復期限是否要顯示
TextBox1.Visible = false;
TextBox2.Visible = false;
Button1.Visible = false;
lbl_repairend.Visible = false;
lbl2.Visible = false;
TextBox1.Enabled = false;
TextBox2.Enabled = false;
Image1.Visible = false;
Image2.Visible = false;
table = "View_ParkingDeviceOnMap";
db = new SQLDB(table);
if (id.Equals("0"))
{
ds = db.Select();
if (ds.Tables.Count == 1)
{
dt = ds.Tables[0];
JSONWebService jsonString = new JSONWebService();
jsonData.Value = jsonString.GetJson(dt);
}
else
{
jsonData.Value = "null";
}
}
else
{
ds = db.Select("Device_ID='" + id + "'");
if (ds.Tables.Count == 1)
{
dt = ds.Tables[0];
JSONWebService jsonString = new JSONWebService();
jsonData.Value = jsonString.GetJson(dt);
}
else
{
jsonData.Value = "null";
}
}
}
else if (dataType.Value.Equals("Case"))
{
Button2.Visible = false;
table = "View_ParkingCaseOnMap";
db = new SQLDB(table);
if (id.Equals("0"))
{
ds = db.Select("status = '維修中'");
dt = ds.Tables[0];
JSONWebService jsonString = new JSONWebService();
jsonData.Value = jsonString.GetJson(dt);
}
else
{
ds = db.Select("CaseID='" + id + "'");
dt = ds.Tables[0];
JSONWebService jsonString = new JSONWebService();
jsonData.Value = jsonString.GetJson(dt);
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
dataType.Value = Request.QueryString["type"].Trim();
string table;
SQLDB db;
DataSet ds;
DataTable dt;
string sqlStr = "";
if (dataType.Value.Equals("Device"))
{
table = "View_ParkingDeviceOnMap";
if (DropDownList1.SelectedValue != "null")
sqlStr += "Location LIKE '%%" + DropDownList1.SelectedValue + "%%' ";
db = new SQLDB(table);
ds = db.Select(sqlStr);
if (ds.Tables.Count == 1)
{
dt = ds.Tables[0];
JSONWebService jsonString = new JSONWebService();
jsonData.Value = jsonString.GetJson(dt);
}
else
{
jsonData.Value = "null";
}
}
else if (dataType.Value.Equals("Case"))
{
table = "View_ParkingCaseOnMap";
if (DropDownList1.SelectedValue != "null")
sqlStr += "Location LIKE '%%" + DropDownList1.SelectedValue + "%%' ";
if (TextBox1.Text.Length != 0)
{
if (sqlStr.Length != 0)
sqlStr += "AND ";
sqlStr += "RepairDeadline>'" + TextBox1.Text + "' ";
}
if (TextBox1.Text.Length != 0)
{
if (sqlStr.Length != 0)
sqlStr += "AND ";
sqlStr += "RepairDeadline<'" + TextBox2.Text + "' ";
}
db = new SQLDB(table);
ds = db.Select(sqlStr);
if (ds.Tables.Count == 1)
{
dt = ds.Tables[0];
JSONWebService jsonString = new JSONWebService();
jsonData.Value = jsonString.GetJson(dt);
}
else
{
jsonData.Value = "null";
}
}
}
