public PolicyRemarkApplyResponse PolicyRemarkApply(PolicyRemarkApplyRequest request)
{
PolicyRemarkApplyResponse response = new PolicyRemarkApplyResponse();
response.Success = false;
if (string.IsNullOrEmpty(request.PolicyRemark.Remark))
{
response.ErrMsg = "无效的备注信息。";
return(response);
}
if (request.PolicyRemark.ProviderId <= 0)
{
response.ErrMsg = "无效的供应商编号。";
return(response);
}
PolicyRemark rateRemark = new PolicyRemark();
rateRemark.ID = request.PolicyRemark.PolicyRemarkId;
rateRemark.AgentID = request.PolicyRemark.ProviderId;
rateRemark.Info = request.PolicyRemark.Remark;
rateRemark.RateType = request.PolicyRemark.PolicyType;
int result = JinRiRateFacade.PolicyRemarkSave(request.Operate, rateRemark);
response.Success = result > 0;
if (result == 0)
{
response.ErrMsg = "未知错误。";
}
return(response);
}
internal int AddPolicyRemark(PolicyRemark rateRemark)
{
const string sql = "INSERT INTO TblRateRemark(AgentID,Info,CreateTime,Status,RateType,ExtendInfo,TempletName) VALUES(@AgentID,@Info,GETDATE(),0,@RateType,@ExtendInfo,@TempletName)";
using (var conn = new SqlConnection(ConnectionString.JinRiRateDB_INSERT))
{
conn.Open();
return(conn.Execute(sql, rateRemark));
}
}
internal int UpdatePolicyRemark(PolicyRemark rateRemark)
{
const string sql = "UPDATE TblRateRemark SET Info=@Info,RateType=@RateType WHERE ID=@ID AND AgentID=@AgentID";
using (var conn = new SqlConnection(ConnectionString.JinRiRateDB_INSERT))
{
conn.Open();
return(conn.Execute(sql, rateRemark));
}
}
/// <summary>
/// 保存政策备注
/// </summary>
/// <param name="operateType"></param>
/// <param name="rateRemark"></param>
/// <returns></returns>
public int PolicyRemarkSave(OperateType operateType, PolicyRemark rateRemark)
{
int result = 0;
switch (operateType)
{
case OperateType.Add:
result = dbCMD.AddPolicyRemark(rateRemark);
break;
case OperateType.Modify:
result = dbCMD.UpdatePolicyRemark(rateRemark);
break;
default: break;
}
return(result);
}
