/// <summary> /// 添加工作流模板信息 /// </summary> /// <param name="workflowTemplate">工作流模板信息</param> /// <returns>返回工作流模板信息</returns> public BusinessWorkflowTemplate AddWorkflowTemplate(BusinessWorkflowTemplate workflowTemplate) { SqlParameterCollection spc = DB.CreateSqlParameterCollection(); spc.Add("@SystemName", workflowTemplate.SystemName); spc.Add("@ModuleName", workflowTemplate.ModuleName); spc.Add("@CategoryName", workflowTemplate.CategoryName); spc.Add("@TemplateContent", workflowTemplate.TemplateContent); spc.Add("@TemplateDesc", workflowTemplate.TemplateDesc); workflowTemplate.CreateDateTime = DateTime.Now; workflowTemplate.ModifyDateTime = DateTime.Now; spc.Add("@CreateDateTime", workflowTemplate.CreateDateTime); spc.Add("@ModifyDateTime", workflowTemplate.ModifyDateTime); workflowTemplate.TemplateID = getNewTemplateID(); spc.Add("@TemplateID", workflowTemplate.TemplateID.ToString()); string sql = "insert into g_BusinessWorkflowTemplate(SystemName, ModuleName, CategoryName, TemplateID, TemplateContent, TemplateDesc, CreateDateTime, ModifyDateTime)" + "values(@SystemName, @ModuleName, @CategoryName, @TemplateID, @TemplateContent, @TemplateDesc, @CreateDateTime, @ModifyDateTime)"; DB.ExecuteNonQuerySql(sql, spc); return(workflowTemplate); }
private BusinessWorkflowTemplate DataRow2WorkflowTemplate(DataRow dr) { BusinessWorkflowTemplate template = new BusinessWorkflowTemplate(); template.SystemName = dr["SystemName"].ToString(); template.ModuleName = dr["ModuleName"].ToString(); template.CategoryName = dr["CategoryName"].ToString(); template.TemplateID = dr["TemplateID"].ToGuid(); template.TemplateContent = dr["TemplateContent"].ToString(); template.TemplateDesc = dr["TemplateDesc"].ToString(); template.CreateDateTime = dr["CreateDateTime"].ToDateTime(); template.ModifyDateTime = dr["ModifyDateTime"].ToDateTime(); return(template); }
/// <summary> /// 更新工作流模板信息 /// </summary> /// <param name="workflowTemplate">工作流模板信息</param> public void UpdateWorkflowTemplate(BusinessWorkflowTemplate workflowTemplate) { SqlParameterCollection spc = DB.CreateSqlParameterCollection(); spc.Add("@SystemName", workflowTemplate.SystemName); spc.Add("@ModuleName", workflowTemplate.ModuleName); spc.Add("@CategoryName", workflowTemplate.CategoryName); spc.Add("@TemplateContent", workflowTemplate.TemplateContent); spc.Add("@TemplateDesc", workflowTemplate.TemplateDesc); workflowTemplate.ModifyDateTime = DateTime.Now; spc.Add("@ModifyDateTime", workflowTemplate.ModifyDateTime); spc.Add("@TemplateID", workflowTemplate.TemplateID.ToString()); string sql = "update g_BusinessWorkflowTemplate set SystemName=@SystemName, ModuleName=@ModuleName, CategoryName=@CategoryName, TemplateContent=@TemplateContent, TemplateDesc=@TemplateDesc, ModifyDateTime=@ModifyDateTime where TemplateID=@TemplateID"; DB.ExecuteNonQuerySql(sql, spc); }