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"));
}
