//public JsonResult GetOrderNumber() //{ // rtn_data rtn = new rtn_data(); // try // { // AllocationOrder.AllocationOrderRule rule = allocationOrder.UserRule(this.UserValidator.UserID); // if (rule != null) // { // //条件 // string condtions = ""; // #region 渠道类型 // if (rule.ChannelType == "内网") // { // condtions += " and app.createdbyparentid ='28a0ba01-4f58-4097-96cb-77c2b09e8253'"; // } // else if (rule.ChannelType == "外网") // { // condtions += " and app.createdbyparentid ='9b8eb0fb-31c2-4577-bea7-9e453812f863'"; // } // #endregion // #region 资产类型 // if (!string.IsNullOrEmpty(rule.AssetCondition)) // { // condtions += " and vehicle.condition='" + rule.AssetCondition + "'"; // } // #endregion // #region 审核额度 // condtions += " and contract.amount_financed>=" + rule.LoanAmountFrom; // condtions += " and contract.amount_financed<=" + rule.LoanAmountTo; // #endregion // #region SQL // string sql = allocationOrder.GetQueryTaskSql(condtions); // #endregion // int filterNumber = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql).Rows.Count; // int totalNumber = allocationOrder.GetTaskTotalNumber(); // rtn.code = 1; // rtn.data = "满足[" + filterNumber + "]/总[" + totalNumber + "]"; // } // else // { // rtn.code = -1; // rtn.message = "无分单规则"; // } // return Json(rtn); // } // catch (Exception ex) // { // rtn.code = -1; // rtn.message = "查询异常"; // return Json(rtn); // } //} public JsonResult TransferUserByRG(string worlitemids, string replaceuserid) { string[] workItems = worlitemids.Split(';'); // 转移工作项 int successCount = 0; if (workItems != null) { foreach (string itemId in workItems) { if (string.IsNullOrEmpty(itemId)) { continue; } var item = this.Engine.WorkItemManager.GetWorkItem(itemId); if (item.DisplayName == "东正风控评估") { var context = this.Engine.InstanceManager.GetInstanceContext(item.InstanceId); //流程数据 string sql = "select app.application_number,det.amount_financed,app.allocation_available from i_application{0} app left join i_contract_detail{0} det on app.objectid = det.parentobjectid where app.objectid = '{1}'"; sql = string.Format(sql, context.BizObjectSchemaCode.ToLower().Replace("application", ""), context.BizObjectId); DataTable dt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql); //允许分单 if (dt.Rows[0]["allocation_available"] + string.Empty == "1") { //获取当前规则 AllocationOrder.AllocationOrderRule rule = allocationOrder.UserRule(replaceuserid); if (rule != null) { allocationOrder.AddLog(LogFileName, DateTime.Now.ToString("yyyy-MM-dd"), string.Format("任务[{0}]分配给{1}[{2}]-->人工分单", itemId, rule.UserName, rule.UserCode)); //现有订单数量 int num = allocationOrder.GetProposalOrderNumber(replaceuserid); //插入到分单历史表中; allocationOrder.SaveToOrderHis(rule, item.InstanceId, item.ObjectID, dt.Rows[0]["application_number"] + string.Empty, dt.Rows[0]["amount_financed"] + string.Empty, context.OrgUnit, num); //分单; allocationOrder.SendOrder(rule, context.BizObjectSchemaCode, context.BizObjectId, item.Participant, item.ObjectID, dt.Rows[0]["amount_financed"] + string.Empty); } } } else { long result1 = this.Engine.WorkItemManager.Transfer(itemId, replaceuserid); if (result1 == ErrorCode.SUCCESS) { this.Engine.LogWriter.Write(string.Format("TransferUserTransferUserByRG itemId:{0},replaceuserid:{1},by:{2}", itemId, replaceuserid, this.UserValidator.UserName + "[" + this.UserValidator.UserCode + "]")); successCount++; } } } } OThinker.H3.Controllers.ActionResult result = new OThinker.H3.Controllers.ActionResult(true, "TransferUser.TransferSucess");//TODO 信息提示 return(Json(result)); }
public JsonResult GetBondCount() { string UserID = this.UserValidator.UserID; return(this.ExecuteFunctionRun(() => { OThinker.H3.Controllers.ActionResult result = new OThinker.H3.Controllers.ActionResult(true); Dictionary <string, int> Extend = new Dictionary <string, int>(); string sql1 = @"select count(distinct Distributorcode) counts from I_Bond"; string sql2 = @"select count(distinct DEALER_CODE)count from IN_WFS.V_DEALER_INFO v"; var count = this.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(sql1); int num1 = Convert.ToInt32(count); int num2 = ExecuteCountSql("Wholesale", sql2); //= @"select count(1) counts from I_Bond where BondState='终审中'"; string sql3 = @"SELECT count(1) from i_bond A JOIN (select Max(b.Modifiedtime) OperationTime ,b.distributorcode from i_bond b group by b.distributorcode ) B ON A.Distributorcode = B.Distributorcode and B.OperationTime = A.Modifiedtime join Ot_Instancecontext c on c.bizobjectid = A.OBJECTID join (select a.objectid workItemcode ,a.instanceid,a.starttime from (select a.objectid instanceid,b.starttime,b.objectid from Ot_Instancecontext a join Ot_Workitem b on a.objectid = b.instanceid where a.workflowcode = 'Bond' and a.state = '2' and b.PARTICIPANT = '{0}' union select a.objectid instanceid,b.starttime,b.objectid from Ot_Instancecontext a join Ot_Workitemfinished b on a.objectid = b.instanceid where a.workflowcode = 'Bond' and a.state = '4' and b.PARTICIPANT = '{0}') a join ( select Max(starttime)receivetime,objectid from ( select a.objectid,b.starttime from Ot_Instancecontext a join Ot_Workitem b on a.objectid = b.instanceid where a.workflowcode = 'Bond' and a.state = '2' and b.PARTICIPANT = '{0}' union select a.objectid,b.starttime from Ot_Instancecontext a join Ot_Workitemfinished b on a.objectid = b.instanceid where a.workflowcode = 'Bond' and a.state = '4' and b.PARTICIPANT = '{0}') group by objectid) b on a.instanceid = b.objectid and b.receivetime = a.starttime ) d on d.instanceid = c.objectid WHERE 1=1 AND FinalState in('创建待审核','修改待审核')"; var count3 = this.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(string.Format(sql3, UserID)); int total1 = num2 - num1; int total2 = Convert.ToInt32(count3); Extend["BondCount"] = total1; Extend["BondFinalCount"] = total2; result.Extend = Extend; return Json(result, JsonRequestBehavior.AllowGet); })); }
public System.Web.Mvc.JsonResult UpdateBondApproval(string param) { WorkItemServer Ws = new WorkItemServer(); string[] paramS = param.Split(','); // DataTable dt = QueryBondApproval(paramS); // List<BondViewModel> paramList = this.Getgriddata(dt);//this.GetgriddataEdit(dtWorkitem, param); // List<BondViewModel> paramList = param; //System.Web.Script.Serialization.JavaScriptSerializer json = new System.Web.Script.Serialization.JavaScriptSerializer(); //json.MaxJsonLength = int.MaxValue; //paramList = json.Deserialize<List<BondViewModel>>(param); return(this.ExecuteFunctionRun(() => { OThinker.H3.Controllers.ActionResult result = new OThinker.H3.Controllers.ActionResult(true); var code = this.UserValidator.UserID; foreach (string item in paramS) { string[] str = item.Split(';'); if (string.IsNullOrEmpty(str[0]) || str[0] == "null") { continue; } List <DataItemParam> paramValues = new List <DataItemParam>(); //paramValues.Add(new DataItemParam() //{ // ItemName = "Distributorcode", // ItemValue = item.Distributorcode //}); //paramValues.Add(new DataItemParam() //{ // ItemName = "Distributorname", // ItemValue = item.Distributorname //}); paramValues.Add(new DataItemParam() { ItemName = "BondProportion", ItemValue = str[0] }); paramValues.Add(new DataItemParam() { ItemName = "OperationTime", ItemValue = DateTime.Now.ToLongDateString() }); paramValues.Add(new DataItemParam() { ItemName = "FinalState", ItemValue = "已生效" }); paramValues.Add(new DataItemParam() { ItemName = "BondState", ItemValue = "已生效" }); Ws.ForwardWorkItem(paramValues, code, "Bond", str[2], str[3]); string sql = @"update I_Bond set BondState = '已失效',FinalState = '已失效' where objectid !='{0}' and Distributorcode ='{1}'"; sql = string.Format(sql, str[4], str[5]); OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql); } return Json(result, "text/html", JsonRequestBehavior.AllowGet); }, string.Empty)); }
public System.Web.Mvc.JsonResult UpdateBondFinalEdit(string page) { WorkItemServer Ws = new WorkItemServer(); string[] WorkItems = page.Split(','); //string[] WorkItems = param; return(this.ExecuteFunctionRun(() => { OThinker.H3.Controllers.ActionResult result = new OThinker.H3.Controllers.ActionResult(true); var code = this.UserValidator.UserCode; foreach (string item in WorkItems) { if (string.IsNullOrEmpty(item)) { continue; } string[] pv = item.Split(';'); if (string.IsNullOrEmpty(pv[2].Trim()) || pv[2].Trim() == "null") { continue; } string sql = @"update I_Bond set BondState = '已失效',FinalState = '已失效' where objectid ='{0}' and Distributorcode ='{1}'"; sql = string.Format(sql, pv[3].Trim(), pv[0].Trim()); OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql); string H3IDSql = string.Format(@"select objectid from Ot_User where APPELLATION = '{0}' and STATE =1 ", pv[0].Trim()); var H3ID = OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(H3IDSql); if (H3ID == null || H3ID.ToString() == "") { sql = "select objectid from Ot_User where APPELLATION = '" + pv[0].Trim() + "'"; H3ID = this.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(sql); } List <DataItemParam> paramValues = new List <DataItemParam>(); paramValues.Add(new DataItemParam() { ItemName = "Distributorcode", ItemValue = pv[0].Trim() }); paramValues.Add(new DataItemParam() { ItemName = "Distributorname", ItemValue = pv[1].Trim() }); paramValues.Add(new DataItemParam() { ItemName = "BondProportion", ItemValue = Convert.ToDecimal(pv[2].Trim()) }); paramValues.Add(new DataItemParam() { ItemName = "OperationTime", ItemValue = DateTime.Now.ToLongDateString() }); paramValues.Add(new DataItemParam() { ItemName = "BondState", ItemValue = "已生效" }); paramValues.Add(new DataItemParam() { ItemName = "FinalState", ItemValue = "已生效" }); paramValues.Add(new DataItemParam() { ItemName = "ISYN", ItemValue = "是" }); paramValues.Add(new DataItemParam() { ItemName = "JXSH3ID", ItemValue = H3ID }); Ws.startWorkflow("Bond", code, true, paramValues); } return Json(result, "text/html", JsonRequestBehavior.AllowGet); }, string.Empty)); }
public System.Web.Mvc.JsonResult UpdateBondEdit(string param) { WorkItemServer Ws = new WorkItemServer(); string[] WorkItems = param.Split(','); return(this.ExecuteFunctionRun(() => { OThinker.H3.Controllers.ActionResult result = new OThinker.H3.Controllers.ActionResult(true); var code = this.UserValidator.UserCode; foreach (string item in WorkItems) { string[] pv = item.Split(';'); if (string.IsNullOrEmpty(pv[2].Trim()) || pv[2].Trim() == "null") { continue; } List <DataItemParam> paramValues = new List <DataItemParam>(); paramValues.Add(new DataItemParam() { ItemName = "Distributorcode", ItemValue = pv[0].Trim() }); paramValues.Add(new DataItemParam() { ItemName = "Distributorname", ItemValue = pv[1].Trim() }); paramValues.Add(new DataItemParam() { ItemName = "BondProportion", ItemValue = Convert.ToDecimal(pv[2].Trim()) }); paramValues.Add(new DataItemParam() { ItemName = "OperationTime", ItemValue = DateTime.Now.ToLongDateString() }); string sql = "select objectid from Ot_User where APPELLATION = '" + pv[0].Trim() + "' and STATE =1 "; var JXSH3ID = this.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(sql); if (JXSH3ID == null || JXSH3ID.ToString() == "") { sql = "select objectid from Ot_User where APPELLATION = '" + pv[0].Trim() + "'"; JXSH3ID = this.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(sql); } paramValues.Add(new DataItemParam() { ItemName = "JXSH3ID", ItemValue = JXSH3ID }); if (pv[3].Trim() == "待创建" || pv[3].Trim() == "已生效") { paramValues.Add(new DataItemParam() { ItemName = "BondState", ItemValue = "终审中" }); if (pv[3].Trim() == "待创建") { paramValues.Add(new DataItemParam() { ItemName = "FinalState", ItemValue = "创建待审核" }); } if (pv[3].Trim() == "已生效") { paramValues.Add(new DataItemParam() { ItemName = "FinalState", ItemValue = "修改待审核" }); } Ws.startWorkflow("Bond", code, true, paramValues); } } return Json(result, "text/html", JsonRequestBehavior.AllowGet); }, string.Empty)); }