protected void BtrDel_OnClick(object sender, EventArgs e) { Button btn = (Button)sender; string strIDNO = btn.ID.Split('_')[1]; Label lb = (Label)TCtrlID.FindControl("LBID_" + strIDNO); TableRow trID = (TableRow)TCtrlID.FindControl("TRCTRLID_" + strIDNO); TableRow trName = (TableRow)TCtrlID.FindControl("TRCTRLName_" + strIDNO); //如果是新添加的则直接隐藏掉那一行 if (lb.Text == "New") { TBControlNum.Text = (Convert.ToInt32(TBControlNum.Text) - 1).ToString(); //移除TR TCtrlID.Rows.Remove(trID); TCtrlName.Rows.Remove(trName); } //如果是以前的则: else { //删除CONTROL中的记录 string sqlText = "Delete From page_control Where con_id='" + lb.Text + "';"; //删除Power_ROLE中的记录 sqlText += "Delete From power_role Where control_id='" + lb.Text + "';"; //如果这个CONTROL对应于一条PAGE,则删除相应的PAGE记录 //sqlText += "Delete From Power_Action_Page Where Page=(Select RelatedPage From Power_Action_Control Where ID='" + lb.Text + "');"; dba.exSQLv(sqlText); TBControlNum.Text = (Convert.ToInt32(TBControlNum.Text) - 1).ToString(); //移除TR TCtrlID.Rows.Remove(trID); TCtrlName.Rows.Remove(trName); } string sql = "update power_page set controlnum=" + TBControlNum.Text + " where page_id=" + Request.QueryString["page_id"].ToString() + ""; dba.exSQLv(sql); Response.Write("<script>javascript:window.location.href=window.location.href;</script>"); }
protected void BtrDel_OnClick(object sender, EventArgs e) { Button btn = (Button)sender; string strIDNO = btn.ID.Split('_')[1]; Label lb = (Label)TCtrlID.FindControl("LBID_" + strIDNO); TableRow trID = (TableRow)TCtrlID.FindControl("TRCTRLID_" + strIDNO); TableRow trName = (TableRow)TCtrlID.FindControl("TRCTRLName_" + strIDNO); //如果是新添加的则直接隐藏掉那一行 if (lb.Text == "New") { //移除TR TCtrlID.Rows.Remove(trID); TCtrlName.Rows.Remove(trName); } //如果是以前的则: else { //删除CONTROL中的记录 string sqlText = "Delete From page_control Where con_id='" + lb.Text + "';"; //删除Power_ROLE中的记录 sqlText += "Delete From power_role Where control_id='" + lb.Text + "';"; //如果这个CONTROL对应于一条PAGE,则删除相应的PAGE记录 //sqlText += "Delete From Power_Action_Page Where Page=(Select RelatedPage From Power_Action_Control Where ID='" + lb.Text + "');"; dba.exSQLv(sqlText); //对应的ControlNum要减少一个 TBControlNum.Text = (Convert.ToInt32(TBControlNum.Text) - 1).ToString(); //移除TR TCtrlID.Rows.Remove(trID); TCtrlName.Rows.Remove(trName); } }
protected void Confirm_Click(object sender, EventArgs e) { string strID = ""; string strCtrl = ""; if (Request.QueryString["Action"] == "Add") { //保存页面到power_page string fatherID = ""; fatherID = DDLCategory.SelectedItem.Value.Split(',')[DDLCategory.SelectedItem.Value.Split(',').Length - 2]; string sqlText = "Insert Into power_page(page, controlNum, fatherID, name, IDPath, pageLevel, create_date, creator) Values("; sqlText += "'" + TBPage.Text + "',"; sqlText += "'" + TBControlNum.Text + "',"; sqlText += "'" + fatherID + "',"; sqlText += "'" + TBPageName.Text + "',"; sqlText += "'" + (DDLCategory.SelectedItem.Value == "0," ? "" : DDLCategory.SelectedItem.Value) + "',"; sqlText += "'" + (DDLCategory.SelectedItem.Value == "0," ? "" : DDLCategory.SelectedItem.Value).Split(',').Length + "',"; sqlText += "'" + DateTime.Now.ToString() + "',"; sqlText += "'" + Session["UserName"] + "') select @@Identity as idnty";//select @@Identity"标记到当前行的序号 SqlDataReader dr = dba.getDRExSQL(sqlText); if (dr.Read()) { strID = dr["idnty"].ToString(); } dr.Close(); //更新当前行的IDPatch,添加当前的PageID主键 sqlText = "Update power_page set IDPath=IDPath+'" + strID + ",' Where page_id='" + strID + "'"; dr = dba.getDRExSQL(sqlText); dr.Close(); //保存控件信息到page_control for (int i = 0; i < Convert.ToInt32(TBControlNum.Text); i++) { TextBox tbID = (TextBox)TCtrlID.FindControl("CtrlID_" + i.ToString()); TextBox tbName = (TextBox)TCtrlName.FindControl("CtrlName_" + i.ToString()); TextBox tbUrl = (TextBox)TCtrlID.FindControl("CtrlUrl_" + i.ToString()); //CheckBox cb = (CheckBox)TCtrlID.FindControl("CtrlIsRepeater_" + i.ToString()); TextBox tbNameing = (TextBox)TCtrlID.FindControl("CtrlNameingContainer_" + i.ToString()); strCtrl += "Insert Into page_control(page_id, control, gotoPage, name, namingContainer, create_date, creator) Values("; strCtrl += "'" + strID + "',"; strCtrl += "'" + tbID.Text + "',"; strCtrl += "'" + tbUrl.Text + "',"; strCtrl += "'" + tbName.Text + "',"; strCtrl += "'" + tbNameing.Text + "',"; strCtrl += "'" + DateTime.Now.ToString() + "',"; strCtrl += "'" + Session["UserName"] + "');"; } dr = dba.getDRExSQL(strCtrl); dr.Close(); } else if (Request.QueryString["Action"] == "Update") { string fatherID = ""; fatherID = DDLCategory.SelectedItem.Value.Split(',')[DDLCategory.SelectedItem.Value.Split(',').Length - 2]; string strPageID = Request.QueryString["page_id"]; string sqlText = "Update power_page Set "; sqlText += "page='" + TBPage.Text + "', "; sqlText += "fatherID='" + fatherID + "', "; sqlText += "controlNum='" + TBControlNum.Text + "', "; sqlText += "name='" + TBPageName.Text + "', "; sqlText += "IDPath='" + (DDLCategory.SelectedItem.Value == "0," ? "" : DDLCategory.SelectedItem.Value) + Request.QueryString["page_id"].ToString() + "," + "', "; sqlText += "pageLevel='" + (DDLCategory.SelectedItem.Value == "0," ? "" : DDLCategory.SelectedItem.Value).Split(',').Length + "' "; sqlText += "Where page_id='" + strPageID + "';"; Label lb = new Label(); int i = 0; while ((lb = (Label)TCtrlID.FindControl("LBID_" + i.ToString())) != null) { TextBox tbCtrlID = (TextBox)TCtrlID.FindControl("CtrlID_" + i.ToString()); TextBox tbCtrlUrl = (TextBox)TCtrlID.FindControl("CtrlUrl_" + i.ToString()); TextBox tbNameing = (TextBox)TCtrlID.FindControl("CtrlNameingContainer_" + i.ToString()); TextBox tbName = (TextBox)TCtrlName.FindControl("CtrlName_" + i.ToString()); if (lb.Text != "New") { sqlText += "Update page_control Set "; sqlText += "control='" + tbCtrlID.Text + "', "; sqlText += "namingContainer='" + tbNameing.Text + "', "; sqlText += "name='" + tbName.Text + "', "; sqlText += "gotoPage='" + tbCtrlUrl.Text + "' "; sqlText += "Where con_id='" + lb.Text + "';"; } else { if (tbCtrlID.Text != "") { sqlText += "Insert Into page_control(page_id, control, gotoPage, name, namingContainer, create_date, creator) Values("; sqlText += "'" + strPageID + "',"; sqlText += "'" + tbCtrlID.Text + "',"; sqlText += "'" + tbCtrlUrl.Text + "',"; sqlText += "'" + tbName.Text + "',"; sqlText += "'" + tbNameing.Text + "',"; sqlText += "'" + DateTime.Now.ToString() + "',"; sqlText += "'" + Session["UserName"] + "');"; } } i++; } SqlDataReader dr = dba.getDRExSQL(sqlText); dr.Close(); } Response.Redirect("QX_Power_List.aspx"); }