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