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 }));
}
}
public IActionResult ModifyCompany(T_QMDS_Company company)
{
try
{
_commercialRepository.ModifyCompany(company);
return(new JsonResult(new { result = 1, message = "修改商户成功！" }));
}
catch (Exception exc)
{
_log.Fatal($"修改商户失败：{exc.Message}");
return(new JsonResult(new { result = 0, message = "修改商户失败！" }));
}
}
/// <summary>
/// 修改公司
/// </summary>
/// <param name="company"></param>
/// <returns></returns>
public bool ModifyCompany(T_QMDS_Company company)
{
var sql = @"UPDATE T_QMDS_Company
SET CompanyName = @CompanyName ,
Phone = @Phone ,
WeiXinPay = @WeiXinPay ,
AliPay = @AliPay ,
License = @License ,
ModifierID = @ModifierID ,
ModifyTime = GETDATE()
WHERE ID=@ID" ;
return(_dapperPlusDB.Execute(sql, company) > 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();
}
}
}
