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