public IActionResult AddRegister(T_QMDS_Company company, T_QMDS_GroupCompany groupCompany, string username, string password) { try { if (_commercialRepository.CheckUser(username)) { return(new JsonResult(new { result = 2, message = "用户名已存在!" })); } if (groupCompany.GCName != null) { groupCompany.ID = _commercialRepository.ProduceID(1); company.GCID = groupCompany.ID; } company.ID = _commercialRepository.ProduceID(2); company.CreaterID = company.ID; var flag = _commercialRepository.Register(company, groupCompany, username, password); if (flag) { return(new JsonResult(new { result = 1, message = "注册成功!" })); } else { return(new JsonResult(new { result = 0, message = "注册失败!" })); } } catch (Exception exc) { _log.Fatal($"注册失败:错误信息{exc.Message}"); return(new JsonResult(new { result = -1, messge = exc.Message })); } }
/// <summary> /// 修改集团 /// </summary> /// <param name="groupCompany"></param> /// <returns></returns> public bool ModifyGroupCompany(T_QMDS_GroupCompany groupCompany) { var sql = @"UPDATE T_QMDS_GroupCompany SET GCName = @GCName , ModifierID = @ModifierID , ModifyTime = GETDATE() WHERE ID=@ID" ; return(_dapperPlusDB.Execute(sql, groupCompany) > 0); }
/// <summary> /// 添加集团 /// </summary> /// <param name="GroupCompany">集团</param> /// <returns></returns> public bool AddGroupCompany(T_QMDS_GroupCompany GroupCompany) { var sql = @"INSERT INTO dbo.T_QMDS_GroupCompany ( GCName , CreaterID , CreateTime ) VALUES ( @GCName , @CreaterID , GETDATE() )"; return(_dapperPlusDB.Execute(sql, GroupCompany) > 0); }
/// <summary> /// 注册 /// </summary> /// <param name="company"></param> /// <param name="groupCompany"></param> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public bool Register(T_QMDS_Company company, T_QMDS_GroupCompany groupCompany, string username, string password) { #region sql语句 var sql1 = @" INSERT INTO dbo.T_QMDS_GroupCompany (ID, GCName, CreaterID, CreateTime ) VALUES (@ID, @GCName, @CreaterID, GETDATE() )"; var sql2 = @"INSERT INTO dbo.T_QMDS_Company ( ID, GCID, CompanyName , Phone , WeiXinPay , AliPay , License , CreaterID , CreateTime ) VALUES ( @ID, @GCID, @CompanyName , @Phone , @WeiXinPay , @AliPay , @License , @CreaterID , GETDATE() )"; var sql3 = @" INSERT INTO dbo.T_QMDS_User ( CompanyID, UserName, [PassWord] ) VALUES ( @CompanyID, @UserName, @PassWord )"; #endregion IDbTransaction transaction = null; IDbConnection conn = null; try { conn = _dapperPlusDB.GetConnection(); conn.Open(); transaction = conn.BeginTransaction(); _dapperPlusDB.Execute(sql2, company, transaction); _dapperPlusDB.Execute(sql3, new { CompanyID = company.ID, UserName = username, PassWord = password }, transaction); if (groupCompany.GCName != null) { _dapperPlusDB.Execute(sql1, groupCompany, transaction); } transaction.Commit(); return(true); } catch (Exception exc) { if (transaction != null) { transaction.Rollback(); } throw new Exception(exc.Message); } finally { if (conn != null) { conn.Close(); } } }