/// <summary>
/// 修改销售订单
/// </summary>
/// <param name="sale_order"></param>
/// <param name="udfValue"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE EditSaleOrder(crm_sales_order sale_order, List <UserDefinedFieldValue> udfValue, long user_id)
{
if (sale_order.status_id == 0 || sale_order.contact_id == 0 || sale_order.owner_resource_id == 0)
{
return(ERROR_CODE.PARAMS_ERROR);
}
if (sale_order.begin_date.ToString("yyyy-MM-dd") == "0001-01-01" || sale_order.end_date == null || ((DateTime)sale_order.end_date).ToString("yyyy-MM-dd") == "0001-01-01")
{
return(ERROR_CODE.PARAMS_ERROR);
}
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
return(ERROR_CODE.USER_NOT_FIND);
}
var old_sale_order = new crm_sales_order_dal().GetSingleSalesOrderByWhere($" and id= {sale_order.id}");
sale_order.oid = old_sale_order.oid;
sale_order.opportunity_id = old_sale_order.opportunity_id;
sale_order.create_user_id = old_sale_order.create_user_id;
sale_order.create_time = old_sale_order.create_time;
sale_order.update_user_id = user.id;
sale_order.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
_dal.Update(sale_order);
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.SALE_ORDER,
oper_object_id = sale_order.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old_sale_order, sale_order),
remark = "修改销售订单"
});
// 销售订单自定义
var udf_sales_list = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.SALES);
new UserDefinedFieldsBLL().UpdateUdfValue(DicEnum.UDF_CATE.SALES, udf_sales_list, sale_order.id, udfValue, user, OPER_LOG_OBJ_CATE.SALE_ORDER);
return(ERROR_CODE.SUCCESS);
}
/// <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);
}
public ERROR_CODE CloseQuote(long user_id, QuoteCloseDto param)
{
// 此向导将会把产品、一次性折扣、配送、成本转为计费项。可选项和费用不会被转换。如果有产品，会生成销售订单。
// 报价中如果有服务 / 包或初始费用，将不会被转换为计费项，也不会创建定期服务合同
// 如果商机状态已经是“关闭”或“已实施”，将会为此商机生成重复的计费项。
// 报价项中如果有物料代码为空的，则需要设置。如果没有需要配置的，则此界面不显示
// 计费项将会生成，是否需要创建发票
// 打开新建的销售订单（链接）——如果创建了销售单才显示
// 关闭报价是关闭商机的另一种方式，
// -- 必填项校验-- 根据系统设置来判断 TODO
var user = UserInfoBLL.GetUserInfo(user_id);
// 1.更新商机信息
#region 1.更新商机信息
// 根据系统设置来选择商机的阶段-- todo
param.opportunity.status_id = (int)DicEnum.OPPORTUNITY_STATUS.CLOSED;
var stageList = new d_general_dal().GetGeneralByTableId((int)GeneralTableEnum.OPPORTUNITY_STATUS);
var defaultStage = stageList.FirstOrDefault(_ => _.ext1 == "1");
if (defaultStage != null)
{
param.opportunity.stage_id = defaultStage.id;
}
var old_opportunity = new crm_opportunity_dal().GetOpportunityById(param.opportunity.id);
new crm_opportunity_dal().Update(param.opportunity);
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.OPPORTUNITY,
oper_object_id = param.opportunity.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old_opportunity, param.opportunity),
remark = "修改商机信息"
});
#endregion
// 2.更新客户信息
#region 2.更新客户信息
var account = new CompanyBLL().GetCompany(param.quote.account_id);
if (account.type_id != (int)DicEnum.ACCOUNT_TYPE.CUSTOMER)
{
account.type_id = (int)DicEnum.ACCOUNT_TYPE.CUSTOMER;
new crm_account_dal().Update(account);
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.CUSTOMER,
oper_object_id = param.quote.account_id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(new CompanyBLL().GetCompany(param.quote.account_id), account),
remark = "修改客户信息"
});
}
#endregion
long?contact_id = null;
if (param.opportunity.contact_id != null)
{
crm_contact contact = new ContactBLL().GetContact((long)param.opportunity.contact_id);
if (contact.is_active == 1)
{
contact_id = contact.id;
}
}
// 3.保存项目信息
#region 3.如果项目关联了项目提案，修改项目提案信息
if (param.quote.project_id != null)
{
var project = new pro_project_dal().GetProjectById((long)param.quote.project_id);
if (project != null)
{
if (project.type_id != (int)PROJECT_TYPE.ACCOUNT_PROJECT)
{
project.type_id = (int)PROJECT_TYPE.ACCOUNT_PROJECT;
project.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
project.update_user_id = user.id;
new sys_oper_log_dal().Insert(new sys_oper_log()
{
user_cate = "用户",
user_id = (int)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.PROJECT,
oper_object_id = project.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(new pro_project_dal().GetProjectById((long)param.quote.project_id), project),
remark = "修改项目提案类型"
});
new pro_project_dal().Update(project);
}
param.project_id = project.id;
}
string costIds = "";
new OpportunityBLL().InsertContract(param.dic, param.opportunity, user, null, out costIds, param.project_id, null);
if (!string.IsNullOrEmpty(costIds))
{
var aapBLL = new ApproveAndPostBLL();
costIds = costIds.Substring(0, costIds.Length - 1);
var costList = costIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var costId in costList)
{
// 审批并提交
aapBLL.Post_Charges(int.Parse(costId), int.Parse(DateTime.Now.ToString("yyyyMMdd")), user);
}
}
}
#endregion
// 4.新增工单信息
#region 4.如果报价未关联项目提案，有需要转换的计费项
// todo 关联sdk_ticket
#endregion
// 5.转换为工单/项目成本
#region 5.转换为工单/项目成本
// todo 关联sdk_ticket_charge
// 一次性折扣根据需要拆分为两行——收税的、不收税的，分别计算折扣额。计算时仍然按照全部周期为一次性的报价项，而不是排除了服务和工时等报价项。
#endregion
// 将报价项转换为计费项
#region 将报价项转换为计费项并审批提交 todo-需要项目ID 或者工单ID才可以进行操作
//string costIds ="";
//new OpportunityBLL().InsertContract(param.dic,param.opportunity,user,null,out costIds, param.project_id,null);
//if (!string.IsNullOrEmpty(costIds))
//{
// var aapBLL = new ApproveAndPostBLL();
// costIds = costIds.Substring(0,costIds.Length-1);
// var costList = costIds.Split(new char[] { ','},StringSplitOptions.RemoveEmptyEntries);
// foreach (var costId in costList)
// {
// // 审批并提交
// aapBLL.Post_Charges(int.Parse(costId),int.Parse(DateTime.Now.ToString("yyyyMMdd")),user);
// }
//}
#endregion
// 6.新增销售订单
#region 6.当有产品/一次性折扣、成本、配送转为计费项时，销售订单就会自动生成。Crm_sales_order
if (param.dic != null && param.dic.Count > 0)
{
var saleOrder = new crm_sales_order_dal().GetSingleSalesOrderByWhere($" and opportunity_id = {param.opportunity.id} ");
if (saleOrder == null)
{
saleOrder = new crm_sales_order()
{
id = _dal.GetNextIdCom(),
opportunity_id = param.opportunity.id,
status_id = (int)SALES_ORDER_STATUS.OPEN,
contact_id = contact_id,
owner_resource_id = param.opportunity.resource_id,
begin_date = DateTime.Now,
create_user_id = user.id,
update_user_id = user.id,
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
};
new crm_sales_order_dal().Insert(saleOrder);
new sys_oper_log_dal().Insert(new sys_oper_log()
{
user_cate = "用户",
user_id = (int)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.SALE_ORDER,
oper_object_id = saleOrder.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(saleOrder),
remark = "关闭报价，新增销售订单"
});
param.saleOrderId = saleOrder.id;
}
}
#endregion
// 7.新增项目备注
#region 7.转为项目计费项时，会生成备注
if (param.quote.project_id != null)
{
com_activity addActivity = new com_activity()
{
id = _dal.GetNextIdCom(),
cate_id = (int)ACTIVITY_CATE.PROJECT_NOTE,
action_type_id = (int)ACTIVITY_TYPE.PROJECT_NOTE,
parent_id = null,
object_id = (long)param.quote.project_id,
object_type_id = (int)OBJECT_TYPE.PROJECT,
// todo发布范围
account_id = param.opportunity.account_id,
contact_id = contact_id,
resource_id = param.opportunity.resource_id,
contract_id = contact_id,
opportunity_id = param.opportunity.id,
ticket_id = null,
// todo 标题
description = $"", // todo 内容描述拼接
status_id = null,
complete_description = null,
complete_time = null,
create_user_id = user.id,
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_user_id = user.id,
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
is_system_generate = 1,
};
new com_activity_dal().Insert(addActivity);
new sys_oper_log_dal().Insert(new sys_oper_log()
{
user_cate = "用户",
user_id = (int)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.ACTIVITY,
oper_object_id = addActivity.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(addActivity),
remark = "商机关闭，新增项目备注"
});
}
#endregion
// 8.新增备注（商机关闭）
#region 8.商机关闭时，会自动生成备注
com_activity closeOppoActivity = new com_activity()
{
id = _dal.GetNextIdCom(),
cate_id = (int)ACTIVITY_CATE.NOTE,
action_type_id = (int)ACTIVITY_TYPE.OPPORTUNITYUPDATE,
parent_id = null,
object_id = param.opportunity.id,
object_type_id = (int)OBJECT_TYPE.OPPORTUNITY,
account_id = param.opportunity.account_id,
contact_id = contact_id,
resource_id = param.opportunity.resource_id,
contract_id = null, // todo 如果转为合同成本，则为“合同”；否则为空
opportunity_id = param.opportunity.id,
ticket_id = null,
start_date = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Parse(DateTime.Now.ToShortDateString() + " 12:00:00")), // todo 从页面获取时间，去页面时间的12：00：00
end_date = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Parse(DateTime.Now.ToShortDateString() + " 12:00:00")),
description = $"关闭时间：{DateTime.Now.ToString("dd/MM/yyyy")}/r通知人：{user.email}/r主题：{param.opportunity.name}已经关闭/r内容：商机关闭向导定义", // todo 内容描述拼接
status_id = null,
complete_description = null,
complete_time = null,
create_user_id = user.id,
create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
update_user_id = user.id,
update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
is_system_generate = 1,
};
new com_activity_dal().Insert(closeOppoActivity);
new sys_oper_log_dal().Insert(new sys_oper_log()
{
user_cate = "用户",
user_id = (int)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.ACTIVITY,
oper_object_id = closeOppoActivity.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(closeOppoActivity),
remark = "新增关闭商机的备注"
});
#endregion
return(ERROR_CODE.SUCCESS);
}
