public static string QianShi(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 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 Data.MSSQL.DBHelper().ExecuteScalar(sql, parArray)); } }
/// <summary> /// 执行自定义步骤事件 /// </summary> /// <param name="eventName"></param> /// <returns></returns> public object ExecuteFlowCustomEvent(string eventName, Data.Model.WorkFlowCustomEventParams eventParams, string dllName = "App_Code") { System.Reflection.Assembly assembly = System.Reflection.Assembly.Load(dllName); string typeName = System.IO.Path.GetFileNameWithoutExtension(eventName); string methodName = eventName.Substring(typeName.Length + 1); Type type = assembly.GetType(typeName, true); object obj = System.Activator.CreateInstance(type, false); var method = type.GetMethod(methodName); if (method != null) { return(method.Invoke(obj, new object[] { eventParams })); } else { throw new MissingMethodException(typeName, methodName); } }
public static object GetJson(Data.Model.WorkFlowCustomEventParams eventParams) { return(new Data.MSSQL.DBHelper().GetDataTable("select * from users")); }
/// <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 = Utility.HttpHelper.SendGet(dataSource1); switch (dataFormat) { case "0": case "1": return(str); case "2": return(jsonToHtml(str)); default: return(""); } } catch { return(""); } case "2": Data.Model.WorkFlowCustomEventParams eventParams = new 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(""); }