public string AddWorkflow_FlowNode2(Workflow_FlowNodeEntity2 _Workflow_FlowNodeEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.WorkflowID ), MakeInParam("@NodeName",(DbType)SqlDbType.VarChar,200,_Workflow_FlowNodeEntity.NodeName), }; string sql = " select * from [dbo].[Workflow_FlowNode] where WorkflowID=@WorkflowID and NodeName=@NodeName "; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { DbParameter[] pramsInsert = { MakeInParam("@NodeName",(DbType)SqlDbType.VarChar,200,_Workflow_FlowNodeEntity.NodeName ), MakeInParam("@NodeDesc",(DbType)SqlDbType.VarChar,2000,_Workflow_FlowNodeEntity.NodeDesc ), MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.WorkflowID ), MakeInParam("@NodeTypeID",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.NodeTypeID ), MakeInParam("@IsOverTime",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.IsOverTime ), MakeInParam("@OverTimeLen",(DbType)SqlDbType.Float,8,_Workflow_FlowNodeEntity.OverTimeLen ), MakeInParam("@SignType",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.SignType ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.DisplayOrder ), MakeInParam("@x",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.X ), MakeInParam("@y",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.Y ), MakeInParam("@width",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.Width ), MakeInParam("@height",(DbType)SqlDbType.Int,4,_Workflow_FlowNodeEntity.Height ), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_FlowNode]"); sb.Append("("); sb.Append(" [NodeName]"); sb.Append(",[NodeDesc]"); sb.Append(",[WorkflowID]"); sb.Append(",[NodeTypeID]"); sb.Append(",[IsOverTime]"); sb.Append(",[OverTimeLen]"); sb.Append(",[SignType]"); sb.Append(",[DisplayOrder]"); sb.Append(",[x]"); sb.Append(",[y]"); sb.Append(",[width]"); sb.Append(",[height]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@NodeName,"); sb.Append("@NodeDesc,"); sb.Append("@WorkflowID,"); sb.Append("@NodeTypeID,"); sb.Append("@IsOverTime,"); sb.Append("@OverTimeLen,"); sb.Append("@SignType,"); sb.Append("@DisplayOrder,"); sb.Append("@x,"); sb.Append("@y,"); sb.Append("@width,"); sb.Append("@height )"); sb.Append("select @@identity;"); //ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert); _Workflow_FlowNodeEntity.NodeID = Convert.ToInt32(ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString()); ArrayList arlst = new ArrayList(); arlst.Add("Workflow_FlowNode"); arlst.Add(_Workflow_FlowNodeEntity.WorkflowID); arlst.Add(""); return sp_ReDisplayOrder(arlst); } }
private int SaveFlowNode(Workflow_FlowNodeEntity2 wfn,string operationState) { Workflow_FlowNodeEntity2 _Workflow_FlowNodeEntity = wfn; string sResult = "-1"; if (operationState == "Add") sResult =DbHelper.GetInstance().AddWorkflow_FlowNode2(_Workflow_FlowNodeEntity); else if (operationState == "Update") sResult =DbHelper.GetInstance().UpdateWorkflow_FlowNode(_Workflow_FlowNodeEntity); int wfnid = _Workflow_FlowNodeEntity.NodeID; return wfnid; }