/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <Data.Model.UsersApp> DataReaderToList(SqlDataReader dataReader)
{
List <Data.Model.UsersApp> List = new List <Data.Model.UsersApp>();
Data.Model.UsersApp model = null;
while (dataReader.Read())
{
model = new Data.Model.UsersApp();
model.ID = dataReader.GetGuid(0);
model.UserID = dataReader.GetGuid(1);
model.ParentID = dataReader.GetGuid(2);
model.RoleID = dataReader.GetGuid(3);
if (!dataReader.IsDBNull(4))
{
model.AppID = dataReader.GetGuid(4);
}
if (!dataReader.IsDBNull(5))
{
model.Title = dataReader.GetString(5);
}
if (!dataReader.IsDBNull(6))
{
model.Params = dataReader.GetString(6);
}
if (!dataReader.IsDBNull(7))
{
model.Ico = dataReader.GetString(7);
}
model.Sort = dataReader.GetInt32(8);
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">Data.Model.UsersApp实体类</param>
public int Update(Data.Model.UsersApp model)
{
string sql = @"UPDATE UsersApp SET
UserID=@UserID,ParentID=@ParentID,RoleID=@RoleID,AppID=@AppID,Title=@Title,Params=@Params,Ico=@Ico,Sort=@Sort
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.UserID
},
new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ParentID
},
new SqlParameter("@RoleID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.RoleID
},
model.AppID == null ? new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.AppID
},
model.Title == null ? new SqlParameter("@Title", SqlDbType.NVarChar, 400)
{
Value = DBNull.Value
} : new SqlParameter("@Title", SqlDbType.NVarChar, 400)
{
Value = model.Title
},
model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@Params", SqlDbType.VarChar, 500)
{
Value = model.Params
},
model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = model.Ico
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">Data.Model.UsersApp实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(Data.Model.UsersApp model)
{
string sql = @"INSERT INTO UsersApp
(ID,UserID,ParentID,RoleID,AppID,Title,Params,Ico,Sort)
VALUES(@ID,@UserID,@ParentID,@RoleID,@AppID,@Title,@Params,@Ico,@Sort)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.UserID
},
new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ParentID
},
new SqlParameter("@RoleID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.RoleID
},
model.AppID == null ? new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@AppID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.AppID
},
model.Title == null ? new SqlParameter("@Title", SqlDbType.NVarChar, 400)
{
Value = DBNull.Value
} : new SqlParameter("@Title", SqlDbType.NVarChar, 400)
{
Value = model.Title
},
model.Params == null ? new SqlParameter("@Params", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@Params", SqlDbType.VarChar, 500)
{
Value = model.Params
},
model.Ico == null ? new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@Ico", SqlDbType.VarChar, 500)
{
Value = model.Ico
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
}
};
return(dbHelper.Execute(sql, parameters));
}
public ActionResult AddApp(FormCollection collection)
{
Business.Platform.AppLibrary bappLibrary = new Business.Platform.AppLibrary();
Business.Platform.UsersApp busersApp = new Business.Platform.UsersApp();
Business.Platform.RoleApp broleApp = new Business.Platform.RoleApp();
Data.Model.UsersApp usersApp = null;
string id = Request.QueryString["id"];
string userID = Request.QueryString["userid"];
string roleID = Request.QueryString["roleid"];
if (collection != null && id.IsGuid() && userID.IsGuid())
{
usersApp = busersApp.Get(id.ToGuid());
if (!Request.Form["Save"].IsNullOrEmpty())
{
string name = Request.Form["Name"];
string type = Request.Form["Type"];
string appid = Request.Form["AppID"];
string params1 = Request.Form["Params"];
string ico = Request.Form["Ico"];
Data.Model.UsersApp usersApp1 = new Data.Model.UsersApp();
usersApp1.ID = Guid.NewGuid();
usersApp1.ParentID = id.ToGuid();
usersApp1.Title = name.Trim();
usersApp1.Sort = broleApp.GetMaxSort(id.ToGuid());
usersApp1.UserID = userID.ToGuid();
usersApp1.RoleID = roleID.IsGuid() ? roleID.ToGuid() : Guid.Empty;
if (appid.IsGuid())
{
usersApp1.AppID = appid.ToGuid();
}
else
{
usersApp1.AppID = null;
}
usersApp1.Params = params1.IsNullOrEmpty() ? null : params1.Trim();
if (!ico.IsNullOrEmpty())
{
usersApp1.Ico = ico;
}
busersApp.Add(usersApp1);
busersApp.ClearCache();
Business.Platform.Log.Add("添加了个人应用", busersApp.Serialize(), Business.Platform.Log.Types.角色应用);
string refreshID = id;
ViewBag.Script = "alert('添加成功!'); parent.frames[0].reLoad('" + refreshID + "')";
}
}
ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions();
return(View());
}
/// <summary>
/// 更新
/// </summary>
public int Update(Data.Model.UsersApp model)
{
return(dataUsersApp.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(Data.Model.UsersApp model)
{
return(dataUsersApp.Add(model));
}
public ActionResult Body1(FormCollection collection)
{
Business.Platform.AppLibrary bappLibrary = new Business.Platform.AppLibrary();
Business.Platform.RoleApp broleApp = new Business.Platform.RoleApp();
Business.Platform.UsersApp buserApp = new Business.Platform.UsersApp();
Data.Model.UsersApp usersApp = null;
string id = Request.QueryString["id"];
string name = string.Empty;
string type = string.Empty;
string appid = string.Empty;
string params1 = string.Empty;
string ico = string.Empty;
Guid appID;
if (id.IsGuid(out appID))
{
usersApp = buserApp.Get(appID);
if (usersApp != null)
{
name = usersApp.Title;
type = usersApp.AppID.HasValue ? bappLibrary.GetTypeByID(usersApp.AppID.Value) : "";
appid = usersApp.AppID.ToString();
params1 = usersApp.Params;
ico = usersApp.Ico;
}
}
if (collection != null && usersApp != null)
{
if (!Request.Form["Save"].IsNullOrEmpty())
{
name = Request.Form["Name"];
type = Request.Form["Type"];
appid = Request.Form["AppID"];
params1 = Request.Form["Params"];
ico = Request.Form["Ico"];
string oldXML = usersApp.Serialize();
usersApp.Title = name.Trim();
if (appid.IsGuid())
{
usersApp.AppID = appid.ToGuid();
}
else
{
usersApp.AppID = null;
}
usersApp.Params = params1.IsNullOrEmpty() ? null : params1.Trim();
if (!ico.IsNullOrEmpty())
{
usersApp.Ico = ico;
}
else
{
usersApp.Ico = null;
}
buserApp.Update(usersApp);
buserApp.ClearCache();
Business.Platform.Log.Add("修改了个人应用", "", Business.Platform.Log.Types.角色应用, oldXML, usersApp.Serialize());
string refreshID = usersApp.ParentID.ToString();
ViewBag.Script = "alert('保存成功!'); parent.frames[0].reLoad('" + refreshID + "')";
}
if (!Request.Form["Delete"].IsNullOrEmpty())
{
int i = buserApp.DeleteAndAllChilds(usersApp.ID);
buserApp.ClearCache();
Business.Platform.Log.Add("删除了个人应用", usersApp.Serialize(), Business.Platform.Log.Types.角色应用);
string refreshID = usersApp.ParentID.ToString();
var parent = buserApp.Get(usersApp.ParentID);
string page = parent == null ? "Body" : "Body1";
ViewBag.Script = "parent.frames[0].reLoad('" + refreshID + "');window.location='" + page + "?id=" + refreshID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&userid=" + Request.QueryString["userid"] + "';";
}
}
ViewBag.AppID = appid;
ViewBag.AppTypesOptions = bappLibrary.GetTypeOptions(type);
return(View(usersApp == null ? new Data.Model.UsersApp() : usersApp));
}
