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