/// <summary>
/// ordertype 1是保存，2是提交
/// </summary>
/// <param name="ordertype"></param>
protected void DealLog(int ordertype)
{
Entities.LeadsTaskOperationLog logmodel = new Entities.LeadsTaskOperationLog();
logmodel.Remark = RequestRemark;
logmodel.TaskID = RequestTaskID;
logmodel.CreateTime = System.DateTime.Now;
logmodel.CreateUserID = userId;
if (ordertype == 1)
{
logmodel.OperationStatus = (int)Entities.Leads_OperationStatus.Save;
logmodel.TaskStatus = (int)Entities.LeadsTaskStatus.Processing;
logmodel.Remark = "保存";
}
else if (ordertype == 2)
{
logmodel.OperationStatus = (int)Entities.Leads_OperationStatus.Submit;
logmodel.TaskStatus = (int)Entities.LeadsTaskStatus.Processed;
logmodel.Remark = "提交";
}
//if (!string.IsNullOrEmpty(RequestRemark))
//{
// logmodel.Remark += "，备注信息：" + RequestRemark;
//}
BLL.LeadsTaskOperationLog.Instance.Insert(logmodel);
}
private Entities.LeadsTaskOperationLog LoadSingleLeadsTaskOperationLog(DataRow row)
{
Entities.LeadsTaskOperationLog model = new Entities.LeadsTaskOperationLog();
if (row["RecID"].ToString() != "")
{
model.RecID = long.Parse(row["RecID"].ToString());
}
model.TaskID = 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());
}
return(model);
}
//分配或收回操作
private void operLeads(string taskID, DateTime dtNow, int userID, string desc)
{
int loginid = BLL.Util.GetLoginUserID();
//更新LeadsTask
Entities.LeadsTask model = BLL.LeadsTask.Instance.GetLeadsTask(taskID);
if (model == null)
{
return;
}
if (desc == "分配")
{
model.Status = (int)Entities.LeadsTaskStatus.NoProcess;
model.AssignUserID = userID;
}
else
{
model.Status = (int)Entities.LeadsTaskStatus.NoAllocation;
model.AssignUserID = -2;
}
model.LastUpdateTime = dtNow;
model.LastUpdateUserID = loginid;
BLL.LeadsTask.Instance.Update(model);
//插入LeadsTaskOperationLog
Entities.LeadsTaskOperationLog model_Log = new Entities.LeadsTaskOperationLog();
model_Log.CreateTime = dtNow;
model_Log.CreateUserID = loginid;
model_Log.Remark = desc;
model_Log.TaskID = taskID;
model_Log.TaskStatus = desc == "分配" ? (int)Entities.LeadsTaskStatus.NoProcess : (int)Entities.LeadsTaskStatus.NoAllocation;
model_Log.OperationStatus = desc == "分配" ? (int)Entities.Leads_OperationStatus.Allocation : (int)Entities.Leads_OperationStatus.Recover;
BLL.LeadsTaskOperationLog.Instance.Insert(model_Log);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.LeadsTaskOperationLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@TaskID", SqlDbType.VarChar, 50),
new SqlParameter("@OperationStatus", SqlDbType.Int, 4),
new SqlParameter("@TaskStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
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;
return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_LEADSTASKOPERATIONLOG_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Insert(Entities.LeadsTaskOperationLog model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RecID", SqlDbType.BigInt, 8),
new SqlParameter("@TaskID", SqlDbType.VarChar, 50),
new SqlParameter("@OperationStatus", SqlDbType.Int, 4),
new SqlParameter("@TaskStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
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;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_LEADSTASKOPERATIONLOG_INSERT, parameters);
return((long)parameters[0].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.LeadsTaskOperationLog model)
{
return(Dal.LeadsTaskOperationLog.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.LeadsTaskOperationLog model)
{
return(Dal.LeadsTaskOperationLog.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Insert(SqlTransaction sqltran, Entities.LeadsTaskOperationLog model)
{
return(Dal.LeadsTaskOperationLog.Instance.Insert(sqltran, model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Insert(Entities.LeadsTaskOperationLog model)
{
return(Dal.LeadsTaskOperationLog.Instance.Insert(model));
}
