//=========================================================================
// 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);
}
