/// <summary>
/// 获取到下拉框中客户和父客户的联系人
/// </summary>
private void GetParAndAccSelect(HttpContext context, long account_id)
{
StringBuilder conHtml = new StringBuilder();
var account = new crm_account_dal().FindNoDeleteById(account_id);
if (account != null)
{
var conList = new crm_contact_dal().GetContactByAccountId(account.id);
if (conList != null && conList.Count > 0)
{
foreach (var con in conList)
{
conHtml.Append($"<option value='{con.id}'>{con.name}</option>");
}
}
if (account.parent_id != null)
{
var parConList = new crm_contact_dal().GetContactByAccountId((long)account.parent_id);
if (parConList != null && parConList.Count > 0)
{
conHtml.Append("<option value=''>-----</option>");
foreach (var con in conList)
{
conHtml.Append($"<option value='{con.id}'>{con.name}</option>");
}
}
}
}
context.Response.Write(conHtml.ToString());
}
/// <summary>
/// 删除前校验
/// </summary>
/// <param name="id"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Delete_Validate(long id, long user_id, out int n)
{
n = 0;
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var data = _dal.FindById(id);
if (data == null)
{
return(ERROR_CODE.ERROR);
}
if (data.is_system > 0)
{
return(ERROR_CODE.SYSTEM);
}
var mar = new crm_account_dal().FindListBySql($"select * from crm_account where classification_id={id} and delete_time=0");
if (mar.Count > 0)
{
n = mar.Count;
return(ERROR_CODE.ACCOUNT_TYPE_USED);
}
data.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.delete_user_id = user_id;
if (!_dal.Update(data))
{
return(ERROR_CODE.ERROR);
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 获取到客户和父客户的联系人
/// </summary>
private void GetConAccAndPar(HttpContext context, long account_id)
{
StringBuilder conHtml = new StringBuilder();
var account = new crm_account_dal().FindNoDeleteById(account_id);
if (account != null)
{
var conList = new crm_contact_dal().GetContactByAccountId(account.id);
if (conList != null && conList.Count > 0)
{
foreach (var con in conList)
{
conHtml.Append("<tr><td><input type='checkbox' value='" + con.id + "' class='checkCon' /></td><td>" + con.name + "</td><td><a href='mailto:" + con.email + "'>" + con.email + "</a></td></tr>");
}
}
if (account.parent_id != null)
{
var parConList = new crm_contact_dal().GetContactByAccountId((long)account.parent_id);
if (parConList != null && parConList.Count > 0)
{
conHtml.Append("<tr><td colspan='3'>父客户联系人</td></tr>");
foreach (var con in conList)
{
conHtml.Append("<tr><td><input type='checkbox' value='" + con.id + "' class='checkCon' /></td><td>" + con.name + "</td><td><a href='mailto:" + con.email + "'>" + con.email + "</a></td></tr>");
}
}
}
}
context.Response.Write(conHtml.ToString());
}
/// <summary>
/// 通过id删除
/// </summary>
/// <param name="id"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Delete(long id, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var data = _dal.FindById(id);
if (data == null)
{
return(ERROR_CODE.ERROR);
}
if (data.is_system > 0)
{
return(ERROR_CODE.SYSTEM);
}
var mar = new crm_account_dal().FindListBySql($"select * from crm_account where classification_id={id} and delete_time=0");
if (mar.Count > 0)
{
foreach (var acc in mar)
{
acc.classification_id = null;
acc.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
acc.update_user_id = user_id;
if (!new crm_account_dal().Update(acc))
{
return(ERROR_CODE.ERROR);
}
}
}
data.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.delete_user_id = user_id;
if (!_dal.Update(data))
{
return(ERROR_CODE.ERROR);
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = "",
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNTCLASS, //
oper_object_id = data.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(data),
remark = "删除客户类别信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 根据员工和相关条件获取相对应的客户
/// </summary>
private void GetAccByRes(HttpContext context, long rId, string showType, bool isShowComp)
{
var list = new crm_account_dal().GetAccByRes(rId, showType, isShowComp);
if (list != null && list.Count > 0)
{
// var accDic = list.GroupBy(_ => _.id).ToDictionary(_ => _.Key, _ => _.FirstOrDefault(f=>!string.IsNullOrEmpty(f.name)).name);
context.Response.Write(new Tools.Serialize().SerializeJson(list));
}
}
void GetAccountByIds(HttpContext context)
{
var ids = context.Request.QueryString["ids"];
if (!string.IsNullOrEmpty(ids))
{
List <crm_account> accList = new crm_account_dal().GetCompanyByIds(ids);
if (accList != null && accList.Count > 0)
{
WriteResponseJson(accList);
}
}
}
private void GetVendorsByProductId(HttpContext context, long product_id)
{
var vendorList = new crm_account_dal().FindListBySql <crm_account>($"SELECT * from crm_account where id in( select vendor_account_id from ivt_product_vendor where product_id = {product_id} )");
if (vendorList != null && vendorList.Count > 0)
{
StringBuilder vendors = new StringBuilder();
foreach (var vendor in vendorList)
{
vendors.Append("<option value='" + vendor.id + "'>" + vendor.name + "</option>");
}
context.Response.Write(vendors);
}
}
/// <summary>
/// 新增合同时添加服务包
/// </summary>
/// <param name="context"></param>
/// <param name="id"></param>
public void AddServiceBundle(HttpContext context, long id)
{
var serBun = new ivt_service_bundle_dal().FindById(id);
string txt = "";
decimal pricePerPeriod = 0;
int monthsPerPeriod = 1;
List <object> result = new List <object>();
if (serBun == null)
{
result.Add(txt);
result.Add(pricePerPeriod);
context.Response.Write(new Tools.Serialize().SerializeJson(result));
return;
}
// 获取供应商名称
string vendorName = "";
if (serBun.vendor_account_id != null)
{
var vendorDal = new ivt_product_vendor_dal();
var accountDal = new crm_account_dal();
var vendor = vendorDal.FindById((long)serBun.vendor_account_id);
if (vendor.vendor_account_id != null)
{
vendorName = accountDal.FindById((long)vendor.vendor_account_id).name;
}
}
// 周期
string period = "";
if (serBun.period_type_id != null)
{
period = new GeneralBLL().GetGeneralName((int)serBun.period_type_id);
if (serBun.unit_price == null)
{
pricePerPeriod = 0;
}
else
{
pricePerPeriod = (decimal)serBun.unit_price;
}
if (serBun.period_type_id == (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.QUARTER)
{
monthsPerPeriod = 3;
}
if (serBun.period_type_id == (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.HALFYEAR)
{
monthsPerPeriod = 6;
}
if (serBun.period_type_id == (int)DicEnum.QUOTE_ITEM_PERIOD_TYPE.YEAR)
{
monthsPerPeriod = 12;
}
}
string unitCost = "";
if (serBun.unit_cost != null)
{
unitCost = "¥" + serBun.unit_cost.ToString();
}
txt += $"<tr id='service{serBun.id}'>";
txt += $"<td style='white - space:nowrap; '><img src = '../Images/delete.png' onclick='RemoveServiceBundle({serBun.id})' alt = '' /></ td > ";
txt += $"<td><span>{serBun.name}</span></td>";
txt += $"<td nowrap>{vendorName}</td>";
txt += $"<td nowrap><span>{period}</span><input type='hidden' id='period{serBun.id}' value='{monthsPerPeriod}' ></td>";
txt += $"<td nowrap align='right'><span>{unitCost}</span></td>";
txt += $"<td nowrap align='right'>" + $"<input type='text' onblur='CalcService()' id='price{serBun.id}' name='price{serBun.id}' value = '{pricePerPeriod}' >" + "</ td > ";
txt += $"<td nowrap align='right'>" + $"<input type='text' onblur='CalcService()' id='num{serBun.id}' name='num{serBun.id}' value = '1' >" + "</ td > ";
txt += $"<td nowrap align='right'>￥" + $"<input type='text' id='pricenum{serBun.id}' value = '{pricePerPeriod}' disabled >" + "</ td > ";
txt += "</tr>";
result.Add(txt);
result.Add(pricePerPeriod);
result.Add(serBun.id);
result.Add(monthsPerPeriod);
context.Response.Write(new Tools.Serialize().SerializeJson(result));
}
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();
}
}
/// <summary>
/// 根据第一页的查询条件，显示第二页的内容
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lbnext_Click(object sender, EventArgs e)
{
var accountId = account_idHidden.Value;
var showChildAcc = ckchildAccounts.Checked;
var showserviceContract = ckserviceContract.Checked;
var showFixPrice = ckFixPrice.Checked;
var showPriceZero = ckPirceZero.Checked;
var project_id = project_idHidden.Value;
var department = department_id.SelectedValue;
var startDate = itemStartDate.Value;
var endDate = itemEndDate.Value;
var contractType = contract_type_id.SelectedValue;
var contractCate = contract_cate_id.SelectedValue;
var project_item = projectItem.SelectedValue;
var type = thisItemTypeId.Value; // 条目类型-多选--toTest
var cadDal = new crm_account_deduction_dal();
var chooseAccount = new CompanyBLL().GetCompany(long.Parse(accountId));
if (chooseAccount == null)
{
return;
}
//accDedList = cadDal.GetAccDed(chooseAccount.id); // 将要在页面上显示的条目
//if (accDedList == null)
// accDedList = new List<crm_account_deduction>();
StringBuilder sqlWhere = new StringBuilder();
if (!string.IsNullOrEmpty(project_id))
{
sqlWhere.Append($" and project_id={project_id}");
}
if ((!string.IsNullOrEmpty(department)) && (department != "0"))
{
sqlWhere.Append($" and department_id={department}");
}
if (!string.IsNullOrEmpty(startDate))
{
sqlWhere.Append($" and item_date>='{startDate}'");
}
if (!string.IsNullOrEmpty(endDate))
{
sqlWhere.Append($" and item_date<='{endDate}'");
}
if (!string.IsNullOrEmpty(type))
{
sqlWhere.Append($" and item_type in ({type}) ");
}
if ((!string.IsNullOrEmpty(contractType)) && contractType != "0")
{
sqlWhere.Append($" and contract_type_id={contractType}");
}
if ((!string.IsNullOrEmpty(contractCate)) && contractCate != "0")
{
sqlWhere.Append($" and contract_cate_id={contractCate}");
}
if (project_item == "onlyProject")
{
sqlWhere.Append($" and project_id is not null");
}
if (project_item == "onlyNoProject")
{
sqlWhere.Append($" and project_id is null");
}
// todo 其余三个Show的过滤
if (!showserviceContract)
{
sqlWhere.Append($" and (item_type in(1318,1319) and contract_type_id not in(1199) or item_type not in(1318,1319) )");
}
if (!showFixPrice)
{
sqlWhere.Append($" and (item_type in(1318,1319) and contract_type_id not in(1201) or item_type not in(1318,1319) )");
}
if (showPriceZero)
{
sqlWhere.Append($" and dollars <>0");
}
List <InvoiceDeductionDto> deeList = null;
var sortOrder = Request.QueryString["sortOrder"];
switch (sortOrder)
{
case "1": // 客户
deeList = cadDal.GetInvDedDtoList(sqlWhere.ToString() + " and account_id=" + chooseAccount.id.ToString() + " and invoice_id is null and purchase_order_no is null");
break;
case "2": // ticket
deeList = cadDal.GetInvDedDtoList(sqlWhere.ToString() + " and account_id=" + chooseAccount.id.ToString() + " and invoice_id is null and purchase_order_no is null AND project_id is null");
break;
case "3": // 项目
var thisProject = Request.QueryString["thisProject"];
deeList = cadDal.GetInvDedDtoList(sqlWhere.ToString() + " and account_id=" + chooseAccount.id.ToString() + " and invoice_id is null and purchase_order_no is null AND project_id = " + thisProject);
break;
case "4": // 采购订单
var thisPurOrder = Request.QueryString["thisPurOrder"];
if (!string.IsNullOrEmpty(thisPurOrder))
{
thisPurOrder = thisPurOrder.Substring(5, thisPurOrder.Length - 5);
deeList = cadDal.GetInvDedDtoList(sqlWhere.ToString() + " and account_id=" + chooseAccount.id.ToString() + " and invoice_id is null and purchase_order_no =" + thisPurOrder);
}
break;
default:
break;
}
#region 加上子公司的条目
if (showChildAcc) // 代表用户选中展示子客户条目
{
var childAccList = new crm_account_dal().GetSubsidiariesById(chooseAccount.id);
if (childAccList != null && childAccList.Count > 0)
{
foreach (var childAcc in childAccList)
{
var childAccDedList = cadDal.GetInvDedDtoList(sqlWhere.ToString() + " and account_id=" + childAcc.id); //+ " and bill_account_id <>"+ chooseAccount.id
if (childAccDedList != null && childAccDedList.Count > 0)
{
childAccDedList.ForEach(_ => {
_.isSub = "1";
});
deeList.AddRange(childAccDedList); // 循环添加子客户条目
}
}
}
}
StringBuilder dedHtml = new StringBuilder();
if (deeList != null && deeList.Count > 0)
{
deeList = deeList.Distinct().ToList();
foreach (var invDedDto in deeList)
{
// 1 代表是不可选的子客户
// 2 待定 可选但是默认不选
var ischeck = invDedDto.isSub == "1" ? "disabled" : invDedDto.isSub == "2"?"": "checked";
var imgSrc = invDedDto.type_icon; // 根据类型选择图片位置
var itemName = invDedDto.item_name; // todo 部分有下标名
var rate = invDedDto.rate == null ? "" : ((decimal)invDedDto.rate).ToString("#0.00");
var quantity = invDedDto.quantity == null ? "" : ((decimal)invDedDto.quantity).ToString("#0.00");
var dollars = invDedDto.dollars == null ? "" : ((decimal)invDedDto.dollars).ToString("#0.00");
var bill_to_parent = string.IsNullOrEmpty(invDedDto.bill_to_parent) ? "" : "√";
var bill_to_sub = string.IsNullOrEmpty(invDedDto.bill_to_sub) ? "" : "√";
dedHtml.Append($"<tr><td align='center' style='width: 20px;'><input type='checkbox' class='thisDedCheck' style='margin: 0;' value='{invDedDto.id}' {ischeck}></td><td width='20px' align='center'><img src='{imgSrc}' /></td> <td width='20' align='center'>{invDedDto.item_date}</td><td>{itemName}</td><td>{invDedDto.account_name}</td><td>{invDedDto.contract_name}</td><td>{invDedDto.department_name}</td><td>{invDedDto.cost_code_name}</td><td>{invDedDto.resource_name}</td><td>{invDedDto.role_name}</td><td>{invDedDto.project_name}</td><td>{rate}</td><td>{quantity}</td><td>{dollars}</td><td>{invDedDto.tax_category_name}</td><td>{bill_to_parent}</td><td>{bill_to_sub}</td></tr>");
//showAccountDed
}
//ClientScript.RegisterStartupScript(this.GetType(), "提示信息", "<script></script>");
}
ClientScript.RegisterStartupScript(this.GetType(), "页面跳转", "<script>document.getElementById('showAccountDed').innerHTML=\"" + dedHtml.ToString() + "\";document.getElementsByClassName('Workspace1')[0].style.display = 'none';document.getElementsByClassName('Workspace2')[0].style.display = '';document.getElementById('date_range_from').value=\"" + startDate + "\";document.getElementById('date_range_to').value=\"" + endDate + "\";</script>");
#endregion
}
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
{
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();
}
}
