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");
}
