private void BindData()
{
//查询
int totalCount = 0;
Entities.QueryProjectTaskInfo query = new Entities.QueryProjectTaskInfo();
query.CRMCustID = ch.CustID;
DataTable table = BitAuto.ISDC.CC2012.BLL.ProjectTaskInfo.Instance.GetProjectTaskInfoForTaskRecord(query, "LastOptTime DESC", ch.CurrentPage, PageSize, out totalCount);
//设置数据源
if (table != null && table.Rows.Count > 0)
{
repeater_TaskRecord.DataSource = table;
}
//绑定列表数据
repeater_TaskRecord.DataBind();
AjaxPager_TaskRecord.InitPager(totalCount);
}
protected void Page_Load(object sender, EventArgs e)
{
if (TaskIDS != "")
{
//选中了任务，就按选中的导出
ExportByIDs();
}
else
{
//没有选中的，就按条件来导出
Entities.QueryProjectTaskInfo query = BLL.ProjectTaskInfo.Instance.GetQuery(RequestName, RequestCustName, RequestStatuss, additionalStatus,
RequestGroup, RequestCategory, RequestCreater, RequestUserId, RequestBeginTime, RequestEndTime, RequestOptUserId,
CRMBrandIDs, NoCRMBrand, TaskID, CustID, RequestOperationStatus, CustType, LastOperStartTime, LastOperEndTime
);
int totalCount = 0;
int userID = BLL.Util.GetLoginUserID();
DataTable dt = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(query, 1, 999999, out totalCount, userID);
string taskIDStr = "";
foreach (DataRow dr in dt.Rows)
{
taskIDStr = taskIDStr + "'" + dr["PTID"].ToString() + "',";
}
if (taskIDStr != "")
{
taskIDStr = taskIDStr.Substring(0, taskIDStr.Length - 1);
}
else
{
return;
}
DataTable taskDt = BLL.ProjectTaskInfo.Instance.GetExportTaskList(taskIDStr);
if (taskDt != null)
{
ExportData(taskDt);
}
}
}
private void BindData()
{
int totalCount = 0;
if (!int.TryParse(RequestPageSize, out pageSize))
{
pageSize = 20;
}
Entities.QueryProjectTaskInfo query = BLL.ProjectTaskInfo.Instance.GetQuery(RequestName, RequestCustName, RequestStatuss, AdditionalStatus,
RequestGroup, RequestCategory, RequestCreater, RequestUserId, RequestBeginTime, RequestEndTime, RequestOptUserId, CRMBrandIDs, NoCRMBrand,
TaskID, CustID, RequestOperationStatus, CustType, LastOperStartTime, LastOperEndTime);
DataTable dt = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(query, BLL.PageCommon.Instance.PageIndex, pageSize, out totalCount, userID);
RecordCount = totalCount;
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, totalCount, pageSize, BLL.PageCommon.Instance.PageIndex, 2);
}
public void ProcessRequest(HttpContext context)
{
BitAuto.YanFa.SysRightManager.Common.UserInfo.Check();
context.Response.ContentType = "text/plain";
string msg = "";
if (Status == "-1")
{
int userID = BLL.Util.GetLoginUserID();
if (!BLL.Util.CheckRight(userID, "SYS024BUT500603"))
{
msg += "您没有执行该操作的的权限";
context.Response.Write(msg);
return;
}
}
else if (Status == "2")
{
int userID = BLL.Util.GetLoginUserID();
if (!BLL.Util.CheckRight(userID, "SYS024BUT500607"))
{
msg += "您没有执行该操作的的权限";
context.Response.Write(msg);
return;
}
}
CheckPro(out msg);
if (msg == "")
{
int userID = BLL.Util.GetLoginUserID();
int totalCount = 0;
Entities.ProjectInfo model = new Entities.ProjectInfo();
model = BLL.ProjectInfo.Instance.GetProjectInfo(int.Parse(ProjectID));
if (model != null)
{
if (Status == "2")
{
if (model.Source == 1 || model.Source == 2)
{
Entities.QueryProjectTaskInfo query = new Entities.QueryProjectTaskInfo();
query.ProjectID = int.Parse(ProjectID);
query.TaskStatus_s = "180012,180000,180001,180003,180004,180010";
DataTable dt = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(query, 1, 999999, out totalCount, userID);
foreach (DataRow dr in dt.Rows)
{
BLL.ProjectTaskInfo.Instance.UpdateTaskStatus(dr["PTID"].ToString(), EnumProjectTaskStatus.STOPTask, EnumProjectTaskOperationStatus.TaskFinish, DateTime.Now);
}
}
else
{
// 结束其他任务
DataTable dt = BLL.OtherTaskInfo.Instance.GetStopForOtherTaskInfoByList(int.Parse(ProjectID));
foreach (DataRow dr in dt.Rows)
{
BLL.OtherTaskInfo.Instance.UpdateTaskStatus(dr["PTID"].ToString(), Entities.OtheTaskStatus.StopTask, Entities.EnumProjectTaskOperationStatus.TaskFinish, "结束项目", userID);
}
}
}
if (Status == "-1")
{
//删除问卷
Entities.QueryProjectSurveyMapping query = new QueryProjectSurveyMapping();
query.ProjectID = int.Parse(ProjectID);
List <Entities.ProjectSurveyMapping> mapList = BLL.ProjectSurveyMapping.Instance.GetProjectSurveyMappingList(query, out totalCount);
if (mapList != null && mapList.Count > 0)
{
foreach (Entities.ProjectSurveyMapping item in mapList)
{
item.Status = -1;
BLL.ProjectSurveyMapping.Instance.Update(item);
}
}
}
#region 修改项目状态
model.Status = int.Parse(Status);
BLL.ProjectInfo.Instance.Update(model);
BLL.ProjectLog.Instance.InsertProjectLog(model.ProjectID, ProjectLogOper.L4_结束项目, "结束项目-" + model.Name);
#endregion
#region 停止自动外呼
int a = BLL.ProjectInfo.Instance.EndAutoCallProject(model.ProjectID);
if (a > 0)
{
BLL.ProjectLog.Instance.InsertProjectLog(model.ProjectID, ProjectLogOper.Z6_结束自动外呼, "");
}
#endregion
}
else
{
msg += "没有找到对应的项目";
}
}
if (msg == "")
{
msg = "success";
}
context.Response.Write(msg);
}
public Entities.QueryProjectTaskInfo GetQuery(string RequestName, string RequestCustName, string RequestStatuss,
string AdditionalStatus, string RequestGroup, string RequestCategory,
string RequestCreater, string RequestUserId, string RequestBeginTime, string RequestEndTime, string RequestOptUserId,
string CRMBrandIDs, string NoCRMBrand, string TaskID, string CustID, string RequestOperationStatus, string CustType, string LastOperStartTime, string LastOperEndTime
)
{
Entities.QueryProjectTaskInfo query = new Entities.QueryProjectTaskInfo();
#region MyRegion
if (RequestName != "")
{
query.ProjectName = RequestName;
}
if (RequestCustName != "")
{
query.CustName = RequestCustName;
}
if (CustID != "")
{
query.CRMCustID = CustID;
}
///状态列表
if (RequestStatuss != "" && RequestStatuss != "-1")
{
if (RequestStatuss == "180099")
{
query.TaskStatus_s = "180003,180004,180010";
}
else
{
query.TaskStatus_s = RequestStatuss;
}
}
if (RequestOperationStatus != "")
{
query.OperationStatus_s = RequestOperationStatus;
}
if (AdditionalStatus != "")
{
query.AdditionalStatus = AdditionalStatus;
}
if (RequestGroup != "")
{
query.BGID = RequestGroup;
}
if (RequestCategory != "")
{
query.PCatageID = RequestCategory;
}
if (RequestCreater != "")
{
query.CreateUserID = int.Parse(RequestCreater);
}
if (RequestUserId != "")
{
query.EmployeeID = int.Parse(RequestUserId);
}
if (RequestOptUserId != "")
{
query.LastOptUserID = int.Parse(RequestOptUserId);
}
if (RequestBeginTime != "")
{
query.BeginTime = RequestBeginTime;
}
if (RequestEndTime != "")
{
query.EndTime = RequestEndTime;
}
if (CRMBrandIDs != "")
{
query.CRMBrandIDs = CRMBrandIDs;
}
if (NoCRMBrand != "")
{
query.NoCRMBrand = NoCRMBrand;
}
if (TaskID != "")
{
query.PTID = TaskID;
}
if (CustType != "" && CustType != "-1")
{
query.CustType = CustType;
}
if (LastOperStartTime != "")
{
query.LastOperStartTime = LastOperStartTime;
}
if (LastOperEndTime != "")
{
query.LastOperEndTime = LastOperEndTime;
}
#endregion
return(query);
}
