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