public ActionResult AddContactMade(int id) { var p = CurrentDatabase.LoadPersonById(id); DbUtil.LogPersonActivity($"Adding contact from: {p.Name}", id, p.Name); var c = new Contact { CreatedDate = Util.Now, CreatedBy = CurrentDatabase.UserId1, ContactDate = Util.Now.Date }; CurrentDatabase.Contacts.InsertOnSubmit(c); CurrentDatabase.SubmitChanges(); var cp = new Contactor { PeopleId = p.PeopleId, ContactId = c.ContactId }; CurrentDatabase.Contactors.InsertOnSubmit(cp); CurrentDatabase.SubmitChanges(); var defaultRole = CurrentDatabase.Setting("Contacts-DefaultRole", null); if (defaultRole.HasValue() && CurrentDatabase.Roles.Any(x => x.RoleName == defaultRole)) { Util.TempSetRole = defaultRole; } Util.TempContactEdit = true; return(Content("/Contact2/" + c.ContactId)); }
public ActionResult AddContactMade(int id) { var p = DbUtil.Db.LoadPersonById(id); DbUtil.LogActivity("Adding contact from: {0}".Fmt(p.Name)); var c = new CmsData.Contact { CreatedDate = Util.Now, CreatedBy = Util.UserId1, ContactDate = Util.Now.Date, ContactTypeId = 99, ContactReasonId = 99, }; DbUtil.Db.Contacts.InsertOnSubmit(c); DbUtil.Db.SubmitChanges(); var cp = new Contactor { PeopleId = p.PeopleId, ContactId = c.ContactId }; DbUtil.Db.Contactors.InsertOnSubmit(cp); DbUtil.Db.SubmitChanges(); return(Content("/Contact.aspx?id=" + c.ContactId)); }
public ActionResult AddContactMade(int id) { var p = DbUtil.Db.LoadPersonById(id); DbUtil.LogPersonActivity($"Adding contact from: {p.Name}", id, p.Name); var c = new Contact { CreatedDate = Util.Now, CreatedBy = Util.UserId1, ContactDate = Util.Now.Date }; DbUtil.Db.Contacts.InsertOnSubmit(c); DbUtil.Db.SubmitChanges(); var cp = new Contactor { PeopleId = p.PeopleId, ContactId = c.ContactId }; DbUtil.Db.Contactors.InsertOnSubmit(cp); DbUtil.Db.SubmitChanges(); TempData["ContactEdit"] = true; return(Content("/Contact2/" + c.ContactId)); }
private ReturnResult AddContactors(int id, int origin) { var c = DbUtil.Db.Contacts.SingleOrDefault(ct => ct.ContactId == id); if (c == null) { return(new ReturnResult { close = true, how = "CloseAddDialog", from = AddContext }); } foreach (var p in PendingList) { AddPerson(p, PendingList, origin, EntryPointId); var ctor = c.contactsMakers.SingleOrDefault(ct => ct.ContactId == id && ct.PeopleId == p.Person.PeopleId); if (ctor == null) { ctor = new Contactor { ContactId = id, PeopleId = p.Person.PeopleId }; c.contactsMakers.Add(ctor); DbUtil.LogActivity("AddContactor " + id, peopleid: p.PeopleId); } } DbUtil.Db.SubmitChanges(); return(new ReturnResult { close = true, cid = id, from = AddContext }); }
private JsonResult AddContactors(int id, SearchAddModel m, int origin) { if (id > 0) { var c = DbUtil.Db.Contacts.SingleOrDefault(ct => ct.ContactId == id); if (c == null) { return(Json(new { close = true, how = "CloseAddDialog" })); } foreach (var p in m.List) { AddPerson(p, m.List, origin, m.EntryPointId); var ctor = c.contactsMakers.SingleOrDefault(ct => ct.ContactId == id && ct.PeopleId == p.person.PeopleId); if (ctor == null) { ctor = new Contactor { ContactId = id, PeopleId = p.person.PeopleId, }; c.contactsMakers.Add(ctor); } } DbUtil.Db.SubmitChanges(); } return(Json(new { close = true, how = "addselected" })); }
public ActionResult AddContactMade(int id) { var p = DbUtil.Db.LoadPersonById(id); DbUtil.LogPersonActivity($"Adding contact from: {p.Name}", id, p.Name); var c = new Contact { CreatedDate = Util.Now, CreatedBy = Util.UserId1, ContactDate = Util.Now.Date }; DbUtil.Db.Contacts.InsertOnSubmit(c); DbUtil.Db.SubmitChanges(); var cp = new Contactor { PeopleId = p.PeopleId, ContactId = c.ContactId }; DbUtil.Db.Contactors.InsertOnSubmit(cp); DbUtil.Db.SubmitChanges(); var defaultRole = DbUtil.Db.Setting("Contacts-DefaultRole", null); if (!string.IsNullOrEmpty(defaultRole) && DbUtil.Db.Roles.Any(x => x.RoleName == defaultRole)) { TempData["SetRole"] = defaultRole; } TempData["ContactEdit"] = true; return(Content("/Contact2/" + c.ContactId)); }
public static IQueryable <客戶聯絡人> Sort(this IQueryable <客戶聯絡人> entity, Contactor ctor, string asc) { IQueryable <客戶聯絡人> new_entity; switch (ctor) { case Contactor.職稱: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.職稱) : entity.OrderByDescending(s => s.職稱); break; case Contactor.姓名: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.姓名) : entity.OrderByDescending(s => s.姓名); break; case Contactor.電子郵件: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.Email) : entity.OrderByDescending(s => s.Email); break; case Contactor.手機: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.手機) : entity.OrderByDescending(s => s.手機); break; case Contactor.電話: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.電話) : entity.OrderByDescending(s => s.電話); break; case Contactor.客戶名稱: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.客戶資料.客戶名稱) : entity.OrderByDescending(s => s.客戶資料.客戶名稱); break; default: new_entity = string.Equals(asc, "up") ? entity.OrderBy(s => s.職稱) : entity.OrderByDescending(s => s.職稱); break; } return(new_entity); }
//добавить контактор в проект public ProjectEquipment AttachContactor(Project project, Contactor cont, string note) { using (DataEntities db = new DataEntities()) { ProjectEquipment pe = new ProjectEquipment(); if (project.IdNumber != 0) { pe.IdProjectNumber = project.IdNumber; } pe.IdCont = cont.Id; pe.Analog = false; db.ProjectEquipments.Add(pe); db.SaveChanges(); return(pe); } }
//добавить контактор в проект public static ProjectEquipment AttachContactor(Project project, Contactor cont, string note) { return(equipobj.AttachContactor(project, cont, note)); }
// Start is called before the first frame update void Start() { contactor = GetComponent <Contactor>(); }
public BaseResult AddContactor(int userId, Contactor contactor, int compId) { var rs = new BaseResult { State = false, Value = -1, Desc = "数据操作层初始化" }; if (userId <= 0) { rs.Failed(-101, "userId无效"); return rs; } if (contactor.Equals(null)) { rs.Failed(-101, "contactor无效"); return rs; } _desc = "某个终端客户添加一个联系人,含分组,联系方式"; _procName = "UP_Addr_Contactor_AddContactor"; _methodName = MethodBase.GetCurrentMethod().Name; _log = new LogBuilder { Method = string.Format("类[{0}]方法[{1}]", ClassName, _methodName), Desc = _desc, Database = _databaseName, StroreProcedure = _procName }; _log.Append("userId", userId); try { //联系方式xml var wayClass = new XMLContactWayClass { XmlContactWay = contactor.CWays.Select( way => new XmlContactWay { ContactWayType = way.ContactWayType, Way = way.Way }).ToArray() }; var wayData = XmlHelper.XmlSerializer<XMLContactWayClass>(wayClass); wayData = wayData.Replace("<?xml version=\"1.0\" encoding=\"utf-8\"?>", ""); //分组xml var groupClass = new XMLContactGroupClass { XmlContactGroup = contactor.CGroups.Select( @group => new XmlContactGroup { ContactorGroupID = @group.ContactorGroupID }).ToArray() }; var groupData = XmlHelper.XmlSerializer<XMLContactGroupClass>(groupClass); groupData = groupData.Replace("<?xml version=\"1.0\" encoding=\"utf-8\"?>", ""); var parameters = new[] { _addrDatabase.MakeInParam("@userId", SqlDbType.Int, 4, userId), _addrDatabase.MakeInParam("@CompID", SqlDbType.Int, 4, compId), _addrDatabase.MakeInParam("@Name", SqlDbType.VarChar, 20, contactor.ContactorName), _addrDatabase.MakeInParam("@ContactWay", SqlDbType.Xml, int.MaxValue, wayData), _addrDatabase.MakeInParam("@ContactGroup", SqlDbType.Xml, int.MaxValue, groupData), _addrDatabase.MakeInParam("@ConfParticipatePhoneNo",SqlDbType.VarChar,50,contactor.ConfParticipatePhoneNo) }; _addrDatabase.ExecuteProc(_procName, parameters, out _result); if (_result != 0) { rs.Failed(-2, "todo"); return rs; } } catch (Exception ex) { rs.Failed(-1, ex.ToString()); _log.Exception = string.Format("{0},发生异常:{1}", _desc, ex.Message); _log.Error(); return rs; } finally { _addrDatabase.Close();//仅显式关闭链接,不做其它操作 } rs.Success(); return rs; }
public ResultContactorDetail GetDetail(int userId, int contactorID, int compId) { var rs = new ResultContactorDetail { State = false, Value = -1, Desc = "数据操作层初始化" }; if (userId <= 0) { rs.Failed(-101, "userId无效"); return rs; } if (contactorID <= 0) { rs.Failed(-102, "compId无效"); return rs; } _desc = "获取某个终端客户的某个联系人详细信息,含姓名、联系方式、所在分组。"; _procName = "UP_Addr_Contactor_GetSingleFullInfo"; _methodName = MethodBase.GetCurrentMethod().Name; _log = new LogBuilder { Method = string.Format("类[{0}]方法[{1}]", ClassName, _methodName), Desc = _desc, Database = _databaseName, StroreProcedure = _procName }; _log.Append("userId", userId); _log.Append("contactorID", contactorID); try { var parameters = new[] { _addrDatabase.MakeInParam("@ContactorID", SqlDbType.Int, 4, contactorID) }; _addrDatabase.ExecuteProc(_procName, parameters, out _ds); if (_ds != null) { if (rs.ContactorInfo == null) { rs.ContactorInfo = new Contactor(); } var obj = new Contactor(); obj.ContactorID = Convert.ToInt32(SqlComponents.ReaderGetString(_ds.Tables[0].Rows[0]["ContactorID"])); obj.ContactorName = SqlComponents.ReaderGetString(_ds.Tables[0].Rows[0]["Name"]); obj.ConfParticipatePhoneNo = SqlComponents.ReaderGetString(_ds.Tables[0].Rows[0]["Field"]); var dtWay = _ds.Tables[1]; //联系方式 var listWay = new List<ContactWay>(); //新版本读取联系方式 if (dtWay != null && dtWay.Rows.Count > 0) { for (var i = 0; i < dtWay.Rows.Count; i++) { var way = new ContactWay { ContactWayID = Convert.ToInt32(dtWay.Rows[i]["SysID"]), ContactWayType = Convert.ToInt32(dtWay.Rows[i]["FieldType"]), Way = dtWay.Rows[i]["Field"].ToString() }; listWay.Add(way); } } obj.CWays = listWay; obj.WayCount = listWay.Count > 0 ? listWay.Count : 0; var dtGroup = _ds.Tables[2]; //所在分组 if (dtGroup != null) { var listGroup = new List<ContactorGroup>(); for (var i = 0; i < dtGroup.Rows.Count; i++) { var group = new ContactorGroup { ContactorCount = Convert.ToInt32(dtGroup.Rows[i]["MemberCount"]), ContactorGroupID = Convert.ToInt32(dtGroup.Rows[i]["ContactGroupID"]), ContactorGroupName = dtGroup.Rows[i]["GroupName"].ToString() }; listGroup.Add(group); } obj.CGroups = listGroup; } rs.ContactorInfo = obj; } else { rs.Failed(-2, "todo"); return rs; } } catch (Exception ex) { rs.Failed(-1, ex.ToString()); _log.Exception = string.Format("{0},发生异常:{1}", _desc, ex.Message); _log.Error(); return rs; } finally { _addrDatabase.Close();//仅显式关闭链接,不做其它操作 } rs.Success(); return rs; }