protected void Page_Load(object sender, EventArgs e)
{
try
{
var thisId = Request.QueryString["project_id"];
if (!string.IsNullOrEmpty(thisId))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(thisId));
}
var taskId = Request.QueryString["task_id"];
if (!string.IsNullOrEmpty(taskId))
{
task = new sdk_task_dal().FindNoDeleteById(long.Parse(taskId));
}
if (thisProject != null)
{
ShowNoteList.Src = "../Common/SearchBodyFrame.aspx?cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_NOTE + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_NOTE + "&con1054=" + thisProject.id + "&con1055=";
actList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.ACTION_TYPE);
if (actList != null && actList.Count > 0)
{
actList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.PROJECT_NOTE).ToString()).ToList();
}
}
else if (task != null)
{
account = new BLL.CompanyBLL().GetCompany(task.account_id);
ShowNoteList.Src = "../Common/SearchBodyFrame.aspx?cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_NOTE + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_NOTE + "&con1054=" + task.id + "&con1055=";
}
}
catch (Exception)
{
Response.End();
}
}
protected decimal?searchRate = null; // 该员工的实际的费率
protected void Page_Load(object sender, EventArgs e)
{
try
{
var thisId = Request.QueryString["id"];
if (!string.IsNullOrEmpty(thisId))
{
thisEntry = new sdk_work_entry_dal().FindNoDeleteById(long.Parse(thisId));
if (thisEntry != null)
{
thisTask = new sdk_task_dal().FindNoDeleteById(thisEntry.task_id);
}
}
if (thisEntry == null || thisTask == null)
{
Response.Write("<script>alert('未找到该工时信息！');window.close();self.opener.location.reload();</script>");
}
else
{
if (thisEntry.contract_id != null)
{
var thisObject = new sdk_work_entry_dal().GetSingle($"select f_get_labor_rate({(long)thisEntry.contract_id},{thisEntry.cost_code_id.ToString()},{thisEntry.role_id.ToString()})");
if (thisObject != null)
{
searchRate = (decimal)thisObject;
}
}
}
}
catch (Exception)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var thisContractId = Request.QueryString["contract_id"];
if (!string.IsNullOrEmpty(thisContractId))
{
thisContract = new ctt_contract_dal().FindNoDeleteById(long.Parse(thisContractId));
}
if (thisContract != null)
{
ShowNoteList.Src = "../Common/SearchBodyFrame.aspx?cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_NOTE + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_NOTE + "&con1054=" + thisContract.id;
}
var taskId = Request.QueryString["task_id"];
if (!string.IsNullOrEmpty(taskId))
{
thisTask = new sdk_task_dal().FindNoDeleteById(long.Parse(taskId));
}
if (thisTask != null)
{
ShowNoteList.Src = "../Common/SearchBodyFrame.aspx?cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_NOTE + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_NOTE + "&con1054=" + thisTask.id;
thisAccount = new BLL.CompanyBLL().GetCompany(thisTask.account_id);
}
}
catch (Exception)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var account_id = Request.QueryString["account_id"];
if (!string.IsNullOrEmpty(account_id))
{
thisAccount = new CompanyBLL().GetCompany(long.Parse(account_id));
}
var ticket_id = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(ticket_id))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticket_id));
if (thisTicket != null)
{
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
}
}
var info = new BLL.QueryCommonBLL().GetQueryGroup((int)DicEnum.QUERY_CATE.TICKET_ACCOUNT_LIST);
if (info != null && info.Count > 0)
{
groupId = info[0].id;
}
if (thisAccount == null)
{
Response.Write("<script>alert('未查询到该客户信息！');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var ticketId = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(ticketId))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticketId));
}
if (thisTicket == null)
{
Response.Write("<script>alert('未查询到该工单信息！');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
long ticketId = 0;
if (!string.IsNullOrEmpty(Request.QueryString["ticketId"]) && long.TryParse(Request.QueryString["ticketId"], out ticketId))
{
ticket = new TicketBLL().GetTask(ticketId);
}
if (ticket != null)
{
account = new CompanyBLL().GetCompany(ticket.account_id);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var tId = Request.QueryString["task_id"];
if (!string.IsNullOrEmpty(tId))
{
thisTask = new sdk_task_dal().FindNoDeleteById(long.Parse(tId));
if (thisTask != null)
{
objId = thisTask.id;
}
}
isFromTicket = !string.IsNullOrEmpty(Request.QueryString["fromTicket"]);
if (thisTask == null)
{
Response.End();
}
else
{
catId = (int)DicEnum.QUERY_CATE.TASK_HISTORY;
queryTypeId = (int)QueryType.TASK_HISTORY;
var groups = bll.GetQueryGroup(catId);
foreach (var g in groups)
{
if (g.query_type_id == queryTypeId)
{
if (paraGroupId != 0) // 一个query_type下有多个group，不能判断使用哪个
{
Response.Close();
return;
}
paraGroupId = g.id;
}
}
QueryData();
CalcTableWidth();
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var tId = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(tId))
{
ticket = new sdk_task_dal().FindNoDeleteById(long.Parse(tId));
}
if (ticket == null)
{
Response.Write("<script>alert('主工单已经删除');window.close();</script>");
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var callId = Request.QueryString["callId"];
var ticketId = Request.QueryString["ticketId"];
if (!string.IsNullOrEmpty(callId) && !string.IsNullOrEmpty(ticketId))
{
thisTicketCall = new sdk_service_call_task_dal().GetSingTaskCall(long.Parse(callId), long.Parse(ticketId));
}
if (thisTicketCall == null)
{
Response.Write("<script>alert('未查询到相关信息，请重新打开');window.close();</script>");
return;
}
else
{
thisTicket = new sdk_task_dal().FindNoDeleteById(thisTicketCall.task_id);
if (thisTicket != null)
{
ticketRes = new sdk_task_resource_dal().GetResByTaskId(thisTicket.id);
if (thisTicket.owner_resource_id != null)
{
priRes = new sys_resource_dal().FindNoDeleteById((long)thisTicket.owner_resource_id);
}
resNameList = new sys_resource_dal().GetResByTicket(thisTicket.id);
}
else
{
Response.Write("<script>alert('工单已删除');window.close();</script>");
return;
}
resList = new sdk_service_call_task_resource_dal().GetTaskResList(thisTicketCall.id);
//resNameList
}
}
catch (Exception msg)
{
Response.Write("<script>alert('" + msg.Message + "');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisEntry = new sdk_work_entry_dal().FindNoDeleteById(long.Parse(id));
}
if (thisEntry == null)
{
Response.End();
}
else
{
if (thisEntry.cost_code_id != null)
{
thisCost = new d_cost_code_dal().FindNoDeleteById((long)thisEntry.cost_code_id);
thisRate = new ContractRateBLL().GetRateByCodeAndRole((long)thisEntry.cost_code_id, (long)thisEntry.role_id);
}
thisTask = new sdk_task_dal().FindNoDeleteById(thisEntry.task_id);
if (thisTask != null && thisTask.project_id != null)
{
thisProject = new pro_project_dal().FindNoDeleteById((long)thisTask.project_id);
if (thisProject != null)
{
thisAccount = new CompanyBLL().GetCompany(thisProject.account_id);
}
}
if (thisEntry.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisEntry.contract_id);
}
}
}
catch (Exception)
{
Response.End();
}
}
/// <summary>
/// 新增内部工时的时候新增Task
/// </summary>
public bool AddInterCodeTask(d_cost_code code, long userId)
{
if (code.cate_id != (int)DicEnum.COST_CODE_CATE.INTERNAL_ALLOCATION_CODE)
{
return(false);
}
var task = new TicketBLL().GetTask(code.id);
if (task != null)
{
var oldCode = GetCodeById(code.id);
code.id = _dal.GetNextIdCom();
_dal.Update(code);
OperLogBLL.OperLogUpdate <d_cost_code>(code, oldCode, code.id, userId, OPER_LOG_OBJ_CATE.D_COST_CODE, "");
AddInterCodeTask(code, userId);
}
else
{
task = new sdk_task()
{
id = code.id,
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(),
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(),
create_user_id = userId,
update_user_id = userId,
account_id = 0,
title = code.name,
no = new TaskBLL().ReturnTaskNo(),
status_id = (int)DicEnum.TICKET_STATUS.NEW,
type_id = (int)TASK_TYPE.INTERNAL_ALLOCATION_CODE,
last_activity_time = Tools.Date.DateHelper.ToUniversalTimeStamp(),
};
new sdk_task_dal().Insert(task);
OperLogBLL.OperLogAdd <sdk_task>(task, task.id, userId, OPER_LOG_OBJ_CATE.PROJECT_TASK, "");
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var taskId = Request.QueryString["task_id"];
if (!string.IsNullOrEmpty(taskId))
{
thisTask = new sdk_task_dal().FindNoDeleteById(long.Parse(taskId));
}
long id = 0;
if (!string.IsNullOrEmpty(Request.QueryString["id"]) && long.TryParse(Request.QueryString["id"], out id))
{
taskLib = new sdk_task_library_dal().FindNoDeleteById(id);
}
if (taskLib != null)
{
isAdd = false;
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var ticketId = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(ticketId))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticketId));
}
if (thisTicket == null)
{
Response.Write($"<script>alert('工单已删除！');window.close();</script>");
return;
}
else
{
thisOther = new sdk_task_other_person_dal().GetPerson(thisTicket.id, LoginUserId);
}
if (thisOther == null)
{
Response.Write($"<script>alert('工单审批人已删除！');window.close();</script>");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
Bind(); // 绑定页面下拉数据
}
CallBack = Request.QueryString["CallBack"];
var accountId = Request.QueryString["account_id"];
if (!string.IsNullOrEmpty(accountId))
{
thisAccount = new CompanyBLL().GetCompany(long.Parse(accountId));
}
var contractId = Request.QueryString["contract_id"];
if (!string.IsNullOrEmpty(contractId))
{
thisContract = new ctt_contract_dal().FindNoDeleteById(long.Parse(contractId));
}
var insProId = Request.QueryString["insProId"];
if (!string.IsNullOrEmpty(insProId))
{
insPro = new crm_installed_product_dal().FindNoDeleteById(long.Parse(insProId));
if (insPro != null && insPro.account_id != null)
{
thisAccount = new CompanyBLL().GetCompany((long)insPro.account_id);
}
}
var taskId = Request.QueryString["id"];
if (!string.IsNullOrEmpty(taskId))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(taskId));
if (thisTicket != null)
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
var isCopyString = Request.QueryString["isCopy"];
if (string.IsNullOrEmpty(isCopyString))
{
isAdd = false;
}
else
{
isCopy = true;
}
if (!IsPostBack)
{
cate_id.ClearSelection();
cate_id.SelectedValue = thisTicket.cate_id.ToString();
this.ticket_type_id.SelectedValue = thisTicket.ticket_type_id.ToString();
this.status_id.SelectedValue = thisTicket.status_id.ToString();
if (isCopy)
{
this.status_id.ClearSelection(); this.status_id.SelectedValue = ((int)DicEnum.TICKET_STATUS.NEW).ToString();
}
if (thisTicket.priority_type_id != null)
{
priority_type_id.SelectedValue = thisTicket.priority_type_id.ToString();
}
if (thisTicket.issue_type_id != null)
{
issue_type_id.SelectedValue = thisTicket.issue_type_id.ToString();
}
if (thisTicket.source_type_id != null)
{
source_type_id.SelectedValue = thisTicket.source_type_id.ToString();
}
if (thisTicket.issue_type_id != null)
{
issue_type_id.SelectedValue = thisTicket.issue_type_id.ToString();
}
if (thisTicket.sla_id != null)
{
sla_id.SelectedValue = thisTicket.sla_id.ToString();
}
if (thisTicket.department_id != null)
{
department_id.SelectedValue = thisTicket.department_id.ToString();
}
}
ticketUdfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.TASK, thisTicket.id, tickUdfList);
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
if (thisTicket.contact_id != null)
{
thisContact = new crm_contact_dal().FindNoDeleteById((long)thisTicket.contact_id);
}
if (thisTicket.owner_resource_id != null && thisTicket.role_id != null)
{
var resDepList = new sys_resource_department_dal().GetResDepByResAndRole((long)thisTicket.owner_resource_id, (long)thisTicket.role_id);
if (resDepList != null && resDepList.Count > 0)
{
proResDep = resDepList[0];
priRes = new sys_resource_dal().FindNoDeleteById((long)thisTicket.owner_resource_id);
}
}
if (thisTicket.installed_product_id != null)
{
insPro = new crm_installed_product_dal().FindNoDeleteById((long)thisTicket.installed_product_id);
}
if (thisTicket.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisTicket.contract_id);
}
if (thisTicket.cost_code_id != null)
{
thisCostCode = new d_cost_code_dal().FindNoDeleteById((long)thisTicket.cost_code_id);
}
var otherResList = new sdk_task_resource_dal().GetTaskResByTaskId(thisTicket.id);
if (otherResList != null && otherResList.Count > 0)
{
foreach (var item in otherResList)
{
if (item.resource_id != null && item.role_id != null)
{
var resDepList = new sys_resource_department_dal().GetResDepByResAndRole((long)item.resource_id, (long)item.role_id);
if (resDepList != null && resDepList.Count > 0)
{
ticketResIds += resDepList[0].id + ",";
}
}
}
if (ticketResIds != "")
{
ticketResIds = ticketResIds.Substring(0, ticketResIds.Length - 1);
}
}
ticketCheckList = new sdk_task_checklist_dal().GetCheckByTask(thisTicket.id);
if (ticketCheckList != null && ticketCheckList.Count > 0)
{
ticketCheckList = ticketCheckList.OrderBy(_ => _.sort_order).ToList();
}
#region 时间轴显示相关 工单备注类型获取
var slaValue = new sdk_task_dal().GetSlaTime(thisTicket);
string slaTimeValue = "";
if (slaValue != null)
{
slaTimeValue = slaValue.ToString();
}
if (!string.IsNullOrEmpty(slaTimeValue))
{
if (slaTimeValue.Substring(0, 1) == "{")
{
slaDic = new EMT.Tools.Serialize().JsonToDictionary(slaTimeValue);
}
}
var actList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.ACTION_TYPE);
if (actList != null && actList.Count > 0)
{
ticketNoteTypeList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
}
#endregion
entryList = new sdk_work_entry_dal().GetList(thisTicket.id);
}
}
var ticket_type_id = Request.QueryString["ticket_type_id"];
if (!string.IsNullOrEmpty(ticket_type_id))
{
this.ticket_type_id.ClearSelection();
this.ticket_type_id.SelectedValue = ticket_type_id;
}
}
catch (Exception msg)
{
Response.Write("<script>alert('" + msg.Message + "');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
actionTypeList = bll.GetCRMActionType();
resourceList = new UserResourceBLL().GetResourceList();
if (!IsPostBack)
{
long noteid;
if (!string.IsNullOrEmpty(Request.QueryString["id"]) && long.TryParse(Request.QueryString["id"], out noteid))
{
if (AuthBLL.GetUserTodoAuth(LoginUserId, LoginUser.security_Level_id, noteid).CanEdit == false)
{
Response.Write("<script>alert('您不能编辑此待办');</script>");
Response.End();
return;
}
note = bll.GetActivity(noteid);
contactList = new ContactBLL().GetContactByCompany((long)note.account_id);
opportunityList = new OpportunityBLL().GetOpportunityByCompany((long)note.account_id);
#region 记录浏览历史
var accountName = "";
if (note.account_id != null)
{
var account = new CompanyBLL().GetCompany((long)note.account_id);
accountName = account == null ? "" : account.name;
}
var history = new sys_windows_history()
{
title = "待办:" + note.description + ":" + accountName,
url = Request.RawUrl,
};
new IndexBLL().BrowseHistory(history, LoginUserId);
#endregion
}
if (long.TryParse(Request.QueryString["accountId"], out accountId))
{
objType = (int)DicEnum.OBJECT_TYPE.CUSTOMER;
objId = accountId;
}
if (long.TryParse(Request.QueryString["contactId"], out contactId))
{
accountId = new ContactBLL().GetContact(contactId).account_id;
objType = (int)DicEnum.OBJECT_TYPE.CONTACT;
objId = contactId;
}
if (long.TryParse(Request.QueryString["opportunityId"], out opportunityId))
{
objType = (int)DicEnum.OBJECT_TYPE.OPPORTUNITY;
objId = opportunityId;
var opp = new OpportunityBLL().GetOpportunity(opportunityId).general;
accountId = opp.account_id;
if (opp.contact_id != null)
{
contactId = (long)opp.contact_id;
}
}
if (long.TryParse(Request.QueryString["saleorderId"], out saleOrderId))
{
objType = (int)DicEnum.OBJECT_TYPE.SALEORDER;
objId = saleOrderId;
var saleOrder = new SaleOrderBLL().GetSaleOrder(saleOrderId);
var opp = new OpportunityBLL().GetOpportunity(saleOrder.opportunity_id).general;
opportunityId = opp.id;
accountId = opp.account_id;
if (opp.contact_id != null)
{
contactId = (long)opp.contact_id;
}
}
if (long.TryParse(Request.QueryString["ticketId"], out ticketId))
{
objType = (int)DicEnum.OBJECT_TYPE.TICKETS;
objId = ticketId;
ticket = new DAL.sdk_task_dal().FindNoDeleteById(ticketId);
accountId = ticket.account_id;
if (ticket.contact_id != null)
{
contactId = (long)ticket.contact_id;
}
if (ticket.opportunity_id != null)
{
opportunityId = (long)ticket.opportunity_id;
}
}
}
else
{
com_activity activity = AssembleModel <com_activity>();
if (activity.contact_id == 0)
{
activity.contact_id = null;
}
activity.start_date = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Parse(Request.Form["start_date2"]));
activity.end_date = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Parse(Request.Form["end_date2"]));
if (!string.IsNullOrEmpty(Request.Form["is_completed"]) && Request.Form["is_completed"].Equals("on"))
{
activity.status_id = (int)DicEnum.ACTIVITY_STATUS.COMPLETED;
activity.complete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Parse(Request.Form["complete_time1"]));
}
else
{
activity.status_id = (int)DicEnum.ACTIVITY_STATUS.NOT_COMPLETED;
activity.complete_description = null;
}
if (string.IsNullOrEmpty(Request.Form["id"]))
{
bll.AddTodo(activity, GetLoginUserId());
}
else
{
bll.EditTodo(activity, GetLoginUserId());
}
if (Request.Form["action"] != null && Request.Form["action"].Equals("SaveNew"))
{
Response.Write("<script>alert('保存待办成功');window.location.href='Notes.aspx';self.opener.location.reload();</script>");
}
else
{
Response.Write("<script>alert('保存待办成功');window.close();self.opener.location.reload();</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
if (!IsPostBack)
{
ThisPageDataBind();
}
task_udfList = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.TASK);
var project_id = Request.QueryString["project_id"];
if (!string.IsNullOrEmpty(project_id))
{
thisProject = ppdal.FindNoDeleteById(long.Parse(project_id));
}
var parTaskId = Request.QueryString["par_task_id"];
if (!string.IsNullOrEmpty(parTaskId))
{
parTask = sdDal.FindNoDeleteById(long.Parse(parTaskId));
if (parTask != null)
{
if (parTask.project_id != null)
{
thisProject = ppdal.FindNoDeleteById((long)parTask.project_id);
}
}
}
var typeString = Request.QueryString["type_id"];
if (!string.IsNullOrEmpty(typeString))
{
type_id = int.Parse(typeString);
if (!IsPostBack)
{
switch (type_id)
{
case (int)DicEnum.TASK_TYPE.PROJECT_ISSUE:
isProject_issue.Checked = true;
break;
case (int)DicEnum.TASK_TYPE.PROJECT_TASK:
isProject_issue.Checked = false;
break;
default:
break;
}
}
}
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisTask = sdDal.FindNoDeleteById(long.Parse(id));
if (thisTask != null)
{
if (thisTask.parent_id != null)
{
parTask = sdDal.FindNoDeleteById((long)thisTask.parent_id);
}
type_id = thisTask.type_id;
isAdd = false;
var isCopyString = Request.QueryString["IsCopy"];
if (!string.IsNullOrEmpty(isCopyString) && thisTask.type_id == (int)DicEnum.TASK_TYPE.PROJECT_TASK)
{
isCopy = true;
}
if (thisTask.project_id != null)
{
thisProject = ppdal.FindNoDeleteById((long)thisTask.project_id);
}
task_udfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.TASK, thisTask.id, task_udfList);
noteList = new com_activity_dal().GetActiList($" and (task_id ={thisTask.id} or object_id={thisTask.id} )");
preList = new sdk_task_predecessor_dal().GetRelList(thisTask.id);
if (!IsPostBack)
{
status_id.SelectedValue = thisTask.status_id.ToString();
if (thisTask.is_visible_in_client_portal == 0)
{
DisplayInCapNone.Checked = true;
}
else
{
if (thisTask.can_client_portal_user_complete_task == 1)
{
DisplayInCapYes.Checked = true;
}
else
{
DisplayInCapYesNoComplete.Checked = true;
}
}
if (thisTask.is_project_issue == 1)
{
isProject_issue.Checked = true;
}
else
{
isProject_issue.Checked = false;
}
if (thisTask.estimated_type_id == (int)DicEnum.TIME_ENTRY_METHOD_TYPE.FIXWORK)
{
TaskTypeFixedWork.Checked = true;
}
else if (thisTask.estimated_type_id == (int)DicEnum.TIME_ENTRY_METHOD_TYPE.FIXDURATION)
{
TaskTypeFixedDuration.Checked = true;
}
else
{
}
department_id.SelectedValue = thisTask.department_id == null ? "" : ((int)thisTask.department_id).ToString();
}
var typeName = "任务";
// 判断是阶段，查询出相关项目的关联合同的里程碑 和自己的里程碑
if (type_id == (int)DicEnum.TASK_TYPE.PROJECT_PHASE && thisProject != null && thisProject.contract_id != null)
{
typeName = "阶段";
// 获取该项目合同下未被关联的里程碑
var proConMilList = new ctt_contract_milestone_dal().GetListByProId(thisProject.id);
// 获取该阶段下的所有里程碑
var phaMilList = new sdk_task_milestone_dal().GetPhaMilList(thisTask.id);
thisPhaMile = new List <PageMile>();
if (proConMilList != null && proConMilList.Count > 0)
{
thisPhaMile.AddRange(proConMilList);
}
if (phaMilList != null && phaMilList.Count > 0)
{
thisPhaMile.AddRange(phaMilList);
}
if (thisPhaMile.Count > 0)
{
thisPhaMile = thisPhaMile.OrderBy(_ => _.dueDate).ToList();
}
}
#region 记录浏览历史
if (!isCopy && !isAdd)
{
var account = new CompanyBLL().GetCompany(thisTask.account_id);
var history = new sys_windows_history()
{
title = $"编辑{typeName}:" + (thisProject != null ? thisProject.name : "") + " " + thisTask.title + " " + (account != null ? account.name : ""),
url = Request.RawUrl,
};
new IndexBLL().BrowseHistory(history, LoginUserId);
}
#endregion
}
}
if (type_id == (int)DicEnum.TASK_TYPE.PROJECT_PHASE)
{
isPhase = true;
}
if (thisProject == null)
{
Response.End();
}
else
{
if (thisProject.contract_id != null)
{
thisProContract = new ctt_contract_dal().FindNoDeleteById((long)thisProject.contract_id);
rateList = new ctt_contract_rate_dal().GetRateByConId((long)thisProject.contract_id);
}
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
showResList = new UserResourceBLL().GetAgentUser(LoginUserId, out isAllowAgentRes);
isComplete = !string.IsNullOrEmpty(Request.QueryString["is_complete"]);
if (!IsPostBack)
{
GetPageDataBind();
}
var ticket_id = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(ticket_id))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticket_id));
if (thisTicket != null)
{
if (thisTicket.contact_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisTicket.contract_id);
}
if (thisTicket.cost_code_id != null)
{
cost_code_id.SelectedValue = thisTicket.cost_code_id.ToString();
}
}
}
var service_id = Request.QueryString["service_id"];
if (!string.IsNullOrEmpty(service_id))
{
thisCall = new sdk_service_call_dal().FindNoDeleteById(long.Parse(service_id));
}
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
ticketLabour = new sdk_work_entry_dal().FindNoDeleteById(long.Parse(id));
if (ticketLabour != null)
{
isAdd = false;
thisTicket = new sdk_task_dal().FindNoDeleteById(ticketLabour.task_id);
if (ticketLabour.resource_id != null)
{
resource_id.SelectedValue = ((long)ticketLabour.resource_id).ToString();
}
if (ticketLabour.cost_code_id != null)
{
cost_code_id.ClearSelection();
cost_code_id.SelectedValue = ticketLabour.cost_code_id.ToString();
}
if (ticketLabour.role_id != null)
{
role_id.SelectedValue = ticketLabour.role_id.ToString();
}
if (ticketLabour.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)ticketLabour.contract_id);
}
}
}
if (thisTicket != null)
{
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
if (!isComplete)
{
status_id.SelectedValue = (thisTicket.status_id).ToString();
}
else
{
status_id.SelectedValue = ((int)DicEnum.TICKET_STATUS.DONE).ToString();
}
}
else
{
Response.Write("<script>alert('未查询到该工单信息！');window.close();</script>");
}
if (thisAccount != null)
{
accAlert = new crm_account_alert_dal().FindAlert(thisAccount.id, DicEnum.ACCOUNT_ALERT_TYPE.COMPANY_DETAIL_ALERT);
}
}
catch (Exception msg)
{
Response.Write("<script>alert('" + msg.Message + "');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
thisTask = new sdk_task_dal().FindNoDeleteById(long.Parse(id));
if (thisTask != null && thisTask.project_id != null)
{
thisBookMark = new IndexBLL().GetSingBook(Request.Url.LocalPath + "?id=" + id, LoginUserId);
tvbDto.Add(new DictionaryEntryDto("type", "类型", 0));
tvbDto.Add(new DictionaryEntryDto("time", "操作时间", 0));
tvbDto.Add(new DictionaryEntryDto("resouName", "员工", 0));
tvbDto.Add(new DictionaryEntryDto("workHours", "实际工作时间", 0));
tvbDto.Add(new DictionaryEntryDto("notTiltle", "说明/标题", 0));
tvbDto.Add(new DictionaryEntryDto("billabled", "是否计费", 0));
tvbDto.Add(new DictionaryEntryDto("billed", "已计费", 0));
expDto.Add(new DictionaryEntryDto("type_id", "类型", 0));
expDto.Add(new DictionaryEntryDto("add_date", "费用日期", 0));
expDto.Add(new DictionaryEntryDto("create_user_id", "创建人", 0));
expDto.Add(new DictionaryEntryDto("expense_cost_code_id", "费用类别", 0));
expDto.Add(new DictionaryEntryDto("amount", "总额", 0));
expDto.Add(new DictionaryEntryDto("is_billable", "计费的", 0));
expDto.Add(new DictionaryEntryDto("approve_and_post_user_id", "已计费", 0));
v_task = new v_task_all_dal().FindById(thisTask.id);
if (thisTask.type_id == (int)DicEnum.TASK_TYPE.PROJECT_ISSUE)
{
taskType = "问题";
}
else if (thisTask.type_id == (int)DicEnum.TASK_TYPE.PROJECT_TASK)
{
taskType = "任务";
}
else
{
Response.End();
}
#region 记录浏览历史
var account = new CompanyBLL().GetCompany(thisTask.account_id);
var history = new sys_windows_history()
{
title = $"查看{taskType}:" + (thisProject != null ? thisProject.name : "") + " " + thisTask.title + " " + (account != null ? account.name : ""),
url = Request.RawUrl,
};
new IndexBLL().BrowseHistory(history, LoginUserId);
#endregion
thisProject = new pro_project_dal().FindNoDeleteById((long)thisTask.project_id);
if (thisProject != null)
{
thisAccount = new crm_account_dal().FindNoDeleteById(thisProject.account_id);
if (thisProject.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisProject.contract_id);
}
}
thisTaskResList = new sdk_task_resource_dal().GetTaskResByTaskId(thisTask.id);
var roleList = dic.FirstOrDefault(_ => _.Key == "role").Value as List <sys_role>;
var sysList = dic.FirstOrDefault(_ => _.Key == "sys_resource").Value as List <DictionaryEntryDto>;
#region 工时备注附件
var tasEntryList = new sdk_work_entry_dal().GetByTaskId(thisTask.id);
if (tasEntryList != null && tasEntryList.Count > 0)
{
var newList = (from a in tasEntryList
join b in roleList on a.role_id equals b.id
join c in sysList on a.resource_id equals long.Parse(c.val)
select new TaskViewDto {
id = a.id, type = "entry", time = Tools.Date.DateHelper.ConvertStringToDateTime((long)(a.end_time ?? a.start_time)), resouName = c.show + "(" + b.name + ")", workHours = a.hours_worked, notTiltle = a.summary_notes, billabled = a.is_billable == 1?"✓":"", billed = a.approve_and_post_date == null?"": "✓", startDate = Tools.Date.DateHelper.ConvertStringToDateTime((long)a.start_time), workTypeId = a.cost_code_id, contractId = a.contract_id, showOnInv = a.show_on_invoice == 1, serviceId = a.service_id
}).ToList();
tvdList.AddRange(newList);
}
var conAttDal = new com_attachment_dal();
var allTaskAttList = new List <com_attachment>();
var taskNoteList = new com_activity_dal().GetActiList($" and (task_id ={thisTask.id} or object_id={thisTask.id} )");
if (taskNoteList != null && taskNoteList.Count > 0)
{
var newList = (from a in taskNoteList
join c in sysList on a.resource_id equals long.Parse(c.val) into temp
from tt in temp.DefaultIfEmpty()
select new TaskViewDto {
id = a.id, type = "note", time = Tools.Date.DateHelper.ConvertStringToDateTime(a.create_time), resouName = tt == null ? "" : tt.show, notTiltle = a.name, noteDescr = a.description
}).ToList();
tvdList.AddRange(newList);
foreach (var thisTaskNote in taskNoteList)
{
var thisNoteAttList = conAttDal.GetAttListByOid(thisTaskNote.id);
if (thisNoteAttList != null && thisNoteAttList.Count > 0)
{
allTaskAttList.AddRange(thisNoteAttList);
}
}
}
var taskAttList = conAttDal.GetAttListByOid(thisTask.id);
if (taskAttList != null && taskAttList.Count > 0)
{
allTaskAttList.AddRange(taskAttList);
}
if (allTaskAttList.Count > 0)
{
var newList = (from a in allTaskAttList
join c in sysList on a.create_user_id equals long.Parse(c.val) into temp
from tt in temp.DefaultIfEmpty()
select new TaskViewDto {
id = a.id, type = "atach", time = Tools.Date.DateHelper.ConvertStringToDateTime(a.create_time), resouName = tt == null?"":tt.show, notTiltle = a.title, fileType = a.type_id
}).ToList();
tvdList.AddRange(newList);
}
if (tvdList != null && tvdList.Count > 0)
{
tvbOrder = Request.QueryString["tvbOrder"];
tvdList = tvdList.OrderBy(_ => _.time).ToList();
if (!string.IsNullOrEmpty(tvbOrder))
{
var tvbOrderArr = tvbOrder.Split(new char[] { '_' }, StringSplitOptions.RemoveEmptyEntries);
var orderFile = tvbDto.FirstOrDefault(_ => _.val == tvbOrderArr[0]);
if (tvbOrderArr[1] == "desc")
{
//tvdList = (from a in tvdList
// orderby tvbOrderArr[0] descending
// select a).ToList();
tvdList.Sort(delegate(TaskViewDto t1, TaskViewDto t2) {
return(GetObjectPropertyValue(t2, tvbOrderArr[0]).CompareTo(GetObjectPropertyValue(t1, tvbOrderArr[0])));
});
orderFile.select = orderFile != null ? 2 : orderFile.select;
}
else
{
//tvdList = (from a in tvdList
// orderby tvbOrderArr[0]
// select a).ToList();
tvdList.Sort(delegate(TaskViewDto t1, TaskViewDto t2) {
return(GetObjectPropertyValue(t1, tvbOrderArr[0]).CompareTo(GetObjectPropertyValue(t2, tvbOrderArr[0])));
});
orderFile.select = orderFile != null ? 1 : orderFile.select;
}
}
}
#endregion
#region 费用
taskExpList = new sdk_expense_dal().GetExpByTaskId(thisTask.id);
if (taskExpList != null && taskExpList.Count > 0)
{
taskExpList = taskExpList.OrderByDescending(_ => _.add_date).ToList();
expOrder = Request.QueryString["expOrder"];
if (!string.IsNullOrEmpty(expOrder))
{
var expOrderArr = expOrder.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var orderFile = expDto.FirstOrDefault(_ => _.val == expOrderArr[0]);
if (expOrderArr[1] == "desc")
{
//taskExpList = (from a in taskExpList
// orderby expOrderArr[0] descending
// select a).ToList();
taskExpList.Sort(delegate(sdk_expense t1, sdk_expense t2) {
return(GetObjectPropertyValue(t2, expOrderArr[0]).CompareTo(GetObjectPropertyValue(t1, expOrderArr[0])));
});
orderFile.select = orderFile != null ? 2 : orderFile.select;
}
else
{
//taskExpList = (from a in taskExpList
// orderby expOrderArr[0]
// select a).ToList();
taskExpList.Sort(delegate(sdk_expense t1, sdk_expense t2) {
return(GetObjectPropertyValue(t1, expOrderArr[0]).CompareTo(GetObjectPropertyValue(t2, expOrderArr[0])));
});
orderFile.select = orderFile != null ? 1 : orderFile.select;
}
}
}
#endregion
}
else
{
Response.End();
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var ticketIds = Request.QueryString["ticketIds"];
var sdDal = new sdk_task_dal();
if (!string.IsNullOrEmpty(ticketIds))
{
ticketList = sdDal.GetTicketByIds(ticketIds);
}
if (ticketList != null && ticketList.Count > 0)
{
if (ticketList.Count == 1)
{
isSingle = true;
}
else
{
isSingle = false;
}
thisTicket = ticketList[0];
}
else
{
Response.Write("<script>alert('未查询到相关工单信息！');window.close();</script>");
return;
}
var udfBLL = new UserDefinedFieldsBLL();
if (thisTicket == null)
{
Response.Write("<script>alert('未查询到相关工单信息！');window.close();</script>");
}
else
{
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
thisUser = new sys_resource_dal().FindNoDeleteById(LoginUserId);
#region 获取相关属性是否可以更改
if (ticketList.Any(_ => _.id != thisTicket.id))
{
isManyTitle = true;
}
else
{
isManyTitle = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id))
{
isManydesc = true;
}
else
{
isManydesc = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.department_id != thisTicket.department_id))
{
isManyDep = true;
}
else
{
isManyDep = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.issue_type_id != thisTicket.issue_type_id))
{
isManyissType = true;
}
else
{
isManyissType = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && (_.owner_resource_id != thisTicket.owner_resource_id && _.role_id != thisTicket.role_id)))
{
isManyPri = true;
}
else
{
isManyPri = false;
if (thisTicket.owner_resource_id != null && thisTicket.role_id != null)
{
thisPriRes = new sys_resource_dal().FindNoDeleteById((long)thisTicket.owner_resource_id);
thisRole = new sys_role_dal().FindNoDeleteById((long)thisTicket.role_id);
var resDepList = new sys_resource_department_dal().GetResDepByResAndRole((long)thisTicket.owner_resource_id, (long)thisTicket.role_id);
if (resDepList != null && resDepList.Count > 0)
{
proResDep = resDepList[0];
}
}
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.cate_id != thisTicket.cate_id))
{
isManyTicketCate = true;
}
else
{
isManyTicketCate = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.estimated_hours != thisTicket.estimated_hours))
{
isManyEstHour = true;
}
else
{
isManyEstHour = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.estimated_end_time != thisTicket.estimated_end_time))
{
isManyDueTime = true;
}
else
{
isManyDueTime = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.account_id != thisTicket.account_id))
{
isManyAccount = true;
}
else
{
isManyAccount = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.contract_id != thisTicket.contract_id))
{
isManyContract = true;
}
else
{
isManyContract = false;
if (thisTicket.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisTicket.contract_id);
}
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.status_id != thisTicket.status_id))
{
isManyStatus = true;
}
else
{
isManyStatus = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.service_id != thisTicket.service_id))
{
isManySerivce = true;
}
else
{
isManySerivce = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.priority_type_id != thisTicket.priority_type_id))
{
isManyPrio = true;
}
else
{
isManyPrio = false;
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.cost_code_id != thisTicket.cost_code_id))
{
isManyWork = true;
}
else
{
isManyWork = false;
if (thisTicket.cost_code_id != null)
{
thisWorkType = new d_cost_code_dal().FindNoDeleteById((long)thisTicket.cost_code_id);
}
}
if (ticketList.Any(_ => _.id != thisTicket.id && _.sub_issue_type_id != thisTicket.sub_issue_type_id))
{
isManySubIssType = true;
}
else
{
isManySubIssType = false;
}
// protected bool isManyStatus;
#endregion
udfValue = udfBLL.GetUdfValue(DicEnum.UDF_CATE.TASK, thisTicket.id, udfTaskPara);
if (udfTaskPara != null && udfTaskPara.Count > 0)
{
foreach (var udfTask in udfTaskPara)
{
var thisValue = "";
if (udfValue.FirstOrDefault(_ => _.id == udfTask.id) != null)
{
thisValue = udfValue.FirstOrDefault(_ => _.id == udfTask.id).value.ToString();
}
var count = new UserDefinedFieldsBLL().GetSameValueCount(DicEnum.UDF_CATE.TASK, ticketIds, udfTask.col_name, thisValue.ToString());
if (count > 1 && (!isSingle))
{
udfValue.FirstOrDefault(_ => _.id == udfTask.id).value = "多个值-保持不变";
}
}
}
var otherResList = new sdk_task_resource_dal().GetTaskResByTaskId(thisTicket.id);
if (otherResList != null && otherResList.Count > 0)
{
foreach (var item in otherResList)
{
if (item.resource_id != null && item.role_id != null)
{
var resDepList = new sys_resource_department_dal().GetResDepByResAndRole((long)item.resource_id, (long)item.role_id);
if (resDepList != null && resDepList.Count > 0)
{
ticketResIds += resDepList[0].id + ",";
}
}
}
if (ticketResIds != "")
{
ticketResIds = ticketResIds.Substring(0, ticketResIds.Length - 1);
}
}
}
if (IsPostBack)
{
var stDal = new sdk_task_dal();
var ticBll = new TicketBLL();
var accBll = new CompanyBLL();
var notiResIds = new System.Text.StringBuilder();
foreach (var tic in ticketList)
{
var ticket = stDal.FindNoDeleteById(tic.id);
if (ticket == null)
{
continue;
}
var user = UserInfoBLL.GetUserInfo(LoginUserId);
#region 获取相关参数
#region 标题，描述，队列，主负责人
var pageTitle = ticket.title;
if (!isManyTitle)
{
pageTitle = Request.Form["title"];
}
var pageDesc = ticket.description;
if (!isManydesc)
{
pageDesc = Request.Form["description"];
}
var pageDepIdString = Request.Form["department_id"];
var pagePriResIdString = Request.Form["pri_res"];
if (string.IsNullOrEmpty(pageDepIdString) && string.IsNullOrEmpty(pagePriResIdString))
{
Response.Write("<script>alert('队列和主负责人请填写其中一项！');</script>");
return;
}
long?pageDepId;
if (!string.IsNullOrEmpty(pageDepIdString) && pageDepIdString != "0")
{
pageDepId = long.Parse(pageDepIdString);
}
else if (string.IsNullOrEmpty(pageDepIdString))
{
pageDepId = null;
}
else
{
pageDepId = ticket.department_id;
}
long?pagePriResId;
if (!string.IsNullOrEmpty(pagePriResIdString) && pagePriResIdString != "0")
{
pagePriResId = long.Parse(pagePriResIdString);
}
else if (string.IsNullOrEmpty(pagePriResIdString))
{
pagePriResId = null;
}
else
{
pagePriResId = ticket.owner_resource_id;
}
#endregion
#region 种类,预估时间，到期时间，合同名称
var pageCateId = ticket.cate_id;
var pageCateIdString = Request.Form["ticket_cate"];
if (!string.IsNullOrEmpty(pageCateIdString) && pageCateIdString != "0")
{
pageCateId = int.Parse(pageCateIdString);
}
else if (string.IsNullOrEmpty(pagePriResIdString))
{
Response.Write("<script>alert('请选择工单种类！');</script>");
return;
}
else
{
pageCateId = ticket.cate_id;
}
var estHours = ticket.estimated_hours;
var pageEstHours = Request.Form["est_hours"];
if (!string.IsNullOrEmpty(pageEstHours) && pageEstHours.Trim() != "多个值-保持不变")
{
estHours = decimal.Parse(pageEstHours);
}
var dueTime = ticket.estimated_end_time;
var pageDueTime = Request.Form["due_time"];
if (!string.IsNullOrEmpty(pageDueTime) && pageDueTime.Trim() != "多个值-保持不变")
{
dueTime = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Parse(pageDueTime));
}
var contractName = ticket.contract_id;
var pageContract = Request.Form["contractName"];
if (!string.IsNullOrEmpty(pageContract) && pageContract != "0")
{
contractName = long.Parse(pageContract);
}
else if (string.IsNullOrEmpty(pageContract))
{
contractName = null;
}
#endregion
#region 状态，服务包，优先级，工作类型，问题类型，子问题类型
var pageStatusId = ticket.status_id;
var pageStuatusIdString = Request.Form["statusId"];
if (!string.IsNullOrEmpty(pageStuatusIdString) && pageStuatusIdString != "0")
{
pageStatusId = int.Parse(pageStuatusIdString);
}
else if (string.IsNullOrEmpty(pageStuatusIdString))
{
Response.Write("<script>alert('请选择工单状态！');</script>");
return;
}
var pageServiceId = ticket.service_id;
var pageServiceIdString = Request.Form["serviceId"];
if (!string.IsNullOrEmpty(pageServiceIdString) && pageServiceIdString != "0")
{
pageServiceId = int.Parse(pageServiceIdString);
}
else if (string.IsNullOrEmpty(pageServiceIdString))
{
pageServiceId = null;
}
var pagePrioId = ticket.priority_type_id;
var pagePrioIdString = Request.Form["priorityId"];
if (!string.IsNullOrEmpty(pagePrioIdString) && pagePrioIdString != "0")
{
pagePrioId = int.Parse(pagePrioIdString);
}
else if (string.IsNullOrEmpty(pagePrioIdString))
{
Response.Write("<script>alert('请选择工单优先级！');</script>");
return;
}
var workTypeId = ticket.cost_code_id;
var pageWorkTypeId = Request.Form["workTypeId"];
if (!string.IsNullOrEmpty(pageWorkTypeId) && pageWorkTypeId != "0")
{
workTypeId = long.Parse(pageWorkTypeId);
}
else if (string.IsNullOrEmpty(pageWorkTypeId))
{
contractName = null;
}
var pageIssId = ticket.issue_type_id;
var pageIssIdString = Request.Form["IssueType"];
if (!string.IsNullOrEmpty(pageIssIdString) && pageIssIdString != "0")
{
pageIssId = int.Parse(pageIssIdString);
}
else if (string.IsNullOrEmpty(pageIssIdString))
{
Response.Write("<script>alert('请选择问题类型！');</script>");
return;
}
var pageSubIssId = ticket.sub_issue_type_id;
var pageSubIssIdString = Request.Form["SubIssueType"];
if (!string.IsNullOrEmpty(pageSubIssIdString) && pageSubIssIdString != "0")
{
pageSubIssId = int.Parse(pageSubIssIdString);
}
else if (string.IsNullOrEmpty(pageSubIssIdString))
{
Response.Write("<script>alert('请选择子问题类型！');</script>");
return;
}
#endregion
#region 自定义字段相关
var thisUdfValue = udfBLL.GetUdfValue(DicEnum.UDF_CATE.TASK, tic.id, udfTaskPara);
if (udfTaskPara != null && udfTaskPara.Count > 0)
{
var list = new List <UserDefinedFieldValue>();
foreach (var udf in udfTaskPara)
{
var new_udf = new UserDefinedFieldValue()
{
id = udf.id
};
var thisvv = Request.Form[udf.id.ToString()];
if (udf.data_type == (int)DicEnum.UDF_DATA_TYPE.LIST)
{
if (thisvv == "0")
{
new_udf.value = thisUdfValue.FirstOrDefault(_ => _.id == udf.id) == null ? "" : thisUdfValue.FirstOrDefault(_ => _.id == udf.id).value;
}
else
{
new_udf.value = thisvv == "" ? null : thisvv;
}
}
else
{
if (thisvv == "多个值-保持不变")
{
new_udf.value = thisUdfValue.FirstOrDefault(_ => _.id == udf.id) == null ? "" : thisUdfValue.FirstOrDefault(_ => _.id == udf.id).value;
}
else
{
new_udf.value = thisvv == "" ? null : thisvv;
}
}
list.Add(new_udf);
}
udfBLL.UpdateUdfValue(DicEnum.UDF_CATE.TASK, udfTaskPara, ticket.id, list, user, DicEnum.OPER_LOG_OBJ_CATE.PROJECT_TASK);
}
#endregion
#endregion
#region 修改工单
ticket.title = pageTitle;
ticket.description = pageDesc;
ticket.department_id = pageDepId;
long?roleId = null;
if (pagePriResId != null)
{
var resDep = new sys_resource_department_dal().FindById((long)pagePriResId);
if (resDep != null)
{
pagePriResId = resDep.resource_id;
roleId = resDep.role_id;
}
else
{
pagePriResId = null;
roleId = null;
}
}
ticket.owner_resource_id = pagePriResId;
ticket.role_id = roleId;
ticket.cate_id = pageCateId;
ticket.estimated_hours = estHours;
ticket.estimated_end_time = dueTime;
ticket.contract_id = contractName;
ticket.status_id = pageStatusId;
ticket.service_id = pageServiceId;
ticket.priority_type_id = pagePrioId;
ticket.cost_code_id = workTypeId;
ticket.issue_type_id = pageIssId;
ticket.sub_issue_type_id = pageSubIssId;
ticBll.EditTicket(ticket, LoginUserId);
#endregion
#region 生成备注
ticBll.AddModifyTicketNote(ticket.id, LoginUserId);
#endregion
#region 单个工单时 修改其他员工相关
if (isSingle)
{
var OtherResId = Request.Form["OtherResId"];
ticBll.TicketResManage(ticket.id, OtherResId, LoginUserId);
}
#endregion
#region 获取需要发送邮件的员工的Id
if (CkPriRes.Checked && ticket.owner_resource_id != null)
{
notiResIds.Append(ticket.owner_resource_id + ",");
}
if (CKcreate.Checked)
{
notiResIds.Append(ticket.create_user_id + ",");
}
if (CKaccMan.Checked)
{
var thisAccount = accBll.GetCompany(ticket.account_id);
if (thisAccount != null && thisAccount.resource_id != null)
{
notiResIds.Append(thisAccount.resource_id + ",");
}
}
#endregion
}
#region 通知相关
if (CCMe.Checked)
{
notiResIds.Append(LoginUserId + ",");
}
var resIds = Request.Form["resIds"];
if (!string.IsNullOrEmpty(resIds))
{
notiResIds.Append(resIds + ",");
}
var notify_id = Request.Form["notify_id"];
if (!string.IsNullOrEmpty(notify_id) && notify_id != "0")
{
}
#endregion
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script>alert('保存成功');self.opener.location.reload();window.close();</script>");
}
}
catch (Exception msg)
{
Response.Write("<script>alert('" + msg.Message + "！');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
long id = 0;
if (!string.IsNullOrEmpty(Request.QueryString["id"]) && long.TryParse(Request.QueryString["id"], out id))
{
deduction = invBll.GetDeduction(id);
}
//if (deduction == null)
//{
// Response.Write("<script>alert('未获取到相关条目');window.close();</script>");
//}
long blockId = 0;
if (!string.IsNullOrEmpty(Request.QueryString["blockId"]) && long.TryParse(Request.QueryString["blockId"], out blockId))
{
block = new ContractBlockBLL().GetBlockById(blockId);
}
if (deduction != null)
{
vItem = new DAL.v_widget_posted_item_dal().FindById(deduction.id);
rate = vItem?.rate;
account = new CompanyBLL().GetCompany(deduction.account_id);
if (deduction.contract_id != null)
{
contract = new ContractBLL().GetContract((long)deduction.contract_id);
}
if (deduction.task_id != null)
{
task = new TicketBLL().GetTask((long)deduction.task_id);
}
labour = new WorkEntryBLL().GetEntryById((long)deduction.object_id);
if (vItem?.tax_category_id != null && vItem?.tax_region_id != null)
{
var thisTax = new DAL.d_tax_region_cate_dal().GetSingleTax((long)vItem?.tax_region_id, (long)vItem?.tax_category_id);
taxRate = thisTax?.total_effective_tax_rate;
}
if (vItem?.resource_id != null)
{
resource = new UserResourceBLL().GetResourceById((long)vItem.resource_id);
}
if (deduction.contract_block_id != null)
{
dedBlock = new ContractBlockBLL().GetBlockById((long)deduction.contract_block_id);
}
}
if (block != null)
{
contract = new ContractBLL().GetContract(block.contract_id);
if (contract != null)
{
account = new CompanyBLL().GetCompany(contract.account_id);
contractType = new GeneralBLL().GetSingleGeneral(contract.type_id);
}
}
if (block == null && deduction == null)
{
Response.Write("<script>alert('未获取到相关条目');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
thisUser = new sys_resource_dal().FindNoDeleteById(GetLoginUserId());
var caDal = new com_activity_dal();
var stDal = new sdk_task_dal();
var ppDal = new pro_project_dal();
var accDal = new crm_account_dal();
var ccDal = new ctt_contract_dal();
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisNote = caDal.FindNoDeleteById(long.Parse(id));
if (thisNote != null)
{
isAdd = false;
thisNoteAtt = new com_attachment_dal().GetAttListByOid(thisNote.id);
thisTicket = stDal.FindNoDeleteById(thisNote.object_id);
if (thisTicket != null)
{
object_id = thisTicket.id;
}
else
{
thisProject = ppDal.FindNoDeleteById(thisNote.object_id);
if (thisProject != null)
{
object_id = thisProject.id;
thisAccount = accDal.FindNoDeleteById(thisProject.account_id);
}
else
{
thisContract = ccDal.FindNoDeleteById(thisNote.object_id);
if (thisContract != null)
{
object_id = thisContract.id;
thisAccount = accDal.FindNoDeleteById(thisContract.account_id);
}
}
}
}
}
var ticketId = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(ticketId))
{
thisTicket = stDal.FindNoDeleteById(long.Parse(ticketId));
}
if (thisTicket != null)
{
object_id = thisTicket.id;
if (thisTicket.type_id == (int)DicEnum.TASK_TYPE.PROJECT_PHASE)
{
// isPhase = true;
}
if (thisTicket.contact_id != null)
{
thisContact = new crm_contact_dal().FindNoDeleteById((long)thisTicket.contact_id);
}
thisAccount = accDal.FindNoDeleteById(thisTicket.account_id);
ticket_creator = new sys_resource_dal().FindNoDeleteById(thisTicket.create_user_id);
if (!IsPostBack)
{
//status_id.SelectedValue = thisTicket.status_id.ToString();
}
if (thisTicket.project_id != null)
{
thisProject = ppDal.FindNoDeleteById((long)thisTicket.project_id);
if (thisProject != null && thisAccount != null)
{
thisAccount = accDal.FindNoDeleteById(thisProject.account_id);
}
}
}
if (thisAccount == null)
{
Response.End();
}
else
{
if (thisAccount.resource_id != null)
{
thisAccManger = new sys_resource_dal().FindNoDeleteById((long)thisAccount.resource_id);
}
}
if (!IsPostBack)
{
publish_type_id.DataTextField = "name";
publish_type_id.DataValueField = "id";
var pushList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.NOTE_PUBLISH_TYPE);
if (pushList != null && pushList.Count > 0)
{
pushList = pushList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TICKET_NOTE).ToString()).ToList();
}
publish_type_id.DataSource = pushList;
publish_type_id.DataBind();
status_id.DataTextField = "show";
status_id.DataValueField = "val";
status_id.DataSource = dic.FirstOrDefault(_ => _.Key == "ticket_status").Value;
status_id.DataBind();
if (thisTicket != null)
{
status_id.SelectedValue = thisTicket.status_id.ToString();
}
action_type_id.DataTextField = "name";
action_type_id.DataValueField = "id";
var actList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.ACTION_TYPE);
actList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
action_type_id.DataSource = actList;
action_type_id.DataBind();
if (thisNote != null)
{
if (!IsPostBack)
{
if (thisNote.publish_type_id != null)
{
publish_type_id.SelectedValue = thisNote.publish_type_id.ToString();
}
action_type_id.SelectedValue = thisNote.action_type_id.ToString();
}
}
//else
//{
// if (isContract)
// {
// publish_type_id.SelectedValue = ((int)DicEnum.NOTE_PUBLISH_TYPE.CONTRACT_INTERNA_USER).ToString();
// }
//}
var tempList = new sys_notify_tmpl_dal().GetTempByEvent(DicEnum.NOTIFY_EVENT.NONE);
notify_id.DataTextField = "name";
notify_id.DataValueField = "id";
notify_id.DataSource = tempList;
notify_id.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var taskId = Request.QueryString["id"];
if (!string.IsNullOrEmpty(taskId))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(taskId));
if (thisTicket != null)
{
isAdd = false;
thisBookMark = new IndexBLL().GetSingBook(Request.Url.LocalPath + "?id=" + taskId, LoginUserId);
ticketUdfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.TASK, thisTicket.id, tickUdfList);
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
if (thisTicket.contact_id != null)
{
thisContact = new crm_contact_dal().FindNoDeleteById((long)thisTicket.contact_id);
}
if (thisTicket.owner_resource_id != null && thisTicket.role_id != null)
{
var resDepList = new sys_resource_department_dal().GetResDepByResAndRole((long)thisTicket.owner_resource_id, (long)thisTicket.role_id);
if (resDepList != null && resDepList.Count > 0)
{
proResDep = resDepList[0];
priRes = new sys_resource_dal().FindNoDeleteById((long)thisTicket.owner_resource_id);
}
}
if (thisTicket.installed_product_id != null)
{
insPro = new crm_installed_product_dal().FindNoDeleteById((long)thisTicket.installed_product_id);
}
if (thisTicket.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisTicket.contract_id);
}
if (thisTicket.cost_code_id != null)
{
thisCostCode = new d_cost_code_dal().FindNoDeleteById((long)thisTicket.cost_code_id);
}
ticketCheckList = new sdk_task_checklist_dal().GetCheckByTask(thisTicket.id);
if (ticketCheckList != null && ticketCheckList.Count > 0)
{
ticketCheckList = ticketCheckList.OrderBy(_ => _.sort_order).ToList();
}
entryList = new sdk_work_entry_dal().GetList(thisTicket.id);
var otherResList = new sdk_task_resource_dal().GetTaskResByTaskId(thisTicket.id);
if (otherResList != null && otherResList.Count > 0)
{
ticketResList = new List <sys_resource_department>();
var srdDal = new sys_resource_department_dal();
foreach (var resRole in otherResList)
{
if (resRole.resource_id == null || resRole.role_id == null)
{
continue;
}
var thisResDep = srdDal.GetResDepByResAndRole((long)resRole.resource_id, (long)resRole.role_id);
if (thisResDep != null && thisResDep.Count > 0)
{
ticketResList.Add(thisResDep[0]);
}
}
}
if (thisTicket.service_id != null)
{
thisService = new ivt_service_dal().FindNoDeleteById((long)thisTicket.service_id);
if (thisService == null)
{
thisServiceBun = new ivt_service_bundle_dal().FindNoDeleteById((long)thisTicket.service_id);
}
}
createRes = new sys_resource_dal().FindNoDeleteById(thisTicket.create_user_id);
var slaValue = new sdk_task_dal().GetSlaTime(thisTicket);
string slaTimeValue = "";
if (slaValue != null)
{
slaTimeValue = slaValue.ToString();
}
if (!string.IsNullOrEmpty(slaTimeValue))
{
if (slaTimeValue.Substring(0, 1) == "{")
{
slaDic = new EMT.Tools.Serialize().JsonToDictionary(slaTimeValue);
}
}
var actList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.ACTION_TYPE);
if (actList != null && actList.Count > 0)
{
ticketNoteTypeList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
}
ticketOther = new sdk_task_other_dal().GetTicketOther(thisTicket.id);
ticketOtherList = new sdk_task_other_person_dal().GetTicketOther(thisTicket.id);
}
}
var ticketIds = Request.QueryString["ids"];
if (!string.IsNullOrEmpty(ticketIds))
{
pageTicketList = new sdk_task_dal().GetTicketByIds(ticketIds);
}
if (thisTicket == null)
{
Response.Write("<script>alert('未查询到该工单信息！');window.close();</script>");
return;
}
var history = new sys_windows_history()
{
title = "工单:" + thisTicket.no + ":" + thisTicket.title,
url = Request.RawUrl,
};
new IndexBLL().BrowseHistory(history, LoginUserId);
}
catch (Exception msg)
{
Response.Write("<script>alert('" + msg.Message + "');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
if (!IsPostBack)
{
Bind(); // 绑定页面下拉数据
}
if (noteTypeList != null && noteTypeList.Count > 0)
{
noteTypeList = noteTypeList.Where(_ => _.ext2 == ((int)DicEnum.TASK_TYPE.RECURRING_TICKET_MASTER).ToString()).ToList();
}
if (publishList != null && publishList.Count > 0)
{
publishList = publishList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TICKET_NOTE).ToString()).ToList();
}
var ticketId = Request.QueryString["id"];
if (!string.IsNullOrEmpty(ticketId))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticketId));
}
if (thisTicket != null)
{
isAdd = false;
objectId = thisTicket.id;
#region 获取工单基本信息
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
if (thisTicket.contact_id != null)
{
thisContact = new crm_contact_dal().FindNoDeleteById((long)thisTicket.contact_id);
}
if (thisTicket.owner_resource_id != null && thisTicket.role_id != null)
{
priRes = new sys_resource_dal().FindNoDeleteById((long)thisTicket.owner_resource_id);
thisRole = new sys_role_dal().FindNoDeleteById((long)thisTicket.role_id);
var resDepList = new sys_resource_department_dal().GetResDepByResAndRole((long)thisTicket.owner_resource_id, (long)thisTicket.role_id);
if (resDepList != null && resDepList.Count > 0)
{
proResDep = resDepList[0];
}
}
if (thisTicket.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisTicket.contract_id);
}
status_id.SelectedValue = thisTicket.status_id.ToString();
if (thisTicket.priority_type_id != null)
{
priority_type_id.SelectedValue = thisTicket.priority_type_id.ToString();
}
if (thisTicket.issue_type_id != null)
{
issue_type_id.SelectedValue = thisTicket.issue_type_id.ToString();
}
if (thisTicket.source_type_id != null)
{
source_type_id.SelectedValue = thisTicket.source_type_id.ToString();
}
if (thisTicket.cate_id != null)
{
cate_id.SelectedValue = thisTicket.cate_id.ToString();
}
if (thisTicket.cost_code_id != null)
{
cost_code_id.SelectedValue = thisTicket.cost_code_id.ToString();
}
if (thisTicket.department_id != null)
{
department_id.SelectedValue = thisTicket.department_id.ToString();
}
if (thisTicket.installed_product_id != null)
{
insPro = new crm_installed_product_dal().FindNoDeleteById((long)thisTicket.installed_product_id);
}
if (insPro != null)
{
thisProduct = new ivt_product_dal().FindNoDeleteById(insPro.product_id);
}
#endregion
#region 获取工单周期信息
thisticketRes = new sdk_recurring_ticket_dal().GetByTicketId(thisTicket.id);
#endregion
ticketUdfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.TASK, thisTicket.id, tickUdfList);
#region 记录浏览历史
var history = new sys_windows_history()
{
title = $"编辑定期服务主工单：" + thisTicket.no + " " + thisTicket.title + " " + (thisAccount != null ? thisAccount.name : ""),
url = Request.RawUrl,
};
new IndexBLL().BrowseHistory(history, LoginUserId);
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
var callId = Request.QueryString["callId"];
var tickeTId = Request.QueryString["ticketId"];
if (!string.IsNullOrEmpty(callId))
{
thisCall = new sdk_service_call_dal().FindNoDeleteById(long.Parse(callId));
}
if (!string.IsNullOrEmpty(tickeTId))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(tickeTId));
}
if (thisTicket != null)
{
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
if (thisTicket.contact_id != null)
{
ticketCon = new crm_contact_dal().FindNoDeleteById((long)thisTicket.contact_id);
}
resList = new List <sys_resource>();
var srDal = new sys_resource_dal();
if (thisTicket.owner_resource_id != null)
{
var priRes = srDal.FindNoDeleteById((long)thisTicket.owner_resource_id);
if (priRes != null)
{
resList.Add(priRes);
}
}
var other = srDal.GetResByTicket(thisTicket.id);
if (other != null && other.Count > 0)
{
resList.AddRange(other);
}
}
if (thisCall != null && thisTicket != null)
{
thisCallTask = new sdk_service_call_task_dal().GetSingTaskCall(thisCall.id, thisTicket.id);
thisAccount = new CompanyBLL().GetCompany(thisCall.account_id);
}
var callTaskId = Request.Form["id"];
if (!string.IsNullOrEmpty(callTaskId))
{
thisCallTask = new sdk_service_call_task_dal().FindNoDeleteById(long.Parse(callTaskId));
}
if (thisCallTask != null)
{
isAdd = false;
serResList = new sdk_service_call_task_resource_dal().GetTaskResList(thisCallTask.id);
callCreater = new sys_resource_dal().FindNoDeleteById(thisCallTask.id);
}
var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (thisAccount != null)
{
if (thisAccount.resource_id != null)
{
accMan = new sys_resource_dal().FindNoDeleteById((long)thisAccount.resource_id);
}
accCallList = new sdk_service_call_dal().GetCallByAccount(thisAccount.id);
if (accCallList != null && accCallList.Count > 0)
{
pageCallList = (from a in accCallList
join b in statusList on a.status_id equals b.id
select new CallDto {
id = a.id, startDate = EMT.Tools.Date.DateHelper.ConvertStringToDateTime(a.start_time).ToString("yyyy-MM-dd HH:mm"), endDate = EMT.Tools.Date.DateHelper.ConvertStringToDateTime(a.end_time).ToString("yyyy-MM-dd HH:mm"), statusId = a.status_id, statusName = b.name, isLimtThri = (timeNow - a.start_time) > (2592000000)
}).ToList();
// 2592000000 = 30 * 24 * 60 * 60 * 1000 30天的毫秒数
}
}
else
{
Response.Write($"<script>alert('为获取到相关客户信息，请重新打开!');window.close();</script>");
return;
}
}
catch (Exception msg)
{
Response.Write($"<script>alert('{msg.Message}!');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var cost_id = Request.QueryString["id"];
var contract_id = Request.QueryString["contract_id"];
var project_id = Request.QueryString["project_id"];
var task_id = Request.QueryString["task_id"];
var ticket_id = Request.QueryString["ticket_id"];
var costCodeId = Request.QueryString["cost_code_id"];
if (!string.IsNullOrEmpty(costCodeId))
{
costCode = new d_cost_code_dal().FindNoDeleteById(long.Parse(costCodeId));
}
#region 拉框赋值
cost_type_id.DataTextField = "show";
cost_type_id.DataValueField = "val";
cost_type_id.DataSource = dic.FirstOrDefault(_ => _.Key == "chargeType").Value;
cost_type_id.DataBind();
cost_type_id.Items.Insert(0, new ListItem()
{
Value = "0", Text = " ", Selected = true
});
cost_type_id.SelectedValue = ((int)DicEnum.COST_TYPE.OPERATIONA).ToString();
// status_id
status_id.DataTextField = "show";
status_id.DataValueField = "val";
var statuList = dic.FirstOrDefault(_ => _.Key == "chargeStatus").Value as List <DictionaryEntryDto>;
#endregion
if (!string.IsNullOrEmpty(contract_id))
{
contract = new ctt_contract_dal().FindNoDeleteById(long.Parse(contract_id));
if (contract != null)
{
if (!IsPostBack)
{
isbillable.Checked = true;
}
}
}
if (!string.IsNullOrEmpty(cost_id))
{
conCost = new ctt_contract_cost_dal().FindNoDeleteById(long.Parse(cost_id));
if (conCost != null)
{
isAdd = false;
costCode = new d_cost_code_dal().FindNoDeleteById(conCost.cost_code_id);
cost_type_id.SelectedValue = conCost.cost_type_id == null ? ((int)DicEnum.COST_TYPE.OPERATIONA).ToString() : conCost.cost_type_id.ToString();
if (!IsPostBack)
{
status_id.SelectedValue = conCost.status_id.ToString();
}
if (conCost.contract_id != null)
{
contract = new ctt_contract_dal().FindNoDeleteById((long)conCost.contract_id);
}
if (conCost.project_id != null)
{
thisProject = new pro_project_dal().FindNoDeleteById((long)conCost.project_id);
}
if (conCost.task_id != null)
{
thisTask = new sdk_task_dal().FindNoDeleteById((long)conCost.task_id);
if (thisTask.type_id == (int)DicEnum.TASK_TYPE.SERVICE_DESK_TICKET)
{
thisTask = null;
thisTicket = new sdk_task_dal().FindNoDeleteById((long)conCost.task_id);
}
}
if (!IsPostBack)
{
isbillable.Checked = conCost.is_billable == 1;
AddConfigItem.Checked = conCost.create_ci == 1;
}
if (conCost.status_id == (int)DicEnum.COST_STATUS.UNDETERMINED)
{
statuList = statuList.Where(_ => _.val == (conCost.status_id).ToString() || _.val == ((int)DicEnum.COST_STATUS.PENDING_PURCHASE).ToString() || _.val == ((int)DicEnum.COST_STATUS.CANCELED).ToString()).ToList();
}
else if (conCost.status_id == (int)DicEnum.COST_STATUS.CANCELED)
{
statuList = statuList.Where(_ => _.val == (conCost.status_id).ToString() || _.val == ((int)DicEnum.COST_STATUS.PENDING_PURCHASE).ToString() || _.val == ((int)DicEnum.COST_STATUS.CANCELED).ToString()).ToList();
}
else
{
statuList = statuList.Where(_ => _.val == (conCost.status_id).ToString() || _.val == ((int)DicEnum.COST_STATUS.CANCELED).ToString()).ToList();
}
}
}
if (!string.IsNullOrEmpty(project_id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(project_id));
}
if (!string.IsNullOrEmpty(task_id))
{
thisTask = new sdk_task_dal().FindNoDeleteById(long.Parse(task_id));
if (thisTask != null && thisTask.project_id != null)
{
thisProject = new pro_project_dal().FindNoDeleteById((long)thisTask.project_id);
}
}
if (!string.IsNullOrEmpty(ticket_id))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticket_id));
}
if (thisTicket != null)
{
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
}
status_id.DataSource = statuList;
status_id.DataBind();
//status_id.Items.Insert(0, new ListItem() { Value = "0", Text = " ", Selected = true });
if (!IsPostBack)
{
if (isAdd)
{
status_id.SelectedValue = ((int)DicEnum.COST_STATUS.PENDING_DELIVERY).ToString();
}
}
}
catch (Exception msg)
{
Response.End();
}
}
protected bool isFromReport = false; // 是否从报表页面进行新增操作
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
PageDataBind();
}
isShowWorkType = new SysSettingBLL().GetValueById(SysSettingEnum.SDK_EXPENSE_SHOW_WORK_TYPE) == "1";// SDK_EXPENSE_SHOW_WORK_TYPE
var seDal = new sdk_expense_dal();
var stDal = new sdk_task_dal();
var eId = Request.QueryString["id"];
if (!string.IsNullOrEmpty(eId))
{
thisExpense = seDal.FindNoDeleteById(long.Parse(eId));
if (thisExpense != null)
{
if (thisExpense.approve_and_post_date != null || thisExpense.approve_and_post_user_id != null)
{
Response.Write("<script>alert('审批提交的费用不可以更改！')window.close();</script>");
Response.End();
}
if (!new TaskBLL().CanEditExpense(thisExpense.id))
{
Response.Write("<script>alert('相关报表状态已经更改，不可以进行编辑！');window.close();</script>");
Response.End();
}
isAdd = false;
if (!IsPostBack)
{
if (thisExpense.cost_code_id != null)
{
cost_code_id.SelectedValue = thisExpense.cost_code_id.ToString();
}
expense_cost_code_id.SelectedValue = thisExpense.expense_cost_code_id.ToString();
RDAddExiRep.Checked = true;
isBillable.Checked = thisExpense.is_billable == 1;
payment_type_id.SelectedValue = thisExpense.payment_type_id.ToString();
hasReceipt.Checked = thisExpense.has_receipt == 1;
if (thisExpense.project_id != null)
{
rbAssProTask.Checked = true;
}
else
{
rbAssNone.Checked = true;
}
}
if (thisExpense.project_id != null)
{
thisProject = new pro_project_dal().FindNoDeleteById((long)thisExpense.project_id);
}
if (thisExpense.project_id != null && thisExpense.task_id != null)
{
thisTask = new sdk_task_dal().FindNoDeleteById((long)thisExpense.task_id);
}
if (thisExpense.project_id == null && thisExpense.task_id != null)
{
thisTicket = new sdk_task_dal().FindNoDeleteById((long)thisExpense.task_id);
}
thisAccount = new crm_account_dal().FindNoDeleteById(thisExpense.account_id);
thisExpRep = new sdk_expense_report_dal().FindNoDeleteById(thisExpense.expense_report_id);
}
}
var task_id = Request.QueryString["task_id"];
if (!string.IsNullOrEmpty(task_id))
{
thisTask = stDal.FindNoDeleteById(long.Parse(task_id));
if (thisTask != null && thisTask.project_id != null)
{
thisProject = new pro_project_dal().FindNoDeleteById((long)thisTask.project_id);
if (thisProject != null)
{
thisAccount = new crm_account_dal().FindNoDeleteById(thisProject.account_id);
}
}
}
var project_id = Request.QueryString["project_id"];
if (!string.IsNullOrEmpty(project_id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(project_id));
if (thisProject != null)
{
thisAccount = new crm_account_dal().FindNoDeleteById(thisProject.account_id);
}
}
var report_id = Request.QueryString["report_id"];
if (!string.IsNullOrEmpty(report_id))
{
thisExpRep = new sdk_expense_report_dal().FindNoDeleteById(long.Parse(report_id));
if (thisExpRep != null)
{
isFromReport = true;
thisAccount = new CompanyBLL().GetDefaultAccount();
}
}
var ticket_id = Request.QueryString["ticket_id"];
if (!string.IsNullOrEmpty(ticket_id))
{
thisTicket = new sdk_task_dal().FindNoDeleteById(long.Parse(ticket_id));
if (thisTicket != null)
{
thisAccount = new CompanyBLL().GetCompany(thisTicket.account_id);
}
}
}
catch (Exception msg)
{
Response.End();
}
}
protected bool noTime = false; // 可以不输入开始结束时间（根据系统设置进行判断）
protected void Page_Load(object sender, EventArgs e)
{
try
{
// 是否需要输入开始结束时间
var isNeedTimeString = Request.QueryString["NoTime"];
var noTimeSet = new SysSettingBLL().GetSetById(SysSettingEnum.SDK_ENTRY_REQUIRED);
if (!string.IsNullOrEmpty(isNeedTimeString))
{
if (noTimeSet != null && noTimeSet.setting_value == "0")
{
noTime = true;
}
}
var callId = Request.QueryString["callId"];
if (!string.IsNullOrEmpty(callId))
{
thisCall = new sdk_service_call_dal().FindNoDeleteById(long.Parse(callId));
}
thisUser = new sys_resource_dal().FindNoDeleteById(GetLoginUserId());
var resList = dic.FirstOrDefault(_ => _.Key == "sys_resource").Value as List <DictionaryEntryDto>;
if (!IsPostBack)
{
resource_id.DataTextField = "show";
resource_id.DataValueField = "val";
var entryProxySet = new SysSettingBLL().GetValueById(SysSettingEnum.SDK_ENTRY_PROXY);
bool isAgent = false;
if (entryProxySet == ((int)DicEnum.PROXY_TIME_ENTRY.DISABLED).ToString())
{
if (resList != null && resList.Count > 0)
{
resList = resList.Where(_ => _.val == LoginUserId.ToString()).ToList();
}
}
else
{
var agentResList = new UserResourceBLL().GetAgentUser(LoginUserId, out isAgent);
if (agentResList != null && agentResList.Count > 0)
{
resList = (from a in agentResList
select new DictionaryEntryDto()
{
val = a.id.ToString(), show = a.name
}).ToList();
}
}
resource_id.DataSource = resList;
resource_id.SelectedValue = LoginUserId.ToString();
resource_id.DataBind();
var statusList = dic.FirstOrDefault(_ => _.Key == "ticket_status").Value as List <DictionaryEntryDto>;
//statusList.Remove(statusList.FirstOrDefault(_=>_.val==((int)DicEnum.TICKET_STATUS.NEW).ToString()));
status_id.DataTextField = "show";
status_id.DataValueField = "val";
status_id.DataSource = statusList;
status_id.DataBind();
cost_code_id.DataTextField = "name";
cost_code_id.DataValueField = "id";
cost_code_id.DataSource = new d_cost_code_dal().GetCostCodeByWhere((int)DicEnum.COST_CODE_CATE.GENERAL_ALLOCATION_CODE);
cost_code_id.DataBind();
notify_id.DataTextField = "name";
notify_id.DataValueField = "id";
notify_id.DataSource = new sys_notify_tmpl_dal().GetTempByEvent(DicEnum.NOTIFY_EVENT.TICKET_TIME_ENTRY_CREATED_EDITED);
notify_id.DataBind();
}
var taskId = Request.QueryString["task_id"];
if (!string.IsNullOrEmpty(taskId))
{
thisTask = new sdk_task_dal().FindNoDeleteById(long.Parse(taskId));
}
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisWorkEntry = new sdk_work_entry_dal().FindNoDeleteById(long.Parse(id));
if (thisWorkEntry != null)
{
if (thisWorkEntry.approve_and_post_date != null || thisWorkEntry.approve_and_post_user_id != null)
{
Response.Write("<script>alert('审批提交的工时不可以更改！');window.close();</script>");
Response.End();
}
if (!resList.Any(_ => _.val == thisWorkEntry.create_user_id.ToString()))
{
Response.Write("<script>alert('系统设置不能代理操作！');window.close();</script>");
return;
}
if (thisWorkEntry.end_time == null && noTimeSet != null && noTimeSet.setting_value == "0")
{
noTime = true;
}
entryList = new sdk_work_entry_dal().GetBatchList(thisWorkEntry.batch_id);
isAdd = false;
thisTask = new sdk_task_dal().FindNoDeleteById(thisWorkEntry.task_id);
if (!IsPostBack)
{
resource_id.ClearSelection();
resource_id.SelectedValue = ((long)thisWorkEntry.resource_id).ToString();
cost_code_id.SelectedValue = ((long)thisWorkEntry.cost_code_id).ToString();
// status_id.SelectedValue = ((long)thisWorkEntry.)
// thisTask = new crm_account_dal().FindNoDeleteById(thisWorkEntry.);
}
if (thisWorkEntry.contract_id != null)
{
thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisWorkEntry.contract_id);
}
if (!IsPostBack)
{
isBilled.Checked = thisWorkEntry.is_billable == 0;
ShowOnInv.Checked = thisWorkEntry.show_on_invoice == 1;
if (isBilled.Checked)
{
ShowOnInv.Enabled = true;
}
}
}
else
{
Response.Write("<script>alert('工时已被删除！')window.close();</script>");
Response.End();
}
}
#region 根据批次获取相关工时
//var batchId = Request.QueryString["batchId"];
//if (!string.IsNullOrEmpty(batchId))
//{
// entryList = new sdk_work_entry_dal().GetBatchList(long.Parse(batchId));
// if(entryList!=null&& entryList.Count > 0)
// {
// thisWorkEntry = entryList[0];
// if (thisWorkEntry.approve_and_post_date != null || thisWorkEntry.approve_and_post_user_id != null)
// {
// Response.Write("<script>alert('审批提交的工时不可以更改！');window.close();</script>");
// Response.End();
// }
// if (!resList.Any(_ => _.val == thisWorkEntry.create_user_id.ToString()))
// {
// Response.Write("<script>alert('系统设置不能代理操作！')window.close();</script>");
// Response.End();
// }
// if (thisWorkEntry.end_time == null && noTimeSet != null && noTimeSet.setting_value == "0")
// {
// noTime = true;
// }
// entryList = new sdk_work_entry_dal().GetBatchList(thisWorkEntry.batch_id);
// isAdd = false;
// thisTask = new sdk_task_dal().FindNoDeleteById(thisWorkEntry.task_id);
// if (!IsPostBack)
// {
// resource_id.SelectedValue = ((long)thisWorkEntry.resource_id).ToString();
// cost_code_id.SelectedValue = ((long)thisWorkEntry.cost_code_id).ToString();
// // status_id.SelectedValue = ((long)thisWorkEntry.)
// // thisTask = new crm_account_dal().FindNoDeleteById(thisWorkEntry.);
// }
// if (thisWorkEntry.contract_id != null)
// {
// thisContract = new ctt_contract_dal().FindNoDeleteById((long)thisWorkEntry.contract_id);
// }
// if (!IsPostBack)
// {
// isBilled.Checked = thisWorkEntry.is_billable == 0;
// ShowOnInv.Checked = thisWorkEntry.show_on_invoice == 1;
// if (isBilled.Checked)
// {
// ShowOnInv.Enabled = true;
// }
// }
// }
//}
#endregion
if (thisTask != null)
{
v_task = new v_task_all_dal().FindById(thisTask.id);
thisProjetc = new pro_project_dal().FindNoDeleteById((long)thisTask.project_id);
if (thisProjetc != null)
{
thisAccount = new crm_account_dal().FindNoDeleteById(thisProjetc.account_id);
if (!IsPostBack)
{
status_id.SelectedValue = thisTask.status_id.ToString();
}
}
}
// 项目关联合同，并且合同中设置-工时录入需要输入开始结束时间
if (thisProjetc != null && thisProjetc.contract_id != null)
{
var thisCttContract = new ctt_contract_dal().FindNoDeleteById((long)thisProjetc.contract_id);
if (thisCttContract != null)
{
if (thisCttContract.timeentry_need_begin_end == 1)
{
noTime = false;
}
}
}
if (thisCall != null)
{
showStartDate = EMT.Tools.Date.DateHelper.ConvertStringToDateTime(thisCall.start_time);
showEndDate = EMT.Tools.Date.DateHelper.ConvertStringToDateTime(thisCall.end_time);
}
if (!string.IsNullOrEmpty(Request.QueryString["chooseDate"]))
{
showStartDate = DateTime.Parse(Request.QueryString["chooseDate"]);
showEndDate = DateTime.Parse(Request.QueryString["chooseDate"]);
}
}
catch (Exception msg)
{
Response.Write($"<script>alert('{msg.Message}');window.close();</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
thisUser = new sys_resource_dal().FindNoDeleteById(GetLoginUserId());
var caDal = new com_activity_dal();
var stDal = new sdk_task_dal();
var ppDal = new pro_project_dal();
var accDal = new crm_account_dal();
var ccDal = new ctt_contract_dal();
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisNote = caDal.FindNoDeleteById(long.Parse(id));
if (thisNote != null)
{
isAdd = false;
thisNoteAtt = new com_attachment_dal().GetAttListByOid(thisNote.id);
thisTask = stDal.FindNoDeleteById(thisNote.object_id);
if (thisTask != null)
{
object_id = thisTask.id;
if (thisTask.type_id == (int)DicEnum.TASK_TYPE.SERVICE_DESK_TICKET)
{
isTicket = true;
thisTask = null;
thisTicket = stDal.FindNoDeleteById(thisNote.object_id);
}
}
else
{
thisProject = ppDal.FindNoDeleteById(thisNote.object_id);
if (thisProject != null)
{
isProject = true;
object_id = thisProject.id;
thisAccount = accDal.FindNoDeleteById(thisProject.account_id);
}
else
{
thisContract = ccDal.FindNoDeleteById(thisNote.object_id);
if (thisContract != null)
{
isContract = true;
object_id = thisContract.id;
thisAccount = accDal.FindNoDeleteById(thisContract.account_id);
}
}
}
}
}
var taskId = Request.QueryString["task_id"];
var project_id = Request.QueryString["project_id"];
var contract_id = Request.QueryString["contract_id"];
var ticket_id = Request.QueryString["ticket_id"];
var call_id = Request.QueryString["call_id"];
if (!string.IsNullOrEmpty(taskId))
{
thisTask = stDal.FindNoDeleteById(long.Parse(taskId));
}
else if (!string.IsNullOrEmpty(project_id))
{
thisProject = ppDal.FindNoDeleteById(long.Parse(project_id));
if (thisProject != null)
{
isProject = true;
object_id = thisProject.id;
thisAccount = accDal.FindNoDeleteById(thisProject.account_id);
}
}
else if (!string.IsNullOrEmpty(contract_id))
{
thisContract = ccDal.FindNoDeleteById(long.Parse(contract_id));
if (thisContract != null)
{
object_id = thisContract.id;
thisAccount = accDal.FindNoDeleteById(thisContract.account_id);
isContract = true;
}
}
else if (!string.IsNullOrEmpty(ticket_id))
{
thisTicket = stDal.FindNoDeleteById(long.Parse(ticket_id));
}
else if (!string.IsNullOrEmpty(call_id))
{
thisCall = new sdk_service_call_dal().FindNoDeleteById(long.Parse(call_id));
if (thisCall != null)
{
isCall = true;
thisAccount = new CompanyBLL().GetCompany(thisCall.account_id);
callTicketList = stDal.GetTciketByCall(thisCall.id);
if (callTicketList != null && callTicketList.Count > 0)
{
thisTask = callTicketList[0];
if (callTicketList.Any(_ => _.id != thisTask.id && _.status_id != thisTask.status_id))
{
isMantStatus = true;
}
if (callTicketList.Any(_ => _.id != thisTask.id && _.account_id != thisTask.account_id))
{
isManyAccount = true;
}
if (callTicketList.Any(_ => _.id != thisTask.id && _.title != thisTask.title))
{
isManyTitle = true;
}
}
else
{
Response.Write("<script>alert('服务预定下暂无工单！');window.close();</script>");
return;
}
}
}
if (thisTask != null)
{
thisAccount = accDal.FindNoDeleteById(thisTask.account_id);
object_id = thisTask.id;
if (thisTask.type_id == (int)DicEnum.TASK_TYPE.PROJECT_PHASE)
{
isPhase = true;
}
task_creator = new sys_resource_dal().FindNoDeleteById(thisTask.create_user_id);
if (thisTask.project_id != null)
{
thisProject = ppDal.FindNoDeleteById((long)thisTask.project_id);
if (thisProject != null)
{
thisAccount = accDal.FindNoDeleteById(thisProject.account_id);
}
}
}
if (thisTicket != null)
{
isTicket = true;
object_id = thisTicket.id;
task_creator = new sys_resource_dal().FindNoDeleteById(thisTicket.create_user_id);
thisAccount = accDal.FindNoDeleteById(thisTicket.account_id);
if (thisTicket.contact_id != null)
{
thisContact = new crm_contact_dal().FindNoDeleteById((long)thisTicket.contact_id);
}
}
if (thisAccount == null)
{
Response.End();
}
else
{
if (thisAccount.resource_id != null)
{
thisAccManger = new sys_resource_dal().FindNoDeleteById((long)thisAccount.resource_id);
}
}
if (!IsPostBack)
{
publish_type_id.DataTextField = "name";
publish_type_id.DataValueField = "id";
var pushList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.NOTE_PUBLISH_TYPE);
if (pushList != null && pushList.Count > 0)
{
if (isProject)
{
pushList = pushList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.PROJECT_NOTE).ToString()).ToList();
}
else if (isContract)
{
pushList = pushList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.CONTRACT_NOTE).ToString()).ToList();
}
else if (isTicket)
{
pushList = pushList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
}
else
{
pushList = pushList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
}
}
publish_type_id.DataSource = pushList;
publish_type_id.DataBind();
status_id.DataTextField = "show";
status_id.DataValueField = "val";
var statusList = dic.FirstOrDefault(_ => _.Key == "ticket_status").Value as List <DictionaryEntryDto>;
if (isMantStatus)
{
statusList.Add(new DictionaryEntryDto()
{
val = "0", show = "多个值，保持不变"
});
}
status_id.DataSource = statusList;
status_id.DataBind();
if (isMantStatus)
{
status_id.SelectedValue = "0";
}
else if (thisTask != null)
{
status_id.SelectedValue = thisTask.status_id.ToString();
}
else if (thisTicket != null)
{
status_id.SelectedValue = thisTicket.status_id.ToString();
}
action_type_id.DataTextField = "name";
action_type_id.DataValueField = "id";
var actList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.ACTION_TYPE);
if (actList != null && actList.Count > 0)
{
if (isProject)
{
actList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.PROJECT_NOTE).ToString()).ToList();
}
else if (isContract)
{
actList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.CONTRACT_NOTE).ToString()).ToList();
}
else if (isTicket)
{
actList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
}
else
{
actList = actList.Where(_ => _.ext2 == ((int)DicEnum.ACTIVITY_CATE.TASK_NOTE).ToString()).ToList();
}
}
action_type_id.DataSource = actList;
action_type_id.DataBind();
if (thisNote != null)
{
if (!IsPostBack)
{
if (thisNote.publish_type_id != null)
{
publish_type_id.SelectedValue = thisNote.publish_type_id.ToString();
}
action_type_id.SelectedValue = thisNote.action_type_id.ToString();
isAnnounce.Checked = thisNote.announce == 1;
}
}
else
{
if (isContract)
{
publish_type_id.SelectedValue = ((int)DicEnum.NOTE_PUBLISH_TYPE.CONTRACT_INTERNA_USER).ToString();
}
}
var tempList = new sys_notify_tmpl_dal().GetTempByEvent(DicEnum.NOTIFY_EVENT.NONE);
notify_id.DataTextField = "name";
notify_id.DataValueField = "id";
notify_id.DataSource = tempList;
notify_id.DataBind();
}
if (isProject)
{
tmplList = new FormTemplateBLL().GetTmplByType((int)DicEnum.FORM_TMPL_TYPE.PROJECT_NOTE, LoginUserId);
}
else if (isTicket && thisTicket != null)
{
tmplList = new FormTemplateBLL().GetTmplByType((int)DicEnum.FORM_TMPL_TYPE.TICKET_NOTE, LoginUserId);
}
else if (thisTask != null)
{
tmplList = new FormTemplateBLL().GetTmplByType((int)DicEnum.FORM_TMPL_TYPE.TASK_NOTE, LoginUserId);
}
}
catch (Exception msg)
{
Response.Write(msg);
Response.End();
}
}
