/// <summary>
/// 填充一个实体类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private XBase.Model.Decision.DataKeyPrepare GetList(SqlDataReader dr)
{
XBase.Model.Decision.DataKeyPrepare entity = new XBase.Model.Decision.DataKeyPrepare();
entity.DataID = SqlClientUtility.GetInt32(dr, "DataID", 0);
entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty);
entity.DataVar = SqlClientUtility.GetString(dr, "DataVar", String.Empty);
entity.DataVal = SqlClientUtility.GetString(dr, "DataVal", String.Empty);
entity.Attachment = SqlClientUtility.GetString(dr, "Attachment", String.Empty);
entity.DataSrc = SqlClientUtility.GetString(dr, "DataSrc", String.Empty);
entity.IsCond = SqlClientUtility.GetString(dr, "IsCond", String.Empty);
return(entity);
}
/// <summary>
/// 填充一个实体类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private XBase.Model.Decision.DataKeyPrepare GetList(SqlDataReader dr)
{
XBase.Model.Decision.DataKeyPrepare entity = new XBase.Model.Decision.DataKeyPrepare();
entity.DataID = SqlClientUtility.GetInt32(dr, "DataID", 0);
entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty);
entity.DataVar = SqlClientUtility.GetString(dr, "DataVar", String.Empty);
entity.DataVal = SqlClientUtility.GetString(dr, "DataVal", String.Empty);
entity.Attachment = SqlClientUtility.GetString(dr, "Attachment", String.Empty);
entity.DataSrc = SqlClientUtility.GetString(dr, "DataSrc", String.Empty);
entity.IsCond = SqlClientUtility.GetString(dr, "IsCond", String.Empty);
return entity;
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="cond">查询条件,多个条件应该以And连接</param>
/// <param name="orderExp">展现顺序</param>
/// <returns>List</returns>
public IList <XBase.Model.Decision.DataKeyPrepare> GetDataKeyPrepareListbyCond(string cond, string orderExp)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@Where", SqlDbType.VarChar, 100, cond),
SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.VarChar, 50, orderExp)
};
XBase.Model.Decision.DataKeyPrepare entity = null;
List <XBase.Model.Decision.DataKeyPrepare> lst = new List <XBase.Model.Decision.DataKeyPrepare>();
SqlDataReader dr;
Database.RunProc("[statdba].DataKeyPrepare_SelectbyCond", parameters, out dr);
while (dr.Read())
{
entity = GetList(dr);
lst.Add(entity);
}
return(lst);
}
