protected void Page_Load(object sender, EventArgs e) { user = new eUser("Manage"); edt = new eForm("a_eke_sysUsers", user); //edt.AutoRedirect = false; if (act.Length == 0) { List(user); return; } if (act == "getrole") { string roleid = eParameters.QueryString("roleid"); DataTable rolePower = eBase.getUserPowerDefault(roleid, "", ""); eJson json = new eJson(rolePower); eBase.Write(json.ToString()); Response.End(); } #region 信息添加、编辑 if (act == "active") //是否显示 { string sql = eParameters.Replace("update a_eke_sysUsers set Active='{querystring:value}' where UserID='{querystring:id}'", null, null); eOleDB.Execute(sql); Response.Redirect(Request.ServerVariables["HTTP_REFERER"] == null ? "Default.aspx" : Request.ServerVariables["HTTP_REFERER"].ToString(), true); eBase.End(); } if (act == "getuser") { sql = "select count(*) from a_eke_sysUsers where yhm='" + eParameters.QueryString("value") + "'"; string temp = eOleDB.getValue(sql); if (temp == "0") { Response.Write("true"); } else { Response.Write("false"); } Response.End(); } if (act == "edit") { f1.Attributes = " readOnly"; } edt.AddControl(eFormControlGroup); eFormControl _roles = new eFormControl("Roles"); _roles.Field = "RoleID"; edt.AddControl(_roles); edt.onChange += new eFormTableEventHandler(edt_onChange); edt.Handle(); #endregion if (act == "add" || act == "edit") { eBase.clearDataCache("a_eke_sysPowers"); LitRoles.Text = getRoles(_roles.Value.ToString()); //edt.Fields["RoleID"].ToString() } }
protected void Action_Actioning(string Actioning) { string sql = ""; eform = new eForm("a_eke_sysModels", user); eform.ModelID = "1"; if (Actioning.ToLower() == "view") { eFormControl uc = new eFormControl("f0"); uc.Field = "Type"; eform.Controls.Add("f0", uc); } if (Actioning.ToLower() == "setsort") { string ParentID = eParameters.QueryString("pid").Replace("NULL", ""); int index = Convert.ToInt32(eParameters.QueryString("index")); DataRow dr = eOleDB.getDataTable("SELECT * FROM a_eke_sysModels where ModelID='" + id + "'").Select()[0]; string oldpid = dr["ParentID"].ToString(); int oldindex = Convert.ToInt32(dr["px"]); if (ParentID == oldpid) //父级不变 { if (oldindex < index) //小变大 { sql = "update a_eke_sysModels set PX=PX-1 where delTag=0 " + (ParentID.Length == 0 ? " and ParentID IS NULL" : " and ParentID='" + ParentID + "'") + " and PX>" + oldindex.ToString() + " and PX<=" + index.ToString(); eOleDB.Execute(sql); } else //大变小 { sql = "update a_eke_sysModels set PX=PX+1 where delTag=0 " + (ParentID.Length == 0 ? " and ParentID IS NULL" : " and ParentID='" + ParentID + "'") + " and PX>=" + index.ToString() + " and PX<" + oldindex.ToString(); eOleDB.Execute(sql); } sql = "update a_eke_sysModels set PX='" + index.ToString() + "' where ModelID='" + id + "'"; eOleDB.Execute(sql); } else { sql = "update a_eke_sysModels set PX=PX-1 where delTag=0 " + (oldpid.Length == 0 ? " and ParentID IS NULL" : " and ParentID='" + oldpid + "'") + " and PX>" + oldindex.ToString(); eOleDB.Execute(sql); sql = "update a_eke_sysModels set PX=PX+1 where delTag=0 " + (ParentID.Length == 0 ? " and ParentID IS NULL" : " and ParentID='" + ParentID + "'") + " and PX>=" + index.ToString(); eOleDB.Execute(sql); sql = "update a_eke_sysModels set PX='" + index.ToString() + "',ParentID=" + (ParentID.Length == 0 ? "NULL" : "'" + ParentID + "'") + " where ModelID='" + id + "'"; eOleDB.Execute(sql); } eBase.clearDataCache("a_eke_sysModels"); eBase.End(); } if (Actioning.Length > 0) { eform.onChange += new eFormTableEventHandler(eform_onChange); eform.AddControl(eFormControlGroup); eform.Handle(); } }