public Contact GetLinkman(string sysNo, int userId, int companyId, Guid linkmanId)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(param_LinkmanId, SqlDbType.UniqueIdentifier).Value = linkmanId;
Contact contact = new Contact(sysNo, userId);
Linkman linkman = null;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetLinkman", cmd))
{
while (sdr.Read())
{
if (linkman == null)
{
linkman = new Linkman(linkmanId);
linkman.Name = sdr[field_Name].ToString();
contact.Linkmans.Add(linkman);
}
if (sdr[field_DetailId] == DBNull.Value || sdr[field_DetailId] == null)
{
continue;
}
LinkmanDetail detail = new LinkmanDetail((Guid)sdr[field_DetailId], (InfoType)sdr[field_Type]);
detail.IsDefault = (bool)sdr[field_IsDefault];
detail.Value = sdr[field_Value] == DBNull.Value ? null : sdr[field_Value].ToString();
linkman.Details.Add(detail);
}
}
return(contact);
}
public void AddLinkmanDetail(Guid linkmanId, LinkmanDetail linkmanDetail)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(param_LinkmanId, SqlDbType.UniqueIdentifier).Value = linkmanId;
cmd.Parameters.Add(param_DetailId, SqlDbType.UniqueIdentifier).Value = linkmanDetail.Id;
cmd.Parameters.Add(param_Type, SqlDbType.Int).Value = linkmanDetail.Type;
if (String.IsNullOrEmpty(linkmanDetail.Value))
{
cmd.Parameters.Add(param_Value, SqlDbType.NVarChar, 255).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(param_Value, SqlDbType.NVarChar, 255).Value = linkmanDetail.Value;
}
cmd.Parameters.Add(param_IsDefault, SqlDbType.Bit).Value = linkmanDetail.IsDefault;
SqlParameter sqlParam = new SqlParameter(param_ReturnValue, SqlDbType.Int);
sqlParam.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(sqlParam);
SqlHelper.ExecuteNonQuery("InsertLinkmanDetail", cmd);
}
/// <summary>
/// 收集日志数据
/// </summary>
/// <returns></returns>
private Linkman CompleteLogData()
{
Linkman link = new Linkman();
link.Name = _View.LinkManName;
LinkmanDetail temp;
temp = new LinkmanDetail(InfoType.Num_Mobile, _View.MobileNo);
link.Details.Add(temp);
temp = new LinkmanDetail(InfoType.Addr_Home, _View.HomeNo);
link.Details.Add(temp);
temp = new LinkmanDetail(InfoType.Addr_Work, _View.OfficeNo);
link.Details.Add(temp);
temp = new LinkmanDetail(InfoType.Addr_Email, _View.EmailAddr);
link.Details.Add(temp);
return(link);
}
public Linkman InsertLinkManInfo()
{
Contact contactMan = new Contact("aaa", 1);
Linkman linkman = new Linkman();
linkman.Name = "link";
LinkmanDetail Detail1 = new LinkmanDetail(InfoType.Num_General);
LinkmanDetail Detail2 = new LinkmanDetail(InfoType.Num_Fax, "2");
linkman.Details.Add(Detail1);
linkman.Details.Add(Detail2);
contactMan.Linkmans.Add(linkman);
_IContactDA.AddLinkman(contactMan.SysNo, contactMan.UserId, 0, linkman);
return(linkman);
}
/// <summary>
/// 显示联系人
/// </summary>
private void ShowDetail()
{
txtName.Text = _currentLinkman.Name;
ViewState["linkmanid"] = _currentLinkman.Id;
LinkmanDetail temp = _currentLinkman.GetLinkmanDetailByType(InfoType.Num_Mobile);
txtMobil.Text = temp.Value;
ViewState["mobile"] = temp.Id;
temp = _currentLinkman.GetLinkmanDetailByType(InfoType.Addr_Home);
txtHome.Text = temp.Value;
ViewState["home"] = temp.Id;
temp = _currentLinkman.GetLinkmanDetailByType(InfoType.Addr_Work);
txtOffice.Text = temp.Value;
ViewState["work"] = temp.Id;
temp = _currentLinkman.GetLinkmanDetailByType(InfoType.Addr_Email);
txtEmail.Text = temp.Value;
ViewState["email"] = temp.Id;
}
public void DataBind(Guid guid)
{
//获取登录员工公司id
int companyId = _IEmployeeFacade.GetEmployeeByAccountID(LoginUser.Id).EmployeeDetails.Work.Company.DepartmentID;
Linkman linkman = _contactService.LoadSomeContactByName(CompanyConfig.SYSTEMID, 0, companyId, string.Empty).GetLinkmanById(guid);
_View.LinkManId = linkman.Id;
_View.LinkManName = linkman.Name;
LinkmanDetail temp = linkman.GetLinkmanDetailByType(InfoType.Num_Mobile);
_View.MobileNo = temp.Value;
temp = linkman.GetLinkmanDetailByType(InfoType.Addr_Home);
_View.HomeNo = temp.Value;
//ViewState["home"] = temp.Id;
temp = linkman.GetLinkmanDetailByType(InfoType.Addr_Work);
_View.OfficeNo = temp.Value;
//ViewState["work"] = temp.Id;
temp = linkman.GetLinkmanDetailByType(InfoType.Addr_Email);
_View.EmailAddr = temp.Value;
//ViewState["email"] = temp.Id;
}
/// <summary>
/// 获取联系人
/// </summary>
private void Refresh()
{
_currentLinkman = new Linkman((Guid)ViewState["linkmanid"]);
_currentLinkman.Name = txtName.Text.Trim();
LinkmanDetail temp;
temp = new LinkmanDetail((Guid)ViewState["mobile"], InfoType.Num_Mobile);
temp.Value = txtMobil.Text.Trim();
_currentLinkman.Details.Add(temp);
temp = new LinkmanDetail((Guid)ViewState["home"], InfoType.Addr_Home);
temp.Value = txtHome.Text.Trim();
_currentLinkman.Details.Add(temp);
temp = new LinkmanDetail((Guid)ViewState["work"], InfoType.Addr_Work);
temp.Value = txtOffice.Text.Trim();
_currentLinkman.Details.Add(temp);
temp = new LinkmanDetail((Guid)ViewState["email"], InfoType.Addr_Email);
temp.Value = txtEmail.Text.Trim();
_currentLinkman.Details.Add(temp);
}
private Contact GetLinkmansByCondition(string sysNo, int userId, string name, string indexKey, int companyId, bool isExternal)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(param_SysNo, SqlDbType.NVarChar, 255).Value = sysNo;
cmd.Parameters.Add(param_UserId, SqlDbType.Int).Value = userId;
cmd.Parameters.Add(param_ComapnyId, SqlDbType.Int).Value = companyId;
cmd.Parameters.Add(param_IsExternal, SqlDbType.Bit).Value = isExternal;
if (String.IsNullOrEmpty(name))
{
cmd.Parameters.Add(param_Name, SqlDbType.NVarChar, 255).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(param_Name, SqlDbType.NVarChar, 255).Value = name;
}
if (String.IsNullOrEmpty(indexKey))
{
cmd.Parameters.Add(param_IndexKey, SqlDbType.Char, 1).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(param_IndexKey, SqlDbType.Char, 1).Value = indexKey;
}
Contact contact = new Contact(sysNo, userId);
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetLinkmansByCondition", cmd))
{
while (sdr.Read())
{
Guid linkmanId = (Guid)sdr[field_LinkmanId];
Linkman linkman;
if (!contact.Contains(linkmanId))
{
linkman = new Linkman(linkmanId);
contact.Linkmans.Add(linkman);
}
else
{
linkman = contact.GetLinkmanById(linkmanId);
}
linkman.Name = sdr[field_Name].ToString();
if (!isExternal)
{
continue;
}
if (sdr[field_DetailId] == DBNull.Value || sdr[field_DetailId] == null)
{
continue;
}
LinkmanDetail detail = new LinkmanDetail((Guid)sdr[field_DetailId], (InfoType)sdr[field_Type]);
detail.IsDefault = (bool)sdr[field_IsDefault];
detail.Value = sdr[field_Value].ToString();
linkman.Details.Add(detail);
}
}
return(contact);
}
