/// <summary>
/// 新增商机表单模板
/// </summary>
/// <param name="param"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool AddOpportunityTmpl(JObject param, long userId)
{
sys_form_tmpl formTmpl = param.ToObject <sys_form_tmpl>();
sys_form_tmpl tmplFind = _dal.GetSingle(_dal.QueryStringDeleteFlag($"SELECT * FROM sys_form_tmpl WHERE speed_code='{formTmpl.speed_code}'")) as sys_form_tmpl;
if (tmplFind != null) // speed_code重复
{
return(false);
}
formTmpl.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
formTmpl.create_user_id = userId;//CachedInfoBLL.GetUserInfo(token).id;
formTmpl.update_time = formTmpl.create_time;
formTmpl.update_user_id = formTmpl.create_user_id;
formTmpl.form_type_id = (int)DicEnum.FORM_TMPL_TYPE.OPPORTUNITY;
formTmpl.id = (int)_dal.GetNextIdSys();
_dal.Insert(formTmpl);
sys_form_tmpl_opportunity opportunityTmpl = param.ToObject <sys_form_tmpl_opportunity>();
opportunityTmpl.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
opportunityTmpl.create_user_id = formTmpl.create_user_id;
opportunityTmpl.update_time = opportunityTmpl.create_time;
opportunityTmpl.update_user_id = opportunityTmpl.create_user_id;
opportunityTmpl.id = (int)_dal.GetNextIdSys();
//opportunityTmpl.form_tmpl_id = formTmpl.id;
new sys_form_tmpl_opportunity_dal().Insert(opportunityTmpl);
return(true);
}
public bool EditTicketTmpl(sys_form_tmpl tmpl, sys_form_tmpl_ticket tmplTicket, List <UserDefinedFieldValue> udfValue, List <CheckListDto> checkList, long userId)
{
var user = UserInfoBLL.GetUserInfo(userId);
sys_form_tmpl_ticket_dal sfttDal = new sys_form_tmpl_ticket_dal();
var oldtmplTicket = sfttDal.FindNoDeleteById(tmplTicket.id);
if (oldtmplTicket == null || user == null)
{
return(false);
}
if (!EditFormTmpl(tmpl, userId))
{
return(false);
}
tmplTicket.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplTicket.update_user_id = userId;
sfttDal.Update(tmplTicket);
OperLogBLL.OperLogUpdate <sys_form_tmpl_ticket>(tmplTicket, oldtmplTicket, tmplTicket.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_TICKET, "");
var udf_ticket_list = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.TICKETS);
if (udf_ticket_list != null && udf_ticket_list.Count > 0)
{
new UserDefinedFieldsBLL().UpdateUdfValue(DicEnum.UDF_CATE.FORM_TICKET, udf_ticket_list, tmplTicket.id, udfValue, user, DicEnum.OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_TICKET_EXT);
}
CheckManage(checkList, tmplTicket.id, userId);
return(true);
}
/// <summary>
/// 新增模板
/// </summary>
public bool AddFormTmpl(sys_form_tmpl tmpl, long userId)
{
if (!CheckTempCode(tmpl.speed_code))
{
return(false);
}
tmpl.id = _dal.GetNextIdCom();
tmpl.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmpl.create_user_id = userId;
tmpl.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmpl.update_user_id = userId;
_dal.Insert(tmpl);
OperLogBLL.OperLogAdd <sys_form_tmpl>(tmpl, tmpl.id, userId, OPER_LOG_OBJ_CATE.FROM, "");
return(true);
}
public bool AddWorkEntryTmpl(sys_form_tmpl tmpl, sys_form_tmpl_work_entry tmplEntry, long userId)
{
if (!AddFormTmpl(tmpl, userId))
{
return(false);
}
tmplEntry.id = _dal.GetNextIdCom();
tmplEntry.form_tmpl_id = tmpl.id;
tmplEntry.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplEntry.create_user_id = userId;
tmplEntry.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplEntry.update_user_id = userId;
new sys_form_tmpl_work_entry_dal().Insert(tmplEntry);
OperLogBLL.OperLogAdd <sys_form_tmpl_work_entry>(tmplEntry, tmplEntry.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_WORK_ENTRY, "");
return(true);
}
public bool AddServiceCallTmpl(sys_form_tmpl tmpl, sys_form_tmpl_service_call tmplServiceCall, long userId)
{
if (!AddFormTmpl(tmpl, userId))
{
return(false);
}
tmplServiceCall.id = _dal.GetNextIdCom();
tmplServiceCall.form_tmpl_id = tmpl.id;
tmplServiceCall.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplServiceCall.create_user_id = userId;
tmplServiceCall.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplServiceCall.update_user_id = userId;
new sys_form_tmpl_service_call_dal().Insert(tmplServiceCall);
OperLogBLL.OperLogAdd <sys_form_tmpl_service_call>(tmplServiceCall, tmplServiceCall.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_SERVICE_CALL, "");
return(true);
}
public bool AddQuoteTmpl(sys_form_tmpl tmpl, sys_form_tmpl_quote tmplQuote, long userId)
{
if (!AddFormTmpl(tmpl, userId))
{
return(false);
}
tmplQuote.id = _dal.GetNextIdCom();
tmplQuote.form_tmpl_id = tmpl.id;
tmplQuote.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplQuote.create_user_id = userId;
tmplQuote.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplQuote.update_user_id = userId;
new sys_form_tmpl_quote_dal().Insert(tmplQuote);
OperLogBLL.OperLogAdd <sys_form_tmpl_quote>(tmplQuote, tmplQuote.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_QUOTE, "");
return(true);
}
/// <summary>
/// 新增商机模板
/// </summary>
public bool AddOpportunityTmpl(sys_form_tmpl tmpl, sys_form_tmpl_opportunity tmplOppo, long userId)
{
if (!AddFormTmpl(tmpl, userId))
{
return(false);
}
tmplOppo.id = _dal.GetNextIdCom();
tmplOppo.form_tmpl_id = tmpl.id;
tmplOppo.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplOppo.create_user_id = userId;
tmplOppo.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplOppo.update_user_id = userId;
new sys_form_tmpl_opportunity_dal().Insert(tmplOppo);
OperLogBLL.OperLogAdd <sys_form_tmpl_opportunity>(tmplOppo, tmpl.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_OPPORTUNITY, "");
return(true);
}
/// <summary>
/// 编辑模板
/// </summary>
public bool EditFormTmpl(sys_form_tmpl tmpl, long userId)
{
var oldTemp = _dal.FindNoDeleteById(tmpl.id);
if (oldTemp == null)
{
return(false);
}
if (!CheckTempCode(tmpl.speed_code, tmpl.id))
{
return(false);
}
tmpl.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmpl.update_user_id = userId;
_dal.Update(tmpl);
OperLogBLL.OperLogUpdate <sys_form_tmpl>(tmpl, oldTemp, tmpl.id, userId, OPER_LOG_OBJ_CATE.FROM, "");
return(true);
}
/// <summary>
/// 模板的快速代码是否通过校验 true 通过校验
/// </summary>
public bool CheckTempCode(string code, long id = 0)
{
if (string.IsNullOrEmpty(code))
{
return(false);
}
sys_form_tmpl temp = _dal.GetByCode(code);
if (temp == null)
{
return(true);
}
if (temp != null && temp.id == id)
{
return(true);
}
return(false);
}
public bool EditWorkEntryTmpl(sys_form_tmpl tmpl, sys_form_tmpl_work_entry tmplEntry, long userId)
{
sys_form_tmpl_work_entry_dal sftweDal = new sys_form_tmpl_work_entry_dal();
var oldtmplEntry = sftweDal.FindNoDeleteById(tmplEntry.id);
if (oldtmplEntry == null)
{
return(false);
}
if (!EditFormTmpl(tmpl, userId))
{
return(false);
}
tmplEntry.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplEntry.update_user_id = userId;
sftweDal.Update(tmplEntry);
OperLogBLL.OperLogUpdate <sys_form_tmpl_work_entry>(tmplEntry, oldtmplEntry, tmplEntry.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_WORK_ENTRY, "");
return(true);
}
public bool EditServiceCallTmpl(sys_form_tmpl tmpl, sys_form_tmpl_service_call tmplServiceCall, long userId)
{
sys_form_tmpl_service_call_dal sftscDal = new sys_form_tmpl_service_call_dal();
var oldtmplServiceCall = sftscDal.FindNoDeleteById(tmplServiceCall.id);
if (oldtmplServiceCall == null)
{
return(false);
}
if (!EditFormTmpl(tmpl, userId))
{
return(false);
}
tmplServiceCall.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplServiceCall.update_user_id = userId;
sftscDal.Update(tmplServiceCall);
OperLogBLL.OperLogUpdate <sys_form_tmpl_service_call>(tmplServiceCall, oldtmplServiceCall, tmplServiceCall.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_SERVICE_CALL, "");
return(true);
}
public bool EditQuoteTmpl(sys_form_tmpl tmpl, sys_form_tmpl_quote tmplQuote, long userId)
{
sys_form_tmpl_quote_dal sftqDal = new sys_form_tmpl_quote_dal();
var oldtmplQuote = sftqDal.FindNoDeleteById(tmplQuote.id);
if (oldtmplQuote == null)
{
return(false);
}
if (!EditFormTmpl(tmpl, userId))
{
return(false);
}
tmplQuote.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplQuote.update_user_id = userId;
sftqDal.Update(tmplQuote);
OperLogBLL.OperLogUpdate <sys_form_tmpl_quote>(tmplQuote, oldtmplQuote, tmplQuote.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_QUOTE, "");
return(true);
}
/// <summary>
/// 编辑商机模板
/// </summary>
public bool EditOpportunityTmpl(sys_form_tmpl tmpl, sys_form_tmpl_opportunity tmplOppo, long userId)
{
if (!EditFormTmpl(tmpl, userId))
{
return(false);
}
sys_form_tmpl_opportunity_dal sftoDal = new sys_form_tmpl_opportunity_dal();
var oldtmplOpp = sftoDal.FindNoDeleteById(tmplOppo.id);
if (oldtmplOpp == null)
{
return(false);
}
tmplOppo.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplOppo.update_user_id = userId;
new sys_form_tmpl_opportunity_dal().Update(tmplOppo);
OperLogBLL.OperLogUpdate <sys_form_tmpl_opportunity>(tmplOppo, oldtmplOpp, tmpl.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_OPPORTUNITY, "");
return(true);
}
public bool AddRecTicketTmpl(sys_form_tmpl tmpl, sys_form_tmpl_recurring_ticket tmplRecTicket, List <UserDefinedFieldValue> udfValue, long userId)
{
if (!AddFormTmpl(tmpl, userId))
{
return(false);
}
tmplRecTicket.id = _dal.GetNextIdCom();
tmplRecTicket.form_tmpl_id = tmpl.id;
tmplRecTicket.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplRecTicket.create_user_id = userId;
tmplRecTicket.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmplRecTicket.update_user_id = userId;
new sys_form_tmpl_recurring_ticket_dal().Insert(tmplRecTicket);
OperLogBLL.OperLogAdd <sys_form_tmpl_recurring_ticket>(tmplRecTicket, tmplRecTicket.id, userId, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_RECURRING_TICKET, "");
var udf_ticket_list = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.TICKETS); // 获取到所有的自定义的字段信息
new UserDefinedFieldsBLL().SaveUdfValue(DicEnum.UDF_CATE.FORM_RECTICKET, userId, tmplRecTicket.id, udf_ticket_list, udfValue, OPER_LOG_OBJ_CATE.SYS_FORM_TMPL_RECURRING_TICKET_EXT); // 保存自定义字段，保存成功，插入日志
return(true);
}
/// <summary>
/// 更新商机表单模板
/// </summary>
/// <param name="param"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool UpdateOpportunityTmpl(JObject param, long userId)
{
sys_form_tmpl formTmpl = param.ToObject <sys_form_tmpl>();
if (formTmpl == null || formTmpl.speed_code.Equals(""))
{
return(false);
}
sys_form_tmpl tmplFind = _dal.FindById(formTmpl.id); // 查询到的修改之前的数据
if (tmplFind == null || formTmpl.form_type_id != tmplFind.form_type_id) // form_type不可修改
{
return(false);
}
sys_form_tmpl_opportunity opportunityTmpl = param.ToObject <sys_form_tmpl_opportunity>();
formTmpl.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
formTmpl.update_user_id = userId;//CachedInfoBLL.GetUserInfo(token).id;
opportunityTmpl.update_time = formTmpl.update_time;
opportunityTmpl.update_user_id = formTmpl.update_user_id;
_dal.Update(formTmpl);
new sys_form_tmpl_opportunity_dal().Update(opportunityTmpl);
//var user = CachedInfoBLL.GetUserInfo(token);// 获取到用户信息之后，将更改的数据内容存储到数据库中
//var user = new UserInfoDto() { id=1,dbid=1,name="zhufei_test",department_id=1,email="*****@*****.**",mobile= "18217750743" ,security_Level_id=2};
//var old_val = new sys_form_tmpl() { id = (int)_dal.GetNextIdSys(), create_time = 123, create_user_id = 1, tmpl_name = "1",remark="备注" };
//var new_val = new sys_form_tmpl() { id = (int)_dal.GetNextIdSys(), create_time = 321, create_user_id = 1, form_type_id = 1, tmpl_name = "2" ,};
//var description = _dal.CompareValue(old_val, new_val);
//if (user != null)
//{
// sys_oper_log log = 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.FROMOPPORTUNITY,// 商机对应id d_general表中定义
// oper_object_id = new_val.id,// 操作对象ID
// oper_type_id = (int)OPER_LOG_TYPE.UPDATE,// 800 增 801 删 802 改
// oper_description = description,
// remark = ""
// };
// new sys_oper_log_dal().Insert(log);
//}
//// 新增时添加日志的测试
//var val = new sys_form_tmpl() { id = (int)_dal.GetNextIdSys(), create_time = 123, create_user_id = 1, form_type_id = 1, tmpl_name = "1" };
//var content = _dal.AddValue(val);
//var addLog = new sys_oper_log()
//{
// user_cate = "用户",
// user_id = user.id,
// name = "",
// phone = user.mobile == null ? "" : user.mobile,
// oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
// oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.FROMOPPORTUNITY,// 商机对应id d_general表中定义
// oper_object_id = val.id,// 操作对象ID
// oper_type_id = (int)OPER_LOG_TYPE.ADD,
// oper_description = content,
// remark = ""
//};
//new sys_oper_log_dal().Insert(addLog);
return(true);
}
