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