/// <summary> /// 添加一个实体类 /// </summary> /// <param name="dr"></param> /// <returns></returns> private XBase.Model.Decision.DataMySubscribe GetList(SqlDataReader dr) { XBase.Model.Decision.DataMySubscribe entity = new XBase.Model.Decision.DataMySubscribe(); entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0); entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty); entity.DataID = SqlClientUtility.GetString(dr, "DataID", String.Empty); entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty); entity.DataVarValue = SqlClientUtility.GetString(dr, "DataVarValue", String.Empty); entity.Conditions = SqlClientUtility.GetString(dr, "Conditions", String.Empty); entity.MyMobile = SqlClientUtility.GetString(dr, "MyMobile", String.Empty); entity.Creator = SqlClientUtility.GetString(dr, "Creator", String.Empty); entity.CreateDate = SqlClientUtility.GetDateTime(dr, "CreateDate", DateTime.Now); entity.DataNote = SqlClientUtility.GetString(dr, "DataNote", String.Empty); entity.Frequency = SqlClientUtility.GetString(dr, "Frequency", String.Empty); entity.Format = SqlClientUtility.GetString(dr, "Format", String.Empty); return(entity); }
/// <summary> /// 条件查询 /// </summary> /// <param name="cond">查询条件,多个条件应该以And连接</param> /// <param name="orderExp">展现顺序</param> /// <returns>List</returns> public IList <XBase.Model.Decision.DataMySubscribe> GetDataMySubscribleListbyCond(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.DataMySubscribe entity = null; List <XBase.Model.Decision.DataMySubscribe> lst = new List <XBase.Model.Decision.DataMySubscribe>(); SqlDataReader dr; Database.RunProc("statdba.DataMySubscribe_SelectbyCond", parameters, out dr); while (dr.Read()) { entity = GetList(dr); lst.Add(entity); } return(lst); }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool ModDataMySubscrible(XBase.Model.Decision.DataMySubscribe entity) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 4, entity.ID), SqlParameterHelper.MakeInParam("@DataId", SqlDbType.VarChar, 100, entity.DataID), SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 400, entity.DataName), SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 1000, entity.DataVarValue), SqlParameterHelper.MakeInParam("@Conditions", SqlDbType.VarChar, 100, entity.Conditions), SqlParameterHelper.MakeInParam("@MyMobile", SqlDbType.VarChar, 100, entity.MyMobile), SqlParameterHelper.MakeInParam("@DataNote", SqlDbType.VarChar, 200, entity.DataNote), SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.VarChar, 50, entity.Frequency), SqlParameterHelper.MakeInParam("@Format", SqlDbType.VarChar, 200, entity.Format) }; bool ret; Database.RunProc("statdba.DataMySubscribe_Modify", parameters, out ret); return(ret); }
/// <summary> /// 添加一条记录 /// </summary> /// <param name="val"></param> /// <returns></returns> public bool AddDataMySubscribe(XBase.Model.Decision.DataMySubscribe entity, out int Id) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD), SqlParameterHelper.MakeInParam("@DataID", SqlDbType.VarChar, 100, entity.DataID), SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 400, entity.DataName), SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 1000, entity.DataVarValue), SqlParameterHelper.MakeInParam("@Conditions", SqlDbType.VarChar, 100, entity.Conditions), SqlParameterHelper.MakeInParam("@MyMobile", SqlDbType.VarChar, 100, entity.MyMobile), SqlParameterHelper.MakeInParam("@Creator", SqlDbType.VarChar, 20, entity.Creator), SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 8, entity.CreateDate), SqlParameterHelper.MakeInParam("@DataNote", SqlDbType.VarChar, 200, entity.DataNote), SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.VarChar, 50, entity.Frequency), SqlParameterHelper.MakeInParam("@Format", SqlDbType.VarChar, 200, entity.Format), SqlParameterHelper.MakeOutParam("@ID", SqlDbType.Int, 6) }; bool ret; Database.RunProc("statdba.DataMySubscribe_Create", parameters, out ret); Id = Convert.ToInt32(parameters[11].Value); return(ret); }
/// <summary> /// 添加一个实体类 /// </summary> /// <param name="dr"></param> /// <returns></returns> private XBase.Model.Decision.DataMySubscribe GetList(SqlDataReader dr) { XBase.Model.Decision.DataMySubscribe entity = new XBase.Model.Decision.DataMySubscribe(); entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0); entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty); entity.DataID = SqlClientUtility.GetString(dr, "DataID",String.Empty); entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty); entity.DataVarValue = SqlClientUtility.GetString(dr, "DataVarValue", String.Empty); entity.Conditions = SqlClientUtility.GetString(dr, "Conditions", String.Empty); entity.MyMobile = SqlClientUtility.GetString(dr, "MyMobile", String.Empty); entity.Creator = SqlClientUtility.GetString(dr, "Creator", String.Empty); entity.CreateDate = SqlClientUtility.GetDateTime(dr, "CreateDate", DateTime.Now); entity.DataNote = SqlClientUtility.GetString(dr, "DataNote", String.Empty); entity.Frequency = SqlClientUtility.GetString(dr, "Frequency", String.Empty); entity.Format = SqlClientUtility.GetString(dr, "Format", String.Empty); return entity; }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool ModDataMySubscrible(XBase.Model.Decision.DataMySubscribe entity) { return(dal.ModDataMySubscrible(entity)); }
/// <summary> /// 添加一条记录 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool AddDataMySubscribe(XBase.Model.Decision.DataMySubscribe entity, out int Id) { return(dal.AddDataMySubscribe(entity, out Id)); }