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