public override void ValidateUrl() { if (!string.IsNullOrEmpty(Request.GroupString["type"])) { long resultID = 0; switch (Request.GroupString["type"]) { case "add": if (!Xy.Tools.Web.Form.ValidateForm(Request.Form)) throw new Exception(WebSetting.Translate["error-empty"]); resultID = XiaoYang.User.PowerList.Add(Request.Form); Response.Write(string.Format("{{ status:'success', id:{0} }}", resultID)); break; case "del": XiaoYang.User.PowerList.Del(Request.QueryString); Response.Write(string.Format("{{ status:'success', id:{0} }}", Request.QueryString["ID"])); break; case "addgroup": if (!Xy.Tools.Web.Form.ValidateForm(Request.Form)) throw new Exception(WebSetting.Translate["error-empty"]); resultID = XiaoYang.User.UserGroup.Add(Request.Form); Response.Write(string.Format("{{ status:'success', id:{0} }}", resultID)); break; case "delgroup": XiaoYang.User.UserGroup.Del(Request.QueryString); Response.Write(string.Format("{{ status:'success', id:{0} }}", Request.QueryString["ID"])); break; case "getpowerbygroup": Response.Write("["); Xy.Data.Procedure _pc = new Xy.Data.Procedure("getPowerList", @"select [PowerList].* from [PowerShip] left join [PowerList] on [PowerList].[ID] = [PowerShip].[PowerList] where [PowerShip].[UserGroup] = " + Request.QueryString["ID"]); System.Data.DataTable _dt = _pc.InvokeProcedureFill(); for (int i = 0; i < _dt.Rows.Count; i++) { System.Data.DataRow _dr = _dt.Rows[i]; if (i > 0) Response.Write(','); Response.Write(string.Format("{{id:\"{0}\",key:\"{1}\",description:\"{2}\"}}", _dr["ID"].ToString(), _dr["Key"].ToString(), _dr["Description"].ToString())); } Response.Write("]"); break; case "addship": if (!Xy.Tools.Web.Form.ValidateForm(Request.Form)) throw new Exception(WebSetting.Translate["error-empty"]); resultID = XiaoYang.User.PowerShip.Add(Request.Form); Response.Write(string.Format("{{ status:'success', id:{0} }}", resultID)); break; case "delship": XiaoYang.User.PowerShip.Del(Request.Form); Response.Write(string.Format("{{ status:'success', id:{0} }}", Request.Form["PowerList"])); break; } if (string.Compare(Request.GroupString["type"], "getpowerbygroup") != 0) XiaoYang.User.UserPermissionCollection.ClearCache(); } }
public EntityCollection GetList(string where, int pageIndex,int pageSize, string order, ref int totalRowCount) { Xy.Data.Procedure _getList = new Xy.Data.Procedure("Entity_SplitPage", new Xy.Data.ProcedureParameter[] { new Xy.Data.ProcedureParameter("Select", System.Data.DbType.String), new Xy.Data.ProcedureParameter("TableName", System.Data.DbType.String), new Xy.Data.ProcedureParameter("Where", System.Data.DbType.String), new Xy.Data.ProcedureParameter("PageIndex", System.Data.DbType.Int32), new Xy.Data.ProcedureParameter("PageSize", System.Data.DbType.Int32), new Xy.Data.ProcedureParameter("Order", System.Data.DbType.String), new Xy.Data.ProcedureParameter("OrderBy", System.Data.DbType.String), new Xy.Data.ProcedureParameter("TotalRowCount", System.Data.DbType.Int32){ Direction = System.Data.ParameterDirection.InputOutput} }); _getList.SetItem("Select", _cache.CacheString_Select_Field); _getList.SetItem("TableName", _cache.CacheString_Select_Table); _getList.SetItem("Where", "[TypeID] = " + _cache.TypeInstance.ID + (string.IsNullOrEmpty(where) ? string.Empty : " and " + where)); _getList.SetItem("PageIndex", pageIndex); _getList.SetItem("PageSize", pageSize); _getList.SetItem("Order", "[EntityBase].[ID] desc"); _getList.SetItem("OrderBy", string.IsNullOrEmpty(order) ? "[ID] desc" : order); _getList.SetItem("TotalRowCount", totalRowCount); System.Data.DataTable _dt = _getList.InvokeProcedureFill(); totalRowCount = Convert.ToInt32(_getList.GetItem("TotalRowCount")); EntityCollection _ec = new EntityCollection(_dt, _cache.TypeInstance.ID); return _ec; }