public static string QianShi(BizProcess.Data.Model.WorkFlowCustomEventParams eventParams) { string title = System.Web.HttpContext.Current.Request.Form["Title"]; string Contents = System.Web.HttpContext.Current.Request.Form["Contents"]; if (eventParams.InstanceID.IsInt()) { string sql = "UPDATE TempTest_CustomForm SET Title=@Title,Contents=@Contents WHERE ID=@ID"; SqlParameter[] parArray = { new SqlParameter("@Title", title), new SqlParameter("@Contents", Contents), new SqlParameter("@ID", eventParams.InstanceID.ToString()) }; new BizProcess.Data.MSSQL.DBHelper().Execute(sql, parArray); return(eventParams.InstanceID.ToString()); } else { string sql = "INSERT INTO TempTest_CustomForm(Title,Contents,FlowCompleted) VALUES(@Title,@Contents,@FlowCompleted);SELECT SCOPE_IDENTITY();"; SqlParameter[] parArray = { new SqlParameter("@Title", title), new SqlParameter("@Contents", Contents), new SqlParameter("@FlowCompleted", "0") }; return(new BizProcess.Data.MSSQL.DBHelper().ExecuteScalar(sql, parArray)); } }
/// <summary> /// 得到Grid的html /// </summary> /// <param name="dataFormat"></param> /// <param name="dataSource"></param> /// <param name="dataSource1"></param> /// <returns></returns> public string GetFormGridHtml(string connID, string dataFormat, string dataSource, string dataSource1) { if (!dataFormat.IsInt() || !dataSource.IsInt() || dataSource1.IsNullOrEmpty()) { return(""); } switch (dataSource) { case "0": DBConnection dbConn = new DBConnection(); var dbconn = dbConn.Get(connID.ToGuid()); if (dbconn == null) { return(""); } DataTable dt = dbConn.GetDataTable(dbconn, dataSource1.ReplaceSelectSql()); switch (dataFormat) { case "0": return(dataTableToHtml(dt)); case "1": return(dt.Rows.Count > 0 ? dt.Rows[0][0].ToString() : ""); case "2": return(dt.Rows.Count > 0 ? jsonToHtml(dt.Rows[0][0].ToString()) : ""); default: return(""); } case "1": string str = string.Empty; try { str = BizProcess.Utility.HttpHelper.SendGet(dataSource1); switch (dataFormat) { case "0": case "1": return(str); case "2": return(jsonToHtml(str)); default: return(""); } } catch { return(""); } case "2": BizProcess.Data.Model.WorkFlowCustomEventParams eventParams = new BizProcess.Data.Model.WorkFlowCustomEventParams(); eventParams.FlowID = (System.Web.HttpContext.Current.Request.QueryString["FlowID"] ?? "").ToGuid(); eventParams.GroupID = (System.Web.HttpContext.Current.Request.QueryString["GroupID"] ?? "").ToGuid(); eventParams.StepID = (System.Web.HttpContext.Current.Request.QueryString["StepID"] ?? "").ToGuid(); eventParams.TaskID = (System.Web.HttpContext.Current.Request.QueryString["TaskID"] ?? "").ToGuid(); eventParams.InstanceID = System.Web.HttpContext.Current.Request.QueryString["InstanceID"] ?? ""; object obj = null; try { obj = new WorkFlowTask().ExecuteFlowCustomEvent(dataSource1, eventParams); switch (dataFormat) { case "0": return(dataTableToHtml((DataTable)obj)); case "1": return(obj.ToString()); case "2": return(jsonToHtml(obj.ToString())); default: return(""); } } catch { return(""); } } return(""); }
/// <summary> /// 子流程结束后事件(示例) /// </summary> /// <param name="eventParams"></param> /// <returns></returns> public static void SubFlowCompletedBefore(BizProcess.Data.Model.WorkFlowCustomEventParams eventParams) { //在这里添加子流程结束后代码 BizProcess.Platform.Log.Add("执行了子流程结束后事件", "", BizProcess.Platform.Log.Types.其它分类); }
/// <summary> /// 子流程激活前事件(示例) /// </summary> /// <param name="eventParams"></param> /// <returns></returns> public static BizProcess.Data.Model.WorkFlowExecute.Execute SubFlowActivationBefore(BizProcess.Data.Model.WorkFlowCustomEventParams eventParams) { BizProcess.Data.Model.WorkFlowExecute.Execute execute = new BizProcess.Data.Model.WorkFlowExecute.Execute(); //在这里添加插入子流程业务数据代码 BizProcess.Platform.Log.Add("执行了子流程激活前事件", "", BizProcess.Platform.Log.Types.其它分类); return(execute); }
public static object GetJson(BizProcess.Data.Model.WorkFlowCustomEventParams eventParams) { return(new BizProcess.Data.MSSQL.DBHelper().GetDataTable("select * from users")); }