public static int UpdateTbl_FlowNode(Tbl_FlowNode tbl_flownode)
{
WebCommon.Public.WriteLog("修改节点：" + tbl_flownode.NodeName);
tbl_flownode.DealUser = WebCommon.Public.GetUserName();
tbl_flownode.DealTime = DateTime.Now;
return(new Tbl_FlowNodeService().UpdateTbl_FlowNodeById(tbl_flownode));
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_FlowNode> getTbl_FlowNodesBySql(string sql)
{
IList <Tbl_FlowNode> list = new List <Tbl_FlowNode>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_FlowNode tbl_flownode = new Tbl_FlowNode();
tbl_flownode.ID = Convert.ToInt32(dr["ID"]);
tbl_flownode.FlowID = Convert.ToInt32(dr["FlowID"]);
tbl_flownode.NodeNo = Convert.ToString(dr["NodeNo"]);
tbl_flownode.NodeName = Convert.ToString(dr["NodeName"]);
tbl_flownode.NodeStage = Convert.ToString(dr["NodeStage"]);
tbl_flownode.NodeType = Convert.ToString(dr["NodeType"]);
tbl_flownode.NodeUser = Convert.ToString(dr["NodeUser"]);
tbl_flownode.NodeUserLimit = Convert.ToString(dr["NodeUserLimit"]);
tbl_flownode.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_flownode.DealUser = Convert.ToString(dr["DealUser"]);
tbl_flownode.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_flownode.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_flownode);
}
}
return(list);
}
public int AddTbl_FlowNode(Tbl_FlowNode tbl_flownode)
{
string sql = "insert into [Tbl_FlowNode] ([FlowID],[NodeNo],[NodeName],[NodeStage],[NodeType],[NodeUser],[NodeUserLimit],[DealUser]) values (@FlowID,@NodeNo,@NodeName,@NodeStage,@NodeType,@NodeUser,@NodeUserLimit,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@FlowID", tbl_flownode.FlowID),
new SqlParameter("@NodeNo", tbl_flownode.NodeNo),
new SqlParameter("@NodeName", tbl_flownode.NodeName),
new SqlParameter("@NodeStage", tbl_flownode.NodeStage),
new SqlParameter("@NodeType", tbl_flownode.NodeType),
new SqlParameter("@NodeUser", tbl_flownode.NodeUser),
new SqlParameter("@NodeUserLimit", tbl_flownode.NodeUserLimit),
new SqlParameter("@DealUser", tbl_flownode.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_FlowNodeById(Tbl_FlowNode tbl_flownode)
{
string sql = "update [Tbl_FlowNode] set [FlowID]=@FlowID,[NodeNo]=@NodeNo,[NodeName]=@NodeName,[NodeStage]=@NodeStage,[NodeType]=@NodeType,[NodeUser]=@NodeUser,[NodeUserLimit]=@NodeUserLimit,[DealUser]=@DealUser,[DealTime]=@DealTime where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_flownode.ID),
new SqlParameter("@FlowID", tbl_flownode.FlowID),
new SqlParameter("@NodeNo", tbl_flownode.NodeNo),
new SqlParameter("@NodeName", tbl_flownode.NodeName),
new SqlParameter("@NodeStage", tbl_flownode.NodeStage),
new SqlParameter("@NodeType", tbl_flownode.NodeType),
new SqlParameter("@NodeUser", tbl_flownode.NodeUser),
new SqlParameter("@NodeUserLimit", tbl_flownode.NodeUserLimit),
new SqlParameter("@DealUser", tbl_flownode.DealUser),
new SqlParameter("@DealTime", tbl_flownode.DealTime.ToString())
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_FlowNode(Tbl_FlowNode tbl_flownode)
{
WebCommon.Public.WriteLog("添加节点：" + tbl_flownode.NodeName);
return(new Tbl_FlowNodeService().AddTbl_FlowNode(tbl_flownode));
}
