public bool AddFlowNodeCondition(FlowNodeConditionEntity flowNodeConditionEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @FlowConditionID"); sqlCommandText.Append(", @JournalID"); sqlCommandText.Append(", @FlowSetID"); sqlCommandText.Append(", @ConditionType"); sqlCommandText.Append(", @ConditionExp"); sqlCommandText.Append(", @AddDate"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.FlowNodeCondition ({0}) VALUES ({1})",sqlCommandText.ToString().Replace("@", ""),sqlCommandText.ToString())); db.AddInParameter(cmd,"@FlowConditionID",DbType.Int64,flowNodeConditionEntity.FlowConditionID); db.AddInParameter(cmd,"@JournalID",DbType.Int64,flowNodeConditionEntity.JournalID); db.AddInParameter(cmd, "@FlowSetID", DbType.Int64, flowNodeConditionEntity.FlowSetID); db.AddInParameter(cmd,"@ConditionType",DbType.Byte,flowNodeConditionEntity.ConditionType); db.AddInParameter(cmd,"@ConditionExp",DbType.AnsiString,flowNodeConditionEntity.ConditionExp); db.AddInParameter(cmd,"@AddDate",DbType.DateTime,flowNodeConditionEntity.AddDate); try { db.ExecuteNonQuery(cmd); flag = true; } catch(SqlException sqlEx) { throw sqlEx; } return flag; }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="flowNodeCondition">FlowNodeConditionEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteFlowNodeCondition(FlowNodeConditionEntity flowNodeCondition) { return FlowNodeConditionDataAccess.Instance.DeleteFlowNodeCondition(flowNodeCondition); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="flowNodeCondition">FlowNodeConditionEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteFlowNodeCondition(FlowNodeConditionEntity flowNodeCondition) { return FlowNodeConditionBusProvider.DeleteFlowNodeCondition(flowNodeCondition); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="flowNodeCondition">FlowNodeConditionEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddFlowNodeCondition(FlowNodeConditionEntity flowNodeCondition) { return FlowNodeConditionBusProvider.AddFlowNodeCondition(flowNodeCondition); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="flowNodeCondition">FlowNodeConditionEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateFlowNodeCondition(FlowNodeConditionEntity flowNodeCondition) { return FlowNodeConditionBusProvider.UpdateFlowNodeCondition(flowNodeCondition); }
public bool UpdateFlowNodeCondition(FlowNodeConditionEntity flowNodeConditionEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" FlowConditionID=@FlowConditionID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" JournalID=@JournalID"); sqlCommandText.Append(", FlowSetID=@FlowSetID"); sqlCommandText.Append(", ConditionType=@ConditionType"); sqlCommandText.Append(", ConditionExp=@ConditionExp"); sqlCommandText.Append(", AddDate=@AddDate"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.FlowNodeCondition SET {0} WHERE {1}",sqlCommandText.ToString(),whereCommandText.ToString())); db.AddInParameter(cmd,"@FlowConditionID",DbType.Int64,flowNodeConditionEntity.FlowConditionID); db.AddInParameter(cmd,"@JournalID",DbType.Int64,flowNodeConditionEntity.JournalID); db.AddInParameter(cmd, "@FlowSetID", DbType.Int64, flowNodeConditionEntity.FlowSetID); db.AddInParameter(cmd,"@ConditionType",DbType.Byte,flowNodeConditionEntity.ConditionType); db.AddInParameter(cmd,"@ConditionExp",DbType.AnsiString,flowNodeConditionEntity.ConditionExp); db.AddInParameter(cmd,"@AddDate",DbType.DateTime,flowNodeConditionEntity.AddDate); try { db.ExecuteNonQuery(cmd); flag = true; } catch(SqlException sqlEx) { throw sqlEx; } return flag; }
public List<FlowNodeConditionEntity> MakeFlowNodeConditionList(IDataReader dr) { List<FlowNodeConditionEntity> list=new List<FlowNodeConditionEntity>(); while(dr.Read()) { FlowNodeConditionEntity flowNodeConditionEntity=new FlowNodeConditionEntity(); flowNodeConditionEntity.FlowConditionID = (Int64)dr["FlowConditionID"]; flowNodeConditionEntity.JournalID = (Int64)dr["JournalID"]; flowNodeConditionEntity.FlowSetID = (Int64)dr["FlowSetID"]; flowNodeConditionEntity.ConditionType = (Byte)dr["ConditionType"]; flowNodeConditionEntity.ConditionExp = (String)dr["ConditionExp"]; flowNodeConditionEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(flowNodeConditionEntity); } dr.Close(); return list; }
public FlowNodeConditionEntity MakeFlowNodeCondition(DataRow dr) { FlowNodeConditionEntity flowNodeConditionEntity=null; if(dr!=null) { flowNodeConditionEntity=new FlowNodeConditionEntity(); flowNodeConditionEntity.FlowConditionID = (Int64)dr["FlowConditionID"]; flowNodeConditionEntity.JournalID = (Int64)dr["JournalID"]; flowNodeConditionEntity.FlowSetID = (Int64)dr["FlowSetID"]; flowNodeConditionEntity.ConditionType = (Byte)dr["ConditionType"]; flowNodeConditionEntity.ConditionExp = (String)dr["ConditionExp"]; flowNodeConditionEntity.AddDate = (DateTime)dr["AddDate"]; } return flowNodeConditionEntity; }
public bool DeleteFlowNodeCondition(FlowNodeConditionEntity flowNodeConditionEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.FlowNodeCondition"); sqlCommandText.Append(" WHERE FlowConditionID=@FlowConditionID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd,"@FlowConditionID",DbType.Int64,flowNodeConditionEntity.FlowConditionID); try { db.ExecuteNonQuery(cmd); flag = true; } catch(SqlException sqlEx) { throw sqlEx; } return flag; }