/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.WorkOrderTagMapping model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@OrderID", SqlDbType.VarChar, 20),
new SqlParameter("@TagID", SqlDbType.Int, 4),
new SqlParameter("@Status", 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)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.OrderID;
parameters[2].Value = model.TagID;
parameters[3].Value = model.Status;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.ModifyTime;
parameters[7].Value = model.ModifyUserID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_WORKORDERTAGMAPPING_INSERT, parameters);
return((int)parameters[0].Value);
}
private Entities.WorkOrderTagMapping LoadSingleWorkOrderTagMapping(DataRow row)
{
Entities.WorkOrderTagMapping model = new Entities.WorkOrderTagMapping();
if (row["RecID"].ToString() != "")
{
model.RecID = int.Parse(row["RecID"].ToString());
}
model.OrderID = row["OrderID"].ToString();
if (row["TagID"].ToString() != "")
{
model.TagID = int.Parse(row["TagID"].ToString());
}
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].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());
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.WorkOrderTagMapping model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 4),
new SqlParameter("@OrderID", SqlDbType.VarChar, 20),
new SqlParameter("@TagID", SqlDbType.Int, 4),
new SqlParameter("@Status", 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)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.OrderID;
parameters[2].Value = model.TagID;
parameters[3].Value = model.Status;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.ModifyTime;
parameters[7].Value = model.ModifyUserID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_WORKORDERTAGMAPPING_UPDATE, parameters));
}
private void PersonalSubmit(out string msg)
{
msg = string.Empty;
try
{
BLL.Loger.Log4Net.Info("【个人工单提交Step1——数据验证】");
#region 验证
validate(out msg);
if (msg != string.Empty)
{
msg = "{'result':'false','msg':'" + msg + "'}";
return;
}
#endregion
#region 插入工单表
Entities.WorkOrderInfo model_WorkOrderInfo = bindWorkOrderInfo(out msg);
if (msg != string.Empty)
{
return;
}
//个人类型增加工单，状态默认-已完成
model_WorkOrderInfo.WorkOrderStatus = (int)Entities.WorkOrderStatus.Completed;
model_WorkOrderInfo.WorkCategory = 1;//工单类型-个人；add lxw 13.9.11
BLL.Loger.Log4Net.Info("【个人工单提交Step2——添加工单开始】");
model_WorkOrderInfo.OrderID = BLL.WorkOrderInfo.Instance.Insert(model_WorkOrderInfo);
BLL.Loger.Log4Net.Info("【个人工单提交Step2——添加工单结束】OrderID=" + model_WorkOrderInfo.OrderID);
//回写IM库
BLL.Loger.Log4Net.Info("【个人工单提交Step3——工单数据回写IM开始】");
UpdateCCWorkOrder2IM(model_WorkOrderInfo);
BLL.Loger.Log4Net.Info("【个人工单提交Step3——工单数据回写IM结束】");
#endregion
//如果有推荐活动，插入WorkOrderActivity表，add lxw 13.1.14
#region 插入推荐活动
if (ActivityIDs != "")
{
string[] aIDs = ActivityIDs.Split(',');
for (int i = 0; i < aIDs.Length; i++)
{
Entities.WorkOrderActivity model_Activity = new Entities.WorkOrderActivity();
model_Activity.ActivityGUID = new Guid(aIDs[i]);
model_Activity.OrderID = model_WorkOrderInfo.OrderID;
model_Activity.CreateTime = operTime;
model_Activity.CreateUserID = operUserID;
BLL.Loger.Log4Net.Info("【个人工单提交Step4——WorkOrderActivity数据入库开始】");
BLL.WorkOrderActivity.Instance.Insert(model_Activity);
BLL.Loger.Log4Net.Info("【个人工单提交Step4——WorkOrderActivity数据入库结束】");
}
}
#endregion
#region 插入工单回复表
Entities.WorkOrderRevert model_Revert = bindWorkOrderRevert(out msg);
if (msg != string.Empty)
{
return;
}
model_Revert.OrderID = model_WorkOrderInfo.OrderID;
model_Revert.ReceiverDepartName = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.GetDistrictNameByUserID(operUserID);
model_Revert.WorkOrderStatus = "已完成";
if (CallID != string.Empty)
{
model_Revert.CallID = Int64.Parse(CallID);
}
BLL.Loger.Log4Net.Info("【个人工单提交Step5——WorkOrderRevert数据入库开始】");
BLL.WorkOrderRevert.Instance.Insert(model_Revert);
BLL.Loger.Log4Net.Info("【个人工单提交Step5——WorkOrderRevert数据入库结束】");
#endregion
#region 插入标签
if (TagIDs != string.Empty)
{
string[] array_TagIDs = TagIDs.Split(',');
for (int k = 0; k < array_TagIDs.Length; k++)
{
Entities.WorkOrderTagMapping model_Mapping = new Entities.WorkOrderTagMapping();
model_Mapping.OrderID = model_WorkOrderInfo.OrderID;
model_Mapping.TagID = int.Parse(array_TagIDs[k]);
model_Mapping.Status = 0;
model_Mapping.CreateTime = model_Mapping.ModifyTime = operTime;
model_Mapping.CreateUserID = model_Mapping.ModifyUserID = operUserID;
BLL.Loger.Log4Net.Info("【个人工单提交Step6——插入标签数据入库开始】");
BLL.WorkOrderTagMapping.Instance.Insert(model_Mapping);
BLL.Loger.Log4Net.Info("【个人工单提交Step6——插入标签数据入库结束】");
}
}
#endregion
msg = "{'result':'true','OrderID':'" + model_WorkOrderInfo.OrderID + "'}";
}
catch (Exception ex)
{
BLL.Loger.Log4Net.Error("【个人工单提交】出现方法出现问题：" + ex.Message);
}
}
private void DealerSubmit(out string msg)
{
msg = string.Empty;
try
{
BLL.Loger.Log4Net.Info("【经销商工单提交Step1——参数验证】CallID IS:" + CallID);
#region 验证
validate(out msg);
if (LastProcessDate != string.Empty)
{
DateTime dtLastProcessDate;
if (DateTime.TryParse(LastProcessDate, out dtLastProcessDate))
{
if (dtLastProcessDate < DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")))
{
msg += "最晚处理日期不能小于当前时间！<br/>";
}
}
}
if (msg != string.Empty)
{
msg = "{'result':'false','msg':'" + msg + "'}";
return;
}
#endregion
#region 插入工单表
BLL.Loger.Log4Net.Info("【经销商工单提交Step2——绑定工单信息】");
Entities.WorkOrderInfo model_WorkOrderInfo = bindWorkOrderInfo(out msg);
if (msg != string.Empty)
{
return;
}
string orderCustID = string.Empty;
//根据CRMCustName查询获取CustID
BLL.Loger.Log4Net.Info("【经销商工单提交Step3——根据CRMCustName查询获取CustID开始】");
DataSet ds_CustID = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustIDByNameToCC(model_WorkOrderInfo.CustName);
BLL.Loger.Log4Net.Info("【经销商工单提交Step3——根据CRMCustName查询获取CustID结束】");
if (ds_CustID != null && ds_CustID.Tables.Count > 0 && ds_CustID.Tables[0].Rows.Count > 0)
{
model_WorkOrderInfo.CRMCustID = orderCustID = ds_CustID.Tables[0].Rows[0]["CustID"].ToString();
}
//OperType=1：添加（状态：已完成）；OperType=2：转出（状态：待审核）
model_WorkOrderInfo.WorkOrderStatus = OperType == "1" ? (int)Entities.WorkOrderStatus.Completed : (int)Entities.WorkOrderStatus.Pending;
model_WorkOrderInfo.WorkCategory = 2;//工单类型-经销商；add lxw 13.9.11
model_WorkOrderInfo.DemandID = DemandID;
BLL.Loger.Log4Net.Info("【经销商工单提交Step4——WorkOrderInfo入库开始】");
model_WorkOrderInfo.OrderID = BLL.WorkOrderInfo.Instance.Insert(model_WorkOrderInfo);
BLL.Loger.Log4Net.Info("【经销商工单提交Step4——WorkOrderInfo入库结束】OrderID=：" + OrderID);
//回写IM库
BLL.Loger.Log4Net.Info("【经销商工单提交Step5——工单信息回写IM库开始】");
UpdateCCWorkOrder2IM(model_WorkOrderInfo);
BLL.Loger.Log4Net.Info("【经销商工单提交Step5——工单信息回写IM库结束】");
#endregion
#region 插入工单回复表
BLL.Loger.Log4Net.Info("【经销商工单提交Step6——绑定工单回复信息】OrderID=" + model_WorkOrderInfo.OrderID + ",CallID=" + CallID);
Entities.WorkOrderRevert model_Revert = bindWorkOrderRevert(out msg);
model_Revert.OrderID = model_WorkOrderInfo.OrderID;
if (CallID != string.Empty)
{
model_Revert.CallID = Int64.Parse(CallID);
}
if (msg != string.Empty)
{
return;
}
model_Revert.WorkOrderStatus = OperType == "1" ? "已完成" : "待审核";
BLL.Loger.Log4Net.Info("【经销商工单提交Step7——根据部门获取部门名称开始】");
model_Revert.ReceiverDepartName = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.GetDistrictNameByUserID(operUserID);
BLL.Loger.Log4Net.Info("【经销商工单提交Step7——根据部门获取部门名称结束】");
BLL.Loger.Log4Net.Info("【经销商工单提交Step8——工单回复信息入库开始】");
BLL.WorkOrderRevert.Instance.Insert(model_Revert);
BLL.Loger.Log4Net.Info("【经销商工单提交Step8——工单回复信息入库结束】");
#endregion
#region 插入标签
if (TagIDs != string.Empty)
{
string[] array_TagIDs = TagIDs.Split(',');
for (int k = 0; k < array_TagIDs.Length; k++)
{
Entities.WorkOrderTagMapping model_Mapping = new Entities.WorkOrderTagMapping();
model_Mapping.OrderID = model_WorkOrderInfo.OrderID;
model_Mapping.TagID = int.Parse(array_TagIDs[k]);
model_Mapping.Status = 0;
model_Mapping.CreateTime = model_Mapping.ModifyTime = operTime;
model_Mapping.CreateUserID = model_Mapping.ModifyUserID = operUserID;
BLL.Loger.Log4Net.Info("【经销商工单提交Step9——插入标签开始】");
BLL.WorkOrderTagMapping.Instance.Insert(model_Mapping);
BLL.Loger.Log4Net.Info("【经销商工单提交Step9——插入标签结束】");
}
}
#endregion
#region 把工单联系人插入个人用户
Web.AjaxServers.CustBaseInfo.CustBasicInfo model_cbInfo = bindCustBasicInfo(out msg);
if (msg != string.Empty)
{
return;
}
Web.AjaxServers.CustBaseInfo.OperPopCustBasicInfo cbi = new Web.AjaxServers.CustBaseInfo.OperPopCustBasicInfo();
BLL.Loger.Log4Net.Info("【经销商工单提交Step10——插入个人用户库信息开始】");
cbi.InsertCustInfo(model_cbInfo, out msg);
BLL.Loger.Log4Net.Info("【经销商工单提交Step10——插入个人用户库信息结束】");
string ccCustID = string.Empty;
string[] aMsg = msg.Split(',');
//如果不存在会新增个人用户 返回ccCustID
//如果存在会直接返回该联系人ccCustID
if (aMsg.Length == 2 && aMsg[0].Split(':')[1] == "'true'")
{
ccCustID = aMsg[1].Split(':')[1].Replace("'", "");
}
#endregion
#region 插入访问记录
if (ccCustID != string.Empty)
{
BLL.Loger.Log4Net.Info("【经销商工单提交Step11——插入联系记录开始】");
long callid = CommonFunction.ObjectToLong(CallID, -2);
int userid = BLL.Util.GetLoginUserID();
BitAuto.ISDC.CC2012.Web.AjaxServers.CustBaseInfo.OperPopCustBasicInfo.OperCustVisitBusiness(ccCustID, model_WorkOrderInfo.OrderID, callid, (int)VisitBusinessTypeEnum.S1_工单, TaskSource, userid, model_WorkOrderInfo.ContactTel);
BLL.Loger.Log4Net.Info("【经销商工单提交Step11——插入联系记录结束】");
}
#endregion
msg = "{'result':'true','OrderID':'" + model_WorkOrderInfo.OrderID + "','orderCustID':'" + orderCustID + "'}";
}
catch (Exception ex)
{
BLL.Loger.Log4Net.Error("【经销商工单提交】出现方法出现问题：" + ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
BitAuto.YanFa.SysRightManager.Common.UserInfo.Check();
context.Response.ContentType = "text/plain";
currentContext = context;
if ((context.Request["TagsSelectAll"] + "").Trim() == "yes")//取登录坐席所属业务组下的标签
{
//取当前登录人的业务组
if (userID != -1)
{
DataTable dt = BLL.BusinessGroup.Instance.GetBusinessGroupTagsByUserID(userID);
if (dt.Rows.Count > 0)
{
//在已选标签中遍历
//判断标签是否在已选择标签里，是则isSelected=true
int isSelected = 0;
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dt.Rows)
{
if (OrderID != string.Empty)
{
//根据工单ID取已选标签
//已选择标签跟坐席权限下标签对比，如果相同则用IsSelected标识，供前台页标注”已选择“样式操作使用。
DataTable dt2 = BLL.WorkOrderTag.Instance.GetWorkOrderTagByOrderID(OrderID);
foreach (DataRow r in dt2.Rows)
{
if (row["TagID"].ToString() == r["TagID"].ToString())
{
isSelected = 1;
}
else
{
isSelected = 0;
}
}
}
sb.Append("{'BGID':'" + row["BGID"].ToString() + "','GroupName':'" + row["GroupName"].ToString() + "','TagID':'" + row["TagID"].ToString() +
"','TagName':'" + row["TagName"].ToString() + "','IsSelected':" + isSelected + "},");
}
message = sb.ToString();
if (message.EndsWith(","))
{
message = message.Substring(0, message.Length - 1);
}
}
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
else if ((context.Request["TagsSelectByOrderID"] + "").Trim() == "yes")//根据工单ID取已选择标签
{
DataTable dt2 = new DataTable();
dt2.Columns.Add("BGID", Type.GetType("System.String"));
dt2.Columns.Add("TagID", Type.GetType("System.String"));
dt2.Columns.Add("TagName", Type.GetType("System.String"));
Random seed = new Random();
Random randomNum = new Random(seed.Next());
DataRow newRow;
for (int i = 0; i < 3; i++)
{
for (int j = 0; j < 10; j++)
{
newRow = dt2.NewRow();
newRow["BGID"] = i;
newRow["TagID"] = randomNum.ToString();
newRow["TagName"] = "标签" + j;
dt2.Rows.Add(newRow);
}
}
if (dt2.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dt2.Rows)
{
sb.Append("{'BGID':'" + row["BGID"].ToString() + "','TagID':'" + row["TagID"].ToString() +
"','TagName':'" + row["TagName"].ToString() + "'},");
}
message = sb.ToString();
if (message.EndsWith(","))
{
message = message.Substring(0, message.Length - 1);
}
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
else if ((context.Request["InsertOrderTagMapping2DB"] + "").Trim() == "yes")
{
int retval = 0;
List <JsonTag> Tags = new List <JsonTag>();
Tags = (List <JsonTag>)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(tagsJSON, typeof(List <JsonTag>));
Entities.WorkOrderTagMapping model = new Entities.WorkOrderTagMapping();
foreach (JsonTag tag in Tags)
{
model.OrderID = tag.OrderID;
model.TagID = tag.TagID;
model.CreateTime = DateTime.Now;
model.CreateUserID = userID;
model.ModifyUserID = userID;
model.ModifyTime = DateTime.Now;
model.Status = Convert.ToInt32(tag.Status);
retval = BLL.WorkOrderTagMapping.Instance.Insert(model);
}
if (retval > 0)
{
message = "操作成功";
}
else
{
message = "操作失败";
}
context.Response.Write(message);
context.Response.End();
}
else
{
success = false;
message = "request error";
BitAuto.ISDC.CC2012.BLL.AJAXHelper.WrapJsonResponse(success, result, message);
}
}
//编辑工单回复表信息
private void EditWorkOrderRevert(Entities.WorkOrderInfo newModel, Entities.WorkOrderInfo oldModel, out string msg)
{
msg = string.Empty;
if (newModel == null || oldModel == null)
{
return;
}
Entities.WorkOrderRevert model_Revert = new Entities.WorkOrderRevert();
Int64 callID = 0;
if (Int64.TryParse(CallID, out callID))
{
//如果有录音，则在之前的录音记录的基础上进行回复表的修改
model_Revert = BLL.WorkOrderRevert.Instance.GetWorkOrderRevertByCallID(callID);
}
else
{
model_Revert.OrderID = oldModel.OrderID;
model_Revert.CreateTime = operTime;
model_Revert.CreateUserID = operUserID;
}
model_Revert.RevertContent = RevertContent;
model_Revert.ReceiverDepartName = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.GetDistrictNameByUserID(operUserID);
model_Revert.IsReturnVisit = RevertContent == string.Empty ? "否" : "是";
//比较工单分类
if (newModel.CategoryID != oldModel.CategoryID)
{
string oldCategoryName = BLL.WorkOrderCategory.Instance.GetCategoryFullName(oldModel.CategoryID.ToString());
string newCategoryName = BLL.WorkOrderCategory.Instance.GetCategoryFullName(newModel.CategoryID.ToString());
model_Revert.CategoryName = fieldDesc(oldCategoryName, newCategoryName);
}
//比较工单状态
if (newModel.WorkOrderStatus != oldModel.WorkOrderStatus)
{
string oldStatus = BLL.Util.GetEnumOptText(typeof(Entities.WorkOrderStatus), (int)oldModel.WorkOrderStatus);
string newStatus = BLL.Util.GetEnumOptText(typeof(Entities.WorkOrderStatus), (int)newModel.WorkOrderStatus);
model_Revert.WorkOrderStatus = fieldDesc(oldStatus, newStatus);
}
//比较优先级
if (newModel.PriorityLevel != oldModel.PriorityLevel)
{
string oldLevel = oldModel.PriorityLevel == 1 ? "普通" : "紧急";
string newLevel = newModel.PriorityLevel == 1 ? "普通" : "紧急";
model_Revert.PriorityLevelName = fieldDesc(oldLevel, newLevel);
}
//比较接收人
if (!string.IsNullOrEmpty(newModel.ReceiverName) || !string.IsNullOrEmpty(oldModel.ReceiverName))
{
model_Revert.ReceiverID = newModel.ReceiverID.ToString();
model_Revert.ReceiverName = fieldDesc(oldModel.ReceiverName, newModel.ReceiverName);
}
//比较是否投诉
if (newModel.IsComplaintType != oldModel.IsComplaintType)
{
string oldIsComplaint = oldModel.IsComplaintType == true ? "投诉" : "普通";
string newIsComplaint = newModel.IsComplaintType == true ? "投诉" : "普通";
model_Revert.IsComplaintType = fieldDesc(oldIsComplaint, newIsComplaint);
}
//比较标签
string tagDesc = GetCompareTagDesc(model_Revert.OrderID, TagIDs);
if (tagDesc != string.Empty)
{
model_Revert.TagName = tagDesc;
//修改标签表
BLL.WorkOrderTagMapping.Instance.DeleteByOrderID(model_Revert.OrderID);
if (TagIDs != string.Empty)
{
string[] array_TagIDs = TagIDs.Split(',');
for (int k = 0; k < array_TagIDs.Length; k++)
{
Entities.WorkOrderTagMapping model_Mapping = new Entities.WorkOrderTagMapping();
model_Mapping.OrderID = model_Revert.OrderID;
model_Mapping.TagID = int.Parse(array_TagIDs[k]);
model_Mapping.Status = 0;
model_Mapping.CreateTime = model_Mapping.ModifyTime = operTime;
model_Mapping.CreateUserID = model_Mapping.ModifyUserID = operUserID;
BLL.WorkOrderTagMapping.Instance.Insert(model_Mapping);
}
}
}
if (callID != 0)
{
BLL.WorkOrderRevert.Instance.Update(model_Revert);
}
else
{
BLL.WorkOrderRevert.Instance.Insert(model_Revert);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.WorkOrderTagMapping model)
{
return(Dal.WorkOrderTagMapping.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.WorkOrderTagMapping model)
{
return(Dal.WorkOrderTagMapping.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.WorkOrderTagMapping model)
{
return(Dal.WorkOrderTagMapping.Instance.Insert(model));
}
