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