protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["project_id"];
if (!string.IsNullOrEmpty(id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (!IsPostBack)
{
interna.Checked = true;
}
}
if (thisProject == null)
{
Response.End();
}
}
catch (Exception)
{
Response.End();
}
}
protected List <ctt_contract_cost> noCicostList = null; // 没有配置项的项目产品
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
var taskList = new sdk_task_dal().GetProTask(thisProject.id);
if (taskList != null && taskList.Count > 0)
{
actTaskList = taskList.Where(_ => _.status_id != (int)DTO.DicEnum.TICKET_STATUS.DONE).ToList();
}
var costList = new ctt_contract_cost_dal().GetCostByProId(thisProject.id);
if (costList != null && costList.Count > 0)
{
noCicostList = costList.Where(_ => _.product_id == null).ToList();
}
if (!IsPostBack)
{
// noTempId
noTempId.DataTextField = "name";
noTempId.DataValueField = "id";
noTempId.DataSource = new sys_notify_tmpl_dal().GetTempByEvent(DicEnum.NOTIFY_EVENT.PROJECT_COMPLETED);
noTempId.DataBind();
}
}
}
catch (Exception msg)
{
Response.End();
}
}
protected bool isTemp = false; // 判断项目是否时项目模板
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
if (AuthBLL.GetUserProjectAuth(LoginUserId, LoginUser.security_Level_id, thisProject.id).CanView == false)
{
Response.Write("<script>alert('无权查看');window.close();</script>");
Response.End();
return;
}
taskList = new sdk_task_dal().GetProjectTask(thisProject.id);
if (thisProject.type_id == (int)DicEnum.PROJECT_TYPE.TEMP)
{
isTemp = true;
}
}
else
{
Response.End();
}
}
catch (Exception msg)
{
Response.End();
}
}
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 DataTable milepostTable; // 里程碑
protected void Page_Load(object sender, EventArgs e)
{
long id = 0;
if (!string.IsNullOrEmpty(Request.QueryString["id"]) && long.TryParse(Request.QueryString["id"], out id))
{
project = proBll.GetPoject(id);
}
if (project == null)
{
Response.Write("<script>alert('为获取到相关项目信息，请刷新页面后重试！');</script>"); return;
}
account = new CompanyBLL().GetCompany(project.account_id);
// taskLsit = new DAL.sdk_task_dal().GetAllProTask(project.id);
expPro = proBll.GetTableBySql(@"select hours_worked,labor_cost,cost_cost_billable+cost_cost_nonbillable,expense_cost_billable+expense_cost_nonbillable,
labor_cost+cost_cost_billable+cost_cost_nonbillable+expense_cost_billable+expense_cost_nonbillable
from v_project_complete_profit where project_id = " + project.id.ToString());
revPro = proBll.GetTableBySql(@"select hours_billed,labor_dollars,cost_dollars,expense_dollars,milestone_dollars,
labor_dollars+cost_dollars+expense_dollars+milestone_dollars
from v_project_complete_profit
where project_id = " + project.id.ToString());
profitPro = proBll.GetTableBySql(@"select labor_dollars-labor_cost,cost_dollars-cost_cost_billable-cost_cost_nonbillable,expense_dollars-expense_cost_billable-expense_cost_nonbillable,milestone_dollars,
labor_dollars+cost_dollars+expense_dollars+milestone_dollars -(labor_cost+cost_cost_billable+cost_cost_nonbillable+expense_cost_billable+expense_cost_nonbillable)
from v_project_complete_profit
where project_id = " + project.id.ToString());
yuguPro = proBll.GetTableBySql(@"select Labor_Revenue,Cost_Revenue,Labor_Revenue+Cost_Revenue
from v_project_complete_profit
where project_id = " + project.id.ToString());
taskTable = proBll.GetTableBySql($@"select if(sid is null ,'项目汇总',a.title) as 标题,if(sid is null ,'',a.status )as 状态,round(a.estimated_hours,2) as 预估时间,round(a.worked_hours,2) as 已工作时间,round(a.Billed_hours,2) as 已计费时间
,round(a.labor_dollars,2) as 工时收入,round(a.labor_cost,2) as 工时成本
from v_task_all a where 1=1 and a.project_id in({project.id.ToString()}) order by a.sort_order");
chargeTable = proBll.GetTableBySql($@"select if(id is null,null,date_purchased),if(id is null,null,name), if(id is null,null,cost_code_name),if(id is null,null,purchase_order_no),if(id is null,'汇总：',Invoice_no),
round(cost,2),round(billable_amount,2),round(revenue,2)
from(
select id,date_purchased,name, (select name from d_cost_code where id=t.cost_code_id) cost_code_name,purchase_order_no,
Invoice_no,sum(Quantity*Unit_Cost)cost, sum(if(is_billable=1,ifnull( extended_price,Quantity*Unit_Price),0 ))billable_amount,
sum(if(is_billable=1 and bill_Status=1 ,ifnull( extended_price,Quantity*Unit_Price),0 ))revenue
from ctt_contract_cost t where project_id={project.id.ToString()} and delete_time=0
GROUP BY id with ROLLUP)t
");
expenseTable = proBll.GetTableBySql($@"select if(id is null,null,Add_Date),if(id is null,null,resource_name), if(id is null,null,type_name),if(id is null,null,description),if(id is null,null,has_Receipt),if(id is null,'汇总：',is_billable),
round(amount,2),round(revenue,2)
from(
select id,Add_Date,(select name from sys_resource where id=t.create_user_id)resource_name, (select name from d_general where id=t.type_id) type_name,description,
if(has_Receipt=1,'√','')has_Receipt,if(is_billable=1,'√','')is_billable,sum(Amount)Amount,sum( if(is_billable=1 and approve_and_post_date is not null ,amount,0 ) )revenue
from sdk_expense t where project_id={project.id.ToString()} and delete_time=0
GROUP BY id with ROLLUP)t
");
milepostTable = proBll.GetTableBySql($@"select if(id is null,null,due_date),if(id is null,'汇总：',name),round(dollars,2),round(revenue,2)
from(
select t.id,t.due_date,t.name,sum(dollars)dollars, sum(if(t.status_id= 1267,dollars,0 ))revenue
from ctt_contract_milestone t ,sdk_task a,sdk_task_milestone b
where t.delete_time=0 and a.delete_time=0 and b.delete_time=0 and t.id=b.contract_milestone_id and b.task_id=a.id and a.project_id={project.id.ToString()}
GROUP BY id with ROLLUP)t
");
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
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.PROJECT_NOTE).ToString()).ToList();
}
publish_type_id.DataSource = pushList;
publish_type_id.DataBind();
}
var project_id = Request.QueryString["project_id"];
if (!string.IsNullOrEmpty(project_id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(project_id));
}
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisCal = new pro_project_calendar_dal().FindNoDeleteById(long.Parse(id));
if (thisCal != null)
{
isAdd = false;
if (!IsPostBack)
{
if (thisCal.publish_type_id != null)
{
publish_type_id.SelectedValue = thisCal.publish_type_id.ToString();
}
}
thisProject = new pro_project_dal().FindNoDeleteById(thisCal.project_id);
}
}
if (thisProject == null)
{
Response.End();
}
}
catch (Exception msg)
{
Response.Write(msg);
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var chooseDateString = Request.QueryString["chooseDate"];
if (!string.IsNullOrEmpty(chooseDateString))
{
chooseDate = DateTime.Parse(chooseDateString);
}
user = UserInfoBLL.GetUserInfo(GetLoginUserId());
if (!string.IsNullOrEmpty(Request.QueryString["isSeven"]))
{
isSeven = true;
}
if (!string.IsNullOrEmpty(Request.QueryString["isShowDetai"]))
{
isShowDetai = true;
}
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
taskList = new sdk_task_dal().GetProTask(thisProject.id, " and type_id in (1807,1808,1812)");
proCalList = new pro_project_calendar_dal().GetCalByPro(thisProject.id);
}
}
if (!string.IsNullOrEmpty(Request.QueryString["isAll"]))
{
isAll = true;
}
if (isAll)
{
taskList = new sdk_task_dal().FindListBySql($"select* from sdk_task where delete_time = 0 and type_id in (1807,1808,1812)");
var ppDal = new DAL.pro_project_dal();
proCalList = new pro_project_calendar_dal().FindListBySql($"SELECT * from pro_project_calendar where delete_time = 0");
const string proLimitJson = "{\"row\":\"7\",\"t1\":\"p\",\"col1\":\"0\",\"col2\":\"0\"}";
var projectLimitSql = Convert.ToString(ppDal.GetSingle($"select f_rpt_getsql_limit('{proLimitJson}',{LoginUserId.ToString()})"));
projectList = ppDal.FindListBySql("select* from pro_project p where p.delete_time =0 " + projectLimitSql);
}
}
catch (Exception msg)
{
Response.End();
}
}
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
}
if (!string.IsNullOrEmpty(Request.QueryString["isAll"]))
{
isAll = true;
}
var chooseDateString = Request.QueryString["chooseDate"];
if (!string.IsNullOrEmpty(chooseDateString))
{
chooseDate = DateTime.Parse(chooseDateString);
}
var showDateString = Request.QueryString["showDate"];
if (!string.IsNullOrEmpty(showDateString))
{
showDate = DateTime.Parse(showDateString);
}
calendar.Text = GetTableByDate(showDate);
if (!string.IsNullOrEmpty(Request.QueryString["isSeven"]))
{
isSeven = true;
}
if (!string.IsNullOrEmpty(Request.QueryString["isShowDetai"]))
{
isShowDetai = true;
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var project_id = Request.QueryString["project_id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(project_id));
if (thisProject != null)
{
project_udf_list = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.PROJECTS);
project_udfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.PROJECTS, thisProject.id, project_udf_list);
thisAccount = new CompanyBLL().GetCompany(thisProject.account_id);
if (thisProject.opportunity_id != null)
{
thisOppo = new crm_opportunity_dal().FindNoDeleteById((long)thisProject.opportunity_id);
}
}
}
catch (Exception)
{
Response.End();
}
}
protected crm_contact thisCon = null; // 成员的联系人
protected void Page_Load(object sender, EventArgs e)
{
var idString = Request.QueryString["id"];
if (!string.IsNullOrEmpty(idString))
{
thisProTeam = new pro_project_team_dal().FindNoDeleteById(long.Parse(idString));
if (thisProTeam != null)
{
isAdd = false;
thisProTeamRoleList = new pro_project_team_role_dal().GetListTeamRole(thisProTeam.id);
thisProject = new pro_project_dal().FindNoDeleteById(thisProTeam.project_id);
if (thisProTeam.resource_id != null)
{
thisRes = new sys_resource_dal().FindNoDeleteById((long)thisProTeam.resource_id);
}
if (thisProTeam.contact_id != null)
{
thisCon = new crm_contact_dal().FindNoDeleteById((long)thisProTeam.contact_id);
}
}
}
var pId = Request.QueryString["project_id"];
if (!string.IsNullOrEmpty(pId))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(pId));
}
if (thisProject != null)
{
thisAccount = new CompanyBLL().GetCompany(thisProject.account_id);
}
if (thisProject == null || thisAccount == null)
{
Response.End();
}
}
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));
}
if (thisProject != null)
{
ShowCalendarList.Src = "../Common/SearchBodyFrame.aspx?cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_CALENDAR + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_CALENDAR + "&id=" + thisProject.id;
}
else
{
Response.End();
}
// project_calendar
}
catch (Exception)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
// 校验 是否有权限进行查看
if (AuthBLL.GetUserProjectAuth(LoginUserId, LoginUser.security_Level_id, thisProject.id).CanView == false)
{
Response.Write("<script>alert('无权查看');window.close();</script>");
Response.End();
return;
}
thisBookMark = new IndexBLL().GetSingBook(Request.Url.LocalPath + "?id=" + id, LoginUserId);
var thisAccount = new CompanyBLL().GetCompany(thisProject.account_id);
ShowTitle.Text = "项目-" + thisProject.no + thisProject.name + "(" + thisAccount.name + ")";
var type = Request.QueryString["type"];
switch (type)
{
case "Schedule":
viewProjectIframe.Src = "ProjectSchedule?project_id=" + thisProject.id;
break;
case "ScheduleTemp":
viewProjectIframe.Src = "ProjectSchedule?project_id=" + thisProject.id + "&isTranTemp=1";
break;
case "Team":
viewProjectIframe.Src = "../Common/SearchBodyFrame.aspx?id=" + thisProject.id + "&cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_TEAM + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_TEAM;
break;
case "Cost":
viewProjectIframe.Src = "../Common/SearchBodyFrame.aspx?id=" + thisProject.id + "&cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_COST_EXPENSE + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_COST_EXPENSE + "&isCheck=1";
break; // project_cost_expense
case "Note":
viewProjectIframe.Src = "ProjectNoteShow?project_id=" + thisProject.id;
break;
case "Rate":
viewProjectIframe.Src = "../Common/SearchBodyFrame.aspx?id=" + thisProject.id + "&cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_RATE + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_RATE;
break;
case "Calendar":
//viewProjectIframe.Src = "../Common/SearchBodyFrame.aspx?id=" + thisProject.id + "&cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_CALENDAR + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_CALENDAR; project_udf
viewProjectIframe.Src = "ProjectCalendarShow?project_id=" + thisProject.id;
break;
case "Attach":
viewProjectIframe.Src = "../Common/SearchBodyFrame.aspx?id=" + thisProject.id + "&cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_ATTACH + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_ATTACH;
break;
case "UDF":
viewProjectIframe.Src = "../Common/SearchBodyFrame.aspx?id=" + thisProject.id + "&cat=" + (int)EMT.DoneNOW.DTO.DicEnum.QUERY_CATE.PROJECT_UDF + "&type=" + (int)EMT.DoneNOW.DTO.QueryType.PROJECT_UDF;
break;
case "ticket":
viewProjectIframe.Src = "../Common/SearchFrameSet.aspx?cat=" + (int)DicEnum.QUERY_CATE.MY_QUEUE_ACTIVE + "&type=" + (int)QueryType.MY_QUEUE_ACTIVE + "&group=215¶m1=4890¶m2=" + thisProject.id + "¶m4=AddHidden";
break;
default:
viewProjectIframe.Src = "ProjectSummary?id=" + thisProject.id;
break;
}
#region 记录浏览历史
var history = new sys_windows_history()
{
title = $"项目：" + thisProject.name + " " + (thisAccount != null? thisAccount.name:""),
url = Request.RawUrl,
};
new IndexBLL().BrowseHistory(history, LoginUserId);
#endregion
}
else
{
Response.End();
}
}
catch (Exception msg)
{
Response.End();
}
}
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)
{
// 批量修改
// 1。多个任务 2.单个任务
try
{
var stDal = new sdk_task_dal();
var ppDal = new pro_project_dal();
var ids = Request.QueryString["taskIds"];
if (!string.IsNullOrEmpty(ids))
{
idList = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (idList.Count() == 1)
{
var thisTask = stDal.FindNoDeleteById(long.Parse(idList[0]));
if (thisTask != null)
{
if (!IsPostBack)
{
thisProject = ppDal.FindNoDeleteById((long)thisTask.project_id);
titleValue = thisTask.title;
statuValue = thisTask.status_id;
priorityValue = thisTask.priority;
estHoursValue = thisTask.estimated_hours;
depValue = thisTask.department_id;
// workTypeValue = thisTask.
priResValue = thisTask.owner_resource_id;
if (thisTask.is_visible_in_client_portal == 1)
{
if (thisTask.can_client_portal_user_complete_task == 1)
{
DisplayInCapYes.Checked = true;
}
else
{
DisplayInCapYesNoComplete.Checked = true;
}
}
else
{
DisplayInCapNone.Checked = true;
}
}
udfValue = new UserDefinedFieldsBLL().GetUdfValue(UDF_CATE.TASK, thisTask.id, udfTaskPara);
taskList.Add(thisTask);
}
}
else if (idList.Count() > 1)
{
taskList = stDal.GetTaskByIds(ids, $" and type_id in ({(int)DicEnum.TASK_TYPE.PROJECT_TASK},{(int)DicEnum.TASK_TYPE.PROJECT_ISSUE})");
if (taskList != null && taskList.Count > 0)
{
thisProject = ppDal.FindNoDeleteById((long)taskList[0].project_id);
var firstTask = taskList[0];
taskList.Remove(firstTask);
if (!IsPostBack)
{
udfValue = udfBLL.GetUdfValue(UDF_CATE.TASK, firstTask.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 = udfBLL.GetSameValueCount(UDF_CATE.TASK, ids, udfTask.col_name, thisValue.ToString());
if (count > 1)
{
udfValue.FirstOrDefault(_ => _.id == udfTask.id).value = "多个值-保持不变";
}
else
{
}
}
}
if (taskList.Any(_ => _.title != firstTask.title))
{
titleValue = "多个值-保持不变";
}
else
{
titleValue = firstTask.title;
}
if (taskList.Any(_ => _.status_id != firstTask.status_id))
{
statuValue = 0;
}
else
{
statuValue = firstTask.status_id;
}
if (taskList.Any(_ => _.priority != firstTask.priority))
{
priorityValue = null;
}
else
{
priorityValue = firstTask.priority;
}
#region 在页面上的显示设置
if (firstTask.is_visible_in_client_portal == 1)
{
if (taskList.Any(_ => _.is_visible_in_client_portal != firstTask.is_visible_in_client_portal))
{
displayWayValue = "1";
}
else
{
if (firstTask.can_client_portal_user_complete_task == 1)
{
if (taskList.Any(_ => _.can_client_portal_user_complete_task != firstTask.can_client_portal_user_complete_task))
{
displayWayValue = "1";
}
else
{
DisplayInCapYes.Checked = true;
}
}
else
{
if (taskList.Any(_ => _.can_client_portal_user_complete_task != firstTask.can_client_portal_user_complete_task))
{
displayWayValue = "1";
}
else
{
DisplayInCapYesNoComplete.Checked = true;
}
}
}
}
else
{
if (taskList.Any(_ => _.is_visible_in_client_portal != firstTask.is_visible_in_client_portal))
{
displayWayValue = "1";
}
else
{
DisplayInCapNone.Checked = true;
}
}
if (!string.IsNullOrEmpty(displayWayValue))
{
noChange.Checked = true;
}
#endregion
#region 固定工作，固定时间的设置
if (taskList.Any(_ => _.estimated_type_id != firstTask.estimated_type_id))
{
fixTypeValue = "1";
typeNoChange.Checked = true;
}
else
{
if (firstTask.estimated_type_id == (int)DicEnum.TIME_ENTRY_METHOD_TYPE.FIXWORK)
{
TaskTypeFixedWork.Checked = true;
}
else if (firstTask.estimated_type_id == (int)DicEnum.TIME_ENTRY_METHOD_TYPE.FIXDURATION)
{
TaskTypeFixedDuration.Checked = true;
}
}
#endregion
if (taskList.Any(_ => _.estimated_hours != firstTask.estimated_hours))
{
estHoursValue = null;
}
else
{
estHoursValue = firstTask.estimated_hours;
}
if (taskList.Any(_ => _.department_id != firstTask.department_id))
{
depValue = null;
}
else
{
depValue = firstTask.department_id;
}
if (taskList.Any(_ => _.owner_resource_id != firstTask.owner_resource_id))
{
priResValue = 0;
}
else
{
priResValue = firstTask.owner_resource_id;
}
}
}
}
if (!IsPostBack)
{
ThisPageDataBind();
}
if (statuValue == 0)
{
status_id.Items.Insert(0, new ListItem()
{
Value = "0", Text = "多个选择-保持不变", Selected = true
});
}
else
{
status_id.SelectedValue = statuValue.ToString();
}
if (depValue == null)
{
department_id.ClearSelection();
department_id.Items.Insert(0, new ListItem()
{
Value = "0", Text = "多个选择-保持不变", Selected = true
});
}
else
{
department_id.ClearSelection();
department_id.SelectedValue = depValue.ToString();
}
}
else
{
Response.End();
}
}
catch (Exception)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var project_id = Request.QueryString["project_id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(project_id));
type = Request.QueryString["dateType"];
if (string.IsNullOrEmpty(type))
{
type = "day";
}
taskList = new sdk_task_dal().GetAllProTask(thisProject.id);
if (taskList != null && taskList.Count > 0)
{
start_date = Tools.Date.DateHelper.ConvertStringToDateTime((long)taskList.Min(_ => _.estimated_begin_time));
end_date = Tools.Date.DateHelper.ConvertStringToDateTime(taskList.Max(_ => (long)_.estimated_end_time));
if (GetDateDiffMonth(start_date, end_date, "month") > 12)
{
end_date = start_date.AddYears(showYearNum).AddDays(-1);
}
else if (GetDateDiffMonth(start_date, end_date, "month") <= 2)
{
end_date = end_date.AddMonths(minMohth).AddDays(-1); // 时间太少，增加宽度
}
// 页面上展示多少月份
var monthNum = GetDateDiffMonth(start_date, end_date, "month");
#region 日期展示说明
// 1.计算出具体显示多少月份，最多显示 showYearNum*12 的月份--循环添加
// 2.开始月份和结束月份可能不是整月，显示部分 --特殊处理
// 3.展示具体的天，周，月信息
#endregion
#region 右日历列表
StringBuilder headInfo = new StringBuilder();
switch (type)
{
case "day":
DayWidth = 32;
for (int i = 0; i < monthNum; i++)
{
headInfo.Append($"<div class='Gantt_dateMonthYear Gantt_titleFont Gantt_divTableHeader Gantt_header Gantt_date'>");
if ((i == 0 || i == monthNum - 1)) // 开始和结束时间以及特殊情况的处理
{
if (i == 0)
{
var monthDayNum = RetuenMonthDay(start_date); // 开始日期的月份的总天数
var surplusDays = (monthDayNum - start_date.Day + 1); // 开始结束时间 --剩余天数
var thisMonthWidth = surplusDays * DayWidth; // 计算出这个月份占的宽度
// style='width: {thisMonthWidth}px;'
headInfo.Append($"<div class='Gantt_monthHolder'>{start_date.Year.ToString() + '.' + start_date.Month.ToString()}</div>");
int s;
for (s = start_date.Day; s <= monthDayNum; s++)
{
var diffDays = s - start_date.Day;
headInfo.Append($"<div class='Gantt_divTableColumn Gantt_header Gantt_date' style='min-width: {DayWidth}px;'>{RetuenWeekDay((int)start_date.AddDays(diffDays).DayOfWeek)+"<br />" +s}</div>");
}
}
else if (i == monthNum - 1)
{
var monthDayNum = RetuenMonthDay(end_date); // 开始日期的月份的总天数
var surplusDays = end_date.Day; // 开始结束时间
var thisMonthWidth = surplusDays * DayWidth; // 计算出这个月份占的宽度
// style='width: {thisMonthWidth}px;'
headInfo.Append($"<div class='Gantt_monthHolder'>{end_date.Year.ToString() + '.' + end_date.Month.ToString()}</div>");
for (int s = 1; s <= surplusDays; s++)
{
var diffDays = s - surplusDays;
headInfo.Append($"<div class='Gantt_divTableColumn Gantt_header Gantt_date' style='min-width: {DayWidth}px;'>{RetuenWeekDay((int)end_date.AddDays(diffDays).DayOfWeek) + "<br />" + s}</div>");
}
}
}
else
{
var monthDayNum = RetuenMonthDay(start_date.AddMonths(i)); // 开始日期的月份的总天数
var thisMonthWidth = monthDayNum * DayWidth;
// style='width: {thisMonthWidth}px;'
headInfo.Append($"<div class='Gantt_monthHolder'>{start_date.AddMonths(i).Year.ToString() + '.' + start_date.AddMonths(i).Month.ToString()}</div>");
var thisMonthFirstDay = new DateTime(start_date.AddMonths(i).Year, start_date.AddMonths(i).Month, 1);
for (int s = 1; s <= monthDayNum; s++)
{
headInfo.Append($"<div class='Gantt_divTableColumn Gantt_header Gantt_date'>{RetuenWeekDay((int)thisMonthFirstDay.AddDays(s - 1).DayOfWeek) + "<br />" + s}</div>");
}
}
headInfo.Append("</div>");
}
break;
case "week":
DayWidth = 30;
headInfo.Append($"<table border='0' cellspacing='0' cellpadding='0'><tbody><tr valign='top'><td><div class='grid TimelineGridHeader'><table border = '0' cellspacing='0' cellpadding='0'><tbody><tr height = '0'></tr></ tbody><thead> ");
// 添加月
headInfo.Append("<tr valign='middle' align='center'>");
for (int i = 0; i < monthNum; i++)
{
if ((i == 0 || i == monthNum - 1)) // 开始和结束时间以及特殊情况的处理
{
if (i == 0)
{
var monthDayNum = RetuenMonthDay(start_date); // 开始日期的月份的总天数
var surplusDays = (monthDayNum - start_date.Day + 1); // 开始结束时间 --剩余天数
var thisMonthWidth = surplusDays * DayWidth; // 计算出这个月份占的宽度
headInfo.Append($"<td colspan='{surplusDays}' class='TextUppercase'>{start_date.Year + "." + start_date.Month}</ td>");
}
else if (i == monthNum - 1)
{
var monthDayNum = RetuenMonthDay(end_date); // 开始日期的月份的总天数
var surplusDays = end_date.Day; // 开始结束时间
var thisMonthWidth = surplusDays * DayWidth; // 计算出这个月份占的宽度
headInfo.Append($"<td colspan='{end_date.Day}' class='TextUppercase'>{end_date.Year.ToString() + '.' + end_date.Month.ToString()}</ td>");
}
}
else
{
var monthDayNum = RetuenMonthDay(start_date.AddMonths(i)); // 开始日期的月份的总天数
var thisMonthWidth = monthDayNum * DayWidth;
headInfo.Append($"<td colspan='{monthDayNum}' class='TextUppercase'>{start_date.AddMonths(i).Year.ToString() + '.' + start_date.AddMonths(i).Month.ToString()}</ td>");
}
}
headInfo.Append("</tr>");
// 添加周
headInfo.Append("<tr valign='middle' align='center'>");
var weekNum = GetDateDiffMonth(start_date, end_date, "week");
for (int s = 0; s < weekNum; s++)
{
if (s != (weekNum - 1))
{
headInfo.Append($"<td colspan='7'><div class='TimelineSecondaryHeader' style='width: {7*DayWidth}px;'>{start_date.AddDays(s * 7).Day}-{start_date.AddDays((s + 1) * 7 - 1).Day}</div></td>");
}
else
{
headInfo.Append($"<td colspan='7'><div class='TimelineSecondaryHeader' style='width: {(end_date.Day- start_date.AddDays(s * 7).Day)*DayWidth}px;'>{start_date.AddDays(s * 7).Day}-{end_date.Day}</div></td>");
}
}
headInfo.Append("</tr>");
headInfo.Append("</thead></table></div></td></tr></tbody></table> ");
break;
case "month":
DayWidth = 15;
for (int i = 0; i < monthNum; i++)
{
headInfo.Append($"<div class='Gantt_dateMonthYear Gantt_titleFont Gantt_divTableHeader Gantt_header Gantt_date'>");
if ((i == 0 || i == monthNum - 1)) // 开始和结束时间以及特殊情况的处理
{
if (i == 0)
{
var monthDayNum = RetuenMonthDay(start_date); // 开始日期的月份的总天数
var surplusDays = (monthDayNum - start_date.Day + 1); // 开始结束时间 --剩余天数
var thisMonthWidth = surplusDays * DayWidth; // 计算出这个月份占的宽度
headInfo.Append($"<div class='Gantt_monthHolder' style='width: {thisMonthWidth}px;'>{start_date.Year.ToString() + '.' + start_date.Month.ToString()}</div>");
}
else if (i == monthNum - 1)
{
var monthDayNum = RetuenMonthDay(end_date); // 开始日期的月份的总天数
var surplusDays = end_date.Day; // 开始结束时间
var thisMonthWidth = surplusDays * DayWidth; // 计算出这个月份占的宽度
headInfo.Append($"<div class='Gantt_monthHolder' style='width: {thisMonthWidth}px;'>{end_date.Year.ToString() + '.' + end_date.Month.ToString()}</div>");
}
}
else
{
var monthDayNum = RetuenMonthDay(start_date.AddMonths(i)); // 开始日期的月份的总天数
var thisMonthWidth = monthDayNum * DayWidth;
headInfo.Append($"<div class='Gantt_monthHolder' style='width: {thisMonthWidth}px;'>{start_date.AddMonths(i).Year.ToString() + '.' + start_date.AddMonths(i).Month.ToString()}</div>");
}
headInfo.Append("</div>");
}
break;
default:
break;
}
liCalendar.Text = headInfo.ToString();
#endregion
#region 左列表
StringBuilder leftInfo = new StringBuilder();
leftInfo.Append($"<div class='Gantt_projectTitleFont Gantt_titleFont Gantt_divTableRow'><div class='Gantt_idFont Gantt_id Gantt_divTableColumnMonth'></div><div class='Gantt_projectFont Gantt_title Gantt_divTableColumnMonth Gantt_projectTitle'><div style = 'display: block; white-space:nowrap; overflow:inherit;'>{thisProject.name}</div></div></div> ");
AddTableHtml(null, taskList, "", "", 0, leftInfo);
liLeftTable.Text = leftInfo.ToString();
#endregion
#region 右图形
StringBuilder rightInfo = new StringBuilder();
var thisDays = GetDateDiffMonth(start_date, DateTime.Now, "day"); // 开始时间距离今天的距离
double noeDaysWidth = 0;
switch (type)
{
case "day":
noeDaysWidth = thisDays * (DayWidth + 10) + 0.8 * (DayWidth + 10);
break;
case "week":
noeDaysWidth = (thisDays + 1) * DayWidth + 0.5 * thisDays;
break;
case "month":
noeDaysWidth = (thisDays + 1) * DayWidth;
break;
}
rightInfo.Append($"<div class='Gantt_divTableRow'><img src = '../Images/todayBarIndicator.png' class='Gantt_TodayBar' style='left: {noeDaysWidth}px;'><div class='Gantt_projectBar' id='Gantt_projectBar' style='width: 100%;'><div style='width: 0%;'></div></div></div>");
AddImgHtml(null, taskList, "", rightInfo);
liRightImg.Text = rightInfo.ToString();
#endregion
}
else
{
liCalendar.Text = "暂无数据";
}
}
catch (Exception msg)
{
Response.End();
}
}
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 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 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 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();
}
}
protected string pageShowType = ""; // 页面过滤数据类型 --默认展示全部的数据（过滤阶段，完成等信息）
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["project_id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
pageShowType = Request.QueryString["pageShowType"];
taskList = new sdk_task_dal().GetProjectTask(thisProject.id);
var isTran = Request.QueryString["isTranTemp"];
if ((!string.IsNullOrEmpty(isTran))) //thisProject.type_id != (int)DicEnum.PROJECT_TYPE.TEMP &&
{
isTransTemp = true;
}
if (!IsPostBack)
{
var tempList = new pro_project_dal().GetTempList();
// 项目模板 --project_temp
if (tempList != null && tempList.Count > 0)
{
project_temp.DataTextField = "name";
project_temp.DataValueField = "id";
project_temp.DataSource = tempList;
project_temp.DataBind();
}
organization_location_id.DataTextField = "name";
organization_location_id.DataValueField = "id";
organization_location_id.DataSource = dic.FirstOrDefault(_ => _.Key == "org_location").Value;
organization_location_id.DataBind();
useResource_daily_hours.Checked = thisProject.use_resource_daily_hours == 1;
excludeWeekend.Checked = thisProject.exclude_weekend == 1;
excludeHoliday.Checked = thisProject.exclude_holiday == 1;
warnTime_off.Checked = thisProject.warn_time_off == 1;
}
// if (!int.TryParse(Request.QueryString["cat"], out catId))
var catIdString = Request.QueryString["CatID"];
if (string.IsNullOrEmpty(catIdString))
{
catId = (int)DicEnum.QUERY_CATE.PROJECT_TASK;
}
else
{
catId = int.Parse(catIdString);
}
// if (!long.TryParse(Request.QueryString["type"], out queryTypeId))
var queryTypeIdString = Request.QueryString["QeryTypeId"];
if (string.IsNullOrEmpty(queryTypeIdString))
{
queryTypeId = (int)QueryType.PROJECT_TASK;
//queryTypeId = (int)QueryType.PROJECT_PHASE;
}
else
{
queryTypeId = int.Parse(queryTypeIdString);
}
if (catId == 0 || queryTypeId == 0)
{
Response.Close();
return;
}
// 一个query_type下只有一个group时可以不传参gruop_id
if (paraGroupId == 0)
{
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;
}
}
}
// if (!long.TryParse(Request.QueryString["id"], out objId))
objId = thisProject.id;
QueryData();
CalcTableWidth();
}
else
{
Response.End();
}
}
catch (Exception msg)
{
Response.End();
}
}
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 void Page_Load(object sender, EventArgs e)
{
try
{
var account_id = Request.QueryString["account_id"];
itemStartDatePara = Request.QueryString["stareDate"];
itemEndDatePara = Request.QueryString["endDate"];
contractTypePara = Request.QueryString["contract_type"];
contractCatePara = Request.QueryString["contract_cate"];
projectItemPara = Request.QueryString["itemDeal"];
var thisProjectId = Request.QueryString["thisProject"];
if (!string.IsNullOrEmpty(thisProjectId))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(thisProjectId));
}
if (thisProject != null)
{
project_idHidden.Value = thisProject.id.ToString();
}
contract_udfList = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.CONTRACTS);
account = new CompanyBLL().GetCompany(long.Parse(account_id));
if (!IsPostBack)
{
PageDataBind();
if (!string.IsNullOrEmpty(itemStartDatePara))
{
itemStartDate.Value = itemStartDatePara;
}
if (!string.IsNullOrEmpty(itemEndDatePara))
{
itemEndDate.Value = itemEndDatePara;
}
if (!string.IsNullOrEmpty(contractTypePara))
{
contract_type_id.SelectedValue = contractTypePara;
}
if (!string.IsNullOrEmpty(contractCatePara))
{
contract_cate_id.SelectedValue = contractCatePara;
}
if (!string.IsNullOrEmpty(projectItemPara))
{
}
var childAccList = new crm_account_dal().GetSubsidiariesById(account.id);
if (childAccList != null && childAccList.Count > 0)
{
if (!string.IsNullOrEmpty(isCheckSunAccountPara))
{
ckchildAccounts.Checked = true;
}
}
else
{
ckchildAccounts.Enabled = false;
}
}
}
catch (Exception)
{
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
{
thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId);
//var checkLimitType = Request.QueryString["type_id"];
//if (checkLimitType == ((int)DicEnum.PROJECT_TYPE.ACCOUNT_PROJECT).ToString() || checkLimitType == ((int)DicEnum.PROJECT_TYPE.IN_PROJECT).ToString())
//{
// var result = GetLimitValue(AuthLimitEnum.PROClientAdd);
// if (result == DicEnum.LIMIT_TYPE_VALUE.NO960)
// {
// Response.Write("alert(没有新增项目权限);window.close();");
// return;
// }
//}
//else if (checkLimitType == ((int)DicEnum.PROJECT_TYPE.PROJECT_DAY).ToString())
//{
// var result = GetLimitValue(AuthLimitEnum.PROProposalAdd);
// if (result == DicEnum.LIMIT_TYPE_VALUE.NO960)
// {
// Response.Write("alert(没有新增项目提案权限);window.close();");
// return;
// }
//}
//else if (checkLimitType == ((int)DicEnum.PROJECT_TYPE.TEMP).ToString())
//{
// var result = GetLimitValue(AuthLimitEnum.PROTemplatesAdd);
// if (result == DicEnum.LIMIT_TYPE_VALUE.NO960)
// {
// Response.Write("alert(没有新增项目模板权限);window.close();");
// return;
// }
//}
var accountIdString = Request.QueryString["account_id"];
if (!string.IsNullOrEmpty(accountIdString))
{
account = new CompanyBLL().GetCompany(long.Parse(accountIdString));
}
callBaclFunction = Request.QueryString["callFunc"];
isFromTemp = Request.QueryString["isFromTemp"];
isTemp = Request.QueryString["isTemp"];
var id = Request.QueryString["id"];
project_udfList = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.PROJECTS);
if (!string.IsNullOrEmpty(id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
if (thisProject.contract_id != null)
{
contract = new ctt_contract_dal().FindNoDeleteById((long)thisProject.contract_id);
}
if (thisProject.type_id == (int)DicEnum.PROJECT_TYPE.TEMP)
{
isTemp = "1";
}
taskList = new sdk_task_dal().GetProTask(thisProject.id);
account = new crm_account_dal().FindNoDeleteById(thisProject.account_id);
project_udfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.PROJECTS, thisProject.id, project_udfList);
isAdd = false;
}
}
else
{
if (!IsPostBack)
{
is_active.Checked = true;
excludeWeekend.Checked = true;
excludeHoliday.Checked = true;
warnTime_off.Checked = true;
}
}
if (!IsPostBack)
{
PageDataBind();
}
if (thisProject != null)
{
#region 根据项目信息为页面数据赋值
if (!IsPostBack)
{
line_of_business_id.SelectedValue = thisProject.line_of_business_id == null ? "0" : thisProject.line_of_business_id.ToString();
type_id.SelectedValue = thisProject.type_id == null ? "0" : thisProject.type_id.ToString();
status_id.SelectedValue = thisProject.status_id.ToString();
department_id.SelectedValue = thisProject.department_id == null ? "0" : thisProject.department_id.ToString();
organization_location_id.SelectedValue = thisProject.organization_location_id.ToString();
template_id.SelectedValue = thisProject.template_id == null ? "0" : thisProject.template_id.ToString();
useResource_daily_hours.Checked = thisProject.use_resource_daily_hours == 1;
owner_resource_id.SelectedValue = thisProject.owner_resource_id == null ? "0" : thisProject.owner_resource_id.ToString();
excludeWeekend.Checked = thisProject.exclude_weekend == 1;
excludeHoliday.Checked = thisProject.exclude_holiday == 1;
warnTime_off.Checked = thisProject.warn_time_off == 1;
if (!string.IsNullOrEmpty(isTemp))
{
is_active.Checked = thisProject.status_id == (int)DicEnum.PROJECT_STATUS.NEW;
}
}
#endregion
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var id = Request.QueryString["project_id"];
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
if (thisProject != null)
{
// if (!int.TryParse(Request.QueryString["cat"], out catId))
var catIdString = Request.QueryString["CatID"];
if (string.IsNullOrEmpty(catIdString))
{
catId = (int)DicEnum.QUERY_CATE.PROJECT_TASK;
}
else
{
catId = int.Parse(catIdString);
}
// if (!long.TryParse(Request.QueryString["type"], out queryTypeId))
var queryTypeIdString = Request.QueryString["QeryTypeId"];
if (string.IsNullOrEmpty(queryTypeIdString))
{
queryTypeId = (int)QueryType.PROJECT_TASK;
//queryTypeId = (int)QueryType.PROJECT_PHASE;
}
else
{
queryTypeId = int.Parse(queryTypeIdString);
}
if (catId == 0 || queryTypeId == 0)
{
Response.Close();
return;
}
// 一个query_type下只有一个group时可以不传参gruop_id
if (paraGroupId == 0)
{
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;
}
}
}
// if (!long.TryParse(Request.QueryString["id"], out objId))
if (thisProject.baseline_project_id != null)
{
objId = (long)thisProject.baseline_project_id;
}
QueryData();
CalcTableWidth();
}
else
{
Response.End();
}
}
catch (Exception msg)
{
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var cid = Request.QueryString["contract_id"];
var project_id = Request.QueryString["project_id"];
var ccid = Request.QueryString["cost_id"];
if (!string.IsNullOrEmpty(cid))
{
contract = new ctt_contract_dal().FindNoDeleteById(long.Parse(cid));
}
if (!string.IsNullOrEmpty(project_id))
{
thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(project_id));
}
conCost = new ctt_contract_cost_dal().FindNoDeleteById(long.Parse(ccid));
if (conCost != null)
{
if (conCost.product_id != null)
{
product = new ivt_product_dal().FindNoDeleteById((long)conCost.product_id);
}
else
{
product = new ivt_product_dal().GetDefaultProduct();
}
if (conCost.quantity != null)
{
var thisSubList = new crm_installed_product_dal().GetInsProByCostId(conCost.id, (long)conCost.quantity);
int num = (int)conCost.quantity;
if (thisSubList != null && thisSubList.Count > 0)
{
num = (int)conCost.quantity - thisSubList.Count;
exisCostList = new ctt_contract_cost_dal().GetItemByNum(conCost.id, thisSubList.Count);
}
if (num > 0)
{
costList = new ctt_contract_cost_dal().GetItemByNum(conCost.id, num);
}
}
if (costList != null && costList.Count > 0)
{
}
}
if (conCost == null)
{
Response.Write("<script>alert('未查询到成本');window.close();</script>");
return;
}
if (conCost.create_ci == 1)
{
Response.Write("<script>alert('成本已创建配置项！');window.close();</script>");
return;
}
}
catch (Exception)
{
Response.End();
}
}
