/// <summary>
/// 编辑附件
/// </summary>
public void EditAttachment(com_attachment att, long userId)
{
var oldAtt = dal.FindNoDeleteById(att.id);
if (oldAtt == null)
{
return;
}
att.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
att.update_user_id = userId;
dal.Update(att);
OperLogBLL.OperLogUpdate <com_attachment>(att, oldAtt, att.id, userId, DicEnum.OPER_LOG_OBJ_CATE.ATTACHMENT, "");
if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.TASK)
{
var task = new sdk_task_dal().FindNoDeleteById(att.object_id);
if (task != null)
{
#region 更新客户最后活动时间
crm_account thisAccount = new CompanyBLL().GetCompany(task.account_id);
if (thisAccount != null)
{
thisAccount.last_activity_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); new CompanyBLL().EditAccount(thisAccount, userId);
}
#endregion
}
}
}
/// <summary>
/// 新增附件
/// </summary>
/// <param name="objType">对象类型</param>
/// <param name="objId">对象id</param>
/// <param name="typeId">附件类型</param>
/// <param name="title">附件名</param>
/// <param name="attLink">附件内容</param>
/// <param name="fileName">上传的文件名</param>
/// <param name="fileSaveName">文件保存服务器的名称</param>
/// <param name="contentType">文件类型</param>
/// <param name="size">文件大小</param>
/// <param name="userId"></param>
/// <returns></returns>
public bool AddAttachment(int objType, long objId, int typeId, string title, string attLink, string fileName, string fileSaveName, string contentType, int size, long userId, string pubTypeId = "")
{
com_attachment att = new com_attachment();
att.object_type_id = objType;
att.object_id = objId;
// 备注和附件的下级备注和附件不能再添加附件
if (objType == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.NOTES)
{
var note = new com_activity_dal().FindById(objId);
if (note.object_type_id == (int)DicEnum.OBJECT_TYPE.NOTES)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.NOTES;
att.object_id = note.object_id;
}
else if (note.object_type_id == (int)DicEnum.OBJECT_TYPE.ATTACHMENT)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.ATTACHMENT;
att.object_id = note.object_id;
}
}
else if (objType == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.ATTACHMENT)
{
var attachment = dal.FindById(objId);
if (attachment.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.NOTES)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.NOTES;
att.object_id = attachment.object_id;
}
else if (attachment.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.ATTACHMENT)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.ATTACHMENT;
att.object_id = attachment.object_id;
}
}
else if (objType == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.LABOUR)
{
var labour = new sdk_work_entry_dal().FindById(objId);
if (labour.parent_id != null)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.LABOUR;
att.object_id = (long)labour.parent_id;
}
else if (labour.parent_attachment_id != null)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.ATTACHMENT;
att.object_id = (long)labour.parent_attachment_id;
}
else if (labour.parent_note_id != null)
{
att.object_type_id = (int)DicEnum.ATTACHMENT_OBJECT_TYPE.NOTES;
att.object_id = (long)labour.parent_note_id;
}
}
if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.ATTACHMENT)
{
var attachment = dal.FindById(att.object_id);
att.account_id = attachment.account_id;
att.parent_id = attachment.id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.NOTES)
{
var note = new com_activity_dal().FindById(att.object_id);
att.account_id = note.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.OPPORTUNITY)
{
var opp = new crm_opportunity_dal().FindById(att.object_id);
att.account_id = opp.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.SALES_ORDER)
{
var so = new crm_sales_order_dal().FindById(att.object_id);
var opp = new crm_opportunity_dal().FindById(so.opportunity_id);
att.account_id = opp.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.CONTRACT)
{
var contract = new ctt_contract_dal().FindById(att.object_id);
att.account_id = contract.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.COMPANY)
{
att.account_id = att.object_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.PROJECT)
{
var project = new pro_project_dal().FindNoDeleteById(att.object_id);
att.account_id = project.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.EXPENSE_REPORT)
{
// 从报表添加附件 - 默认使用声联（oid=0） 的客户
var defaultAccount = new CompanyBLL().GetDefaultAccount();
att.account_id = defaultAccount.id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.TASK)
{
var task = new sdk_task_dal().FindNoDeleteById(att.object_id);
if (task != null)
{
att.account_id = task.account_id;
#region 更新客户最后活动时间
crm_account thisAccount = new CompanyBLL().GetCompany(task.account_id);
if (thisAccount != null)
{
thisAccount.last_activity_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); new CompanyBLL().EditAccount(thisAccount, userId);
}
#endregion
}
if (!string.IsNullOrEmpty(pubTypeId))
{
att.publish_type_id = int.Parse(pubTypeId);
}
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.LABOUR)
{
var labour = new sdk_work_entry_dal().FindNoDeleteById(att.object_id);
if (labour == null)
{
return(false);
}
var ticket = new sdk_task_dal().FindNoDeleteById(labour.task_id);
if (ticket == null)
{
return(false);
}
att.account_id = ticket.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.KNOWLEDGE)
{
var thisArt = new sdk_kb_article_dal().FindNoDeleteById(att.object_id);
if (thisArt == null)
{
return(false);
}
att.account_id = thisArt.account_id;
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.RESOURCE)
{
}
else if (att.object_type_id == (int)DicEnum.ATTACHMENT_OBJECT_TYPE.CONFIGITEM)
{
crm_installed_product insPro = new crm_installed_product_dal().FindNoDeleteById(att.object_id);
if (insPro == null)
{
return(false);
}
att.account_id = insPro.account_id;
}
else
{
return(false);
}
att.id = dal.GetNextIdCom();
att.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
att.create_user_id = userId;
att.update_time = att.create_time;
att.update_user_id = userId;
att.title = title;
att.type_id = typeId;
if (typeId == (int)DicEnum.ATTACHMENT_TYPE.FILE_LINK ||
typeId == (int)DicEnum.ATTACHMENT_TYPE.FOLDER_LINK)
{
att.uncpath = attLink;
att.filename = @"file://" + attLink;
}
else if (typeId == (int)DicEnum.ATTACHMENT_TYPE.URL)
{
if (attLink.IndexOf(@"http://") == 0)
{
attLink = attLink.Remove(0, 7);
att.urlpath = attLink;
att.filename = @"http://" + attLink;
}
else if (attLink.IndexOf(@"https://") == 0)
{
attLink = attLink.Remove(0, 8);
att.urlpath = attLink;
att.filename = @"https://" + attLink;
}
else
{
att.urlpath = attLink;
att.filename = @"http://" + attLink;
}
}
else if (typeId == (int)DicEnum.ATTACHMENT_TYPE.ATTACHMENT)
{
att.href = fileSaveName;
att.filename = fileName;
att.sizeinbyte = size;
att.content_type = contentType;
}
else
{
return(false);
}
dal.Insert(att);
OperLogBLL.OperLogAdd <com_attachment>(att, att.id, userId, DicEnum.OPER_LOG_OBJ_CATE.ATTACHMENT, "新增附件");
return(true);
}
