public List <ExpressException> getExpressExceptions(string sql) { string sqlStr = "select EO_ID,EO_EIID,EO_LCID,EO_BARCODE,EO_ORDERNO,EO_EXPTYPE,EO_VALIDATECODE,EO_OVERTIMEDAY,EO_OVERTIMECNT,EO_OVERTIMEPRICE,EO_OVERTIMEFEE,EO_REMARK,TF_BUZSTATUS,TF_DELETEFLAG,TF_CREATERID,TF_CREATERNAME,TF_CREATEDATE,TF_UPDATERID,TF_UPDATERNAME,TF_UPDATEDATE,TF_BACKUPFIELD1,TF_BACKUPFIELD2,TF_BACKUPFIELD3 from EBOX_EXPRESSEXCEPTION " + sql; SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = sqlStr; cmd.Connection = conn; SQLiteDataReader reader = cmd.ExecuteReader(); List <ExpressException> lists = new List <ExpressException>(); while (reader.Read()) { ExpressException result = convertExpressException(reader); lists.Add(result); } cmd.Dispose(); return(lists); }
public ExpressException convertExpressException(SQLiteDataReader reader) { ExpressException expressException = new ExpressException(); expressException.EOID = reader.GetInt32(0); if (!Convert.IsDBNull(reader.GetValue(1))) { expressException.EOEIID = reader.GetInt32(1); } if (!Convert.IsDBNull(reader.GetValue(2))) { expressException.EOLCID = reader.GetInt32(2); } if (!Convert.IsDBNull(reader.GetValue(3))) { expressException.EOBARCODE = reader.GetString(3); } if (!Convert.IsDBNull(reader.GetValue(4))) { expressException.EOORDERNO = reader.GetString(4); } if (!Convert.IsDBNull(reader.GetValue(5))) { expressException.EOEXPTYPE = reader.GetInt32(5); } if (!Convert.IsDBNull(reader.GetValue(6))) { expressException.EOVALIDATECODE = reader.GetInt32(6); } if (!Convert.IsDBNull(reader.GetValue(7))) { expressException.EOOVERTIMEDAY = reader.GetInt32(7); } if (!Convert.IsDBNull(reader.GetValue(8))) { expressException.EOOVERTIMECNT = reader.GetInt32(8); } if (!Convert.IsDBNull(reader.GetValue(9))) { expressException.EOOVERTIMEPRICE = reader.GetDouble(9); } if (!Convert.IsDBNull(reader.GetValue(10))) { expressException.EOOVERTIMEFEE = reader.GetDouble(10); } if (!Convert.IsDBNull(reader.GetValue(11))) { expressException.EOREMARK = reader.GetString(11); } if (!Convert.IsDBNull(reader.GetValue(12))) { expressException.TFBUZSTATUS = reader.GetInt32(12); } if (!Convert.IsDBNull(reader.GetValue(13))) { expressException.TFDELETEFLAG = reader.GetInt32(13); } if (!Convert.IsDBNull(reader.GetValue(14))) { expressException.TFCREATERID = reader.GetInt32(14); } if (!Convert.IsDBNull(reader.GetValue(15))) { expressException.TFCREATERNAME = reader.GetString(15); } if (!Convert.IsDBNull(reader.GetValue(16))) { expressException.TFCREATEDATE = reader.GetString(16); } if (!Convert.IsDBNull(reader.GetValue(17))) { expressException.TFUPDATERID = reader.GetInt32(17); } if (!Convert.IsDBNull(reader.GetValue(18))) { expressException.TFUPDATERNAME = reader.GetString(18); } if (!Convert.IsDBNull(reader.GetValue(19))) { expressException.TFUPDATEDATE = reader.GetString(19); } if (!Convert.IsDBNull(reader.GetValue(20))) { expressException.TFBACKUPFIELD1 = reader.GetDouble(20); } if (!Convert.IsDBNull(reader.GetValue(21))) { expressException.TFBACKUPFIELD2 = reader.GetString(21); } if (!Convert.IsDBNull(reader.GetValue(22))) { expressException.TFBACKUPFIELD3 = reader.GetString(22); } return(expressException); }