public Model.pushparam GetPushByUserId(int userID)
{
Model.pushparam pushParam = new Model.pushparam();
using (SqlDataReader reader = DBHelper.ExecuteReader("proc_GetPushByUserId", CommandType.StoredProcedure, new SqlParameter("@userID", userID)))
{
if (reader.Read())
{
pushParam.id = Convert.ToInt32(reader[0].ToString());
pushParam.app_id = reader[1].ToString();
pushParam.channel_id = reader[2].ToString();
pushParam.error_code = reader[3].ToString();
pushParam.request_id = reader[4].ToString();
pushParam.user_id = reader[5].ToString();
pushParam.employeeid = Convert.ToInt32(reader[6].ToString());
pushParam.device_type = Convert.ToInt32(reader[7].ToString());
pushParam.push_num = Convert.ToInt32(reader[8]);
}
}
return pushParam;
}
public IList<Model.pushparam> GetAllPush()
{
IList<Model.pushparam> list = new List<Model.pushparam>();
using (SqlDataReader reader = DBHelper.ExecuteReader("select * from pushparam where state=0", CommandType.Text))
{
while (reader.Read())
{
Model.pushparam pushParam = new Model.pushparam();
pushParam.id = Convert.ToInt32(reader[0].ToString());
pushParam.app_id = reader[1].ToString();
pushParam.channel_id = reader[2].ToString();
pushParam.error_code = reader[3].ToString();
pushParam.request_id = reader[4].ToString();
pushParam.user_id = reader[5].ToString();
pushParam.employeeid = Convert.ToInt32(reader[6].ToString());
pushParam.device_type = Convert.ToInt32(reader[7].ToString());
pushParam.push_num = Convert.ToInt32(reader[8]);
list.Add(pushParam);
}
}
return list;
}