public EboxMouthArk convertMouthArk(SQLiteDataReader reader) { EboxMouthArk eboxMouthArk = new EboxMouthArk(); if (!Convert.IsDBNull(reader.GetValue(0))) { eboxMouthArk.ID = reader.GetInt32(0); } if (!Convert.IsDBNull(reader.GetValue(1))) { eboxMouthArk.MOPBID = reader.GetInt32(1); } if (!Convert.IsDBNull(reader.GetValue(2))) { eboxMouthArk.MOPBNO = reader.GetString(2); } if (!Convert.IsDBNull(reader.GetValue(3))) { eboxMouthArk.MOCSAID = reader.GetInt32(3); } if (!Convert.IsDBNull(reader.GetValue(4))) { eboxMouthArk.MOCSANO = reader.GetString(4); } if (!Convert.IsDBNull(reader.GetValue(5))) { eboxMouthArk.MOTYPEID = reader.GetInt32(5); } if (!Convert.IsDBNull(reader.GetValue(6))) { eboxMouthArk.MOLOCKNO = reader.GetString(6); } if (!Convert.IsDBNull(reader.GetValue(7))) { eboxMouthArk.MOFULLNO = reader.GetString(7); } if (!Convert.IsDBNull(reader.GetValue(8))) { eboxMouthArk.MONO = reader.GetString(8); } if (!Convert.IsDBNull(reader.GetValue(9))) { eboxMouthArk.MOSCALE = reader.GetString(9); } if (!Convert.IsDBNull(reader.GetValue(10))) { eboxMouthArk.MOSIZE = reader.GetString(10); } if (!Convert.IsDBNull(reader.GetValue(11))) { eboxMouthArk.MOSTANDFEE = reader.GetDouble(11); } if (!Convert.IsDBNull(reader.GetValue(12))) { eboxMouthArk.TFBUZSTATUS = reader.GetInt32(12); } return(eboxMouthArk); }
public List <EboxMouthArk> getEboxMouthArks(string sql) { string sqlStr = "select ID,MO_PBID,MO_PBNO,MO_CSAID,MO_CSANO,MO_TYPEID,MO_LOCKNO,MO_FULLNO,MO_NO,MO_SCALE,MO_SIZE,MO_STANDFEE,TF_BUZSTATUS from EBOX_MOUTH_ARK " + sql; LogHelper.Log("getEboxMouthArks= " + sqlStr); SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = sqlStr; cmd.Connection = conn; SQLiteDataReader reader = cmd.ExecuteReader(); List <EboxMouthArk> lists = new List <EboxMouthArk>(); while (reader.Read()) { EboxMouthArk result = convertMouthArk(reader); lists.Add(result); } cmd.Dispose(); return(lists); }