/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="ID">MQ订单提醒设置ID</param> /// <returns>MQ订单提醒设置对象实体</returns> public virtual Model.MQStructure.IMAcceptMsgPeople GetModel(string ID) { if (string.IsNullOrEmpty(ID)) { return(null); } Model.MQStructure.IMAcceptMsgPeople model = null; DbCommand dc = base.MQStore.GetSqlStringCommand(Sql_Select + " where ID=@ID "); base.MQStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, ID); using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MQStore)) { if (dr.Read()) { model = new EyouSoft.Model.MQStructure.IMAcceptMsgPeople(); model.ID = dr["ID"].ToString(); model.CompanyId = dr["CompanyId"].ToString(); model.OperatorId = dr["OperatorId"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("TourAreaId"))) { model.TourAreaId = int.Parse(dr["TourAreaId"].ToString()); } } } return(model); }
/// <summary> /// 更新一条数据(时间不更新) /// </summary> /// <param name="model">MQ订单提醒设置实体</param> /// <returns>返回操作是否成功</returns> public virtual bool Update(Model.MQStructure.IMAcceptMsgPeople model) { if (model == null) { return(false); } DbCommand dc = base.MQStore.GetSqlStringCommand(Sql_Update); base.MQStore.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); base.MQStore.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId); base.MQStore.AddInParameter(dc, "TourAreaId", DbType.Int32, model.TourAreaId); base.MQStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID); if (DbHelper.ExecuteSql(dc, base.MQStore) > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">MQ订单提醒设置实体</param> /// <returns>返回操作是否成功</returns> public virtual bool Add(Model.MQStructure.IMAcceptMsgPeople model) { if (model == null) { return(false); } DbCommand dc = base.MQStore.GetSqlStringCommand(Sql_Add); base.MQStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString()); base.MQStore.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); base.MQStore.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId); base.MQStore.AddInParameter(dc, "TourAreaId", DbType.Int32, model.TourAreaId); base.MQStore.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now); if (DbHelper.ExecuteSql(dc, base.MQStore) > 0) { return(true); } else { return(false); } }