/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.GroupOrderTaskOperationLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@TaskID", SqlDbType.BigInt, 8),
new SqlParameter("@OperationStatus", SqlDbType.Int, 4),
new SqlParameter("@TaskStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 1000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@CallRecordID", SqlDbType.BigInt, 8)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.TaskID;
parameters[2].Value = model.OperationStatus;
parameters[3].Value = model.TaskStatus;
parameters[4].Value = model.Remark;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
parameters[7].Value = model.CallRecordID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_GROUPORDERTASKOPERATIONLOG_INSERT, parameters);
return((int)parameters[0].Value);
}
private Entities.GroupOrderTaskOperationLog LoadSingleGroupOrderTaskOperationLog(DataRow row)
{
Entities.GroupOrderTaskOperationLog model = new Entities.GroupOrderTaskOperationLog();
if (row["RecID"].ToString() != "")
{
model.RecID = long.Parse(row["RecID"].ToString());
}
if (row["TaskID"].ToString() != "")
{
model.TaskID = long.Parse(row["TaskID"].ToString());
}
if (row["OperationStatus"].ToString() != "")
{
model.OperationStatus = int.Parse(row["OperationStatus"].ToString());
}
if (row["TaskStatus"].ToString() != "")
{
model.TaskStatus = int.Parse(row["TaskStatus"].ToString());
}
model.Remark = row["Remark"].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["CallRecordID"].ToString() != "")
{
model.CallRecordID = long.Parse(row["CallRecordID"].ToString());
}
return(model);
}
/// <summary>
/// ordertype 1是保存，2是提交
/// </summary>
/// <param name="ordertype"></param>
protected void DealLog(int ordertype)
{
//判断是否有通话记录，如果有通话则有不为空;
if (string.IsNullOrEmpty(HistoryLogID))
{
Entities.GroupOrderTaskOperationLog logmodel = new Entities.GroupOrderTaskOperationLog();
logmodel.CreateUserID = userId;
logmodel.CreateTime = System.DateTime.Now;
logmodel.Remark = RequestRemark;
logmodel.TaskID = long.Parse(RequestTaskID);
if (ordertype == 1)
{
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Save;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.Processing;
}
else if (ordertype == 2)
{
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Submit;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.Processed;
}
BLL.GroupOrderTaskOperationLog.Instance.Insert(logmodel);
}
else
{
int historylogid = 0;
if (int.TryParse(HistoryLogID, out historylogid))
{
Entities.GroupOrderTaskOperationLog logmodel = BLL.GroupOrderTaskOperationLog.Instance.GetGroupOrderTaskOperationLog(historylogid);
logmodel.Remark = RequestRemark;
if (ordertype == 1)
{
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Save;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.Processing;
}
else if (ordertype == 2)
{
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Submit;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.Processed;
}
BLL.GroupOrderTaskOperationLog.Instance.Update(logmodel);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.GroupOrderTaskOperationLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@TaskID", SqlDbType.BigInt, 8),
new SqlParameter("@OperationStatus", SqlDbType.Int, 4),
new SqlParameter("@TaskStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 1000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@CallRecordID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.RecID;
parameters[1].Value = model.TaskID;
parameters[2].Value = model.OperationStatus;
parameters[3].Value = model.TaskStatus;
parameters[4].Value = model.Remark;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
parameters[7].Value = model.CallRecordID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_GROUPORDERTASKOPERATIONLOG_UPDATE, parameters));
}
/// <summary>
/// 分配任务
/// </summary>
/// <param name="msg"></param>
private void AssignTask(out string msg)
{
msg = string.Empty;
string Result = "yes";
string ErrorMsg = "";
//不为空
if (!string.IsNullOrEmpty(TaskIDS) && !string.IsNullOrEmpty(AssignUserID))
{
if (TaskIDS.IndexOf(',') > 0)
{
string[] arrayTaskIDS = TaskIDS.Split(',');
foreach (string taskid in arrayTaskIDS)
{
Entities.GroupOrderTask Model = BLL.GroupOrderTask.Instance.GetGroupOrderTask(Convert.ToInt32(taskid));
if (Model.TaskStatus == (int)Entities.GroupTaskStatus.NoAllocation)
{
Model.AssignUserID = Convert.ToInt32(AssignUserID);
Model.AssignTime = System.DateTime.Now;
Model.TaskStatus = (int)Entities.GroupTaskStatus.NoProcess;
BLL.GroupOrderTask.Instance.Update(Model);
//插入任务操作日志
Entities.GroupOrderTaskOperationLog logmodel = new Entities.GroupOrderTaskOperationLog();
logmodel.TaskID = Model.TaskID;
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Allocation;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.NoProcess;
logmodel.CreateTime = System.DateTime.Now;
logmodel.CreateUserID = BLL.Util.GetLoginUserID();
BLL.GroupOrderTaskOperationLog.Instance.Insert(logmodel);
}
else
{
Result = "no";
ErrorMsg += "任务ID为" + Model.TaskID + "的任务状态不是待分配。";
}
}
}
else
{
Entities.GroupOrderTask Model = BLL.GroupOrderTask.Instance.GetGroupOrderTask(Convert.ToInt32(TaskIDS));
if (Model.TaskStatus == (int)Entities.GroupTaskStatus.NoAllocation)
{
Model.AssignUserID = Convert.ToInt32(AssignUserID);
Model.AssignTime = System.DateTime.Now;
Model.TaskStatus = (int)Entities.GroupTaskStatus.NoProcess;
BLL.GroupOrderTask.Instance.Update(Model);
//插入任务操作日志
Entities.GroupOrderTaskOperationLog logmodel = new Entities.GroupOrderTaskOperationLog();
logmodel.TaskID = Model.TaskID;
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Allocation;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.NoProcess;
logmodel.CreateTime = System.DateTime.Now;
logmodel.CreateUserID = BLL.Util.GetLoginUserID();
BLL.GroupOrderTaskOperationLog.Instance.Insert(logmodel);
}
else
{
Result = "no";
ErrorMsg += "任务ID为" + Model.TaskID + "的任务状态不是待分配。";
}
}
}
msg = "{Result:'" + Result + "',CustID:'',ErrorMsg:'" + ErrorMsg + "'}";
}
/// <summary>
/// 收回任务
/// </summary>
/// <param name="msg"></param>
public void RevokeTask(out string msg)
{
msg = string.Empty;
string Result = "yes";
string ErrorMsg = "";
//不为空
if (!string.IsNullOrEmpty(TaskIDS))
{
if (TaskIDS.IndexOf(',') > 0)
{
for (int i = 0; i < TaskIDS.Split(',').Length; i++)
{
int userid = 0;
Entities.GroupOrderTask Model = BLL.GroupOrderTask.Instance.GetGroupOrderTask(Convert.ToInt32(TaskIDS.Split(',')[i]));
//判断任务状态，是否为已处理
if (Model.TaskStatus != (int)Entities.GroupTaskStatus.Processed)
{
//取要被收回任务的处理人
if (Model.AssignUserID != null && Model.AssignUserID != -2)
{
userid = Convert.ToInt32(Model.AssignUserID);
}
Model.AssignUserID = null;
Model.TaskStatus = (int)Entities.GroupTaskStatus.NoAllocation;
BLL.GroupOrderTask.Instance.Update(Model);
Entities.GroupOrderTaskOperationLog logmodel = new Entities.GroupOrderTaskOperationLog();
logmodel.TaskID = Model.TaskID;
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Recover;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.NoAllocation;
logmodel.CreateTime = System.DateTime.Now;
logmodel.CreateUserID = BLL.Util.GetLoginUserID();
BLL.GroupOrderTaskOperationLog.Instance.Insert(logmodel);
}
else
{
Result = "no";
ErrorMsg += "任务ID为" + Model.TaskID + "的任务状态为已处理，不能回收。";
}
}
}
else
{
int userid = 0;
Entities.GroupOrderTask Model = BLL.GroupOrderTask.Instance.GetGroupOrderTask(Convert.ToInt32(TaskIDS));
//判断任务状态，是否为已处理
if (Model.TaskStatus != (int)Entities.GroupTaskStatus.Processed)
{
//取要被收回任务的处理人
if (Model.AssignUserID != null && Model.AssignUserID != -2)
{
userid = Convert.ToInt32(Model.AssignUserID);
}
Model.AssignUserID = null;
Model.TaskStatus = (int)Entities.GroupTaskStatus.NoAllocation;
BLL.GroupOrderTask.Instance.Update(Model);
Entities.GroupOrderTaskOperationLog logmodel = new Entities.GroupOrderTaskOperationLog();
logmodel.TaskID = Model.TaskID;
logmodel.OperationStatus = (int)Entities.GO_OperationStatus.Recover;
logmodel.TaskStatus = (int)Entities.GroupTaskStatus.NoAllocation;
logmodel.CreateTime = System.DateTime.Now;
logmodel.CreateUserID = BLL.Util.GetLoginUserID();
BLL.GroupOrderTaskOperationLog.Instance.Insert(logmodel);
}
else
{
Result = "no";
ErrorMsg += "任务ID为" + Model.TaskID + "的任务状态为已处理，不能回收。";
}
}
}
msg = "{Result:'" + Result + "',CustID:'',ErrorMsg:'" + ErrorMsg + "'}";
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.GroupOrderTaskOperationLog model)
{
return(Dal.GroupOrderTaskOperationLog.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.GroupOrderTaskOperationLog model)
{
return(Dal.GroupOrderTaskOperationLog.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Insert(Entities.GroupOrderTaskOperationLog model)
{
return(Dal.GroupOrderTaskOperationLog.Instance.Insert(model));
}
