/// <summary>
/// 添加一个实体类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private XBase.Model.Decision.DataStat GetList(SqlDataReader dr)
{
XBase.Model.Decision.DataStat entity = new XBase.Model.Decision.DataStat();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty);
entity.DataID = SqlClientUtility.GetInt32(dr, "DataID", 0);
entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty);
entity.DataVarValue = SqlClientUtility.GetString(dr, "DataVarValue", String.Empty);
entity.DataNum = SqlClientUtility.GetDecimal(dr, "DataNum", Convert.ToDecimal("0.00"));
entity.StatType = SqlClientUtility.GetString(dr, "StatType", String.Empty);
entity.DataDateim = SqlClientUtility.GetDateTime(dr, "DataDateim", DateTime.Now);
return(entity);
}
/// <summary>
/// 添加一个实体类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private XBase.Model.Decision.DataStat GetList(SqlDataReader dr)
{
XBase.Model.Decision.DataStat entity = new XBase.Model.Decision.DataStat();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty);
entity.DataID = SqlClientUtility.GetInt32(dr, "DataID", 0);
entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty);
entity.DataVarValue = SqlClientUtility.GetString(dr, "DataVarValue", String.Empty);
entity.DataNum = SqlClientUtility.GetDecimal(dr, "DataNum",Convert.ToDecimal("0.00"));
entity.StatType = SqlClientUtility.GetString(dr, "StatType", String.Empty);
entity.DataDateim = SqlClientUtility.GetDateTime(dr, "DataDateim", DateTime.Now);
return entity;
}
/// <summary>
/// 添加统计信息
/// </summary>
/// <param name="p"></param>
/// <param name="dataMySubscribe"></param>
private bool AddDataStat(XBase.Model.Decision.DataStat entity)
{
SqlParameter[] prams =
{
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@DataID", SqlDbType.Int, 4, entity.DataID),
SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 100, entity.DataName),
SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 100, entity.DataVarValue),
SqlParameterHelper.MakeInParam("@DateNum", SqlDbType.Decimal, 9, entity.DataNum),
SqlParameterHelper.MakeInParam("@StatType", SqlDbType.Char, 1, entity.StatType),
SqlParameterHelper.MakeInParam("@DateDateim", SqlDbType.DateTime, 8, DateTime.Now)
};
bool ret;
Database.RunProc("[statdba].[DataStat_Add]", prams, out ret);
return(ret);
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="cond">查询条件,多个条件应该以And连接</param>
/// <param name="orderExp">展现顺序</param>
/// <returns>List</returns>
public IList <XBase.Model.Decision.DataStat> GetDataStatListbyCond(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.DataStat entity = null;
List <XBase.Model.Decision.DataStat> lst = new List <XBase.Model.Decision.DataStat>();
SqlDataReader dr;
Database.RunProc("statdba.DataStat_SelectbyCond", parameters, out dr);
while (dr.Read())
{
entity = GetList(dr);
lst.Add(entity);
}
return(lst);
}
