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