/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
DialerInfoCampaignModel dialerinfocampaign = new DialerInfoCampaignModel();
ret = DbUtil.Current.DeleteMultiple(dialerinfocampaign, pc);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <returns>影响的记录行数</returns>
public int Delete()
{
int ret = 0;
DialerInfoCampaignModel dialerinfocampaign = new DialerInfoCampaignModel();
ret = DbUtil.Current.Delete(dialerinfocampaign);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dialerinfocampaign">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(DialerInfoCampaignModel dialerinfocampaign, ParameterCollection pc)
{
int ret = 0;
dialerinfocampaign.ModifiedBy = SessionUtil.Current.UserId;
dialerinfocampaign.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(dialerinfocampaign, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dialerinfocampaign">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(DialerInfoCampaignModel dialerinfocampaign)
{
int ret = 0;
dialerinfocampaign.ModifiedBy = SessionUtil.Current.UserId;
dialerinfocampaign.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(dialerinfocampaign);
return(ret);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <returns>实体</returns>
public DialerInfoCampaignModel Retrieve()
{
DialerInfoCampaignModel dialerinfocampaign = new DialerInfoCampaignModel();
DataTable dt = DbUtil.Current.Retrieve(dialerinfocampaign);
if (dt.Rows.Count < 1)
{
return(null);
}
dialerinfocampaign.ConvertFrom(dt);
return(dialerinfocampaign);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <DialerInfoCampaignModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <DialerInfoCampaignModel> dialerinfocampaigns = new List <DialerInfoCampaignModel>();
DialerInfoCampaignModel dialerinfocampaign = new DialerInfoCampaignModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(dialerinfocampaign, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
dialerinfocampaign = new DialerInfoCampaignModel();
dialerinfocampaign.ConvertFrom(dt, i);
dialerinfocampaigns.Add(dialerinfocampaign);
}
return(dialerinfocampaigns);
}
/// <summary>
/// 更新自动外呼策略信息。
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool UpdateAutoDialerCampaign(DialerInfoCampaignModel info)
{
bool result = false;
try
{
DbUtil.IVRDBManager.BeginTransaction();
string sql = @"
UPDATE
[Dialer_Info_Campaign]
SET
TIMES = $Times$,
INTERVAL = $Interval$,
MaxPorts = $Maxports$
WHERE
CampaignID = 1
";
ParameterCollection pc = new ParameterCollection();
pc.Add("Times", info.Times);
pc.Add("Interval", info.Interval);
pc.Add("Maxports", info.Maxports);
if (DbUtil.IVRDBManager.IData.ExecuteNonQuery(sql, pc) > 0)
{
DbUtil.IVRDBManager.CommitTransaction();
result = true;
}
else
{
DbUtil.IVRDBManager.RollbackTransaction();
}
}
catch (Exception ex)
{
DbUtil.IVRDBManager.RollbackTransaction();
LogUtil.Error("更新IVR系统自动外呼策略异常", ex);
throw ex;
}
return(result);
}
/// <summary>
/// 获取自动外呼策略信息。
/// </summary>
/// <returns></returns>
public DialerInfoCampaignModel GetIVRServerDialerCampaignInfo()
{
string sql = @"
SELECT [CampaignID]
,[CampaignName]
,[CampaignCmt]
,[TIMES]
,[INTERVAL]
,[AcdType]
,[RoutePoint]
,[MaxPorts]
,[MaxTimeOut]
FROM
[Dialer_Info_Campaign]
WHERE
CampaignID = 1";
DialerInfoCampaignModel result = null;
DataTable dt = DbUtil.IVRDBManager.IData.ExecuteDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
result = new DialerInfoCampaignModel();
result.Campaignid = Convert.ToInt32(dt.Rows[0]["CampaignID"]);
result.Campaignname = dt.Rows[0]["CampaignName"].ToString();
result.Campaigncmt = dt.Rows[0]["CampaignCmt"].ToString();
result.Times = Convert.ToInt32(dt.Rows[0]["TIMES"]);
result.Interval = Convert.ToInt32(dt.Rows[0]["INTERVAL"]);
result.Acdtype = Convert.ToInt32(dt.Rows[0]["AcdType"]);
result.Routepoint = dt.Rows[0]["RoutePoint"].ToString();
result.Maxports = Convert.ToInt32(dt.Rows[0]["MaxPorts"]);
result.Maxtimeout = Convert.ToInt32(dt.Rows[0]["MaxTimeOut"]);
}
return(result);
}
