public IWsModel <ReqAddCorporation, ResCorporation> UpdateCorporation([FromBody] WsModel <ReqAddCorporation, ResCorporation> model)
{
if (model == null)
{
return(new WsModel <ReqAddCorporation, ResCorporation>().Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (model.Request == null)
{
return(model.Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (string.IsNullOrWhiteSpace(model.Request.CorporationId))
{
return(model.Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
var retCorporation = new DbsAccount().GetCorporationInfo(model.Request.CorporationId);
if (retCorporation == null)
{
return(model.Fail(ErrorCode.DB_NOTEXISTED, "数据不存在"));
}
if (AlterModel(ref retCorporation, model.Request))
{
var result = new DbaAccount().UpdateCorporation(retCorporation);
if (result == 0)
{
return(model.Fail(ErrorCode.DB_SAVE_FAILED, "修改失败"));
}
}
var ret = new ResCorporation(retCorporation);
return(model.Ok(ret));
}
public IWsModel <ReqAddCorporation, ResCorporation> AddCorporation([FromBody] WsModel <ReqAddCorporation, ResCorporation> model)
{
if (model == null)
{
return(new WsModel <ReqAddCorporation, ResCorporation>().Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (model.Request == null)
{
return(model.Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (!model.Request.Valid4AddCorporation())
{
return(model.Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (new DbsAccount().GetCorporationInfoByName(model.Request.Name) != null)
{
return(model.Fail(ErrorCode.DB_EXISTED, "数据已存在"));
}
var corporation = new Corporation(model.Request.Name, model.Request.Address, model.Request.Presentation, model.Request.FixPhone, model.Request.Image, ValidityState.Disabled, DateTime.Now);
var result = new DbaAccount().AddCorporation(corporation);
if (result == 0)
{
return(model.Fail(ErrorCode.DB_SAVE_FAILED, "添加失败"));
}
var ret = new ResCorporation(corporation);
return(model.Ok(ret));
}
/// <summary>
/// 根据用户openid获取公司信息（含个人信息）
/// </summary>
/// <param name="opendid"></param>
/// <param name="state"></param>
/// <returns></returns>
public ResCorporation GetCorporation(string openid, ValidityState state)
{
using (var dbs = WxDbFactory.GetDbContext("hch_dbs").MyDB)
{
ResCorporation ret = dbs.Single <ResCorporation>("SELECT ac.`Name`AS AccountName,ac.OpenId,ac.Phone,ac.Wechat,ac.WechatName,co.`Name` as CorporationName,co.Address,co.FixPhone,co.Id,co.Presentation,co.Image AS CorporationImage FROM"
+ " (SELECT Wechat, WechatName, OpenId, Phone,`Name`, Corporation FROM Account WHERE OpenId = @openid AND State=@state) AS ac"
+ " INNER JOIN Corporation AS co ON co.Id = ac.Corporation AND co.State=@state", new { openid = openid, state = state });
return(ret);
}
}
public IWsModel <ReqAccount, ResCorporation> CorporationInfo([FromBody] WsModel <ReqAccount, ResCorporation> model)
{
if (model == null)
{
return(new WsModel <ReqAccount, ResCorporation>().Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (model.Request == null)
{
return(model.Fail(ErrorCode.PARAM_NULL, "参数为空"));
}
if (string.IsNullOrWhiteSpace(model.Request.CorporationId))
{
return(model.Fail(ErrorCode.PARAM_NULL, "参数CorporationId为空"));
}
var cor = new DbsAccount().GetCorporationInfo(model.Request.CorporationId, ValidityState.Enabled);
if (cor == null)
{
return(model.Fail(ErrorCode.DB_NOTEXISTED, "公司不存在"));
}
var ret = new ResCorporation(cor);
return(model.Ok(ret));
}
