/// <summary>
/// 单条添加题
/// </summary>
/// <param name="questionBank"></param>
/// <returns></returns>
public int ADD(QuestionBankinherit questionBankinherit)
{
try
{
//添加到题库
QuestionBank questionBank = new QuestionBank();
questionBank.Subject = questionBankinherit.Subject;
questionBank.Answer = questionBankinherit.Answer;
questionBank.Photo = questionBankinherit.Photo;
questionBank.TypeOfExam = questionBankinherit.TypeOfExam;
questionBank.Enable = questionBankinherit.Enable;
SqlSugarClient sugarClient = Educationcontext.GetClient();
var resultquestionBank = QuestionBankDB.Insert(questionBank);
//获取最后一个Id
questionBank = sugarClient.SqlQueryable <QuestionBank>("select id from QuestionBank order by id DESC limit 1").First();
var resultQuestionBankId = questionBank.Id;
//添加到选项
Option option = new Option();
option.QuestionBankId = resultQuestionBankId;
option.AnswerA = questionBankinherit.AnswerA;
option.AnswerB = questionBankinherit.AnswerB;
option.AnswerC = questionBankinherit.AnswerC;
option.AnswerD = questionBankinherit.AnswerD;
option.AnswerE = questionBankinherit.AnswerE;
var resultoption = OptionDB.Insert(option);
return(1);
}
catch (Exception ex)
{
//return ex.Message;
return(0);
}
}
/// <summary>
/// 单条添加用户角色信息
/// </summary>
/// <param name="usersInfo"></param>
/// <returns></returns>
public int Add(UsersInfo usersInfo)
{
//实例化用户表
Users users = new Users();
users.UserName = usersInfo.UserName;
users.Password = usersInfo.Password;
var result = UsersDB.Insert(users);
//如果result为true
if (result)
{
SqlSugarClient sqlSugarClient = Educationcontext.GetClient();
var db = sqlSugarClient.SqlQueryable <Users>("select Id from Users order by Id ").Max(s => s.Id);
//实例化用户角色表
UserandRole userandRole = new UserandRole();
userandRole.UsersId = db;
var num = usersInfo.RoleName.Substring(0, usersInfo.RoleName.LastIndexOf(',')).Split(',');
var usersdb = 0;
foreach (var item in num)
{
userandRole.RolesId = int.Parse(item);
usersdb += sqlSugarClient.Insertable <UserandRole>(userandRole).ExecuteCommand();
}
if (usersdb == num.Length)
{
return(1);
}
}
return(0);
}
public ActionResult Save(int id, string title, string remark, string url)
{
FileUploadManager fileUploadManager = new FileUploadManager();
SimpleClient <fileupload> FileDb = new SimpleClient <fileupload>(fileUploadManager.Db);
try
{
var file = new fileupload()
{
id = id,
filename = title,
filecontent = url,
filetype = remark,
};
FileDb.Insert(file);
return(Json(new
{
Result = true
}));
}
catch (Exception exception)
{
return(Json(new
{
Result = true,
exception.Message
}));
}
}
/// <summary>
/// 单条添加用户角色数据
/// </summary>
/// <param name="jurisdictionInfo"></param>
/// <returns></returns>
public int Add(JurisdictionInfo jurisdictionInfo)
{
//实例化角色表
Role role = new Role();
role.RoleName = jurisdictionInfo.RoleName;
var result = RoleDB.Insert(role);
//如果为true
if (result)
{
SqlSugarClient sqlSugarClient = Educationcontext.GetClient();
//排序查询最大值
var db = sqlSugarClient.SqlQueryable <Role>("select Id from Role order by Id").Max(s => s.Id);
RoleanJurisdiction roleanJurisdiction = new RoleanJurisdiction();
roleanJurisdiction.RolesId = db;
var num = jurisdictionInfo.Name.Substring(0, jurisdictionInfo.Name.LastIndexOf(',')).Split(',');
var roledb = 0;
foreach (var item in num)
{
roleanJurisdiction.JurisdictionId = int.Parse(item);
roledb += sqlSugarClient.Insertable <RoleanJurisdiction>(roleanJurisdiction).ExecuteCommand();
}
if (roledb == num.Length)
{
return(1);
}
}
return(0);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public bool add(User et)
{
//添加用户的时候对用户密码进行加密操作。
string userpassword = string.Empty;
string md5str = Common.SecurityHelper.MD5("000000", Encoding.UTF8);
userpassword = Common.SecurityHelper.Base64Encode(md5str);
et.isActivy = true;//添加用户默认是激活状态
et.password = userpassword;
return(userClent.Insert(et));
}
public async Task <T> AddAsync(T entity)
{
var test = new SimpleClient <T>(Db);
if (test.Insert(entity))
{
return(await Task.FromResult(entity));
}
else
{
return(null);
}
}
public T Add(T entity)
{
var test = new SimpleClient <T>(Db);
if (test.Insert(entity))
{
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新用户和角色表关系
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool SaveUserAndRole(User user)
{
var db = new SimpleClient(Db);
#region 使用事务
var result = Db.Ado.UseTran(() =>
{
user.LastErrTime = DateTime.Now;
user.UpdateTime = DateTime.Now;
db.Update(user);
var userRole = Db.Queryable <UserRole>().Where(a => a.UserId == user.Id).First();
if (userRole != null)
{
userRole.RoleId = user.RoleId;
userRole.ModifyTime = DateTime.Now;
db.Update(userRole);
}
else
{
var userRoleEntity = new UserRole
{
IsDelete = false,
UserId = user.Id,
RoleId = user.RoleId,
CreateTime = DateTime.Now,
ModifyTime = DateTime.Now
};
db.Insert(userRoleEntity);
}
});
#endregion
return(result.IsSuccess);
}
public bool Add(T entity)
{
return sdb.Insert(entity);
}
public bool add(Organization et)
{
return(Client.Insert(et));
}
public bool Insert(T entity)
{
return(sdb.Insert(entity));
}
public bool add(Menu et)
{
//TODO:添加
return(Client.Insert(et));
}
/// <summary>
/// 增加角色和用户关系
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public bool add(RoleUser et)
{
return(Client.Insert(et));
}
public bool Add(Student student)
{
return(sdb.Insert(student));
}
public bool Add(UserInfo entity)
{
return(sdb.Insert(entity));
}
public bool Insert(Venue venue)
{
return(rdb.Insert(venue));
}
public bool Add(RefereeApply entity)
{
return(rdb.Insert(entity));
}
/// <summary>
/// 等待考生考完试,添加考试所用的时间
/// </summary>
/// <param name="testTime"></param>
/// <returns></returns>
public int ADDTime(TestTime testTime)
{
var result = Convert.ToInt32(TestTimeDB.Insert(testTime));
return(result);
}
public bool Add(Club entity)
{
return(rdb.Insert(entity));
}
/// <summary>
/// 添加患者信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public new bool Add(pt_info entity)
{
return(pdb.Insert(entity));
}
public void Add(T model)
{
client.Insert((V)model);
}
public TEntity Add(TEntity entity)
{
var result = _dbSet.Insert(entity);
return(entity);
}
public bool Insert(Level level)
{
return(rdb.Insert(level));
}
/// <summary>
/// 增加组织关系表
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public bool add(OrganizationOrg organizationOrg)
{
return(Client.Insert(organizationOrg));
}
public bool Add(Star entity)
{
return(sdb.Insert(entity));
}
public bool add(Role et)
{
return roleClient.Insert(et);
}