예제 #1
0
        public bool InsertIVRSatisfaction(Entities.IVRSatisfaction model, ref string msg)
        {
            if (model == null || (model != null && model.CallID == null))
            {
                msg = "参数IVRSatisfaction的Model为空"; return(false);
            }

            InsertIVRSatisfactionRecord(model);

            return(true);
        }
예제 #2
0
        public bool InsertIVRSatisfactionByHYUC(string NewCallID, string CallID, int score, ref string msg)
        {
            BLL.Loger.Log4Net.Info("[InsertIVRSatisfactionByHYUC]:IVR满意度数据插入开始,CallID:" + CallID + ",Score:" + score + ",NewCallID:" + NewCallID);
            bool flag = false;

            try
            {
                if (string.IsNullOrEmpty(NewCallID) || string.IsNullOrEmpty(CallID))
                {
                    msg = "参数NewCallID或CallID为空";
                }
                //根据青牛传过来的SessionID查话务总表拿到CallID
                Entities.IVRSatisfaction model = new Entities.IVRSatisfaction();
                Entities.CallRecord_ORIG orig  = new Entities.CallRecord_ORIG();
                orig = BLL.CallRecord_ORIG.Instance.GetCallRecord_ORIGBySessionID(NewCallID);
                if (orig == null)
                {
                    msg = "没有找到话务记录";
                    BLL.Loger.Log4Net.Info("[InsertIVRSatisfactionByHYUC]:没有找到话务记录,SessionID:" + NewCallID + ",Score:" + score);
                    return(flag);
                }

                Int64 _callid = 0;
                model.CallRecordID = Convert.ToInt64(orig.CallID);
                if (Int64.TryParse(CallID, out _callid))
                {
                    model.CallID     = _callid;
                    model.Score      = score;
                    model.CreateTime = DateTime.Now;
                    flag             = InsertIVRSatisfactionRecord(model) > 0 ? true : false;
                }
                else
                {
                    msg = "参数CallID,格式不正确,必须是Long类型的";
                }
            }
            catch (Exception ex)
            {
                BLL.Loger.Log4Net.Error("[InsertIVRSatisfactionByHYUC]新增满意度数据出错", ex); return(false);
            }
            if (!string.IsNullOrEmpty(msg))
            {
                BLL.Loger.Log4Net.Info("[InsertIVRSatisfactionByHYUC]新增满意度数据出错:" + msg);
            }

            BLL.Loger.Log4Net.Info("[InsertIVRSatisfactionByHYUC]:IVR满意度数据插入结束,CallID:" + CallID + ",Score:" + score);
            return(flag);
        }
예제 #3
0
        public bool InsertIVRSatisfactionByGenesys(string NewCallID, string CallID, int score, ref string msg)
        {
            BLL.Loger.Log4Net.Info("[InsertIVRSatisfactionByGenesys]:IVR满意度数据插入开始,CallID:" + CallID + ",Score:" + score + ",NewCallID:" + NewCallID);
            bool flag = false;

            try
            {
                if (string.IsNullOrEmpty(NewCallID) || string.IsNullOrEmpty(CallID))
                {
                    msg = "参数NewCallID或CallID为空";
                }

                Entities.IVRSatisfaction model = new Entities.IVRSatisfaction();
                Int64 _callid = 0;
                if (Int64.TryParse(NewCallID, out _callid))
                {
                    model.CallRecordID = _callid;
                    if (Int64.TryParse(CallID, out _callid))
                    {
                        model.CallID     = _callid;
                        model.Score      = score;
                        model.CreateTime = DateTime.Now;
                        flag             = InsertIVRSatisfactionRecord(model) > 0?true:false;
                    }
                    else
                    {
                        msg = "参数CallID,格式不正确,必须是Long类型的";
                    }
                }
                else
                {
                    msg = "参数NewCallID,格式不正确,必须是Long类型的";
                }
            }
            catch (Exception ex)
            {
                BLL.Loger.Log4Net.Error("[IVRSatifactionService.asmx]新增满意度数据出错", ex); return(false);
            }
            if (!string.IsNullOrEmpty(msg))
            {
                BLL.Loger.Log4Net.Info("[IVRSatifactionService.asmx]新增满意度数据出错:" + msg);
            }

            BLL.Loger.Log4Net.Info("[InsertIVRSatisfactionByGenesys]:IVR满意度数据插入结束,CallID:" + CallID + ",Score:" + score);
            return(flag);
        }
예제 #4
0
        ///  增加一条满意度数据
        /// <summary>
        ///  增加一条满意度数据
        /// </summary>
        public int Insert(Entities.IVRSatisfaction model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@RecID",        SqlDbType.BigInt, 8),
                new SqlParameter("@CallID",       SqlDbType.BigInt, 8),
                new SqlParameter("@CallRecordID", SqlDbType.BigInt, 8),
                new SqlParameter("@Score",        SqlDbType.Int,    4),
                new SqlParameter("@CreateTime",   SqlDbType.DateTime)
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.CallID;
            parameters[2].Value     = model.CallRecordID;
            parameters[3].Value     = model.Score;
            parameters[4].Value     = model.CreateTime;

            SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_IVRSATISFACTION_INSERT, parameters);
            return(int.Parse(parameters[0].Value.ToString()));
        }
예제 #5
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Insert(Entities.IVRSatisfaction model)
 {
     return(Dal.IVRSatisfaction.Instance.Insert(model));
 }
예제 #6
0
 private int InsertIVRSatisfactionRecord(Entities.IVRSatisfaction model)
 {
     return(BitAuto.ISDC.CC2012.BLL.IVRSatisfaction.Instance.Insert(model));
 }