/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(SqlTransaction sqltran, Entities.OtherTaskInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@PTID", SqlDbType.VarChar, 20),
new SqlParameter("@ProjectID", SqlDbType.BigInt, 8),
new SqlParameter("@RelationTableID", SqlDbType.NVarChar, 20),
new SqlParameter("@RelationID", SqlDbType.VarChar, 20),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int),
new SqlParameter("@LastOptTime", SqlDbType.DateTime),
new SqlParameter("@LastOptUserID", SqlDbType.Int),
new SqlParameter("@TaskStatus", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@CustID", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.PTID;
parameters[1].Value = model.ProjectID;
parameters[2].Value = model.RelationTableID;
parameters[3].Value = model.RelationID;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUserID;
parameters[6].Value = model.LastOptTime;
parameters[7].Value = model.LastOptUserID;
parameters[8].Value = model.TaskStatus;
parameters[9].Value = model.Status;
parameters[10].Value = model.CustID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_OTHERTASKINFO_INSERT, parameters);
}
/// <summary>
/// 保存自定义表单数据
/// </summary>
/// <param name="RelationID"></param>
/// <param name="RelationTableID"></param>
/// <param name="Body"></param>
/// <param name="msg"></param>
private void SavecustomData(string RelationID, string TaskID, string RelationTableID, string Body, out string msg)
{
msg = "";
Dictionary <string, string> customdata = GetcustomData(Body);
bool flag = BLL.OtherTaskInfo.Instance.SaveCustomData(TaskID, RelationID, RelationTableID, customdata, 0);
if (!flag)
{
msg = "保存自定义表单数据失败";
}
else
{
BLL.OtherTaskInfo.Instance.UpdateTaskStatus(TaskID, Entities.OtheTaskStatus.Processing, Entities.EnumProjectTaskOperationStatus.TaskSave, "保存", userId);
//如果是使用了个人属性模板，需要将自定义表的数据更新到任务表，以供后期查询
if (!string.IsNullOrEmpty(CustName) && !string.IsNullOrEmpty(Sex) && !string.IsNullOrEmpty(TelePhone))
{
Entities.OtherTaskInfo model = new Entities.OtherTaskInfo();
model.PTID = TaskID;
model.CustNameTemp = CustName;
model.SexTemp = Convert.ToInt32(Sex);
model.TelePhoneTemp = TelePhone;
model.DataTypeTemp = 1;
BLL.OtherTaskInfo.Instance.Update(model);
}
}
}
private void CheckTelByProjectID(out string msg)
{
msg = "Yes";
if (!string.IsNullOrEmpty(TaskID) && !string.IsNullOrEmpty(TelePhone))
{
//根据TaskID取projectID
Entities.OtherTaskInfo model = BLL.OtherTaskInfo.Instance.GetOtherTaskInfo(TaskID);
if (model != null)
{
bool flag = BLL.BlackWhiteList.Instance.CheckPhoneAndTelIsInBlackList(model.ProjectID, TelePhone);
if (flag)
{
msg = "No";
}
}
}
}
public void GetTaskOrderInfoValues(string PTID, out string ProvinceID, out string CityID, out string YXBrandID, out string YXSerialID)
{
ProvinceID = "";
CityID = "";
YXBrandID = "";
YXSerialID = "";
//BLL.Loger.Log4Net.Info(string.Format("BitAuto.ISDC.CC2012.BLL.OtherTaskInfo，根据任务id:{0}取意向车型，意向品牌，省份，城市，开始...", PTID));
Entities.OtherTaskInfo taskInfo = BLL.OtherTaskInfo.Instance.GetOtherTaskInfo(PTID);
if (taskInfo != null)
{
Entities.TTable ttable = BLL.TTable.Instance.GetTTableByTTCode(taskInfo.RelationTableID);
if (ttable != null)
{
DataTable TempDataTable = Dal.OtherTaskInfo.Instance.GetCustomTable(taskInfo.RelationID, ttable.TTName);
if (TempDataTable.Rows.Count == 1)
{
for (int colIndex = TempDataTable.Columns.Count - 1; colIndex >= 0; colIndex--)
{
if (TempDataTable.Columns[colIndex].ColumnName.IndexOf("_Province") != -1)
{
//存在省份字段
ProvinceID = TempDataTable.Rows[0][colIndex].ToString();
}
if (TempDataTable.Columns[colIndex].ColumnName.IndexOf("_City") != -1)
{
//存在城市字段
CityID = TempDataTable.Rows[0][colIndex].ToString();
}
if (TempDataTable.Columns[colIndex].ColumnName.IndexOf("_YXBrand") != -1)
{
//存在意向品牌字段
YXBrandID = TempDataTable.Rows[0][colIndex].ToString();
}
if (TempDataTable.Columns[colIndex].ColumnName.IndexOf("_YXSerial") != -1)
{
//存在意向车型字段
YXSerialID = TempDataTable.Rows[0][colIndex].ToString();
}
}
}
}
}
//BLL.Loger.Log4Net.Info(string.Format("BitAuto.ISDC.CC2012.BLL.OtherTaskInfo，根据任务id:{0}取意向车型，意向品牌，省份，城市，结束", PTID));
}
private bool VerifyLogic(string taskID, int userId, ref string msg)
{
bool flag = false;
Entities.OtherTaskInfo model = BLL.OtherTaskInfo.Instance.GetOtherTaskInfo(taskID);
if (model != null)
{
switch (model.TaskStatus)
{
case (Int32)Entities.OtheTaskStatus.Processed:
msg = "该任务已处理完毕！";
break;
case (Int32)Entities.OtheTaskStatus.StopTask:
msg = "该任务已结束！";
break;
case (Int32)Entities.OtheTaskStatus.Unallocated:
msg = "该任务未分配处理人！";
break;
default:
DataTable dtEmployee = BLL.ProjectTask_Employee.Instance.GetProjectTask_Employee(taskID);
if (dtEmployee != null && dtEmployee.Rows.Count > 0)
{
if (userId.ToString() != dtEmployee.Rows[0]["userid"].ToString())
{
msg = "您没有该任务的处理权限！";
}
else
{
flag = true;
}
}
else
{
msg = "该任务未分配处理人！";
}
break;
}
}
return(flag);
}
/// <summary>
/// 提交自定义表单数据
/// </summary>
/// <param name="RelationID"></param>
/// <param name="RelationTableID"></param>
/// <param name="Body"></param>
/// <param name="msg"></param>
private void SubcustomData(string RelationID, string TaskID, string RelationTableID, string Body, out string msg)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
msg = "";
BLL.Loger.Log4Net.Info("【提交自定义表单数据提交Step1】开始,任务ID为：" + TaskID);
Dictionary <string, string> customdata = GetcustomData(Body);
bool flag = BLL.OtherTaskInfo.Instance.SaveCustomData(TaskID, RelationID, RelationTableID, customdata, 1);
BLL.Loger.Log4Net.Info("【提交自定义表单数据提交Step2】结束，返回值：" + flag.ToString());
if (!flag)
{
msg = "提交自定义表单数据失败";
BLL.Loger.Log4Net.Info("【提交自定义表单数据提交Step3】提交自定义表单数据失败");
}
else
{
BLL.Loger.Log4Net.Info("【提交自定义表单数据提交Step4】更新其他任务状态开始");
BLL.OtherTaskInfo.Instance.UpdateTaskStatus(TaskID, Entities.OtheTaskStatus.Processed, Entities.EnumProjectTaskOperationStatus.TaskSubmit, "提交", userId);
BLL.Loger.Log4Net.Info("【提交自定义表单数据提交Step5】更新其他任务状态结束");
//如果是使用了个人属性模板，需要将自定义表的数据更新到任务表，以供后期查询
if (!string.IsNullOrEmpty(CustName) && !string.IsNullOrEmpty(Sex) && !string.IsNullOrEmpty(TelePhone))
{
Entities.OtherTaskInfo model = new Entities.OtherTaskInfo();
model.PTID = TaskID;
model.CustNameTemp = CustName;
model.SexTemp = Convert.ToInt32(Sex);
model.TelePhoneTemp = TelePhone;
model.DataTypeTemp = 1;
BLL.Loger.Log4Net.Info(string.Format("提交自定义表单数据提交Step6】BitAuto.ISDC.CC2012.Web.AjaxServers.OtherTask.OtherTaskDeal.ashx，参数：PTID={0},将自定义表的数据更新到任务表开始...", TaskID));
BLL.OtherTaskInfo.Instance.Update(model);
BLL.Loger.Log4Net.Info(string.Format("提交自定义表单数据提交Step7】BitAuto.ISDC.CC2012.Web.AjaxServers.OtherTask.OtherTaskDeal.ashx，参数：PTID={0},将自定义表的数据更新到任务表结束", TaskID));
}
}
stopwatch.Stop();
BLL.Loger.Log4Net.Info(string.Format("【提交自定义表单数据提交Step8】总耗时：{0}毫秒", stopwatch.Elapsed.TotalMilliseconds));
}
private Entities.OtherTaskInfo LoadSingleOtherTaskInfo(DataRow row)
{
Entities.OtherTaskInfo model = new Entities.OtherTaskInfo();
model.PTID = row["PTID"].ToString();
if (row["ProjectID"].ToString() != "")
{
model.ProjectID = long.Parse(row["ProjectID"].ToString());
}
model.RelationTableID = row["RelationTableID"].ToString();
model.RelationID = row["RelationID"].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["LastOptTime"].ToString() != "")
{
model.LastOptTime = DateTime.Parse(row["LastOptTime"].ToString());
}
if (row["LastOptUserID"].ToString() != "")
{
model.LastOptUserID = int.Parse(row["LastOptUserID"].ToString());
}
if (row["TaskStatus"].ToString() != "")
{
model.TaskStatus = int.Parse(row["TaskStatus"].ToString());
}
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["GUID"].ToString() != "")
{
model.GUID = new Guid(row["GUID"].ToString());
}
return(model);
}
/// <summary>
/// 更新一条数据(更新个人用户属性自定义表值到任务表)
/// </summary>
public int Update(Entities.OtherTaskInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@PTID", SqlDbType.VarChar, 20),
new SqlParameter("@CustName", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@TelePhone", SqlDbType.NVarChar, 50),
new SqlParameter("@DataType", SqlDbType.Int, 4),
new SqlParameter("@CustID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.PTID;
parameters[1].Value = model.CustNameTemp;
parameters[2].Value = model.SexTemp;
parameters[3].Value = model.TelePhoneTemp;
parameters[4].Value = model.DataTypeTemp;
parameters[5].Value = model.CustID;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_OTHERTASKINFO_UPDATE, parameters));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(OtherTaskID))
{
Entities.OtherTaskInfo model = BLL.OtherTaskInfo.Instance.GetOtherTaskInfo(OtherTaskID);
if (model != null)
{
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>");
}
}
}
}
/// <summary>
/// 加载页面元素
/// </summary>
protected void LoadTPage()
{
if (!string.IsNullOrEmpty(RequestTaskID))
{
Entities.OtherTaskInfo model = null;
//根据任务id，取自定义数据表编号，自定义数据表主键
model = BLL.OtherTaskInfo.Instance.GetOtherTaskInfo(RequestTaskID);
if (model != null)
{
RelationID = model.RelationID;
TTCode = model.RelationTableID;
Entities.QueryProjectInfo query = new Entities.QueryProjectInfo();
query.ProjectID = model.ProjectID;
int totalCount = 0;
DataTable dt = BLL.ProjectInfo.Instance.GetProjectInfo(query, "", 1, 999, out totalCount);
if (dt != null && dt.Rows.Count > 0)
{
TPName = dt.Rows[0]["Name"].ToString();
}
}
}
}
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 int Update(Entities.OtherTaskInfo model)
{
return(Dal.OtherTaskInfo.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(SqlTransaction sqltran, Entities.OtherTaskInfo model)
{
Dal.OtherTaskInfo.Instance.Insert(sqltran, model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Entities.OtherTaskInfo model)
{
Dal.OtherTaskInfo.Instance.Insert(model);
}
