private Workflow_NodeTriggerWorkflowEntity GetWorkflow_NodeTriggerWorkflowFromIDataReader(DbDataReader dr)
{
Workflow_NodeTriggerWorkflowEntity dt = new Workflow_NodeTriggerWorkflowEntity();
if (dr.FieldCount > 0)
{
if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
if (dr["NodeID"].ToString() != "" || dr["NodeID"] != null) dt.NodeID = Int32.Parse(dr["NodeID"].ToString());
if (dr["OPTime"].ToString() != "" || dr["OPTime"] != null) dt.OPTime = Int32.Parse(dr["OPTime"].ToString());
dt.OPCondition = dr["OPCondition"].ToString();
if (dr["TriggerWFID"].ToString() != "" || dr["TriggerWFID"] != null) dt.TriggerWFID = Int32.Parse(dr["TriggerWFID"].ToString());
if (dr["TriggerWFCreator"].ToString() != "" || dr["TriggerWFCreator"] != null) dt.TriggerWFCreator = Int32.Parse(dr["TriggerWFCreator"].ToString());
if (dr["WFCreateNode"].ToString() != "" || dr["WFCreateNode"] != null) dt.WFCreateNode = Int32.Parse(dr["WFCreateNode"].ToString());
if (dr["WFCreateFieldID"].ToString() != "" || dr["WFCreateFieldID"] != null) dt.WFCreateFieldID = Int32.Parse(dr["WFCreateFieldID"].ToString());
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (dr["CreateSID"].ToString() != "" || dr["CreateSID"] != null) dt.CreateSID = Int32.Parse(dr["CreateSID"].ToString());
if (dr["IsCancel"].ToString() != "" || dr["IsCancel"] != null) dt.IsCancel = Int32.Parse(dr["IsCancel"].ToString());
if (dr["CancelDate"].ToString() != "" || dr["CancelDate"] != null) dt.CancelDate = Convert.ToDateTime(dr["CancelDate"]);
if (dr["CancelSID"].ToString() != "" || dr["CancelSID"] != null) dt.CancelSID = Int32.Parse(dr["CancelSID"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_NodeTriggerWorkflowEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_NodeTriggerWorkflow(Workflow_NodeTriggerWorkflowEntity _Workflow_NodeTriggerWorkflowEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = { MakeInParam("@TriggerID", (DbType)SqlDbType.Int, 4, _Workflow_NodeTriggerWorkflowEntity.TriggerID) };
string sql = "select * from Workflow_NodeTriggerWorkflow where IsCancel=0 and TriggerID=@TriggerID";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.WorkflowID ),
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.NodeID ),
MakeInParam("@OPTime",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.OPTime ),
MakeInParam("@OPCondition",(DbType)SqlDbType.VarChar,2000,_Workflow_NodeTriggerWorkflowEntity.OPCondition ),
MakeInParam("@TriggerWFID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.TriggerWFID ),
MakeInParam("@TriggerWFCreator",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.TriggerWFCreator ),
MakeInParam("@WFCreateNode",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.WFCreateNode ),
MakeInParam("@WFCreateFieldID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.WFCreateFieldID ),
MakeInParam("@CreateSID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.CreateSID )
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeTriggerWorkflow]");
sb.Append("(");
sb.Append("[WorkflowID]");
sb.Append(",[NodeID]");
sb.Append(",[OPTime]");
sb.Append(",[OPCondition]");
sb.Append(",[TriggerWFID]");
sb.Append(",[TriggerWFCreator]");
sb.Append(",[WFCreateNode]");
sb.Append(",[WFCreateFieldID]");
sb.Append(",[CreateSID]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@WorkflowID,");
sb.Append("@NodeID,");
sb.Append("@OPTime,");
sb.Append("@OPCondition,");
sb.Append("@TriggerWFID,");
sb.Append("@TriggerWFCreator,");
sb.Append("@WFCreateNode,");
sb.Append("@WFCreateFieldID");
sb.Append(",@CreateSID");
sb.Append(") ;");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_NodeTriggerWorkflowEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_NodeTriggerWorkflow(Workflow_NodeTriggerWorkflowEntity _Workflow_NodeTriggerWorkflowEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.WorkflowID ),
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.NodeID ),
MakeInParam("@OPTime",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.OPTime ),
MakeInParam("@TriggerWFID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.TriggerWFID ),
MakeInParam("@TriggerWFCreator",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.TriggerWFCreator ),
MakeInParam("@WFCreateNode",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.WFCreateNode ),
MakeInParam("@WFCreateFieldID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.WFCreateFieldID ),
MakeInParam("@TriggerID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerWorkflowEntity.TriggerID )
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_NodeTriggerWorkflow]");
sb.Append(" set ");
sb.Append(" [WorkflowID]=@WorkflowID,");
sb.Append(" [NodeID]=@NodeID,");
sb.Append(" [OPTime]=@OPTime,");
sb.Append(" [TriggerWFID]=@TriggerWFID,");
sb.Append(" [TriggerWFCreator]=@TriggerWFCreator,");
sb.Append(" [WFCreateNode]=@WFCreateNode,");
sb.Append(" [WFCreateFieldID]=@WFCreateFieldID");
sb.Append(" where ");
sb.Append(" [TriggerID]=@TriggerID;select @@rowcount");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
}
private string SaveData()
{
Workflow_NodeTriggerWorkflowEntity _NT = new Workflow_NodeTriggerWorkflowEntity();
_NT.TriggerID = txtTriggerID.Value != string.Empty ? Convert.ToInt32(txtTriggerID.Value) : 0;
_NT.WorkflowID = DNTRequest.GetInt("id", 0);
_NT.NodeID = Int32.Parse(ddlNodeID.SelectedValue);
// _NT.OPCycleType = Int32.Parse(ddlOPCycleType.SelectedValue);
_NT.OPTime = Int32.Parse(ddlOPTime.SelectedValue);
_NT.TriggerWFCreator = Int32.Parse(ddlTriggerCreator.SelectedValue);
_NT.TriggerWFID = Int32.Parse(txtTriggerWFID.Value);
_NT.WFCreateFieldID = (ddlTriggerCreator.SelectedValue == "2") ? Int32.Parse(ddlWFCreateFieldName.SelectedValue) : 0;
_NT.WFCreateNode = (ddlTriggerCreator.SelectedValue == "1") ? Int32.Parse(ddlWFCreateNode.SelectedValue) : 0;
_NT.OPCondition = "(1=1)";
string sResult = "-1";
if (strOperationState == "Add")
{
_NT.CreateSID = userEntity.UserSerialID;
sResult = DbHelper.GetInstance().AddWorkflow_NodeTriggerWorkflow(_NT);
}
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_NodeTriggerWorkflow(_NT);
return sResult;
}
