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;
}
