//========================================================================= // FunctionName : Query /// <summary> /// 检索方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public FilterReportApplicationData Query(FilterReportApplicationData appData) { FilterReportBusinessEntity instanceFilterReportBusinessEntity = (FilterReportBusinessEntity)CreateBusinessEntityInstance(typeof(FilterReportBusinessEntity)); instanceFilterReportBusinessEntity.AppData = appData; if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { instanceFilterReportBusinessEntity.SelectByKey(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { instanceFilterReportBusinessEntity.SelectByObjectID(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceFilterReportBusinessEntity.SelectByAnyCondition(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceFilterReportBusinessEntity.SelectByAnyCondition(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } return(instanceFilterReportBusinessEntity.AppData); }
//========================================================================= // FunctionName : Count /// <summary> /// 统计记录数方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public FilterReportApplicationData Count(FilterReportApplicationData appData) { FilterReportBusinessEntity instanceFilterReportBusinessEntity = (FilterReportBusinessEntity)CreateBusinessEntityInstance(typeof(FilterReportBusinessEntity)); instanceFilterReportBusinessEntity.AppData = appData; instanceFilterReportBusinessEntity.CountByAnyCondition(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; return(instanceFilterReportBusinessEntity.AppData); }
public void SaveFilterReport(FilterReportApplicationData filterReportApplicationData) { if (filterReportApplicationData.ObjectID.IsNullOrWhiteSpace()) { this.Add(filterReportApplicationData); } else { this.Modify(filterReportApplicationData); } }
//========================================================================= // FunctionName : Modify /// <summary> /// 更新方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public FilterReportApplicationData Modify(FilterReportApplicationData appData) { FilterReportBusinessEntity instanceFilterReportBusinessEntity = (FilterReportBusinessEntity)CreateBusinessEntityInstance(typeof(FilterReportBusinessEntity)); instanceFilterReportBusinessEntity.AppData = appData; if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { if (instanceFilterReportBusinessEntity.IsExistByKey() == true) { instanceFilterReportBusinessEntity.UpdateByKey(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { if (instanceFilterReportBusinessEntity.IsExistByObjectID() == true) { instanceFilterReportBusinessEntity.UpdateByObjectID(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.BATCH) { instanceFilterReportBusinessEntity.UpdateByObjectIDBatch(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceFilterReportBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceFilterReportBusinessEntity.UpdateByAnyCondition(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { if (instanceFilterReportBusinessEntity.IsExistByObjectID() == true) { instanceFilterReportBusinessEntity.UpdateByObjectID(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } return(instanceFilterReportBusinessEntity.AppData); }
//===================================================================== // FunctionName : GetDataByObjectID /// <summary> /// 以ObjectID为条件查询记录并返回AppData /// </summary> //===================================================================== public static FilterReportApplicationData GetDataByObjectID(string strObjectID) { // 创建数据库连接 Database db = DatabaseFactory.CreateDatabase("strConnManager"); string strProcName = "SP_SelectFilterReportByObjectID"; DbCommand cmdProc = db.GetStoredProcCommand(strProcName); // 设定存储过程输入参数 db.AddInParameter(cmdProc, "@ObjectID", DbType.String); // 对存储过程参数赋值 db.SetParameterValue(cmdProc, "@ObjectID", strObjectID); // 执行存储过程 return(FilterReportApplicationData.FillDataFromDataReader(db.ExecuteReader(cmdProc))); }
//========================================================================= // FunctionName : Add /// <summary> /// 添加方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public FilterReportApplicationData Add(FilterReportApplicationData appData) { FilterReportBusinessEntity instanceFilterReportBusinessEntity = (FilterReportBusinessEntity)CreateBusinessEntityInstance(typeof(FilterReportBusinessEntity)); instanceFilterReportBusinessEntity.AppData = appData; if (instanceFilterReportBusinessEntity.IsExistByKey() == false) { instanceFilterReportBusinessEntity.Insert(); instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceFilterReportBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } return(instanceFilterReportBusinessEntity.AppData); }
public static IEnumerable <FilterReportApplicationData> GetCollectionFromImportDataTable(DataTable dt) { List <FilterReportApplicationData> collection = new List <FilterReportApplicationData>(); foreach (DataRow dr in dt.Rows) { FilterReportApplicationData applicationData = new FilterReportApplicationData() { ObjectID = (dr.ReadGuidNullable("ObjectID") == null ? null : dr.ReadGuidNullable("ObjectID").ToString()), BGMC = dr.ReadString("BGMC"), UserID = dr.ReadString("UserID"), BGLX = dr.ReadString("BGLX"), GXBG = dr.ReadString("GXBG"), XTBG = dr.ReadString("XTBG"), BGCXTJ = dr.ReadString("BGCXTJ"), BGCJSJ = dr.ReadDateTimeNullable("BGCJSJ"), }; collection.Add(applicationData); } return(collection); }