/// <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 bool Update(EyouSoft.Model.MQStructure.IMAcceptMsgPeople model)
{
if (model == null)
{
return(false);
}
return(dal.Update(model));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string CompanyId = Request.QueryString["CompanyId"];
int AreaId = EyouSoft.Common.Function.StringValidate.GetIntValue(Request.QueryString["AreaId"]);
string UserId = Request.QueryString["UserId"];
string IsCheck = Request.QueryString["IsCheck"]; //0:取消设置 1:设置
if (AreaId == 0 || string.IsNullOrEmpty(CompanyId) || string.IsNullOrEmpty(UserId) || string.IsNullOrEmpty(IsCheck))
{
Response.Write("0"); //0:操作失败 1:操作成功
Response.Flush();
Response.End();
return;
}
EyouSoft.Model.MQStructure.IMAcceptMsgPeople model = new EyouSoft.Model.MQStructure.IMAcceptMsgPeople();
model.CompanyId = CompanyId.Trim();
model.OperatorId = UserId.Trim();
model.TourAreaId = AreaId;
string returnVal = "0";
if (IsCheck == "1") //表示为设置
{
returnVal = EyouSoft.BLL.MQStructure.IMAcceptMsgPeople.CreateInstance().Add(model) == true ? "1" : "0";
}
else //取消设置
{
returnVal = EyouSoft.BLL.MQStructure.IMAcceptMsgPeople.CreateInstance().Delete(CompanyId, UserId, AreaId) == true ? "1" : "0";
}
Response.Write(returnVal);
Response.Flush();
Response.End();
}
}
/// <summary>
/// 执行查询返回实体集合
/// </summary>
/// <param name="dc">查询命令</param>
/// <returns>返回实体集合</returns>
private IList <EyouSoft.Model.MQStructure.IMAcceptMsgPeople> GetQueryList(DbCommand dc)
{
IList <EyouSoft.Model.MQStructure.IMAcceptMsgPeople> List = new List <EyouSoft.Model.MQStructure.IMAcceptMsgPeople>();
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MQStore))
{
EyouSoft.Model.MQStructure.IMAcceptMsgPeople model = null;
while (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());
}
List.Add(model);
}
model = null;
}
return(List);
}
