protected void gvData_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string SQL = "DELETE AREADATA WHERE 地號 ='{0}' AND 地段號='{1}' ";
SQL = string.Format(SQL, e.Values["地號"], e.Values["地段號"]);
this.lblResult.Text = WebApp.ExceCmd(SQL).ToString();
DataBind(1);
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
// 0地號,1地段名稱,2所有者,3異動時間,4地段號,5ID
string SQL = "INSERT INTO AREADATA VALUES('{0}','{1}','{2}',{3},'{4}',{5}) ";
SQL = string.Format(SQL, e.Values["地號"], e.Values["地段名稱"], e.Values["所有者"], "sysdate", e.Values["地段號"], e.Values["行政區"]);
this.lblResult.Text = WebApp.ExceCmd(SQL).ToString();
this.DetailsView1.DefaultMode = DetailsViewMode.ReadOnly;
//17 仁武區 5480012 2140 仁龍段
}
protected void btnQuery_Click(object sender, EventArgs e)
{
string Area = this.ddlArea.SelectedValue; //行政區ID
string Lot = this.ddlLot.SelectedValue; //地段號
string SQL = "INSERT INTO AREADATA VALUES('{0}','{1}','{2}',{3},'{4}','{5}') ";
SQL = string.Format(SQL, this.ddlLot.SelectedValue, this.ddlLot.SelectedItem.Text, TextBox3.Text, "sysdate", txtArea.Text, this.ddlArea.SelectedValue);
this.lblResult.Text = WebApp.ExceCmd(SQL).ToString();
this.DetailsView1.DefaultMode = DetailsViewMode.ReadOnly;
DataBind(1);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string Area = this.ddlArea.SelectedValue; //管轄行政區
string Orgn = this.ddlOrgn.SelectedValue; //機關
try
{
WebApp.ExceCmd("INSERT INTO R_機關資料_行政區 VALUES(" + Orgn + ", " + Area + ")");
lblResult.Text = Orgn + ", " + Area;
}
catch (Exception ex)
{
lblResult.Text = "sql:" + "INSERT INTO R_機關資料_行政區 VALUES(" + Orgn + ", " + Area + ")" + ex.Message;
}
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
string ID = WebApp.GetValue("SELECT MAX(機關ID)+1 FROM 機關資料 ").ToString();
string SQL = " INSERT INTO 機關資料 ( 機關ID, 名稱, 類別, 地址, 聯絡資訊 ) VALUES ( {0}, '{1}', '{2}', '{3}', '{4}' ); ";
try {
SQL = string.Format(SQL, ID, e.Values["名稱"], e.Values["類別"], e.Values["地址"], e.Values["聯絡資訊"]);
WebApp.ExceCmd(SQL);
this.DetailsView1.DefaultMode = DetailsViewMode.ReadOnly;
}
catch (Exception ex)
{
lblResult.Text = SQL + ex.Message;
}
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
string SQL = "UPDATE AREADATA SET 地號='{0}',地段名稱='{1}',所有者='{2}',異動時間={3},地段號='{4}' WHERE 地號='{0}' AND 地段號='{4}' ";
try
{
SQL = string.Format(SQL, e.NewValues["地號"], e.NewValues["地段名稱"], e.NewValues["所有者"], "sysdate", e.NewValues["地段號"]
, e.NewValues["行政區"]);
this.lblResult.Text = WebApp.ExceCmd(SQL).ToString();
this.DetailsView1.Visible = false;
this.DetailsView1.DefaultMode = DetailsViewMode.ReadOnly;
DataBind(1);
}
catch (Exception ex)
{
lblResult.Text = SQL;
}
}