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); }