public List <G_Page> GetEntities(string role, string id, int type)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.VarChar, 100),
new SqlParameter("@ObjId", SqlDbType.VarChar, 100),
new SqlParameter("@ObjType", SqlDbType.Int) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(role);
parms[1].Value = SqlTypeConverter.DBNullStringChecker(id);
parms[2].Value = SqlTypeConverter.DBNullInt32Checker(type);
var entities = new List <G_Page>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_G_Page_Repository_GetEntitiesInObj, parms)) {
while (rdr.Read())
{
var entity = new G_Page();
entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.IsHome = SqlTypeConverter.DBNullBooleanHandler(rdr["IsHome"]);
entity.Content = SqlTypeConverter.DBNullStringHandler(rdr["Content"]);
entity.ObjId = SqlTypeConverter.DBNullStringHandler(rdr["ObjId"]);
entity.ObjType = SqlTypeConverter.DBNullInt32Handler(rdr["ObjType"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
entities.Add(entity);
}
}
return(entities);
}
public List <G_Page> GetEntities()
{
var entities = new List <G_Page>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_G_Page_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new G_Page();
entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.IsHome = SqlTypeConverter.DBNullBooleanHandler(rdr["IsHome"]);
entity.Content = SqlTypeConverter.DBNullStringHandler(rdr["Content"]);
entity.ObjId = SqlTypeConverter.DBNullStringHandler(rdr["ObjId"]);
entity.ObjType = SqlTypeConverter.DBNullInt32Handler(rdr["ObjType"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
entities.Add(entity);
}
}
return(entities);
}
public G_Page GetEntity(string name)
{
SqlParameter[] parms = { new SqlParameter("@Name", SqlDbType.VarChar, 200) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(name);
G_Page entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_G_Page_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new G_Page();
entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.IsHome = SqlTypeConverter.DBNullBooleanHandler(rdr["IsHome"]);
entity.Content = SqlTypeConverter.DBNullStringHandler(rdr["Content"]);
entity.ObjId = SqlTypeConverter.DBNullStringHandler(rdr["ObjId"]);
entity.ObjType = SqlTypeConverter.DBNullInt32Handler(rdr["ObjType"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
}
}
return(entity);
}
public String SaveGVPage(string role, [FromBody] API_GV_Page page)
{
try {
if (string.IsNullOrWhiteSpace(role))
{
throw new ArgumentNullException("role");
}
if (page == null)
{
throw new ArgumentNullException("value");
}
var target = new G_Page {
RoleId = (int)EnmAPISCObj.Device == page.SCObjType ? U_Role.SuperId : role,
Name = page.Name,
IsHome = page.IsHome,
Content = page.Content,
ObjId = page.SCObjID,
ObjType = page.SCObjType
};
if (_gpageService.Exist(page.Name))
{
_gpageService.Update(target);
}
else
{
_gpageService.Add(target);
}
} catch (Exception exc) {
return(exc.Message);
}
return(null);
}
