private Entities.QS_Result LoadSingleQS_Result(DataRow row)
{
Entities.QS_Result model = new Entities.QS_Result();
if (row["QS_RID"].ToString() != "")
{
model.QS_RID = int.Parse(row["QS_RID"].ToString());
}
if (row["CallReCordID"].ToString() != "")
{
model.CallReCordID = Int64.Parse(row["CallReCordID"].ToString());
}
if (row["QS_RTID"].ToString() != "")
{
model.QS_RTID = int.Parse(row["QS_RTID"].ToString());
}
model.SeatID = row["SeatID"].ToString();
if (row["ScoreType"].ToString() != "")
{
model.ScoreType = int.Parse(row["ScoreType"].ToString());
}
if (row["Score"].ToString() != "")
{
model.Score = decimal.Parse(row["Score"].ToString());
}
if (row["IsQualified"].ToString() != "")
{
model.IsQualified = int.Parse(row["IsQualified"].ToString());
}
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["StateResult"].ToString() != "")
{
model.StateResult = int.Parse(row["StateResult"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
if (row["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
}
if (row["ModifyUserID"].ToString() != "")
{
model.ModifyUserID = int.Parse(row["ModifyUserID"].ToString());
}
if (row["CallID"].ToString() != "")
{
model.CallID = Int64.Parse(row["CallID"].ToString());
}
model.QualityAppraisal = row["QualityAppraisal"].ToString();
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(QS_RID))
{
int intiy = 0;
if (int.TryParse(QS_RID, out intiy))
{
Entities.QS_Result model = BLL.QS_Result.Instance.GetQS_Result(intiy);
if (model != null)
{
Entities.QS_RulesTable QS_RulesTableModel = BLL.QS_RulesTable.Instance.GetQS_RulesTable(model.QS_RTID);
if (QS_RulesTableModel != null)
{
TableName = QS_RulesTableModel.Name;
if (QS_RulesTableModel.ScoreType == 2)
{
TableName += "（致命项数" + QS_RulesTableModel.DeadItemNum + ",非致命项数" + QS_RulesTableModel.NoDeadItemNum + "）";
}
}
this.QualityStandardViewID.QS_RTID = model.QS_RTID;
this.QualityStandardViewID.QS_RID = model.QS_RID;
UCCallRecordView1.QS_RID = model.QS_RID;
UCCallRecordView1.CallID = model.CallID;
QualityStandardViewID.PageFrom = PageFrom;
UCCallRecordView1.tableEndName = tableEndName;
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('评分成绩不存在！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('评分成绩主键数据格式不正确！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('请求参数错误！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
}
/// 审核保存
/// <summary>
/// 审核保存
/// </summary>
/// <param name="userID"></param>
/// <param name="sInfoData"></param>
/// <param name="status"></param>
/// <returns></returns>
public override int AuditSave(int userID, QS_ResultData sInfoData, QSResultStatus status)
{
Entities.QS_Result model = null;
model = BLL.QS_Result.Instance.GetQS_Result(Convert.ToInt32(sInfoData.QS_RID));
model.ModifyTime = System.DateTime.Now;
model.ModifyUserID = userID;
model.ScoreType = Convert.ToInt32(sInfoData.ScoreType);
model.Status = (Int32)status;
model.StateResult = 1;
BLL.QS_Result.Instance.Update(model);
return(model.QS_RID);
}
/// 维护成绩表
/// <summary>
/// 维护成绩表
/// </summary>
/// <param name="sInfoData"></param>
/// <param name="userID"></param>
/// <param name="QS_RTID"></param>
/// <param name="status"></param>
/// <returns></returns>
private int InsertOrUpdateResult(QS_ResultData sInfoData, int userID, out int QS_RTID, QSResultStatus status, string tableEndName)
{
Entities.QS_Result model = null;
//由于易湃外呼业务签入cc系统，易湃不入库CallRecordInfo表，所以此处改成从CallRecord_ORIG_Business取录音创建坐席 modify by qizq 2014-4-17
Entities.CallRecord_ORIG_Business callModel = BLL.CallRecord_ORIG_Business.Instance.GetByCallID(Convert.ToInt64(sInfoData.CallID), tableEndName);
//说明是初次
if (sInfoData.QS_RID == "0")
{
if (status == QSResultStatus.Submitted)
{
if (BLL.QS_Result.Instance.HasScored(sInfoData.CallID))
{
// "此话务已评分过分了，不能再次评分！";
QS_RTID = 0;
return(-9999);
}
}
model = new Entities.QS_Result();
model.CallReCordID = Convert.ToInt64(sInfoData.CallID);
model.CallID = Convert.ToInt64(sInfoData.CallID);
model.QS_RTID = Convert.ToInt32(sInfoData.QS_RTID);
model.SeatID = callModel.CreateUserID.ToString();
model.ScoreType = Convert.ToInt32(sInfoData.ScoreType);
model.CreateTime = System.DateTime.Now;
model.CreateUserID = userID;
model.QualityAppraisal = sInfoData.QualityAppraisal;
model.Status = (Int32)status;
model.QS_RID = BLL.QS_Result.Instance.Insert(model, tableEndName);
if (model.QS_RID == -9999)
{
// "此话务已评分过分了，不能再次评分！";
QS_RTID = 0;
return(-9999);
}
}
//再次保存
else
{
model = BLL.QS_Result.Instance.GetQS_Result(Convert.ToInt32(sInfoData.QS_RID));
model.QualityAppraisal = sInfoData.QualityAppraisal;
model.ModifyTime = System.DateTime.Now;
model.ModifyUserID = userID;
model.ScoreType = Convert.ToInt32(sInfoData.ScoreType);
model.Status = (Int32)status;
BLL.QS_Result.Instance.Update(model);
}
//返回结果
QS_RTID = model.QS_RTID;
return(model.QS_RID);
}
/// 增加一条数据
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.QS_Result model, string tableEndName)
{
//校验
var old = Dal.QS_Result.Instance.GetQS_Result(model.CallReCordID);
if (old != null)
{
// "此话务已评分过分了，不能再次评分！";
return(-9999);
}
else
{
return(Dal.QS_Result.Instance.Insert(model, tableEndName));
}
}
public void Dispose(Entities.QSResultStatus status, Entities.QSApprovalType type, bool IsReject, out string msg)
{
msg = string.Empty;
int rid = 0;
if (int.TryParse(RequestQS_RID, out rid))
{
Entities.QS_Result info = BLL.QS_Result.Instance.GetQS_Result(rid);
if (info != null)
{
int userId = BLL.Util.GetLoginUserID();
info.Status = (int)status;
info.ModifyTime = DateTime.Now;
info.ModifyUserID = userId;
Entities.QS_ApprovalHistory model = new QS_ApprovalHistory();
model.CreateTime = DateTime.Now;
model.CreateUserID = userId;
model.QS_RID = rid;
model.QS_RTID = info.QS_RTID;
model.Remark = RequestRemark;
model.Status = (int)status;
model.ApprovalType = ((int)type).ToString();
if (type != QSApprovalType.ScoreAppeal)
{
if (IsReject)
{
model.ApprovalResult = 2;
info.StateResult = 2;
}
else
{
model.ApprovalResult = 1;
info.StateResult = 1;
}
}
model.Type = "1";
BLL.QS_Result.Instance.Update(info);
BLL.QS_ApprovalHistory.Instance.Insert(model);
msg = "success";
}
else
{
msg = "不存在此评分";
}
}
}
/// 保存成绩
/// <summary>
/// 保存成绩
/// </summary>
/// <param name="sInfoData"></param>
/// <param name="HaveDead"></param>
/// <param name="QS_RID"></param>
public override void SaveScoreResult(QS_ResultData sInfoData, bool HaveDead, int QS_RID)
{
//取成绩实体
Entities.QS_Result model = BLL.QS_Result.Instance.GetQS_Result(QS_RID);
//计算成绩
decimal?Score;
int? IsQualified;
CalcResult(sInfoData, HaveDead, model.QS_RID, model.QS_RTID, model.ScoreType, out Score, out IsQualified);
model.Score = Score;
model.IsQualified = IsQualified;
model.ModifyTime = DateTime.Now;
model.ModifyUserID = BLL.Util.GetLoginUserID();
//保存
BLL.QS_Result.Instance.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.QS_Result model)
{
SqlParameter[] parameters =
{
new SqlParameter("@QS_RID", SqlDbType.Int, 4),
new SqlParameter("@CallReCordID", SqlDbType.BigInt, 8),
new SqlParameter("@QS_RTID", SqlDbType.Int, 4),
new SqlParameter("@SeatID", SqlDbType.VarChar, 50),
new SqlParameter("@ScoreType", SqlDbType.Int, 4),
new SqlParameter("@Score", SqlDbType.Decimal),
new SqlParameter("@IsQualified", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@StateResult", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@QualityAppraisal", SqlDbType.VarChar, 2000),new SqlParameter("@CallID",SqlDbType.BigInt, 8)
};
parameters[0].Value = model.QS_RID;
parameters[1].Value = model.CallID;
parameters[2].Value = model.QS_RTID;
parameters[3].Value = model.SeatID;
parameters[4].Value = model.ScoreType;
parameters[5].Value = model.Score;
parameters[6].Value = model.IsQualified;
parameters[7].Value = model.Status;
parameters[8].Value = model.StateResult;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.CreateUserID;
parameters[11].Value = model.ModifyTime;
parameters[12].Value = model.ModifyUserID;
parameters[13].Value = model.QualityAppraisal;
parameters[14].Value = model.CallID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_QS_RESULT_UPDATE, parameters));
}
private void VerifyData()
{
string sysId = ConfigurationUtil.GetAppSettingValue("ThisSysID");
int userId = BLL.Util.GetLoginUserID();
FirstTrialButton = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.CheckRight("SYS024BUT600102", sysId, userId);
RecheckButton = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.CheckRight("SYS024BUT600103", sysId, userId);
AppealButton = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.CheckRight("SYS024BUT600106", sysId, userId);
int rid = 0;
if (int.TryParse(RequestQS_RID, out rid))
{
Entities.QS_Result info = BLL.QS_Result.Instance.GetQS_Result(rid);
if (info != null)
{
//由于易湃外呼业务签入cc系统，易湃不入库CallRecordInfo表，所以此处改成从CallRecord_ORIG_Business取录音创建坐席 modify by qizq 2014-4-17
Entities.CallRecord_ORIG_Business callRecordInfo = BLL.CallRecord_ORIG_Business.Instance.GetByCallID(Convert.ToInt64(info.CallID), tableEndName);
//Entities.CallRecordInfo callRecordInfo = BLL.CallRecordInfo.Instance.GetCallRecordInfoByCallID(info.CallID);
if (callRecordInfo != null)
{
//判断单据状态，如果不是待复审，不能复审
Entities.QS_RulesTable QS_RulesTableModel = BLL.QS_RulesTable.Instance.GetQS_RulesTable(info.QS_RTID);
if (QS_RulesTableModel != null)
{
TableName = QS_RulesTableModel.Name;
if (QS_RulesTableModel.ScoreType == 2)
{
TableName += "（致命项数" + QS_RulesTableModel.DeadItemNum + ",非致命项数" + QS_RulesTableModel.NoDeadItemNum + "）";
}
}
//如果具有申诉权限，并且当前人不是此录音的创建人员，关闭此页面
if (AppealButton && callRecordInfo.CreateUserID != BLL.Util.GetLoginUserID() & !RecheckButton & !AppealButton)
{
Response.Write(@"<script language='javascript'>alert('您没有权限查看此评分！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
//如果不是本人录音，申诉按钮不显示
if (AppealButton && callRecordInfo.CreateUserID != BLL.Util.GetLoginUserID())
{
AppealButton = false;
}
this.ucCallRecordView.QS_RID = info.QS_RID;
this.ucCallRecordView.CallID = info.CallID;
this.ucCallRecordView.tableEndName = tableEndName;
}
Status = info.Status.ToString();
switch (Status)
{
case "20003":
Title = "录音质检成绩初审";
this.UCScoreTableView.QS_RID = info.QS_RID;
this.UCScoreTableView.QS_RTID = info.QS_RTID;
break;
case "20004":
Title = "录音质检成绩复审";
this.ucTableDispose.CallID = info.CallID;
this.ucTableDispose.QS_RID = info.QS_RID;
this.ucTableDispose.QS_RTID = info.QS_RTID;
break;
default:
Title = "录音质检成绩查看";
this.UCScoreTableView.QS_RID = info.QS_RID;
this.UCScoreTableView.QS_RTID = info.QS_RTID;
break;
}
}
else
{
Response.Write(@"<script language='javascript'>alert('不存在此评分！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self',''); window.close();
};</script>");
}
}
else
{
Response.Write(@"<script language='javascript'>alert('参数有误！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self',''); window.close();
};</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int userId = BLL.Util.GetLoginUserID();
if (!BLL.Util.CheckRight(userId, "SYS024BUT600104"))
{
Response.Write(BLL.Util.GetNotAccessMsgPage("您没有访问该页面的权限"));
Response.End();
}
if (QS_RTID != 0 && CallID != 0)
{
if (QS_RID <= 0)
{
QS_RID = BLL.QS_Result.Instance.GetRidByCallidAndRtid(QS_RTID, CallID);
}
Entities.QS_RulesTable tablemodel = BLL.QS_RulesTable.Instance.GetQS_RulesTable(QS_RTID);
//由于易湃外呼业务录音不入CC的CallRecordInfo表，所以取CallRecord_ORIG_Business来判断录音是否存在 modify by qizq 2014-4-17
//Entities.CallRecordInfo callmodel = BLL.CallRecordInfo.Instance.GetCallRecordInfoByCallID(CallID);
Entities.CallRecord_ORIG_Business callmodel = BLL.CallRecord_ORIG_Business.Instance.GetByCallID(CallID, tableEndName);
if (tablemodel != null && callmodel != null)
{
TableName = tablemodel.Name;
if (tablemodel.ScoreType == 2)
{
TableName += "（致命项数" + tablemodel.DeadItemNum + "，非致命项数" + tablemodel.NoDeadItemNum + "）";
}
bool flag = true;
if (QS_RID != 0)
{
Entities.QS_Result modelQS_Result = BLL.QS_Result.Instance.GetQS_Result(QS_RID);
if (modelQS_Result != null && modelQS_Result.Status == (Int32)Entities.QSResultStatus.WaitScore)
{
}
else
{
flag = false;
}
}
if (flag)
{
QualityStandardEditID.QS_RTID = QS_RTID;
QualityStandardEditID.QS_RID = QS_RID;
QualityStandardEditID.CallID = CallID;
UCCallRecordView1.QS_RID = QS_RID;
UCCallRecordView1.CallID = CallID;
UCCallRecordView1.tableEndName = tableEndName;
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('当前评分成绩不是待评分状态！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('评分表不存在或录音不存在！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('页面请求参数不正确！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.QS_Result model)
{
return(Dal.QS_Result.Instance.Update(model));
}
private void BindData()
{
#region 成绩结果
if (QS_RID != 0)
{
Entities.QS_Result model = BLL.QS_Result.Instance.GetQS_Result(QS_RID);
if (model != null)
{
if (model.ScoreType == 1 || model.ScoreType == 3)
{
tdScore.InnerText = model.Score.ToString().Replace(".0", "") + "分";
}
else
{
tdScore.InnerText = model.IsQualified == 1 ? "合格" : "不合格";
}
if (model.Status != (int)QSResultStatus.WaitScore)
{
this.tdScore.Visible = true;
}
}
}
#endregion
#region 录音
Entities.CallRecord_ORIG origM = BLL.CallRecord_ORIG.Instance.GetCallRecord_ORIGByCallID(CallID, tableEndName);
Entities.CallRecord_ORIG_Business businessM = BLL.CallRecord_ORIG_Business.Instance.GetByCallID(CallID, tableEndName);
if (origM != null && businessM != null)
{
this.spCallID.InnerText = origM.CallID.ToString();
this.spLiuShui.InnerHtml = string.Format("<a href='/KnowledgeLib/Personalization/DownLoadFilePage.aspx?theAction=1&theUrl={1}'>{0}</a>", origM.SessionID, HttpUtility.UrlEncode(origM.AudioURL));
this.spUserName.InnerText = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName((int)businessM.CreateUserID);
this.spBeginTime.InnerText = origM.EstablishedTime.ToString();
this.spTimeLong.InnerText = origM.TallTime.ToString();
this.spCallType.InnerText = BitAuto.ISDC.CC2012.BLL.Util.GetCallStatus(origM.CallStatus.Value.ToString());
FileUrl = origM.AudioURL;
this.spTaskID.InnerText = businessM.BusinessID;
//分类名称
Entities.SurveyCategory ScMode = BLL.SurveyCategory.Instance.GetSurveyCategory((int)businessM.SCID);
if (ScMode != null)
{
this.spSCName.InnerText = ScMode.Name;
}
//链接
string url = BLL.CallRecord_ORIG_Business.Instance.GetTaskUrl(businessM.BusinessID, businessM.BGID.ToString(), businessM.SCID.ToString());
url = BLL.CallRecord_ORIG_Business.Instance.GetViewUrl(businessM.BusinessID, url);
this.spTaskID.InnerHtml = BLL.Util.GenBusinessURLByBGIDAndSCID(businessM.BGID.ToString(), businessM.SCID.ToString(), url, businessM.BusinessID, YPFanXianHBuyCarURL, EPEmbedCCHBuyCar_APPID);
}
//满意度加载
int ivrscore = BLL.IVRSatisfaction.Instance.GetIVRScoreBYCallID(CallID, tableEndName);
string strScore = "";
switch (ivrscore)
{
case 0:
strScore = "未评价";
break;
case 1:
strScore = "满意";
break;
case 2:
strScore = "对问题处理结果不满意";
break;
case 3:
strScore = "对客服代表服务不满意";
break;
case 10:
strScore = "已解决,未评价";
break;
case 11:
strScore = "已解决,满意";
break;
case 12:
strScore = "已解决,对处理结果不满意";
break;
case 13:
strScore = "已解决,对客服代表服务不满意";
break;
case 20:
strScore = "未解决,未评价";
break;
case 21:
strScore = "未解决,满意";
break;
case 22:
strScore = "未解决,对处理结果不满意";
break;
case 23:
strScore = "未解决,对客服代表服务不满意";
break;
default:
break;
}
spIVRScore.InnerText = strScore;
#endregion
}
/// 增加一条数据
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.QS_Result model, string tableEndName)
{
//复制话务数据到质检话务冗余表
string sql1 = @"INSERT INTO CallRecord_ORIG_QS
( [RecID] , [SessionID] , [CallID] , [ExtensionNum] , [PhoneNum] , [ANI] ,
[CallStatus] , [SwitchINNum] , [OutBoundType] , [SkillGroup] , [InitiatedTime] , [RingingTime] ,
[EstablishedTime] , [AgentReleaseTime] , [CustomerReleaseTime] , [AfterWorkBeginTime] , [AfterWorkTime] ,
[ConsultTime] , [ReconnectCall] , [TallTime] , [AudioURL] , [CreateTime] , [CreateUserID] ,
[TransferInTime] , [TransferOutTime]
)
SELECT [RecID] ,[SessionID] ,[CallID] ,[ExtensionNum] ,[PhoneNum] ,[ANI] ,
[CallStatus] ,[SwitchINNum] ,[OutBoundType] ,[SkillGroup] ,[InitiatedTime] ,[RingingTime] ,
[EstablishedTime] ,[AgentReleaseTime] ,[CustomerReleaseTime] ,[AfterWorkBeginTime] , [AfterWorkTime] ,
[ConsultTime] ,[ReconnectCall] ,[TallTime] ,[AudioURL] , [CreateTime] ,[CreateUserID] ,
[TransferInTime] ,[TransferOutTime]
FROM CallRecord_ORIG" + tableEndName + @"
WHERE CallID = '" + model.CallReCordID + @"'
AND [RecID] NOT IN (SELECT RecID FROM CallRecord_ORIG_QS)";
string sql2 = @" INSERT INTO CallRecord_ORIG_Business_QS
( [RecID] ,[CallID] ,[BGID] ,[SCID] ,[BusinessID] ,[CreateUserID] ,[CreateTime] ,[BFTaskID])
SELECT [RecID] ,[CallID] ,[BGID] ,[SCID] ,[BusinessID] ,[CreateUserID] ,[CreateTime] ,[BFTaskID]
FROM CallRecord_ORIG_Business" + tableEndName + @"
WHERE CallID = '" + model.CallReCordID + @"'
AND [RecID] NOT IN (SELECT RecID FROM CallRecord_ORIG_Business_QS)";
string sql3 = @"INSERT INTO IVRSatisfaction_QS
([Oid] ,[CallID] ,[CallRecordID] ,[Score] ,[CreateTime])
SELECT [Oid] ,[CallID] ,[CallRecordID] ,[Score] ,[CreateTime]
FROM IVRSatisfaction" + tableEndName + @"
WHERE CallID = '" + model.CallReCordID + @"'
AND [Oid] NOT IN (SELECT Oid FROM IVRSatisfaction_QS)";
int j = 0;
j += SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.Text, sql1);
j += SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.Text, sql2);
j += SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.Text, sql3);
SqlParameter[] parameters =
{
new SqlParameter("@QS_RID", SqlDbType.Int, 4),
new SqlParameter("@CallReCordID", SqlDbType.BigInt, 8),
new SqlParameter("@QS_RTID", SqlDbType.Int, 4),
new SqlParameter("@SeatID", SqlDbType.VarChar, 50),
new SqlParameter("@ScoreType", SqlDbType.Int, 4),
new SqlParameter("@Score", SqlDbType.Int, 4),
new SqlParameter("@IsQualified", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@StateResult", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@ModifyUserID", SqlDbType.Int, 4),
new SqlParameter("@QualityAppraisal", SqlDbType.VarChar, 2000),
new SqlParameter("@CallID", SqlDbType.BigInt, 8),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.CallReCordID;
parameters[2].Value = model.QS_RTID;
parameters[3].Value = model.SeatID;
parameters[4].Value = model.ScoreType;
parameters[5].Value = model.Score;
parameters[6].Value = model.IsQualified;
parameters[7].Value = model.Status;
parameters[8].Value = model.StateResult;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.CreateUserID;
parameters[11].Value = model.ModifyTime;
parameters[12].Value = model.ModifyUserID;
parameters[13].Value = model.QualityAppraisal;
parameters[14].Value = model.CallID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_QS_RESULT_INSERT, parameters);
int id = (int)parameters[0].Value;
return(id);
}
