/// <summary> /// 修改知识库的类别( 某一类别下的所有知识库包括子类别的所有知识库 ) /// </summary> public void ChangeArtCate(long cateId, long userId, int parentId) { var subArt = _dal.GetArtByCate(cateId); var dgDal = new d_general_dal(); var gBll = new GeneralBLL(); var subMenu = dgDal.GetGeneralByParentId(cateId); if (subArt != null && subArt.Count > 0) { foreach (var art in subArt) { subArt.ForEach(_ => { _.kb_category_id = parentId; UpdateKnow(_, userId); }); } } if (subMenu != null && subMenu.Count > 0) { foreach (var menu in subMenu) { ChangeArtCate(menu.id, userId, parentId); dgDal.SoftDelete(menu, userId); OperLogBLL.OperLogAdd <d_general>(menu, menu.id, userId, OPER_LOG_OBJ_CATE.General_Code, "删除知识库目录"); } } }
/// <summary> /// 新增工时 /// </summary> /// <param name="weList"></param> /// <param name="userId"></param> /// <returns></returns> public bool AddWorkEntry(List <sdk_work_entry> weList, long userId) { var bll = new TimeOffPolicyBLL(); tst_timeoff_balance_dal balDal = new tst_timeoff_balance_dal(); long batchId = dal.GetNextId("seq_entry_batch"); foreach (var we in weList) { we.id = dal.GetNextIdCom(); we.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); we.update_time = we.create_time; we.create_user_id = userId; we.update_user_id = userId; we.batch_id = batchId; dal.Insert(we); OperLogBLL.OperLogAdd <sdk_work_entry>(we, we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "新增工时"); if (we.task_id == (long)CostCode.Sick) // 病假需要在假期余额表添加记录 { bll.UpdateTimeoffBalance(we.resource_id.Value, Tools.Date.DateHelper.TimeStampToUniversalDateTime(we.start_time.Value), (CostCode)we.task_id); //var balance = bll.UpdateTimeoffBalance((long)we.resource_id, Tools.Date.DateHelper.TimeStampToDateTime((long)we.start_time), 0 - (decimal)we.hours_billed); //tst_timeoff_balance bal = new tst_timeoff_balance(); //bal.object_id = we.id; //bal.object_type_id = 2214; //bal.task_id = we.task_id; //bal.resource_id = (long)we.resource_id; //bal.balance = balance - (decimal)we.hours_billed; //balDal.Insert(bal); } } return(true); }
/// <summary> /// 服务新增 /// </summary> /// <param name="ser"></param> /// <param name="userId"></param> /// <returns></returns> public bool AddService(ivt_service ser, long userId) { ivt_service service = new ivt_service(); ivt_service_dal dal = new ivt_service_dal(); service.id = dal.GetNextIdCom(); service.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); service.update_time = service.create_time; service.create_user_id = userId; service.update_user_id = userId; service.name = ser.name; service.description = ser.description; service.invoice_description = ser.invoice_description; service.sla_id = ser.sla_id; service.vendor_account_id = ser.vendor_account_id; service.period_type_id = ser.period_type_id; service.unit_cost = ser.unit_cost; service.unit_price = ser.unit_price; service.cost_code_id = ser.cost_code_id; service.is_active = ser.is_active; dal.Insert(service); OperLogBLL.OperLogAdd <ivt_service>(service, service.id, userId, DTO.DicEnum.OPER_LOG_OBJ_CATE.IVT_SERVICE, "新增服务"); return(true); }
private void SaveProductSn(string snList, long productId, long userId) { if (string.IsNullOrEmpty(snList)) { return; } var sns = snList.Split('\n'); ivt_warehouse_product_sn_dal snDal = new ivt_warehouse_product_sn_dal(); foreach (var sn in sns) { string s = sn.Trim(); if (string.IsNullOrEmpty(s)) { continue; } ivt_warehouse_product_sn psn = new ivt_warehouse_product_sn(); psn.id = dal.GetNextIdCom(); psn.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); psn.create_user_id = userId; psn.update_time = psn.create_time; psn.update_user_id = userId; psn.warehouse_product_id = productId; psn.sn = s; snDal.Insert(psn); OperLogBLL.OperLogAdd <ivt_warehouse_product_sn>(psn, psn.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_SN, "新增库存产品串号"); } }
/// <summary> /// 删除知识库目录 /// </summary> public bool DeleteKnowMenu(long cateId, long userId, ref string failReason) { var dgDal = new d_general_dal(); var cate = dgDal.FindNoDeleteById(cateId); if (cate == null) { return(true); } if (cate.parent_id == null) { failReason = "根目录不可删除"; return(false); } var gBll = new GeneralBLL(); ChangeArtCate(cateId, userId, (int)cate.parent_id); //var subMenu = dgDal.GetGeneralByParentId(cateId); //if (subMenu != null && subMenu.Count > 0) // subMenu.ForEach(_ => { // _.parent_id = cate.parent_id; // gBll.EditGeneral(_,userId); // }); //var subArt = _dal.GetArtByCate(cateId); //if(subArt!=null&& subArt.Count > 0) // subArt.ForEach(_=> { // _.kb_category_id = (int)cate.parent_id; // UpdateKnow(_,userId); // }); dgDal.SoftDelete(cate, userId); OperLogBLL.OperLogAdd <d_general>(cate, cate.id, userId, OPER_LOG_OBJ_CATE.General_Code, "删除知识库目录"); return(true); }
/// <summary> /// 新增评论 /// </summary> public bool SaveComment(long artId, string comment, long userId) { var thisArt = _dal.FindNoDeleteById(artId); var thisUser = new sys_resource_dal().FindNoDeleteById(userId); if (thisArt != null && !string.IsNullOrEmpty(comment) && thisUser != null) { var skacDal = new sdk_kb_article_comment_dal(); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); var comm = new sdk_kb_article_comment() { comment = comment, create_time = timeNow, create_user_id = userId, id = skacDal.GetNextIdCom(), update_time = timeNow, update_user_id = userId, creator_name = thisUser.name, kb_article_id = thisArt.id, }; skacDal.Insert(comm); OperLogBLL.OperLogAdd <sdk_kb_article_comment>(comm, comm.id, userId, OPER_LOG_OBJ_CATE.SDK_KONWLEDGE_COMMENT, "新增知识库评论"); return(true); } else { return(false); } }
/// <summary> /// 新增工作组员工 /// </summary> public bool AddGroupResource(sys_workgroup_resouce group, long userId) { sys_workgroup_resouce_dal swrDal = new sys_workgroup_resouce_dal(); group.id = swrDal.GetNextIdCom(); swrDal.Insert(group); OperLogBLL.OperLogAdd <sys_workgroup_resouce>(group, group.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_WORKGROUP_RESOURCE, ""); return(true); }
/// <summary> /// 新增队列 /// </summary> public bool AddQueue(sys_department queue, long userId) { queue.id = _dal.GetNextIdCom(); queue.create_time = queue.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); queue.create_user_id = queue.update_user_id = userId; _dal.Insert(queue); OperLogBLL.OperLogAdd <sys_department>(queue, queue.id, userId, OPER_LOG_OBJ_CATE.DEPARTMENT, ""); return(true); }
/// <summary> /// 费用报表 管理(新增,编辑) /// </summary> public bool ReportManage(sdk_expense_report report, long userId, bool isCopy = false, long copyId = 0) { try { var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); report.update_user_id = userId; report.update_time = timeNow; if (report.id == 0) { report.id = _dal.GetNextIdCom(); report.create_time = timeNow; report.create_user_id = userId; report.submit_user_id = userId; report.submit_time = report.create_time; _dal.Insert(report); OperLogBLL.OperLogAdd <sdk_expense_report>(report, report.id, userId, OPER_LOG_OBJ_CATE.SDK_EXPENSE_REPORT, "新增费用报表"); // 代表是复制操作 if (isCopy && copyId != 0) { var seDal = new sdk_expense_dal(); // 复制时,将原有的费用复制,已经审批提交的只复制相关信息,审批状态不复制 var thisExpList = seDal.GetExpByReport(copyId); if (thisExpList != null && thisExpList.Count > 0) { thisExpList.ForEach(_ => { _.id = seDal.GetNextIdCom(); _.oid = 0; _.expense_report_id = report.id; _.create_time = timeNow; _.update_time = timeNow; _.create_user_id = userId; _.update_user_id = userId; _.approve_and_post_date = null; _.approve_and_post_user_id = null; seDal.Insert(_); OperLogBLL.OperLogAdd <sdk_expense>(_, _.id, userId, OPER_LOG_OBJ_CATE.SDK_EXPENSE, "新增费用"); }); } } } else { var oldReport = _dal.FindNoDeleteById(report.id); if (oldReport != null) { _dal.Update(report); OperLogBLL.OperLogUpdate <sdk_expense_report>(report, oldReport, report.id, userId, OPER_LOG_OBJ_CATE.SDK_EXPENSE_REPORT, "修改费用报表"); } } } catch (Exception) { return(false); } return(true); }
/// <summary> /// 工时表提交 /// </summary> /// <param name="startDate"></param> /// <param name="resourceId"></param> /// <param name="userId"></param> /// <returns></returns> public bool SubmitWorkEntry(DateTime startDate, long resourceId, long userId) { var weList = GetWorkEntryListByStartDate(startDate, resourceId); //if (weList.Count == 0) // return false; sdk_work_entry_report report = new sdk_work_entry_report(); sdk_work_entry_report_dal rptDal = new sdk_work_entry_report_dal(); var find = rptDal.FindSignleBySql <sdk_work_entry_report>($"select * from sdk_work_entry_report where resource_id={resourceId} and start_date='{startDate}' and delete_time=0"); if (find != null && find.status_id != (int)DicEnum.WORK_ENTRY_REPORT_STATUS.HAVE_IN_HAND && find.status_id != (int)DicEnum.WORK_ENTRY_REPORT_STATUS.REJECTED) { return(false); } if (find == null) { report.id = rptDal.GetNextIdCom(); report.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); report.update_time = report.create_time; report.create_user_id = userId; report.update_user_id = userId; report.resource_id = resourceId; report.start_date = startDate; report.end_date = startDate.AddDays(6); report.status_id = (int)DicEnum.WORK_ENTRY_REPORT_STATUS.WAITING_FOR_APPROVAL; report.submit_time = report.create_time; report.submit_user_id = userId; rptDal.Insert(report); OperLogBLL.OperLogAdd <sdk_work_entry_report>(report, report.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_RECORD, "工时表提交"); foreach (var we in weList) { var weOld = dal.FindById(we.id); we.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); we.update_user_id = userId; we.work_entry_report_id = report.id; dal.Update(we); OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <sdk_work_entry>(weOld, we), we.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_ENTRY, "工时表提交"); } } else { sdk_work_entry_report reportOld = rptDal.FindById(find.id); find.status_id = (int)DicEnum.WORK_ENTRY_REPORT_STATUS.WAITING_FOR_APPROVAL; find.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); find.update_user_id = userId; find.submit_time = find.update_time; find.submit_user_id = userId; rptDal.Update(find); OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <sdk_work_entry_report>(reportOld, find), find.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_RECORD, "工时表提交"); } return(true); }
/// <summary> /// 工时表审批 /// </summary> /// <param name="ids">,号分割的多个工时表id</param> /// <param name="userId"></param> /// <returns></returns> public int ApproveWorkEntryReport(string ids, long userId) { int appCnt = 0; var rptDal = new sdk_work_entry_report_dal(); var logDal = new tst_work_entry_report_log_dal(); var reports = rptDal.FindListBySql($"select * from sdk_work_entry_report where id in({ids}) and status_id={(int)DicEnum.WORK_ENTRY_REPORT_STATUS.WAITING_FOR_APPROVAL} and delete_time=0"); if (reports == null || reports.Count == 0) { return(appCnt); } var user = new UserResourceBLL().GetResourceById(userId); foreach (var report in reports) { // 判断用户是否在当前可以审批工时表 int tier = GetWorkEntryReportCurrentApproveTier(report.id); if (tier == 3) { continue; } var aprvResList = GetApproverList((long)report.resource_id); tier++; if (user.security_level_id == 1 || aprvResList.Exists(_ => _.tier == tier && _.approver_resource_id == userId)) // 用户是管理员或用户可以审批下一级 { tst_work_entry_report_log log = new tst_work_entry_report_log(); log.id = logDal.GetNextIdCom(); log.work_entry_report_id = report.id; log.oper_user_id = userId; log.oper_type_id = (int)DicEnum.WORK_ENTRY_REPORT_OPER_TYPE.APPROVAL; log.oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); log.tier = tier; logDal.Insert(log); OperLogBLL.OperLogAdd <tst_work_entry_report_log>(log, log.id, userId, DicEnum.OPER_LOG_OBJ_CATE.WORK_ENTRY_REPORT_LOG, "工时表审批"); appCnt++; if (aprvResList.Count == 0 || aprvResList.Max(_ => _.tier) == tier) // 是最后一级审批人 { var rptOld = rptDal.FindById(report.id); report.status_id = (int)DicEnum.WORK_ENTRY_REPORT_STATUS.PAYMENT_BEEN_APPROVED; report.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); report.update_user_id = userId; report.approve_time = report.update_time; report.approve_user_id = userId; rptDal.Update(report); OperLogBLL.OperLogUpdate(OperLogBLL.CompareValue <sdk_work_entry_report>(rptOld, report), report.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SDK_WORK_RECORD, "工时表审批"); } } } return(appCnt); }
/// <summary> /// 新增工作组 /// </summary> public bool AddGroup(sys_workgroup group, long userId) { sys_workgroup_dal swDal = new sys_workgroup_dal(); group.id = swDal.GetNextIdCom(); group.create_time = group.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); group.create_user_id = group.update_user_id = userId; swDal.Insert(group); OperLogBLL.OperLogAdd <sys_workgroup>(group, group.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SYS_WORKGROUP, ""); return(true); }
/// <summary> /// 新增工作流规则 /// </summary> /// <param name="workflow"></param> /// <param name="userId"></param> /// <returns></returns> public bool AddWorkflow(sys_workflow workflow, long userId) { workflow.id = dal.GetNextIdCom(); workflow.create_user_id = userId; workflow.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); workflow.update_time = workflow.create_time; workflow.update_user_id = userId; dal.Insert(workflow); OperLogBLL.OperLogAdd <sys_workflow>(workflow, workflow.id, userId, DicEnum.OPER_LOG_OBJ_CATE.WORKFLOW_RULE, "新增工作流规则"); return(true); }
/// <summary> /// 报价参数设置 /// </summary> /// <param name="quoteRef"></param> /// <param name="emailQuoteContact">是否通知报价联系人</param> /// <param name="emailAccountResource">是否通知客户经理</param> /// <param name="userId"></param> /// <returns></returns> public bool PreferencesQuote(crm_account_reference quoteRef, bool emailQuoteContact, bool emailAccountResource, long userId) { crm_account_reference_dal refDal = new crm_account_reference_dal(); var oldPref = refDal.GetAccountQuoteRef(quoteRef.account_id); crm_account_reference newPref; if (oldPref == null) { newPref = new crm_account_reference(); } else { newPref = refDal.GetAccountQuoteRef(quoteRef.account_id); } newPref.account_id = quoteRef.account_id; newPref.quote_tmpl_id = quoteRef.quote_tmpl_id; newPref.quote_email_message_tmpl_id = quoteRef.quote_email_message_tmpl_id; newPref.invoice_tmpl_id = null; newPref.invoice_email_message_tmpl_id = null; newPref.email_to_contacts = quoteRef.email_to_contacts; newPref.email_to_others = quoteRef.email_to_others; newPref.email_bcc_resources = quoteRef.email_bcc_resources; if (emailAccountResource) { var account = new CompanyBLL().GetCompany(newPref.account_id); if (account.resource_id != null) { newPref.email_bcc_account_manager = account.resource_id.ToString(); } } newPref.email_notes = quoteRef.email_notes; newPref.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); newPref.update_user_id = userId; if (oldPref == null) { newPref.create_time = newPref.update_time; newPref.create_user_id = userId; newPref.id = refDal.GetNextIdCom(); refDal.Insert(newPref); OperLogBLL.OperLogAdd <crm_account_reference>(newPref, newPref.id, userId, OPER_LOG_OBJ_CATE.REFERENCE, "添加客户报价参数"); } else { refDal.Update(newPref); OperLogBLL.OperLogUpdate <crm_account_reference>(oldPref, newPref, newPref.id, userId, OPER_LOG_OBJ_CATE.REFERENCE, "修改客户报价参数"); } return(true); }
/// <summary> /// 编辑库存产品 /// </summary> /// <param name="pdt"></param> /// <param name="sn"></param> /// <param name="userId"></param> /// <returns></returns> public bool EditIvtProduct(ivt_warehouse_product pdt, string sn, long userId) { ivt_warehouse_product product = dal.FindById(pdt.id); ivt_warehouse_product productOld = dal.FindById(pdt.id); if (product == null) { return(false); } product.reference_number = pdt.reference_number; product.bin = pdt.bin; product.quantity_minimum = pdt.quantity_minimum; product.quantity_maximum = pdt.quantity_maximum; product.quantity = pdt.quantity; product.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); product.update_user_id = userId; string desc = OperLogBLL.CompareValue <ivt_warehouse_product>(productOld, product); if (!string.IsNullOrEmpty(desc)) { dal.Update(product); OperLogBLL.OperLogUpdate(desc, product.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM, "修改库存产品"); } if (product.quantity != productOld.quantity) // 修改库存数量记录库存转移 { var transferDal = new ivt_transfer_dal(); var trsf = new ivt_transfer(); trsf.id = dal.GetNextIdCom(); trsf.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); trsf.create_user_id = userId; trsf.update_time = trsf.create_time; trsf.update_user_id = userId; trsf.quantity = product.quantity - productOld.quantity; trsf.type_id = (int)DicEnum.INVENTORY_TRANSFER_TYPE.MANUAL; trsf.product_id = product.product_id; trsf.from_warehouse_id = (long)product.warehouse_id; trsf.notes = ""; transferDal.Insert(trsf); OperLogBLL.OperLogAdd <ivt_transfer>(trsf, trsf.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM_TRANSFER, "新增库存转移"); } //OperLogBLL.OperLogUpdate<ivt_warehouse_product>(product, productOld, product.id, userId, DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM, "修改库存产品"); string sql = $"update ivt_warehouse_product_sn set delete_user_id={userId},delete_time={Tools.Date.DateHelper.ToUniversalTimeStamp()} where warehouse_product_id={product.id}"; dal.ExecuteSQL(sql); SaveProductSn(sn, product.id, userId); return(true); }
/// <summary> /// 新增知识库 /// </summary> public void AddKnow(sdk_kb_article thisArt, long userId) { var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); thisArt.id = _dal.GetNextIdCom(); thisArt.create_time = timeNow; thisArt.update_time = timeNow; thisArt.create_user_id = userId; thisArt.update_user_id = userId; _dal.Insert(thisArt); OperLogBLL.OperLogAdd <sdk_kb_article>(thisArt, thisArt.id, userId, OPER_LOG_OBJ_CATE.SDK_KONWLEDGE, "新增知识库"); }
/// <summary> /// 新增变更委员会 /// </summary> public bool AddBoard(d_change_board board, string resIds, long userId) { if (!CheckBoardName(board.name)) { return(false); } board.id = _dal.GetNextIdCom(); board.create_time = board.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); board.create_user_id = board.update_user_id = userId; _dal.Insert(board); OperLogBLL.OperLogAdd <d_change_board>(board, board.id, userId, DicEnum.OPER_LOG_OBJ_CATE.CHANGE_BOARD, ""); BoardResourceManage(board.id, resIds, userId); return(true); }
/// <summary> /// 新增产品 /// </summary> /// <param name="pdt"></param> /// <param name="sn">序列化产品的序列号</param> /// <param name="userId"></param> /// <returns></returns> public bool AddIvtProduct(ivt_warehouse_product pdt, string sn, long userId) { pdt.id = dal.GetNextIdCom(); pdt.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp(); pdt.create_user_id = userId; pdt.update_time = pdt.create_time; pdt.update_user_id = userId; dal.Insert(pdt); OperLogBLL.OperLogAdd <ivt_warehouse_product>(pdt, pdt.id, userId, DTO.DicEnum.OPER_LOG_OBJ_CATE.INVENTORY_ITEM, "新增库存产品"); SaveProductSn(sn, pdt.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); }
/// <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); }
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); }
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); }
/// <summary> /// 新增队列员工 /// </summary> public bool AddQueueResource(sys_resource_department resDep, long userId, ref string faileReason) { sys_resource_department_dal srdDal = new sys_resource_department_dal(); if (!CheckResourceRole(resDep)) { faileReason = "已存在该员工角色"; return(false); } if (resDep.is_lead == 1) // && resDep.is_active==1 { ClearLeadResource(resDep.department_id, userId); } resDep.id = srdDal.GetNextIdCom(); srdDal.Insert(resDep); OperLogBLL.OperLogAdd <sys_resource_department>(resDep, resDep.id, userId, OPER_LOG_OBJ_CATE.SYS_RESOURCE_DEPARTMENT, ""); return(true); }
/// <summary> /// 新增约会 /// </summary> public bool AddAppointment(sdk_appointment dispatch, long userId) { if (dispatch == null) { return(false); } dispatch.id = saDal.GetNextIdCom(); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); dispatch.create_time = timeNow; dispatch.update_time = timeNow; dispatch.create_user_id = userId; dispatch.update_user_id = userId; saDal.Insert(dispatch); OperLogBLL.OperLogAdd <sdk_appointment>(dispatch, dispatch.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SERVICE_APPOINTMENT, "新增约会"); return(true); }
public bool AddCode(d_cost_code code, long userId) { // code.id if (!CheckCodeName(code.name, code.cate_id)) { return(false); } code.id = _dal.GetNextIdCom(); code.create_time = code.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); code.create_user_id = code.update_user_id = userId; _dal.Insert(code); OperLogBLL.OperLogAdd <d_cost_code>(code, code.id, userId, OPER_LOG_OBJ_CATE.D_COST_CODE, ""); if (code.cate_id == (int)DicEnum.COST_CODE_CATE.INTERNAL_ALLOCATION_CODE) { AddInterCodeTask(code, userId); } return(true); }
/// <summary> /// 新增约会 /// </summary> public bool AddDispatchView(sdk_dispatcher_view disView, long userId) { if (disView == null) { return(false); } var sdDal = new sdk_dispatcher_view_dal(); disView.id = saDal.GetNextIdCom(); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); disView.create_time = timeNow; disView.update_time = timeNow; disView.create_user_id = userId; disView.update_user_id = userId; sdDal.Insert(disView); OperLogBLL.OperLogAdd <sdk_dispatcher_view>(disView, disView.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SERVICE_DISPATCHER_VIEW, "新增调度工作室视图"); return(true); }
/// <summary> /// 快速新增 /// </summary> public bool AddQuickCall(ServiceCallDto param, long userId) { // 新增工单 var tBll = new TicketBLL(); param.thisTicket.type_id = (int)DicEnum.TASK_TYPE.SERVICE_DESK_TICKET; param.thisTicket.status_id = (int)DicEnum.TICKET_STATUS.NEW; tBll.InsertTicket(param.thisTicket, userId); // 新增自定义 var udf_list = new UserDefinedFieldsBLL().GetUdf(DicEnum.UDF_CATE.TICKETS); new UserDefinedFieldsBLL().SaveUdfValue(DicEnum.UDF_CATE.TICKETS, userId, param.thisTicket.id, udf_list, param.udfList, DicEnum.OPER_LOG_OBJ_CATE.PROJECT_TASK_INFORMATION); // 新增其他负责人 if (!string.IsNullOrEmpty(param.resIds)) { tBll.TicketResManage(param.thisTicket.id, param.resIds, userId); } // 新增服务预定 var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); tBll.AddCallOnly(param.call, userId); var ssctDal = new sdk_service_call_task_dal(); var taskRes = new sdk_service_call_task() { id = ssctDal.GetNextIdCom(), create_time = timeNow, create_user_id = userId, service_call_id = param.call.id, task_id = param.thisTicket.id, update_time = timeNow, update_user_id = userId, }; ssctDal.Insert(taskRes); OperLogBLL.OperLogAdd <sdk_service_call_task>(taskRes, taskRes.id, userId, DicEnum.OPER_LOG_OBJ_CATE.SERVICE_CALL_TICKET, "新增服务预定关联工单"); if (!string.IsNullOrEmpty(param.resIds)) { tBll.CallTicketResManage(param.call.id, param.resIds, userId); } 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> public bool AddServiceBundle(ivt_service_bundle SerBun, long userId, string serIds) { try { var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); var isbDal = new ivt_service_bundle_dal(); SerBun.id = isbDal.GetNextIdCom(); SerBun.create_time = timeNow; SerBun.update_time = timeNow; SerBun.create_user_id = userId; SerBun.update_user_id = userId; isbDal.Insert(SerBun); OperLogBLL.OperLogAdd <ivt_service_bundle>(SerBun, SerBun.id, userId, DTO.DicEnum.OPER_LOG_OBJ_CATE.IVT_SERVICE_BUNDLE, "新增服务包"); ServiceBundleManage(SerBun.id, serIds, userId); } catch (Exception msg) { return(false); } return(true); }