/// <summary>
/// 修改公司模板关系
/// </summary>
/// <param name="tQMDSCompanyTemplateRelation"></param>
/// <returns></returns>
public bool ModifyCompanyTemplateRelation(TQMDSCompanyTemplateRelation tQMDSCompanyTemplateRelation)
{
if (tQMDSCompanyTemplateRelation == null)
{
throw new Exception("公司模板关系不能为空");
}
var sql = @"UPDATE [dbo].[T_QMDS_CompanyTemplateRelation]
SET
,[TemplateID] = @TemplateID
,[ModifyTime] =GETDATE()
,[ModifierID] = @ModifierID
WHERE CompanyID=@companyID";
return(dapperPlusDB.Execute(sql, tQMDSCompanyTemplateRelation) > 0);
}
public IActionResult ModifyCompanyTemplate(TQMDSCompanyTemplateRelation tQMDSCompanyTemplateRelation)
{
try
{
var result = companyTemplateRepository.ModifyCompanyTemplateRelation(tQMDSCompanyTemplateRelation);
var ret = employeeTemplateRelationRepository.DeleteEmployeeTemplateRelationsByComponyID(tQMDSCompanyTemplateRelation.CompanyID, tQMDSCompanyTemplateRelation.TemplateID);
return(new JsonResult(new BackData <bool> {
Result = true
}));
}
catch (Exception exc)
{
return(new JsonResult(new BackData <bool> {
Result = false, ErrMeg = exc.Message
}));
}
}
/// <summary>
/// 添加公司打赏模板
/// </summary>
/// <param name="tQMDSCompanyTemplateRelation">公司打赏模板关系</param>
/// <returns></returns>
public bool AddCompanyTemplateRelation(TQMDSCompanyTemplateRelation tQMDSCompanyTemplateRelation)
{
if (tQMDSCompanyTemplateRelation == null)
{
throw new Exception("公司模板信息不能为空");
}
var sql = @"INSERT INTO [dbo].[T_QMDS_CompanyTemplateRelation]
([CompanyID]
,[TemplateID]
,[CreateTime]
,[CreaterID]
,[FValid])
VALUES
(@CompanyID
,@TemplateID
,GETDATE()
,@CreaterID
,1)";
return(dapperPlusDB.Execute(sql, tQMDSCompanyTemplateRelation) > 0);
}
