/// <summary> /// Applies methodName or aml string. /// </summary> /// <param name="methodName">Method Name. if empty - applies aml</param> /// <param name="aml">Aml string.</param> /// <returns>Response Item object.</returns> private string _Apply(string methodName, string aml) { CheckAuthorization(); Item response = (methodName == null) ? inn.applyAML(aml) : inn.applyMethod(methodName, aml); if (response.isError()) { this.ThrowException(response); } XmlNode resultNode = response.dom.DocumentElement.SelectSingleNode("/*[local-name()='Envelope']/*[local-name()='Body']/*[local-name(.)='Result']"); if (resultNode != null) { return(resultNode.OuterXml); } else { XmlNode bodyNode = response.dom.DocumentElement.SelectSingleNode("/*[local-name()='Envelope']/*[local-name()='Body']"); if (bodyNode != null) { return(bodyNode.InnerXml); } else { return(response.dom.OuterXml); } } }
public HttpResponseMessage GetCall(string id) { //Item req = call.Inn.newItem(call.ItemType, call.Action); //req.setProperty("qd_id", id); //Item res = req.apply(); Innovator inn = call.Inn; Item res = inn.applyMethod("RDF Transform Query Execution", "<qd_id>" + id + "</qd_id>"); if (res.isError()) { return(Request.CreateResponse(HttpStatusCode.BadRequest, res.getErrorString())); } string result = res.ToString(); result = result.Replace("xmlns:SOAP-ENV=\"", ""); result = result.Replace("http://schemas.xmlsoap.org/soap/envelope/\" ", ""); result = result.Replace("<SOAP-ENV:Envelope xmlns:i18n=\"http://www.aras.com/I18N\"><SOAP-ENV:Body><Result>", ""); result = result.Replace("</Result></SOAP-ENV:Body></SOAP-ENV:Envelope>", ""); result = result.Replace("{\"root\":", ""); result = result.Substring(0, result.Length - 1); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK); response.Content = new StringContent(result, Encoding.UTF8, "application/json"); return(response); }
/// <summary> /// 获取费用类别根据名称 /// </summary> /// <param name="inn"></param> /// <param name="name"></param> /// <returns></returns> public static Item GetExpenseCategoryByName(Innovator inn, string b_CostName) { string strSql = "select * from innovator.b_ExpenseCategory where b_CostName=N'" + b_CostName + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 查询根据领导 /// </summary> /// <param name="inn"></param> /// <param name="b_NodePersonName"></param> /// <param name="b_NodeLevel"></param> /// <returns></returns> public static Item GetOrganizationalStructureByLeader(Innovator inn, string b_NodePersonName, int b_NodeLevel) { string strSql = "select * from b_OrganizationalStructure where b_NodePersonName=N'" + b_NodePersonName + "' and b_NodeLevel='" + b_NodeLevel + "'"; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(result); }
/// <summary> /// 删除审核配置表 /// </summary> /// <param name="inn"></param> /// <returns></returns> public static Item DeleteExpenseAuditConfiguration(Innovator inn) { string strSql = "delete innovator.b_ExpenseAuditConfiguration"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 获取活动根据活动名称 /// </summary> /// <returns></returns> public static Item GetActivityByNames(Innovator inn, List <string> names, string ItemId, string tableName, string activityStatus = "Pending") { if (names == null || names.Count() == 0) { return(null); } string whereStr = " where i.KEYED_NAME in ("; for (int i = 0; i < names.Count(); i++) { if (i == (names.Count() - 1)) { whereStr += "'" + names[i] + "'" + ")"; } else { whereStr += "'" + names[i] + "'" + ","; } } whereStr += " and g.id='" + ItemId + "' and i.state='" + activityStatus + "'"; string sqlStr = @"select i.* from {0} g inner join innovator.WORKFLOW t on g.id=t.SOURCE_ID inner join innovator.WORKFLOW_PROCESS y on t.RELATED_ID=y.ID inner join innovator.WORKFLOW_PROCESS_ACTIVITY u on y.ID=u.SOURCE_ID inner join innovator.ACTIVITY i on u.RELATED_ID=i.ID"; sqlStr = sqlStr + whereStr; sqlStr = string.Format(sqlStr, tableName); var activitys = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + sqlStr + "</sqlCommend>"); return(activitys); }
public static Item GetActivityAssignment(Innovator inn, string source_id) { string strSql = "select g.* from ACTIVITY_ASSIGNMENT g inner join [innovator].[IDENTITY] t on g.RELATED_ID=t.id where g.SOURCE_ID='" + source_id + "' and t.name!='Administrators'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 获取当前任务的操作权限 /// </summary> /// <param name="activityId"></param> /// <returns></returns> public static Item GetIdentityByActivityId(Innovator inn, string activityId, bool isClose) { string strSql = "select t.* from ACTIVITY_ASSIGNMENT g inner join [innovator].[IDENTITY] t on g.RELATED_ID=t.id where g.SOURCE_ID='" + activityId + "' and g.CLOSED_BY is null and g.VOTING_WEIGHT>0"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 获取权限子节点 /// </summary> /// <param name="inn"></param> /// <param name="identityId"></param> /// <returns></returns> public static Item GetChildIdentity(Innovator inn, string identityId) { string strSql = "select y.* from [innovator].[IDENTITY] g inner join [innovator].[MEMBER] t on g.id=t.source_id inner join [innovator].[IDENTITY] y on t.related_id=y.id where g.id='" + identityId + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 获取流程状态Select列表 /// </summary> /// <param name="inn"></param> /// <param name="workFlowName"></param> /// <returns></returns> public static Item GetWorkflowStatusList(Innovator inn, string workFlowName) { string sqlStr = "select y.KEYED_NAME from WORKFLOW_MAP g inner join WORKFLOW_MAP_ACTIVITY t on g.id=t.SOURCE_ID inner join ACTIVITY_TEMPLATE y on t.related_id=y.id where g.KEYED_NAME='" + workFlowName + "' and g.IS_CURRENT=1 order by y.CREATED_ON asc"; Item result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + sqlStr + "</sqlCommend>"); return(result); }
/// <summary> /// 根据条件获取身份 /// </summary> /// <param name="inn"></param> /// <param name="keyed_name"></param> /// <param name="description"></param> /// <returns></returns> public static Item GetIdentityByCondition(Innovator inn, string id, string keyed_name) { string strSql = "select count(*) as ncount from innovator.[IDENTITY] where keyed_name='" + keyed_name + "' and id!='" + id + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 是否存在项目编号 /// </summary> /// <param name="inn"></param> /// <param name="b_ProjectRecordNo"></param> /// <param name="id"></param> /// <returns></returns> public static bool isExistProjectRecordNo(Innovator inn, string b_ProjectRecordNo, string id) { string strSql = "select * from innovator.B_PROJECTMANAGE where b_ProjectRecordNo='" + b_ProjectRecordNo + "' and id!='" + id + "'"; Item result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(result.getItemCount() > 0 ? true : false); }
/// <summary> /// 删除组织结构 /// </summary> public static Item DeleteOrganizationalStructure(Innovator inn) { string strSql = "delete innovator.b_OrganizationalStructure"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 根据节点代码 获取节点 /// </summary> /// <param name="inn"></param> /// <param name="b_NodeCode"></param> /// <returns></returns> public static Item GetOrganizationalStructureByNodeCode(Innovator inn, string b_NodeCode) { string strSql = "select * from b_OrganizationalStructure where b_NodeCode='" + b_NodeCode + "'"; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(result); }
public static Item GetActivityAssignmentById(Innovator inn, string id) { string strSql = "select * from innovator.ACTIVITY_ASSIGNMENT where id='" + id + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 获取合同单号 获取数据 /// </summary> /// <param name="inn"></param> /// <param name="contractNo"></param> /// <returns></returns> public static Item GetPrManageByContractNo(Innovator inn, string contractNo) { string strSql = @"select g.*,y.b_Buyer,y.b_PrRecordNo from [innovator].B_PrChoiceSuppliers g inner join [innovator].[B_CHOICESUPPLIERS] t on g.id=t.RELATED_ID inner join [innovator].B_PRMANAGE y on t.SOURCE_ID=y.id where g.b_PoNo='" + contractNo + "'"; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(result); }
/// <summary> /// 获取项目管理根据名称 /// </summary> public static bool GetProjectManageByName(Innovator inn, string name, string id) { string strSql = "select * from innovator.B_PROJECTMANAGE where b_projectname='" + name + "' and id!='" + id + "'"; Item result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); //string strAml = "<AML><Item type='B_PROJECTMANAGE' action='get' where='id!=" + id + "'><b_projectname>" + name + "</b_projectname></Item></AML>"; //var result = inn.applyAML(strAml); return(result.getItemCount() > 0 ? true : false); }
/// <summary> /// 获取老备注 /// </summary> /// <param name="inn"></param> /// <param name="id"></param> /// <returns></returns> public static string GetOldRemarkById(Innovator inn, string id) { string strSql = "select b_Remark from innovator.b_TripReimbursementForm where id='" + id + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!returnItem.isError() && returnItem.getItemCount() > 0) { return(returnItem.getProperty("b_remark")); } return(""); }
/// <summary> /// 生成单据单号 /// </summary> /// <param name="inn"></param> /// <param name="id"></param> /// <returns></returns> public static string CreateRecordNo(Innovator inn, string id) { string b_recordno = ""; if (!string.IsNullOrEmpty(id)) { string sqlStr = "Declare @IndexNum int Select @IndexNum = isnull(Max(B_INDEXNUM), 0) + 1 from innovator.b_TripReimbursementForm where CREATED_ON >= CONVERT(varchar(10),dateadd(dd,-day(getdate())+1,getdate()),120) and CREATED_ON < CONVERT(CHAR(10),DATEADD(m,1,DATEADD(dd,-DAY(GETDATE())+1,GETDATE())),111) update innovator.b_TripReimbursementForm set b_RecordNo = b_RecordNo + RIGHT('00000' + CAST(@IndexNum as varchar), 5),b_indexnum=@IndexNum where id = '" + id + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + sqlStr + "</sqlCommend>"); b_recordno = GetRecordNoById(inn, id); } return(b_recordno); }
/// <summary> /// 根据名称地区,获取角色权限 /// </summary> /// <param name="inn"></param> /// <param name="keyed_name"></param> /// <param name="description"></param> /// <returns></returns> public static Item GetIdentityByParam(Innovator inn, string keyed_name, string description) { string strSql = "select * from innovator.[IDENTITY] where keyed_name=N'" + keyed_name + "'"; if (!string.IsNullOrEmpty(description)) { strSql += "and innovator.[IDENTITY].[DESCRIPTION]=N'" + description + "'"; } var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 根据代码 获取公司名称 /// </summary> /// <param name="code"></param> /// <returns></returns> public static string GetCompanyNameByCode(Innovator inn, string code) { string companyName = ""; string strSql = "select b_CompanyName from innovator.b_CompanyInfo where b_CompanyCode=" + code; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!result.isError() && result.getItemCount() > 0) { companyName = result.getItemByIndex(0).getProperty("b_companyname"); } return(companyName); }
/// <summary> /// 获取挑选的供应商 /// </summary> /// <param name="inn"></param> /// <param name="id"></param> /// <returns></returns> public static decimal GetPrContractPrice(Innovator inn, string id) { decimal contractPrice = 0; string strSql = "select sum(t.B_CONTRACTPRICE) as CONTRACTPRICE from b_ChoiceSuppliers g inner join B_PrChoiceSuppliers t on g.RELATED_ID=t.id where g.SOURCE_ID='" + id + "'"; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!result.isError()) { contractPrice = decimal.Parse(result.getProperty("contractprice")); } return(contractPrice); }
public static bool CheckedContractNoIsExist(Innovator inn, string contractNo, string id) { string strSql = "select * from B_PrChoiceSuppliers where b_PoNo='" + contractNo + "' and id !='" + id + "'"; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!result.isError() && result.getItemCount() > 0) { return(false); } else { return(true); } }
/// <summary> /// 获取当前活动 /// </summary> /// <param name="inn"></param> /// <param name="id"></param> /// <returns></returns> public static Item GetActivityByItemId(Innovator inn, string id, string tableName) { string sqlStr = @"select i.ID as activityId,o.ID as activityAssignmentId,i.KEYED_NAME from {0} g inner join innovator.WORKFLOW t on g.id=t.SOURCE_ID inner join innovator.WORKFLOW_PROCESS y on t.RELATED_ID=y.ID inner join innovator.WORKFLOW_PROCESS_ACTIVITY u on y.ID=u.SOURCE_ID inner join innovator.ACTIVITY i on u.RELATED_ID=i.ID inner join innovator.ACTIVITY_ASSIGNMENT o on i.ID=o.SOURCE_ID where i.STATE = 'active' and g.id='" + id + "'"; sqlStr = string.Format(sqlStr, tableName); var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + sqlStr + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 是否存在该地区 /// </summary> public static bool isExistRegionByName(Innovator inn, string regionName) { string strSql = "select * from innovator.b_region where b_RegionName=N'" + regionName + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!returnItem.isError() && returnItem.getItemCount() > 0) { return(true); } else { return(false); } }
/// <summary> /// 判断费用类别是否存在 /// </summary> /// <param name="inn"></param> /// <param name="b_CostName"></param> /// <param name="id"></param> /// <returns></returns> public static bool IsExistExpenseCategory(Innovator inn, string b_CostName, string id) { string strSql = "select * from innovator.b_ExpenseCategory where b_CostName=N'" + b_CostName + "' and id!='" + id + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!returnItem.isError() && returnItem.getItemCount() > 0) { return(true); } else { return(false); } }
/// <summary> /// 判断二级中心是否存在 /// </summary> /// <param name="inn"></param> /// <param name="nodeName"></param> /// <returns></returns> public static bool IsExistCentre(Innovator inn, string nodeName) { string strSql = "select * from b_OrganizationalStructure where b_NodeName=N'" + nodeName + "' and b_NodeLevel=2"; var result = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); if (!result.isError() && result.getItemCount() > 0) { return(true); } else { return(false); } }
/// <summary> /// 节点审核,根据登录角色权限 /// </summary> /// <param name="inn"></param> /// <param name="id"></param> /// <param name="tableName"></param> /// <param name="roles"></param> /// <returns></returns> public static Item GetActivityAuditByLoginInfo(Innovator inn, string id, string tableName, List <string> roles, List <string> agentRoles = null) { List <string> newRoles = new List <string>(); if (roles != null && roles.Count > 0) { newRoles.AddRange(roles); } if (agentRoles != null && agentRoles.Count > 0) { newRoles.AddRange(agentRoles); } string sqlStr = @"select i.ID as activityId,o.ID as activityAssignmentId,i.KEYED_NAME from {0} g inner join innovator.WORKFLOW t on g.id=t.SOURCE_ID inner join innovator.WORKFLOW_PROCESS y on t.RELATED_ID=y.ID inner join innovator.WORKFLOW_PROCESS_ACTIVITY u on y.ID=u.SOURCE_ID inner join innovator.ACTIVITY i on u.RELATED_ID=i.ID inner join innovator.ACTIVITY_ASSIGNMENT o on i.ID=o.SOURCE_ID inner join innovator.[IDENTITY] p on o.RELATED_ID=p.ID where i.STATE = 'active' and o.CLOSED_BY is null and g.id='" + id + "'"; if (newRoles != null && newRoles.Count > 0) { sqlStr += " and p.id in ("; for (int i = 0; i < newRoles.Count; i++) { if (i == newRoles.Count - 1) { sqlStr += "'" + newRoles[i] + "'" + ")"; } else { sqlStr += "'" + newRoles[i] + "',"; } } } sqlStr = string.Format(sqlStr, tableName); var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + sqlStr + "</sqlCommend>"); return(returnItem); }
/// <summary> /// 修改报销状态 /// </summary> /// <param name="inn"></param> /// <param name="b_IsReimbursement"></param> /// <param name="id"></param> public static void UpdateBusinessTravelIsReimbursement(Innovator inn, string b_IsReimbursement, string b_BTRecordNo) { string sqlStr = "update b_BusinessTravel set b_IsReimbursement='" + b_IsReimbursement + "' where b_documentno='" + b_BTRecordNo + "'"; var returnItem = inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + sqlStr + "</sqlCommend>"); }
public static void UpdateActivityAssignmentVotingWeight(Innovator inn, string id, int votingWeight) { string strSql = "update innovator.ACTIVITY_ASSIGNMENT set Voting_Weight='" + votingWeight + "' where id='" + id + "'"; inn.applyMethod("bcs_RunQuery", "<sqlCommend>" + strSql + "</sqlCommend>"); }