/// <summary> /// 注释XXXX_BEGIN和XXXX_END为替换区域,这些注释不能删除否则自动生成代码会失败,并且自定义内容不能写在注释之间,否则下次自动生成内容时会覆盖掉。 /// </summary> public void Read(SQLiteTable table) { if (table == null) { return; } dic.Clear(); list.Clear(); while (table.Read()) { //TABLE_READ_BEGIN TBRole o = new TBRole(); o.id = table.GetByColumnName("id", 0); o.name = table.GetByColumnName("name", ""); o.type = table.GetByColumnName("type", 0); o.height = table.GetByColumnName("height", 0f); o.desc = table.GetByColumnName("desc", ""); o.weigth = table.GetByColumnName("weigth", 0f); o.config = table.GetByColumnName("config", 0); o.y = table.GetByColumnName("y", 0); dic.Add(o.id, o); list.Add(o); //TABLE_READ_END } }
public ReturnData AJAX_BE_Insert(string name) { try { DataClassesDataContext db = new DataClassesDataContext(); var existRole = db.TBRoles.Where(x => x.Name.ToLower() == name.ToLower()).FirstOrDefault(); if (existRole != null) { return(ReturnData.MessageFailed("Role's name is already registered", null)); } TBRole role = new TBRole(); role.Name = name; role.Deflag = false; role.DateInsert = DateTime.Now; role.DateLastUpdate = DateTime.Now; db.TBRoles.InsertOnSubmit(role); db.SubmitChanges(); return(ReturnData.MessageSuccess("New role was added", role)); } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
public ReturnData AJAX_BE_Updates(int idRole, string name) { try { DataClassesDataContext db = new DataClassesDataContext(); TBRole role = db.TBRoles.Where(x => !x.Deflag && x.IDRole == idRole).FirstOrDefault(); if (role == null) { return(ReturnData.MessageFailed("Role not found", null)); } role.IDRole = idRole; role.Name = name; if (role.Name != name) { var existRole = db.TBRoles.Where(x => !x.Deflag && x.Name == name).FirstOrDefault(); if (existRole != null) { return(ReturnData.MessageFailed("Role's name is already registered", null)); } } role.DateLastUpdate = DateTime.Now; db.SubmitChanges(); return(ReturnData.MessageSuccess("Data updated successfully", null)); } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
public ReturnData AJAX_BE_Delete(int idRole) { try { DataClassesDataContext db = new DataClassesDataContext(); TBRole role = db.TBRoles.Where(x => !x.Deflag && x.IDRole == idRole).FirstOrDefault(); if (role == null) { return(ReturnData.MessageFailed("Role not found", null)); } role.Deflag = true; role.DateLastUpdate = DateTime.Now; db.SubmitChanges(); return(ReturnData.MessageSuccess("Data deleted successfully", null)); } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }