private static Entities.ProjectTask_Employee LoadSingleProjectTask_Employee(DataRow row)
{
Entities.ProjectTask_Employee model = new Entities.ProjectTask_Employee();
if (row["RecID"] != DBNull.Value)
{
model.RecID = Convert.ToInt32(row["RecID"].ToString());
}
if (row["PTID"] != DBNull.Value)
{
model.PTID = row["PTID"].ToString();
}
if (row["UserID"] != DBNull.Value)
{
model.UserID = Convert.ToInt32(row["UserID"].ToString());
}
if (row["Status"] != DBNull.Value)
{
model.Status = Convert.ToInt32(row["Status"].ToString());
}
return(model);
}
/// <summary>
/// 修改销售网络信息
/// </summary>
/// <param name="model">实体类销售网络信息</param>
/// <returns>成功:索引值;失败:-1</returns>
public int UpdataProjectTask_Employee(Entities.ProjectTask_Employee model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.PTID;
parameters[2].Value = model.UserID;
parameters[3].Value = model.Status;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_EMPLOYEE_UPDATE, parameters));
}
/// <summary>
/// 添加销售网络信息
/// </summary>
/// <param name="model">实体类销售网络信息</param>
/// <returns>成功:索引值;失败:-1</returns>
public int InsertProjectTask_Employee(Entities.ProjectTask_Employee model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.PTID;
parameters[2].Value = model.UserID;
parameters[3].Value = model.Status;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_EMPLOYEE_INSERT, parameters);
return(Convert.ToInt32(parameters[0].Value.ToString()));
}
//分配 插入日志 lxw 2013-6-5
private void insertLog(Entities.ProjectTask_Employee oldModel, Entities.ProjectTask_Employee newModel)
{
string userLogStr = string.Empty;
string logStr = string.Empty;
Hashtable ht_FieldName = new Hashtable();
ht_FieldName.Add("PTID", "任务ID");
ht_FieldName.Add("UserID", "操作人");
ht_FieldName.Add("Status", "状态");
ht_FieldName.Add("CreateTime", "时间");
ht_FieldName.Add("CreateUserID", "操作人");
BLL.GetLogDesc.ht_FieldName = ht_FieldName;
Hashtable ht_FieldType = new Hashtable();
ht_FieldType.Add("UserID", "UserID");
ht_FieldType.Add("CreateUserID", "UserID");
BLL.GetLogDesc.ht_FieldType = ht_FieldType;
if (oldModel == null)//为空，则是新增
{
//插入日志
BLL.GetLogDesc.getAddLogInfo(newModel, out userLogStr);
logStr = "其他任务分配新增：" + userLogStr;
}
else //不为空，则是编辑
{
//插入日志
BLL.GetLogDesc.getCompareLogInfo(oldModel, newModel, out userLogStr);
logStr = "其他任务分配编辑：" + userLogStr;
}
if (userLogStr != string.Empty)
{
BLL.Util.InsertUserLog(logStr);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(Entities.ProjectTask_Employee model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.Int, 8),
new SqlParameter("@PTID", SqlDbType.VarChar, 20),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.PTID;
parameters[2].Value = model.UserID;
parameters[3].Value = model.Status;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, "p_ProjectTaskInfo_Employee_Insert_One", parameters));
//return (long)parameters[0].Value;
}
/// <summary>
/// 分配任务
/// </summary>
/// <param name="msg"></param>
private void AssignTaskByUseid(out string msg)
{
msg = "";
#region ID列表串
string taskIDStr = "";
string[] tidList = TaskIDS.Split(',');
foreach (string item in tidList)
{
taskIDStr += "'" + item + "',";
}
if (taskIDStr != "")
{
taskIDStr = taskIDStr.Substring(0, taskIDStr.Length - 1);
}
else
{
msg += "请选择任务";
return;
}
#endregion
#region 判断任务状态
//判断任务状态
DataTable taskDt = BLL.OtherTaskInfo.Instance.GetTaskInfoListByIDs(taskIDStr);
if (taskDt != null)
{
foreach (DataRow dr in taskDt.Rows)
{
int isAutoCall = CommonFunction.ObjectToInteger(dr["isAutoCall"].ToString());
int projectacstatus = CommonFunction.ObjectToInteger(dr["ProjectACStatus"].ToString());
int taskstatus = CommonFunction.ObjectToInteger(dr["TaskStatus"].ToString());
//所能分配的任务为：1-未分配；未处理-2；处理中-3
if (taskstatus != 1 && taskstatus != 2 && taskstatus != 3)
{
msg += "所选任务中，存在不允许分配的任务";
break;
}
else if (isAutoCall == 1 && projectacstatus == (int)ProjectACStatus.P01_进行中)
{
msg += "所选任务中，存在正在进行中的自动外呼任务，无法分配任务";
break;
}
}
if (msg != "")
{
return;
}
}
else
{
msg += "没找到对应任务";
}
#endregion
#region MyRegion
Entities.ProjectTask_Employee model = null;
List <Entities.ProjectTask_Employee> list = new List <Entities.ProjectTask_Employee>();
foreach (string str in tidList)
{
model = new Entities.ProjectTask_Employee();
model.PTID = str;
model.UserID = int.Parse(AssignUserID);
model.Status = 0;
model.CreateTime = DateTime.Now;
model.CreateUserID = userId;
list.Add(model);
}
#endregion
#region 除原分配信息，插入新分配信息
BLL.ProjectTask_Employee.Instance.DeleteByIDs(taskIDStr);
foreach (Entities.ProjectTask_Employee item in list)
{
BLL.ProjectTask_Employee.Instance.Add(item);
insertLog(null, item);
}
foreach (string item in tidList)
{
BLL.OtherTaskInfo.Instance.UpdateTaskStatus(item, Entities.OtheTaskStatus.Untreated, Entities.EnumProjectTaskOperationStatus.TaskAllot, "分配", userId);
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(OtherTaskID))
{
Entities.OtherTaskInfo model = BLL.OtherTaskInfo.Instance.GetOtherTaskInfo(OtherTaskID);
BlackWhiteList = Convert.ToInt16(Entities.NotEstablishReason.N05_免打扰屏蔽).ToString();
if (model != null)
{
UserID = BLL.Util.GetLoginUserID().ToString();
if (IsAutoCall == "true")
{
//重新分配坐席
BLL.ProjectTask_Employee.Instance.DeleteByIDs("'" + OtherTaskID + "'");
//新建坐席数据
Entities.ProjectTask_Employee info = new Entities.ProjectTask_Employee();
info.PTID = OtherTaskID;
info.UserID = int.Parse(UserID);
info.Status = 0;
info.CreateTime = DateTime.Now;
info.CreateUserID = int.Parse(UserID);
BLL.ProjectTask_Employee.Instance.Add(info);
//修改任务状态=处理中
BLL.OtherTaskInfo.Instance.UpdateTaskStatus(info.PTID, Entities.OtheTaskStatus.Processing, Entities.EnumProjectTaskOperationStatus.TaskAllot, "分配", info.UserID.Value);
//修改实体类中属性
model.TaskStatus = (Int32)Entities.OtheTaskStatus.Processing;
}
if (model.TaskStatus == (Int32)Entities.OtheTaskStatus.Processed)
{
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 if (model.TaskStatus == (Int32)Entities.OtheTaskStatus.StopTask)
{
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 if (model.TaskStatus == (Int32)Entities.OtheTaskStatus.Unallocated)
{
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
{
DataTable dtEmployee = BLL.ProjectTask_Employee.Instance.GetProjectTask_Employee(OtherTaskID);
if (dtEmployee != null && dtEmployee.Rows.Count > 0)
{
if (BLL.Util.GetLoginUserID().ToString() == dtEmployee.Rows[0]["userid"].ToString())
{
OtherTaskEdit1.RequestTaskID = OtherTaskID;
}
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>");
}
}
Entities.ProjectInfo projectModel = BLL.ProjectInfo.Instance.GetProjectInfo((long)model.ProjectID);
if (projectModel != null)
{
BGID = projectModel.BGID.ToString();
SCID = projectModel.PCatageID.ToString();
Entities.TPage pageModel = BLL.TPage.Instance.GetTPageByTTCode(projectModel.TTCode);
if (pageModel.IsShowSubmitOrder.ToString() == "1")
{
IsShowSubmitOrder = true;
}
}
}
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 long Add(Entities.ProjectTask_Employee model)
{
return(Dal.ProjectTask_Employee.Instance.Add(model));
}
private void AssignTaskByUseid(out string msg)
{
msg = "";
int userId = BLL.Util.GetLoginUserID();
if (BLL.Util.CheckRight(userId, "SYS024BUT150102")) //添加“任务列表--其它任务”回收验证逻辑
{
msg += "没有回收权限";
return;
}
#region ID列表串
string taskIDStr = "";
string[] tidList = TaskIDS.Split(',');
foreach (string item in tidList)
{
taskIDStr += "'" + item + "',";
}
if (taskIDStr != "")
{
taskIDStr = taskIDStr.Substring(0, taskIDStr.Length - 1);
}
else
{
msg += "请选择任务";
return;
}
#endregion
#region 判断任务状态
//判断任务状态
DataTable taskDt = BLL.ProjectTaskInfo.Instance.GetTaskInfoListByIDs(taskIDStr);
if (taskDt != null)
{
foreach (DataRow dr in taskDt.Rows)
{
if (dr["TaskStatus"].ToString() != "180012" && dr["TaskStatus"].ToString() != "180000" && dr["TaskStatus"].ToString() != "180001")
{
msg += "所选任务中，存在不允许分配的任务";
break;
}
}
if (msg != "")
{
return;
}
}
else
{
msg += "没找到对应任务";
}
List <Entities.CustLastOperTask> list_OperTask = new List <Entities.CustLastOperTask>();
List <Entities.CustLastOperTask> list_OldOperTask = new List <Entities.CustLastOperTask>();
DateTime operTime = DateTime.Now;
for (int p = 0; p < taskDt.Rows.Count; p++)
{
if (taskDt.Rows[p]["CRMCustID"].ToString() != "")
{
Entities.CustLastOperTask operTaskModel = new CustLastOperTask();
Entities.CustLastOperTask operOldTaskModel = null;
operOldTaskModel = BLL.CustLastOperTask.Instance.GetCustLastOperTask(taskDt.Rows[p]["CRMCustID"].ToString());
if (operOldTaskModel != null)
{
list_OldOperTask.Add(operOldTaskModel);
operTaskModel.CustID = taskDt.Rows[p]["CRMCustID"].ToString();
operTaskModel.TaskID = taskDt.Rows[p]["PTID"].ToString();
operTaskModel.TaskType = 1;
operTaskModel.LastOperTime = operTime;
operTaskModel.LastOperUserID = BLL.Util.GetLoginUserID();
list_OperTask.Add(operTaskModel);
}
}
}
#endregion
#region MyRegion
Entities.ProjectTask_Employee model = null;
List <Entities.ProjectTask_Employee> list = new List <Entities.ProjectTask_Employee>();
foreach (string str in tidList)
{
model = new Entities.ProjectTask_Employee();
model.PTID = str;
model.UserID = int.Parse(AssignUserID);
model.Status = 0;
model.CreateTime = operTime;
model.CreateUserID = userId;
list.Add(model);
}
#endregion
#region 除原分配信息，插入新分配信息
BLL.ProjectTask_Employee.Instance.DeleteByIDs(taskIDStr);
foreach (Entities.ProjectTask_Employee item in list)
{
BLL.ProjectTask_Employee.Instance.Add(item);
}
//BLL.ProjectTask_Employee.Instance.UpdateStatus(taskIDStr, "180000");
foreach (string item in tidList)
{
BLL.ProjectTaskInfo.Instance.UpdateTaskStatus(item, EnumProjectTaskStatus.NoAssign, EnumProjectTaskOperationStatus.TaskAllot, operTime);
}
#endregion
}
