/// <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> 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> /// 获取配置项相关详情数据 /// </summary> private void GetInsProDetail(HttpContext context) { var insProId = context.Request.QueryString["insProId"]; if (!string.IsNullOrEmpty(insProId)) { var insPr = new crm_installed_product_dal().FindNoDeleteById(long.Parse(insProId)); if (insPr != null) { string name = ""; string contactName = ""; string contactId = ""; string insTime = ""; string insUser = ""; string insWarnTime = ""; // 保修期 string vendorId = ""; string vendorName = ""; string insService = ""; int relateNum = 0; // 相关配置项 var thisPro = new ivt_product_dal().FindNoDeleteById(insPr.product_id); if (thisPro != null) { name = thisPro.name; } if (insPr.contact_id != null) { var contact = new crm_contact_dal().FindNoDeleteById((long)insPr.contact_id); if (contact != null) { contactId = contact.id.ToString(); contactName = contact.name; } } if (insPr.installed_resource_id != null) { var insRes = new sys_resource_dal().FindNoDeleteById((long)insPr.installed_resource_id); if (insRes != null) { insUser = insRes.name; } } if (insPr.vendor_account_id != null) { var thisVnedor = new CompanyBLL().GetCompany((long)insPr.vendor_account_id); if (thisVnedor != null) { vendorId = thisVnedor.id.ToString(); vendorName = thisVnedor.name; } } insTime = Tools.Date.DateHelper.ConvertStringToDateTime(insPr.create_time).ToString("yyyy-MM-dd"); context.Response.Write(new Tools.Serialize().SerializeJson(new { id = insPr.id, name = name, contactId = contactId, contactName = contactName, insTime = insTime, insUser = insUser, insWarnTime = insWarnTime, vendorId = vendorId, vendorName = vendorName, insService = insService, relateNum = relateNum })); } } }
private void GetContactInfo(HttpContext context) { var contatc_id = context.Request.QueryString["contact_id"]; if (!string.IsNullOrEmpty(contatc_id)) { var thisContact = new crm_contact_dal().FindNoDeleteById(long.Parse(contatc_id)); if (thisContact != null) { context.Response.Write(new Tools.Serialize().SerializeJson(thisContact)); } } }
private void GetConName(HttpContext context, string ids) { StringBuilder con = new StringBuilder(); if (!string.IsNullOrEmpty(ids)) { var conList = new crm_contact_dal().GetContactByIds(ids); if (conList != null && conList.Count > 0) { conList.ForEach(_ => con.Append($";{_.name}")); } } context.Response.Write(con.ToString()); }
public bool UpdateContacts(string updateIds, string phone, string fax, long user_id) { var user = UserInfoBLL.GetUserInfo(user_id); if (user == null) { return(false); } var con_list = updateIds.Split(','); var contactList = _dal.GetContactByIds(updateIds); if (contactList != null && contactList.Count > 0) { foreach (var item in con_list) { var contact = new crm_contact_dal().FindById(Convert.ToInt64(item)); // 获取到对应的联系人信息 if (contact != null) { contact.phone = phone; contact.fax = fax; contact.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); contact.update_user_id = user.id; new crm_contact_dal().Update(contact); // 修改联系人 new sys_oper_log_dal().Insert(new sys_oper_log() { user_cate = "用户", user_id = user.id, name = user.name, phone = user.mobile == null ? "" : user.mobile, oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS, oper_object_id = contact.id, oper_type_id = (int)OPER_LOG_TYPE.UPDATE, oper_description = _dal.CompareValue(contactList.FirstOrDefault(_ => _.id == contact.id), contact), remark = "修改联系人电话或传真", }); // 插入更改日志 } } } return(true); }
/// <summary> /// 获取联系人的详情信息 /// </summary> private void GetContactDetail(HttpContext context) { var contatc_id = context.Request.QueryString["contact_id"]; if (!string.IsNullOrEmpty(contatc_id)) { var thisContact = new crm_contact_dal().FindNoDeleteById(long.Parse(contatc_id)); if (thisContact != null) { int ticketNum = 0; // 所有打开的工单的数量 int monthNum = 0; // 近三十天工单的数量 var ticketList = new sdk_task_dal().GetTicketByContact(thisContact.id); if (ticketList != null && ticketList.Count > 0) { ticketNum = ticketList.Count; } context.Response.Write(new Tools.Serialize().SerializeJson(new { id = thisContact.id, name = thisContact.name, phone = thisContact.phone, ticketNum = ticketNum, monthNum = monthNum, })); } } }
protected void Page_Load(object sender, EventArgs e) { try { // 预付时间合同、预付费合同、事件合同的详情主界面 var contract_id = Request.QueryString["contract_id"]; if (!string.IsNullOrEmpty(contract_id)) { thisContract = new ctt_contract_dal().FindNoDeleteById(long.Parse(contract_id)); } var thisId = Request.QueryString["id"]; var srDal = new sys_resource_dal(); var ccDal = new crm_contact_dal(); if (!string.IsNullOrEmpty(thisId)) { thisRule = new ctt_contract_notify_rule_dal().FindNoDeleteById(long.Parse(thisId)); if (thisRule != null) { isAdd = false; thisContract = new ctt_contract_dal().FindNoDeleteById(thisRule.contract_id); new ctt_contract_notify_rule_recipient_dal(); thisRuleResList = srDal.GetConRuleList(thisRule.id); otherRuleResList = srDal.GetNotInConRuleList(thisRule.id); thisRuleConList = ccDal.GetConRuleList(thisRule.id); otherRuleConList = ccDal.GetNotInConRuleList(thisRule.id, thisContract.account_id); } } else { otherRuleResList = srDal.GetSourceList(); otherRuleConList = ccDal.GetContactByAccountId(thisContract.account_id); } if (thisContract == null) { Response.Write("<script>window.close();</script>"); Response.End(); } if (thisContract.type_id == (int)DicEnum.CONTRACT_TYPE.BLOCK_HOURS || thisContract.type_id == (int)DicEnum.CONTRACT_TYPE.RETAINER || thisContract.type_id == (int)DicEnum.CONTRACT_TYPE.PER_TICKET) { // conTypeName List <sys_notify_tmpl> thisTemp = null; var sntDal = new sys_notify_tmpl_dal(); if (thisContract.type_id == (int)DicEnum.CONTRACT_TYPE.BLOCK_HOURS) { conTypeName = "预付时间"; thisTemp = sntDal.GetTempByEvent(DicEnum.NOTIFY_EVENT.BLOCK_CONTRACT_RULE); } else if (thisContract.type_id == (int)DicEnum.CONTRACT_TYPE.RETAINER) { conTypeName = "预付费"; thisTemp = sntDal.GetTempByEvent(DicEnum.NOTIFY_EVENT.RETAINER_CONTRACT_RULE); } else { conTypeName = "事件"; thisTemp = sntDal.GetTempByEvent(DicEnum.NOTIFY_EVENT.PER_CONTRACT_RULE); } notify_tmpl_id.DataTextField = "name"; notify_tmpl_id.DataValueField = "id"; notify_tmpl_id.DataSource = thisTemp; notify_tmpl_id.DataBind(); if (thisRule != null) { notify_tmpl_id.SelectedValue = thisRule.notify_tmpl_id.ToString(); } } else { Response.Write("<script>alert('该合同类型暂不能添加通知规则');window.close();</script>"); Response.End(); } } catch (Exception) { Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { try { thisBookMark = new IndexBLL().GetSingBook(Request.RawUrl, LoginUserId); var soid = Request.QueryString["id"]; if (AuthBLL.GetUserSaleorderAuth(LoginUserId, LoginUser.security_Level_id, Convert.ToInt64(soid)).CanEdit == false) { Response.End(); return; } sale_order = new crm_sales_order_dal().GetSingleSalesOrderByWhere($" and id = {soid}"); if (sale_order != null) { sale_udfList = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.SALES); sale_udfValueList = new UserDefinedFieldsBLL().GetUdfValue(DicEnum.UDF_CATE.SALES, sale_order.id, sale_udfList); opportunity = new crm_opportunity_dal().GetOpportunityById(sale_order.opportunity_id); if (!IsPostBack) { var contactList = new crm_contact_dal().GetContactByAccountId(opportunity.account_id); #region 拉赋值 status_id.DataTextField = "show"; status_id.DataValueField = "val"; status_id.DataSource = dic.FirstOrDefault(_ => _.Key == "sales_order_status").Value; status_id.DataBind(); status_id.Items.Insert(0, new ListItem() { Value = "0", Text = " ", Selected = true }); owner_resource_id.DataTextField = "show"; owner_resource_id.DataValueField = "val"; owner_resource_id.DataSource = dic.FirstOrDefault(_ => _.Key == "sys_resource").Value; owner_resource_id.DataBind(); owner_resource_id.Items.Insert(0, new ListItem() { Value = "0", Text = " ", Selected = true }); // bill_country_id bill_country_id.DataTextField = "show"; bill_country_id.DataValueField = "val"; bill_country_id.DataSource = dic.FirstOrDefault(_ => _.Key == "country").Value; bill_country_id.DataBind(); bill_country_id.Items.Insert(0, new ListItem() { Value = "0", Text = " ", Selected = true }); bill_country_id.SelectedValue = "1"; ship_country_id.DataTextField = "show"; ship_country_id.DataValueField = "val"; ship_country_id.DataSource = dic.FirstOrDefault(_ => _.Key == "country").Value; ship_country_id.DataBind(); ship_country_id.Items.Insert(0, new ListItem() { Value = "0", Text = " ", Selected = true }); ship_country_id.SelectedValue = "1"; // contact_id contact_id.DataTextField = "name"; contact_id.DataValueField = "id"; contact_id.DataSource = contactList.Where(_ => _.is_active == 1).ToList(); contact_id.DataBind(); contact_id.Items.Insert(0, new ListItem() { Value = "0", Text = " ", Selected = true }); if (sale_order.contact_id != null) { contact_id.SelectedValue = sale_order.contact_id.ToString(); } #endregion billTo_use_account_address.Checked = sale_order.bill_to_use_account_address == 1; shipTo_use_account_address.Checked = sale_order.ship_to_use_account_address == 1; shipTo_use_bill_to_address.Checked = sale_order.ship_to_use_bill_to_address == 1; status_id.SelectedValue = sale_order.status_id.ToString(); owner_resource_id.SelectedValue = sale_order.owner_resource_id.ToString(); } } else { Response.End(); } } catch (Exception) { Response.End(); } }