public async Task <ResultObj <int> > Delete(int keyId) { ResultObj <int> reObj = new ResultObj <int>(); dbHelper.TranscationBegin(); try { await dbHelper.Exec("delete from sys_user_role where user_id = " + keyId); await dbHelper.Exec("DELETE sys_login FROM sys_login ,sys_user where sys_login.login_name=sys_user.login_name and sys_user.id=" + keyId); reObj.data = await dbHelper.Delete(i => i.id == keyId); reObj.success = reObj.data > 0; dbHelper.TranscationCommit(); } catch (Exception e) { reObj.success = false; reObj.msg = e.Message; dbHelper.TranscationRollback(); } return(reObj); }
public async Task <ResultObj <int> > Delete(int key) { ResultObj <int> reObj = new ResultObj <int>(); reObj.data = await dbHelper.Delete(i => i.id == key); reObj.success = reObj.data > 0; return(reObj); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <ResultObj <int> > Delete(int id) { var reObj = new ResultObj <int>(); reObj.data = await dbHelper.Delete(x => x.id == id); reObj.success = reObj.data > 0; return(reObj); }
public async Task <int> Delete(Expression <Func <SysQueryEntity, bool> > where) { return(await dal.Delete(where)); }